Adding auth

[z_archive/kelsier.git] / dbdump.sql

diff --git a/dbdump.sql b/dbdump.sql
index e0b0c5c1c001525d75672413c4181439b562a409..1c9349c65ecbe681c7a6d69daf4cd6bcb3801708 100644 (file)
--- a/dbdump.sql
+++ b/dbdump.sql
@@ -1,14 +1,25 @@
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+DROP TABLE IF EXISTS `bots`;
 CREATE TABLE `bots` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `nick` varchar(40) NOT NULL,
+  `nick` varchar(30) NOT NULL,
   `ident` varchar(10) NOT NULL DEFAULT 'kelsier',
-  `realname` varchar(100) NOT NULL DEFAULT 'Kelsier IRC Bot',
+  `realname` varchar(100) NOT NULL DEFAULT 'Kelsier',
   `bindip` varchar(15) DEFAULT NULL,
   `server` varchar(100) NOT NULL DEFAULT 'irc.quakenet.org',
   `serverport` smallint(5) unsigned NOT NULL DEFAULT '6667',
-  PRIMARY KEY (`id`)
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `nick` (`nick`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
 INSERT INTO `bots` VALUES (1,'Kelsier','kelsier','Kelsier IRC Bot',NULL,'irc.quakenet.org',6667);
+
+DROP TABLE IF EXISTS `m_id_quakenet`;
+CREATE TABLE `m_id_quakenet` (
+  `botid` int(10) unsigned NOT NULL,
+  `authname` varchar(15) NOT NULL,
+  `authpass` varchar(10) NOT NULL,
+  PRIMARY KEY (`botid`),
+  CONSTRAINT `m_id_quakenet_ibfk_1` FOREIGN KEY (`botid`) REFERENCES `bots` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+-- mysqldump -ukelsier -p kelsier --compact --add-drop-table >dbdump.sql