]>
Commit | Line | Data |
---|---|---|
6b4ba0b6 JR |
1 | CREATE TABLE `bots` ( |
2 | `nick` varchar(30) NOT NULL, | |
3 | `user` varchar(10) NOT NULL DEFAULT 'erebus', | |
4 | `bind` varchar(15) DEFAULT NULL, | |
5 | `authname` varchar(30) DEFAULT NULL, | |
6 | `authpass` varchar(20) DEFAULT NULL, | |
7 | `active` tinyint(1) NOT NULL DEFAULT 1, | |
8 | `connected` tinyint(1) NOT NULL DEFAULT 0, | |
9 | PRIMARY KEY (`nick`) | |
10 | ); | |
11 | CREATE TABLE `chans` ( | |
12 | `chname` varchar(100) NOT NULL, | |
13 | `bot` varchar(30) NOT NULL, | |
14 | `active` tinyint(1) NOT NULL DEFAULT 1, | |
15 | PRIMARY KEY (`chname`) | |
16 | ); | |
17 | CREATE INDEX chans_bot ON chans (bot); | |
18 | CREATE TABLE `chusers` ( | |
19 | `chan` varchar(100) NOT NULL, | |
20 | `user` varchar(30) NOT NULL, | |
21 | `level` int(11) NOT NULL, | |
22 | PRIMARY KEY (`chan`,`user`) | |
23 | ); | |
24 | CREATE TABLE `users` ( | |
25 | `auth` varchar(30) NOT NULL, | |
26 | `level` tinyint(3) NOT NULL, | |
27 | PRIMARY KEY (`auth`) | |
28 | ); |