1 -- $Id: schema.mysql,v 1.7 2001-09-18 19:16:23 dairiki Exp $
3 drop table if exists page;
6 pagename VARCHAR(100) BINARY NOT NULL,
7 hits INT NOT NULL DEFAULT 0,
8 pagedata MEDIUMTEXT NOT NULL DEFAULT '',
13 drop table if exists version;
14 CREATE TABLE version (
18 minor_edit TINYINT DEFAULT 0,
19 content MEDIUMTEXT NOT NULL DEFAULT '',
20 versiondata MEDIUMTEXT NOT NULL DEFAULT '',
21 PRIMARY KEY (id,version),
25 drop table if exists recent;
34 drop table if exists nonempty;
35 CREATE TABLE nonempty (
40 drop table if exists link;
42 linkfrom INT NOT NULL,