database.sql
author Dan
Sat, 15 Mar 2008 20:45:32 -0400
changeset 2 c474904ed707
parent 0 d02690a8552c
child 20 e2f6e3af9959
permissions -rw-r--r--
Moved db_name to config.php; added !snippets virtual snippet that lists all snippet codes in database; abstracted database query and error checking code
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     1
CREATE TABLE snippets(
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     2
  snippet_id int(12) NOT NULL auto_increment,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     3
  snippet_code varchar(32) NOT NULL DEFAULT '',
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     4
  snippet_text text,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     5
  snippet_channels text,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     6
  PRIMARY KEY ( snippet_id )
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     7
);
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     8
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
     9
CREATE TABLE irclog (
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    10
  id int(11) NOT NULL auto_increment,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    11
  channel varchar(30) default NULL,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    12
  day char(10) default NULL,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    13
  nick varchar(40) default NULL,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    14
  timestamp int(11) default NULL,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    15
  line text,
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    16
  spam tinyint(1) default '0',
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    17
  PRIMARY KEY  (id)
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    18
);
d02690a8552c Initial population. EnanoBot v0.1.
Dan
parents:
diff changeset
    19