]>
jfr.im git - erebus.git/blob - sqlite.sql
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,
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`
)
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`
)
24 CREATE TABLE `users`
(
25 `auth`
varchar(30) NOT NULL,
26 `
level`
tinyint(3) NOT NULL,