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