1 -- http://www.hezmatt.org/~mpalmer/sqlite-phpwiki/sqlite.sql
3 -- $Id: sqlite.sql,v 1.2 2004-04-06 20:00: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 char(32) not null default '',
50 sess_data blob not null,
51 sess_date INT UNSIGNED NOT NULL,
52 sess_ip char(15) not null,
56 CREATE INDEX sessdate_index ON session (sess_date);
57 CREATE INDEX sessip_index ON session (sess_ip);
59 -- Optional DB Auth and Prefs
60 -- For these tables below the default table prefix must be used
61 -- in the DBAuthParam SQL statements also.
64 userid CHAR(48) BINARY NOT NULL UNIQUE,
65 prefs TEXT NULL DEFAULT '',