1 -- http://www.hezmatt.org/~mpalmer/sqlite-phpwiki/sqlite.sql
3 -- $Id: sqlite.sql,v 1.5 2004-07-05 14:12:59 rurban Exp $
6 id INTEGER PRIMARY KEY,
7 pagename VARCHAR(100) NOT NULL,
8 hits INTEGER NOT NULL DEFAULT 0,
9 pagedata MEDIUMTEXT NOT NULL DEFAULT ''
12 CREATE UNIQUE INDEX page_index ON page (pagename);
14 CREATE TABLE version (
16 version INTEGER NOT NULL,
17 mtime INTEGER NOT NULL,
18 minor_edit TINYINTEGER DEFAULT 0,
19 content MEDIUMTEXT NOT NULL DEFAULT '',
20 versiondata MEDIUMTEXT NOT NULL DEFAULT '',
21 PRIMARY KEY (id,version)
24 CREATE INDEX version_index ON version (mtime);
27 id INTEGER NOT NULL PRIMARY KEY,
28 latestversion INTEGER,
33 CREATE TABLE nonempty (
36 CREATE INDEX nonempty_index ON nonempty (id);
39 linkfrom INTEGER NOT NULL,
40 linkto INTEGER NOT NULL
43 CREATE INDEX linkfrom_index ON link (linkfrom);
44 CREATE INDEX linkto_index ON link (linkto);
46 CREATE TABLE session (
47 sess_id CHAR(32) NOT NULL DEFAULT '' PRIMARY KEY,
48 sess_data BLOB NOT NULL,
49 sess_date INTEGER UNSIGNED NOT NULL,
50 sess_ip CHAR(15) NOT NULL
53 CREATE INDEX sessdate_index ON session (sess_date);
54 CREATE INDEX sessip_index ON session (sess_ip);
56 -- Optional DB Auth and Prefs
57 -- For these tables below the default table prefix must be used
58 -- in the DBAuthParam SQL statements also.
61 userid CHAR(48) NOT NULL PRIMARY KEY,
62 prefs TEXT NULL DEFAULT ''