diff -r 000000000000 -r d02690a8552c database.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/database.sql Sat Mar 15 19:53:27 2008 -0400 @@ -0,0 +1,19 @@ +CREATE TABLE snippets( + snippet_id int(12) NOT NULL auto_increment, + snippet_code varchar(32) NOT NULL DEFAULT '', + snippet_text text, + snippet_channels text, + PRIMARY KEY ( snippet_id ) +); + +CREATE TABLE irclog ( + id int(11) NOT NULL auto_increment, + channel varchar(30) default NULL, + day char(10) default NULL, + nick varchar(40) default NULL, + timestamp int(11) default NULL, + line text, + spam tinyint(1) default '0', + PRIMARY KEY (id) +); +