1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
DROP TABLE onak_keys;
DROP TABLE onak_uids;
DROP TABLE onak_sigs;
CREATE TABLE onak_keys (
keyid char(16) NOT NULL,
keydata oid NOT NULL,
PRIMARY KEY (keyid)
);
CREATE INDEX onak_keys_keyid_index ON onak_keys(keyid);
CREATE TABLE onak_uids (
keyid char(16) NOT NULL,
uid varchar(6000) NOT NULL,
pri boolean,
FOREIGN KEY (keyid) REFERENCES onak_keys
);
CREATE TABLE onak_sigs (
signer char(16) NOT NULL,
signee char(16) NOT NULL,
FOREIGN KEY (signee) REFERENCES onak_keys
);
CREATE INDEX onak_sigs_signee_index ON onak_sigs(signee);
|
