X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fmysql%2Fonjoin.sql;h=63f351468404235295d9454aadc3aba9c7431c4b;hb=826d5a49991db9d4dc69596fd280bca036717773;hp=d3eb6d5760067b937e32ead1505d8d1bef45559d;hpb=ef39fddb7f57fd75471e2c676a40efd3fb1a3291;p=infobot.git

diff --git a/setup/mysql/onjoin.sql b/setup/mysql/onjoin.sql
index d3eb6d5..63f3514 100644
--- 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;