1 -- http://www.hezmatt.org/~mpalmer/sqlite-phpwiki/sqlite.sql
3 -- $Id: sqlite.sql,v 1.1 2004-03-24 01:02:11 rurban Exp $
7 pagename VARCHAR(100) NOT NULL,
8 hits INT NOT NULL DEFAULT 0,
9 pagedata MEDIUMTEXT NOT NULL DEFAULT '',
13 CREATE UNIQUE INDEX page_index ON page (pagename);
15 CREATE TABLE version (
19 minor_edit TINYINT DEFAULT 0,
20 content MEDIUMTEXT NOT NULL DEFAULT '',
21 versiondata MEDIUMTEXT NOT NULL DEFAULT '',
22 PRIMARY KEY (id,version)
25 CREATE INDEX version_index ON version (mtime);
35 CREATE TABLE nonempty (
41 linkfrom INT NOT NULL,
45 CREATE INDEX linkfrom_index ON link (linkfrom);
46 CREATE INDEX linkto_index ON link (linkto);
48 CREATE TABLE session (
49 sess_id varchar(32) not null default '',
50 sess_data blob not null,
51 sess_date INT UNSIGNED NOT NULL,