File: factoids.sql

package info (click to toggle)
blootbot 1.1.0-2
  • links: PTS
  • area: main
  • in suites: woody
  • size: 1,420 kB
  • ctags: 586
  • sloc: perl: 15,941; sh: 154; makefile: 56; sql: 45
file content (19 lines) | stat: -rw-r--r-- 341 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
CREATE TABLE factoids (
	factoid_key VARCHAR(64) NOT NULL,

	requested_by VARCHAR(64),
	requested_time INT,
	requested_count SMALLINT UNSIGNED,
	created_by VARCHAR(64),
	created_time INT,

	modified_by VARCHAR(192),
	modified_time INT,

	locked_by VARCHAR(64),
	locked_time INT,

	factoid_value TEXT NOT NULL,

	PRIMARY KEY (factoid_key)
);