]>
Commit | Line | Data |
---|---|---|
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 |