* Missed DebianBugs.pl in the previous merge

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

diff --git a/setup/mysql/botmail.sql b/setup/mysql/botmail.sql
index 2789338defddc531df50ea1701b74ce0e1dd3d5c..53031729d517ec0e0bcb837e7c2255fed219cccf 100644 (file)
--- a/setup/mysql/botmail.sql
+++ b/setup/mysql/botmail.sql
@@ -1,8 +1,12 @@
-CREATE TABLE botmail (
- srcwho VARCHAR(20) NOT NULL,
- dstwho VARCHAR(20) NOT NULL,
- srcuh VARCHAR(80) NOT NULL,
- time INT UNSIGNED DEFAULT 'UNIX_TIMESTAMP()',
- msg TEXT NOT NULL,
- PRIMARY KEY (srcwho,dstwho)
-);
+--
+-- Table structure for table `botmail`
+--
+
+CREATE TABLE `botmail` (
+  `srcwho` varchar(20) NOT NULL default '',
+  `dstwho` varchar(20) NOT NULL default '',
+  `srcuh` varchar(80) NOT NULL default '',
+  `time` int(10) unsigned default '0',
+  `msg` text NOT NULL,
+  PRIMARY KEY  (`srcwho`,`dstwho`)
+) TYPE=MyISAM;