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