dbdump.sql

   1 DROP TABLE IF EXISTS `bots`;
   2 CREATE TABLE `bots` (
   3   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   4   `nick` varchar(30) NOT NULL,
   5   `ident` varchar(10) NOT NULL DEFAULT 'kelsier',
   6   `realname` varchar(100) NOT NULL DEFAULT 'Kelsier',
   7   `bindip` varchar(15) DEFAULT NULL,
   8   `server` varchar(100) NOT NULL DEFAULT 'irc.quakenet.org',
   9   `serverport` smallint(5) unsigned NOT NULL DEFAULT '6667',
  10   PRIMARY KEY (`id`),
  11   UNIQUE KEY `nick` (`nick`)
  12 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  13 INSERT INTO `bots` VALUES (1,'Kelsier','kelsier','Kelsier IRC Bot',NULL,'irc.quakenet.org',6667);
  14
  15 DROP TABLE IF EXISTS `m_id_quakenet`;
  16 CREATE TABLE `m_id_quakenet` (
  17   `botid` int(10) unsigned NOT NULL,
  18   `authname` varchar(15) NOT NULL,
  19   `authpass` varchar(10) NOT NULL,
  20   PRIMARY KEY (`botid`),
  21   CONSTRAINT `m_id_quakenet_ibfk_1` FOREIGN KEY (`botid`) REFERENCES `bots` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  23
  24
  25 -- mysqldump -ukelsier -p kelsier --compact --add-drop-table >dbdump.sql