1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
-- $Id: mysql-test-initialize.sql,v 1.5 2006/06/05 09:35:02 rurban Exp $
-- for the regression suite
drop table if exists test_page;
drop table if exists test_version;
drop table if exists test_recent;
drop table if exists test_nonempty;
drop table if exists test_link;
drop table if exists test_session;
-- since 1.3.7:
drop table if exists test_pref;
drop table if exists test_user;
drop table if exists test_member;
drop table if exists test_rating;
drop table if exists test_accesslog;
CREATE TABLE test_page (
id INT NOT NULL AUTO_INCREMENT,
pagename VARCHAR(100) BINARY NOT NULL,
hits INT NOT NULL DEFAULT 0,
pagedata MEDIUMTEXT NOT NULL DEFAULT '',
cached_html MEDIUMBLOB,
PRIMARY KEY (id),
UNIQUE KEY (pagename)
);
CREATE TABLE test_version (
id INT NOT NULL,
version INT NOT NULL,
mtime INT NOT NULL,
minor_edit TINYINT DEFAULT 0,
content MEDIUMTEXT NOT NULL DEFAULT '',
versiondata MEDIUMTEXT NOT NULL DEFAULT '',
PRIMARY KEY (id,version),
INDEX (mtime)
);
CREATE TABLE test_recent (
id INT NOT NULL,
latestversion INT,
latestmajor INT,
latestminor INT,
PRIMARY KEY (id)
);
CREATE TABLE test_nonempty (
id INT NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE test_link (
linkfrom INT NOT NULL,
linkto INT NOT NULL,
relation INT DEFAULT 0,
INDEX (linkfrom),
INDEX (linkto),
INDEX (relation)
);
CREATE TABLE test_session (
sess_id CHAR(32) NOT NULL DEFAULT '',
sess_data BLOB NOT NULL,
sess_date INT UNSIGNED NOT NULL,
sess_ip CHAR(15) NOT NULL,
PRIMARY KEY (sess_id),
INDEX (sess_date)
); -- TYPE=heap; -- if your Mysql supports it and you have enough RAM
-- upgrade to 1.3.8: (see lib/upgrade.php)
-- ALTER TABLE session ADD sess_ip CHAR(15) NOT NULL;
-- CREATE INDEX sess_date on session (sess_date);
-- update to 1.3.10: (see lib/upgrade.php)
-- ALTER TABLE page CHANGE id id INT NOT NULL AUTO_INCREMENT;
-- Optional DB Auth and Prefs
-- For these tables below the default table prefix must be used
-- in the DBAuthParam SQL statements also.
CREATE TABLE test_pref (
userid CHAR(48) BINARY NOT NULL UNIQUE,
prefs TEXT NULL DEFAULT '',
PRIMARY KEY (userid)
);
-- better use the extra pref table where such users can be created easily
-- without password.
--CREATE TABLE test_user (
-- userid CHAR(48) BINARY NOT NULL UNIQUE,
-- passwd CHAR(48) BINARY DEFAULT '',
-- prefs TEXT NULL DEFAULT '',
-- groupname CHAR(48) BINARY DEFAULT 'users',
-- PRIMARY KEY (userid)
--) TYPE=MyISAM;
-- only if you plan to use the wikilens theme
CREATE TABLE test_rating (
dimension INT(4) NOT NULL,
raterpage INT(11) NOT NULL,
rateepage INT(11) NOT NULL,
ratingvalue FLOAT NOT NULL,
rateeversion INT(11) NOT NULL,
tstamp TIMESTAMP(14) NOT NULL,
PRIMARY KEY (dimension, raterpage, rateepage)
);
-- only if you need fast log-analysis (spam prevention, recent referrers)
-- see http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/#id2756178
CREATE TABLE test_accesslog (
time_stamp int unsigned,
remote_host varchar(50),
remote_user varchar(50),
request_method varchar(10),
request_line varchar(255),
request_args varchar(255),
request_file varchar(255),
request_uri varchar(255),
request_time char(28),
status smallint unsigned,
bytes_sent smallint unsigned,
referer varchar(255),
agent varchar(255),
request_duration float
);
CREATE INDEX log_time ON test_accesslog (time_stamp);
CREATE INDEX log_host ON test_accesslog (remote_host);
|
