database.sql
author Dan
Sat, 11 Oct 2008 23:09:13 +0000
changeset 14 506a7e0fb106
parent 0 d02690a8552c
child 20 e2f6e3af9959
permissions -rw-r--r--
Disabled "snippet not found" message, for now

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