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