* Fix SQL for broken MySQL schema

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

diff --git a/setup/mysql/onjoin.sql b/setup/mysql/onjoin.sql
index d3eb6d5760067b937e32ead1505d8d1bef45559d..63f351468404235295d9454aadc3aba9c7431c4b 100644 (file)
--- a/setup/mysql/onjoin.sql
+++ b/setup/mysql/onjoin.sql
@@ -1,14 +1,12 @@
-CREATE TABLE onjoin (
-       nick VARCHAR(20) NOT NULL,
-       channel VARCHAR(30) NOT NULL,
-       message VARCHAR(255) NOT NULL,
-       modified_by VARCHAR(20) NOT NULL DEFAULT 'nobody',
-       modified_time INT NOT NULL DEFAULT '0',
-       PRIMARY KEY (nick, channel)
-);
+--
+-- Table structure for table `onjoin`
+--
 
--- v.2 -> v.3
--- ALTER TABLE onjoin ADD COLUMN modified_by VARCHAR(20) NOT NULL DEFAULT 'nobody';
--- ALTER TABLE onjoin ADD COLUMN modified_time INT NOT NULL DEFAULT '0';
--- ** the following doesn't work for sqlite **
--- ALTER TABLE onjoin ADD PRIMARY KEY (nick, channel);
+CREATE TABLE `onjoin` (
+  `nick` varchar(20) NOT NULL default '',
+  `channel` varchar(30) NOT NULL default '',
+  `message` varchar(255) NOT NULL default '',
+  `modified_by` varchar(20) NOT NULL default 'nobody',
+  `modified_time` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`nick`,`channel`)
+) TYPE=MyISAM;