File: onak.sql

package info (click to toggle)
onak 0.4.1-1
  • links: PTS
  • area: main
  • in suites: wheezy
  • size: 1,096 kB
  • sloc: ansic: 9,703; perl: 277; sh: 217; makefile: 152; sql: 21
file content (24 lines) | stat: -rw-r--r-- 545 bytes parent folder | download | duplicates (11) 
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);