]>
jfr.im git - irc/thales.git/blob - data/mysql-bahamut.sql
1 DROP TABLE IF EXISTS chan
;
2 DROP TABLE IF EXISTS ison
;
3 DROP TABLE IF EXISTS server;
4 DROP TABLE IF EXISTS user;
5 DROP TABLE IF EXISTS maxvalues
;
8 chanid
int unsigned
NOT NULL auto_increment
,
9 channel
varchar(33) binary NOT NULL default '',
11 topicauthor
varchar(31) default NULL,
12 topictime datetime
default NULL,
13 mode_lc
enum('Y','N') NOT NULL default 'N',
14 mode_li
enum('Y','N') NOT NULL default 'N',
15 mode_lk
enum('Y','N') NOT NULL default 'N',
16 mode_ll
enum('Y','N') NOT NULL default 'N',
17 mode_lm
enum('Y','N') NOT NULL default 'N',
18 mode_ln
enum('Y','N') NOT NULL default 'N',
19 mode_lp
enum('Y','N') NOT NULL default 'N',
20 mode_lr
enum('Y','N') NOT NULL default 'N',
21 mode_ls
enum('Y','N') NOT NULL default 'N',
22 mode_lt
enum('Y','N') NOT NULL default 'N',
23 mode_ul
enum('Y','N') NOT NULL default 'N',
24 mode_um
enum('Y','N') NOT NULL default 'N',
25 mode_ur
enum('Y','N') NOT NULL default 'N',
26 mode_uo
enum('Y','N') NOT NULL default 'N',
27 mode_ll_data
int(10) NOT NULL default '0',
28 mode_lk_data
varchar(23) NOT NULL default '',
30 UNIQUE KEY channel (channel
)
34 nickid
int unsigned
NOT NULL default '0',
35 chanid
int unsigned
NOT NULL default '0',
36 mode_lo
enum('Y','N') NOT NULL default 'N',
37 mode_lv
enum('Y','N') NOT NULL default 'N',
38 PRIMARY KEY (nickid
,chanid
)
42 servid
int unsigned
NOT NULL auto_increment
,
43 server varchar(64) NOT NULL default '',
44 comment varchar(255) NOT NULL default '',
45 linkedto
tinyint(3) unsigned
default NULL,
46 connecttime datetime
default NULL,
47 online
enum('Y','N') NOT NULL DEFAULT 'Y',
48 lastsplit datetime
default NULL,
50 UNIQUE KEY server (server),
51 KEY linkedto (linkedto
)
56 nickid
int unsigned
NOT NULL auto_increment
,
57 nick
varchar(31) NOT NULL default '',
58 realname
varchar(51) NOT NULL default '',
59 hostname
varchar(64) NOT NULL default '',
60 ipaddr
varchar(16) NOT NULL default '',
61 username
varchar(11) NOT NULL default '',
62 connecttime datetime
NOT NULL default '0000-00-00 00:00:00',
63 servid
int unsigned
NOT NULL default '0',
64 away
enum('Y','N') NOT NULL default 'N',
66 online
enum('Y','N') NOT NULL DEFAULT 'Y',
67 lastquit datetime
default NULL,
68 mode_la
enum ('Y','N') NOT NULL default 'N',
69 mode_lb
enum('Y','N') NOT NULL default 'N',
70 mode_lc
enum('Y','N') NOT NULL default 'N',
71 mode_ld
enum('Y','N') NOT NULL default 'N',
72 mode_le
enum('Y','N') NOT NULL default 'N',
73 mode_lf
enum('Y','N') NOT NULL default 'N',
74 mode_lg
enum('Y','N') NOT NULL default 'N',
75 mode_lh
enum('Y','N') NOT NULL default 'N',
76 mode_li
enum('Y','N') NOT NULL default 'N',
77 mode_lk
enum('Y','N') NOT NULL default 'N',
78 mode_lm
enum('Y','N') NOT NULL default 'N',
79 mode_ln
enum('Y','N') NOT NULL default 'N',
80 mode_lo
enum('Y','N') NOT NULL default 'N',
81 mode_lr
enum('Y','N') NOT NULL default 'N',
82 mode_ls
enum('Y','N') NOT NULL default 'N',
83 mode_lw
enum('Y','N') NOT NULL default 'N',
84 mode_ly
enum('Y','N') NOT NULL default 'N',
85 mode_ua
enum('Y','N') NOT NULL default 'N',
86 mode_ur
enum('Y','N') NOT NULL default 'N',
88 UNIQUE KEY nick (nick
),
92 CREATE TABLE maxvalues (
93 type varchar(10) NOT NULL default '',
94 val
int unsigned
NOT NULL default '0',
95 time datetime
NOT NULL default '0000-00-00 00:00:00',