author | Dan |
Sun, 12 Oct 2008 00:31:56 -0400 | |
changeset 17 | b07b23187b17 |
parent 0 | d02690a8552c |
child 20 | e2f6e3af9959 |
permissions | -rw-r--r-- |
0 | 1 |
CREATE TABLE snippets( |
2 |
snippet_id int(12) NOT NULL auto_increment, |
|
3 |
snippet_code varchar(32) NOT NULL DEFAULT '', |
|
4 |
snippet_text text, |
|
5 |
snippet_channels text, |
|
6 |
PRIMARY KEY ( snippet_id ) |
|
7 |
); |
|
8 |
||
9 |
CREATE TABLE irclog ( |
|
10 |
id int(11) NOT NULL auto_increment, |
|
11 |
channel varchar(30) default NULL, |
|
12 |
day char(10) default NULL, |
|
13 |
nick varchar(40) default NULL, |
|
14 |
timestamp int(11) default NULL, |
|
15 |
line text, |
|
16 |
spam tinyint(1) default '0', |
|
17 |
PRIMARY KEY (id) |
|
18 |
); |
|
19 |