File: onak.sql

package info (click to toggle)
onak 0.3.2-1.1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 892 kB
  • ctags: 514
  • sloc: ansic: 7,879; perl: 223; makefile: 87; sh: 25; sql: 21
file content (24 lines) | stat: -rw-r--r-- 545 bytes parent folder | download | duplicates (10) 
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);