* Synced schema for seen table in other engines to match sqlite2 schema (PKEY only...

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

diff --git a/setup/mysql/seen.sql b/setup/mysql/seen.sql
index d920f79bc5230843719147a5e59ab7b381c567e9..9a2b691531db5a57b8250e03decda1603dbf4178 100644 (file)
--- a/setup/mysql/seen.sql
+++ b/setup/mysql/seen.sql
@@ -1,8 +1,12 @@
-CREATE TABLE seen (
- nick VARCHAR(20) NOT NULL,
- time INT NOT NULL,
- channel VARCHAR(20) NOT NULL,
- host VARCHAR(80) NOT NULL,
- message TINYTEXT NOT NULL,
- PRIMARY KEY (nick,channel)
-);
+--
+-- Table structure for table `seen`
+--
+
+CREATE TABLE `seen` (
+  `nick` varchar(20) NOT NULL default '',
+  `time` int(11) NOT NULL default '0',
+  `channel` varchar(30) NOT NULL default '',
+  `host` varchar(64) NOT NULL default '',
+  `message` tinytext NOT NULL,
+  PRIMARY KEY  (`nick`)
+) TYPE=MyISAM;