Added bot class, misc other changes

[z_archive/kelsier.git] / dbdump.sql

diff --git a/dbdump.sql b/dbdump.sql
new file mode 100644 (file)
index 0000000..e0b0c5c
--- /dev/null
+++ b/dbdump.sql
@@ -0,0 +1,14 @@
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `bots` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `nick` varchar(40) NOT NULL,
+  `ident` varchar(10) NOT NULL DEFAULT 'kelsier',
+  `realname` varchar(100) NOT NULL DEFAULT 'Kelsier IRC Bot',
+  `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`)
+) 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);