| Sergiusz Bazanski | 1fad2e5 | 2019-08-01 20:16:27 +0200 | [diff] [blame^] | 1 | CREATE TABLE peer_pgp_keys ( |
| 2 | peer_id UUID NOT NULL, | ||||
| 3 | id UUID DEFAULT gen_random_uuid(), | ||||
| 4 | |||||
| 5 | fingerprint STRING NOT NULL, | ||||
| 6 | time_created INT NOT NULL, | ||||
| 7 | |||||
| 8 | UNIQUE (peer_id), | ||||
| 9 | PRIMARY KEY (peer_id, id), | ||||
| 10 | CONSTRAINT fk_peer FOREIGN KEY (peer_id) REFERENCES peers (id) ON DELETE CASCADE | ||||
| 11 | ) INTERLEAVE IN PARENT peers (peer_id); | ||||