4 id INT NOT NULL AUTO_INCREMENT,
5 pagename VARCHAR(100) NOT NULL,
6 hits INT NOT NULL DEFAULT 0,
7 pagedata TEXT NOT NULL DEFAULT '',
8 cached_html TEXT NOT NULL DEFAULT '', -- added with 1.3.11
13 CREATE TABLE version (
17 minor_edit TINYINT DEFAULT 0,
18 content TEXT NOT NULL DEFAULT '',
19 versiondata TEXT NOT NULL DEFAULT '',
20 PRIMARY KEY (id,version)
22 CREATE INDEX version_mtime ON version (mtime);
32 CREATE TABLE nonempty (
38 linkfrom INT NOT NULL,
41 CREATE INDEX linkfrom ON link (linkfrom);
42 CREATE INDEX linkto ON link (linkto);
44 CREATE TABLE session (
45 sess_id CHAR(32) NOT NULL DEFAULT '',
46 sess_data BLOB NOT NULL,
47 sess_date INT UNSIGNED NOT NULL,
48 sess_ip CHAR(40) NOT NULL,
51 CREATE INDEX sessdate_index ON session (sess_date);
52 CREATE INDEX sessip_index ON session (sess_ip);
54 -- Optional DB Auth and Prefs
55 -- For these tables below the default table prefix must be used
56 -- in the DBAuthParam SQL statements also.
59 userid CHAR(48) NOT NULL,
60 prefs TEXT NULL DEFAULT '',
61 passwd CHAR(48) DEFAULT '',
62 groupname CHAR(48) DEFAULT 'users',
66 -- update to 1.3.12: (see lib/upgrade.php)
67 -- ALTER TABLE pref ADD passwd CHAR(48) BINARY DEFAULT '';
68 -- ALTER TABLE pref ADD groupname CHAR(48) BINARY DEFAULT 'users';
70 -- deprecated since 1.3.12. only useful for separate databases.
71 -- better use the extra pref table where such users can be created easily
73 -- CREATE TABLE user (
74 -- userid CHAR(48) NOT NULL,
75 -- passwd CHAR(48) DEFAULT '',
76 -- prefs TEXT NULL DEFAULT '',
77 -- groupname CHAR(48) DEFAULT 'users'
80 -- Use the member table, if you need it for n:m user-group relations,
81 -- and adjust your DBAUTH_AUTH_ SQL statements.
83 userid CHAR(48) NOT NULL,
84 groupname CHAR(48) NOT NULL DEFAULT 'users'
86 CREATE INDEX member_userid ON member (userid);
87 CREATE INDEX member_groupname ON member (groupname);
89 -- only if you plan to use the wikilens theme
91 dimension INT(4) NOT NULL,
92 raterpage INT(11) NOT NULL,
93 rateepage INT(11) NOT NULL,
94 ratingvalue FLOAT NOT NULL,
95 rateeversion INT(11) NOT NULL,
96 tstamp TIMESTAMP(14) NOT NULL,
97 PRIMARY KEY (dimension, raterpage, rateepage)
99 CREATE INDEX rating_dimension ON rating (dimension);
100 CREATE INDEX rating_raterpage ON rating (raterpage);
101 CREATE INDEX rating_rateepage ON rating (rateepage);
103 -- if ACCESS_LOG_SQL > 0
104 -- only if you need fast log-analysis (spam prevention, recent referrers)
105 -- see http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/#id2756178
106 CREATE TABLE accesslog (
107 time_stamp INT UNSIGNED,
108 remote_host VARCHAR(100),
109 remote_user VARCHAR(50),
110 request_method VARCHAR(10),
111 request_line VARCHAR(255),
112 request_args VARCHAR(255),
113 request_file VARCHAR(255),
114 request_uri VARCHAR(255),
115 request_time CHAR(28),
116 status SMALLINT UNSIGNED,
117 bytes_sent SMALLINT UNSIGNED,
118 referer VARCHAR(255),
120 request_duration FLOAT
122 CREATE INDEX log_time ON accesslog (time_stamp);
123 CREATE INDEX log_host ON accesslog (remote_host);
124 -- create extra indices on demand (usually referer. see plugin/AccessLogSql)