3 -- the CREATE FUNCTION section must be run as a separate query. cut/paste run before executing the remainder
4 -- of the contents of this file
5 CREATE FUNCTION hasContent
6 (@ContentField varchar(max))
11 IF @ContentField NOT LIKE ''
16 -- end separate section
21 pagename VARCHAR(100) NOT NULL,
22 hits INT NOT NULL DEFAULT 0,
23 pagedata TEXT NOT NULL DEFAULT '',
24 cached_html TEXT NOT NULL DEFAULT '', -- added with 1.3.11
28 -- SET IDENTITY_INSERT page ON;
30 CREATE TABLE version (
34 minor_edit TINYINT DEFAULT 0,
35 content varchar(max) NOT NULL DEFAULT '', -- can't be text
36 versiondata TEXT NOT NULL DEFAULT '',
37 PRIMARY KEY (id,version)
39 CREATE INDEX version_mtime ON version (mtime);
49 CREATE TABLE nonempty (
55 linkfrom INT NOT NULL,
59 CREATE INDEX linkfrom ON link (linkfrom);
60 CREATE INDEX linkto ON link (linkto);
62 CREATE TABLE session (
63 sess_id CHAR(32) NOT NULL DEFAULT '',
64 sess_data IMAGE NOT NULL,
65 sess_date BIGINT NOT NULL,
66 sess_ip CHAR(40) NOT NULL,
69 CREATE INDEX sessdate_index ON session (sess_date);
70 CREATE INDEX sessip_index ON session (sess_ip);
72 -- Optional DB Auth and Prefs
73 -- For these tables below the default table prefix must be used
74 -- in the DBAuthParam SQL statements also.
77 userid CHAR(48) NOT NULL,
78 prefs TEXT NULL DEFAULT '',
79 passwd CHAR(48) DEFAULT '',
80 groupname CHAR(48) DEFAULT 'users',
84 -- update to 1.3.12: (see lib/upgrade.php)
85 -- ALTER TABLE pref ADD passwd CHAR(48) BINARY DEFAULT '';
86 -- ALTER TABLE pref ADD groupname CHAR(48) BINARY DEFAULT 'users';
88 -- deprecated since 1.3.12. only useful for separate databases.
89 -- better use the extra pref table where such users can be created easily
91 -- CREATE TABLE user (
92 -- userid CHAR(48) NOT NULL,
93 -- passwd CHAR(48) DEFAULT '',
94 -- prefs TEXT NULL DEFAULT '',
95 -- groupname CHAR(48) DEFAULT 'users'
98 -- Use the member table, if you need it for n:m user-group relations,
99 -- and adjust your DBAUTH_AUTH_ SQL statements.
100 CREATE TABLE member (
101 userid CHAR(48) NOT NULL,
102 groupname CHAR(48) NOT NULL DEFAULT 'users'
104 CREATE INDEX member_userid ON member (userid);
105 CREATE INDEX member_groupname ON member (groupname);
107 -- only if you plan to use the wikilens theme
108 CREATE TABLE rating (
109 dimension smallINT NOT NULL,
110 raterpage INT NOT NULL,
111 rateepage INT NOT NULL,
112 ratingvalue FLOAT NOT NULL,
113 rateeversion INT NOT NULL,
114 tstamp bigint NOT NULL,
115 PRIMARY KEY (dimension, raterpage, rateepage)
117 CREATE INDEX rating_dimension ON rating (dimension);
118 CREATE INDEX rating_raterpage ON rating (raterpage);
119 CREATE INDEX rating_rateepage ON rating (rateepage);
121 -- if ACCESS_LOG_SQL > 0
122 -- only if you need fast log-analysis (spam prevention, recent referrers)
123 -- see http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/#id2756178
124 CREATE TABLE accesslog (
126 remote_host VARCHAR(255),
127 remote_user VARCHAR(50),
128 request_method VARCHAR(10),
133 request_time CHAR(28),
138 request_duration FLOAT
140 CREATE INDEX log_time ON accesslog (time_stamp);
141 CREATE INDEX log_host ON accesslog (remote_host);
142 -- create extra indices on demand (usually referer. see plugin/AccessLogSql)