1 CREATE TABLE factoids (
2 factoid_key VARCHAR(64) NOT NULL,
3 requested_by VARCHAR(80) DEFAULT 'nobody' NOT NULL,
4 requested_time numeric(11) DEFAULT 0 NOT NULL,
5 requested_count numeric(5) DEFAULT 0 NOT NULL,
6 created_by VARCHAR(80),
7 created_time numeric(11) DEFAULT 0 NOT NULL,
8 modified_by VARCHAR(80),
9 modified_time numeric(11) DEFAULT 0 NOT NULL,
10 locked_by VARCHAR(80),
11 locked_time numeric(11) DEFAULT 0 NOT NULL,
12 factoid_value text NOT NULL
15 REVOKE ALL ON TABLE factoids FROM PUBLIC;
17 CREATE INDEX factoids_idx_fvalue ON factoids USING hash (factoid_value);
19 ALTER TABLE ONLY factoids
20 ADD CONSTRAINT factoids_pkey_fkey PRIMARY KEY (factoid_key);