DROP TABLE IF EXISTS `bots`;
CREATE TABLE `bots` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nick` varchar(30) NOT NULL,
  `ident` varchar(10) NOT NULL DEFAULT 'kelsier',
  `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`),
  UNIQUE KEY `nick` (`nick`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
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 
