join debugging

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

diff --git a/setup/mysql/rootwarn.sql b/setup/mysql/rootwarn.sql
index afcee2c59afe343dc37f19a17fc57892724504f2..f5479eda05b6aadf63695027a1be61ad8b710104 100644 (file)
--- a/setup/mysql/rootwarn.sql
+++ b/setup/mysql/rootwarn.sql
@@ -1,8 +1,12 @@
-CREATE TABLE rootwarn (
- nick VARCHAR(20) NOT NULL,
- attempt SMALLINT UNSIGNED,
- time INT NOT NULL,
- host VARCHAR(80) NOT NULL,
- channel VARCHAR(20) NOT NULL,
- PRIMARY KEY (nick)
-);
+--
+-- Table structure for table `rootwarn`
+--
+
+CREATE TABLE `rootwarn` (
+  `nick` varchar(20) NOT NULL default '',
+  `attempt` smallint(5) unsigned default NULL,
+  `time` int(11) NOT NULL default '0',
+  `host` varchar(64) NOT NULL default '',
+  `channel` varchar(30) NOT NULL default '',
+  PRIMARY KEY  (`nick`)
+) TYPE=MyISAM;