--- /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)
+);
+