1 CREATE TABLE factoids (
2 factoid_key VARCHAR(64) NOT NULL,
4 requested_by VARCHAR(64) NOT NULL,
5 requested_time INT NOT NULL DEFAULT '0',
6 requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',
7 created_by VARCHAR(64),
8 created_time INT NOT NULL DEFAULT '0',
10 modified_by VARCHAR(192),
11 modified_time INT NOT NULL DEFAULT '0',
13 locked_by VARCHAR(64),
14 locked_time INT NOT NULL DEFAULT '0',
16 factoid_value TEXT NOT NULL,
18 PRIMARY KEY (factoid_key)