* Missed DebianBugs.pl in the previous merge

[infobot.git] / setup / mysql / factoids.sql

diff --git a/setup/mysql/factoids.sql b/setup/mysql/factoids.sql
index d5189d0d7a72c5e1342e94d8e1f311d0f1b27ce5..50523952cffac31c284b53bb85b3afa3264f40a3 100644 (file)
--- a/setup/mysql/factoids.sql
+++ b/setup/mysql/factoids.sql
@@ -1,14 +1,18 @@
-CREATE TABLE factoids (
- factoid_key VARCHAR(64) NOT NULL,
- requested_by VARCHAR(64) NOT NULL DEFAULT 'nobody',
- requested_time INT NOT NULL DEFAULT '0',
- requested_count SMALLINT UNSIGNED NOT NULL DEFAULT '0',
- created_by VARCHAR(64),
- created_time INT NOT NULL DEFAULT '0',
- modified_by VARCHAR(192),
- modified_time INT NOT NULL DEFAULT '0',
- locked_by VARCHAR(64),
- locked_time INT NOT NULL DEFAULT '0',
- factoid_value TEXT NOT NULL,
- PRIMARY KEY (factoid_key)
-);
+--
+-- Table structure for table `factoids`
+--
+
+CREATE TABLE `factoids` (
+  `factoid_key` varchar(64) NOT NULL,
+  `requested_by` varchar(100) default NULL,
+  `requested_time` int(11) default NULL,
+  `requested_count` smallint(5) unsigned NOT NULL default '0',
+  `created_by` varchar(100) default NULL,
+  `created_time` int(11) default NULL,
+  `modified_by` varchar(100) default NULL,
+  `modified_time` int(11) default NULL,
+  `locked_by` varchar(100) default NULL,
+  `locked_time` int(11) default NULL,
+  `factoid_value` text NOT NULL,
+  PRIMARY KEY  (`factoid_key`)
+) TYPE=MyISAM;