]> jfr.im git - z_archive/kelsier.git/blob - dbdump.sql
Added bot class, misc other changes
[z_archive/kelsier.git] / dbdump.sql
1 /*!40101 SET @saved_cs_client = @@character_set_client */;
2 /*!40101 SET character_set_client = utf8 */;
3 CREATE TABLE `bots` (
4 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
5 `nick` varchar(40) NOT NULL,
6 `ident` varchar(10) NOT NULL DEFAULT 'kelsier',
7 `realname` varchar(100) NOT NULL DEFAULT 'Kelsier IRC Bot',
8 `bindip` varchar(15) DEFAULT NULL,
9 `server` varchar(100) NOT NULL DEFAULT 'irc.quakenet.org',
10 `serverport` smallint(5) unsigned NOT NULL DEFAULT '6667',
11 PRIMARY KEY (`id`)
12 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
13 /*!40101 SET character_set_client = @saved_cs_client */;
14 INSERT INTO `bots` VALUES (1,'Kelsier','kelsier','Kelsier IRC Bot',NULL,'irc.quakenet.org',6667);