1 -- $Id: mssql-initialize.sql,v 1.3 2005-06-21 05:59:18 rurban Exp $
5 id INT NOT NULL AUTO_INCREMENT,
6 pagename VARCHAR(100) NOT NULL,
7 hits INT NOT NULL DEFAULT 0,
8 pagedata TEXT NOT NULL DEFAULT '',
9 cached_html TEXT NOT NULL DEFAULT '', -- added with 1.3.11
14 CREATE TABLE version (
18 minor_edit TINYINT DEFAULT 0,
19 content TEXT NOT NULL DEFAULT '',
20 versiondata TEXT NOT NULL DEFAULT '',
21 PRIMARY KEY (id,version)
23 CREATE INDEX version_mtime ON version (mtime);
33 CREATE TABLE nonempty (
39 linkfrom INT NOT NULL,
42 CREATE INDEX linkfrom ON link (linkfrom);
43 CREATE INDEX linkto ON link (linkto);
45 CREATE TABLE session (
46 sess_id CHAR(32) NOT NULL DEFAULT '',
47 sess_data BLOB NOT NULL,
48 sess_date INT UNSIGNED NOT NULL,
49 sess_ip CHAR(40) NOT NULL,
52 CREATE INDEX sessdate_index ON session (sess_date);
53 CREATE INDEX sessip_index ON session (sess_ip);
55 -- Optional DB Auth and Prefs
56 -- For these tables below the default table prefix must be used
57 -- in the DBAuthParam SQL statements also.
60 userid CHAR(48) NOT NULL UNIQUE,
61 prefs TEXT NULL DEFAULT '',
65 -- better use the extra pref table where such users can be created easily
68 -- userid CHAR(48) NOT NULL UNIQUE,
69 -- passwd CHAR(48) DEFAULT '',
70 -- prefs TEXT NULL DEFAULT '',
71 -- groupname CHAR(48) DEFAULT 'users',
72 -- PRIMARY KEY (userid)
75 --CREATE TABLE member (
76 -- userid CHAR(48) NOT NULL,
77 -- groupname CHAR(48) NOT NULL DEFAULT 'users',
81 --CREATE INDEX member_userid ON member (userid);
82 --CREATE INDEX member_groupname ON member (groupname);
84 -- only if you plan to use the wikilens theme
86 dimension INT(4) NOT NULL,
87 raterpage INT(11) NOT NULL,
88 rateepage INT(11) NOT NULL,
89 ratingvalue FLOAT NOT NULL,
90 rateeversion INT(11) NOT NULL,
91 tstamp TIMESTAMP(14) NOT NULL,
92 PRIMARY KEY (dimension, raterpage, rateepage)
94 CREATE INDEX rating_dimension ON rating (dimension);
95 CREATE INDEX rating_raterpage ON rating (raterpage);
96 CREATE INDEX rating_rateepage ON rating (rateepage);
98 -- if ACCESS_LOG_SQL > 0
99 -- only if you need fast log-analysis (spam prevention, recent referrers)
100 -- see http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/#id2756178
101 CREATE TABLE accesslog (
102 time_stamp INT UNSIGNED,
103 remote_host VARCHAR(50),
104 remote_user VARCHAR(50),
105 request_method VARCHAR(10),
106 request_line VARCHAR(255),
107 request_args VARCHAR(255),
108 request_file VARCHAR(255),
109 request_uri VARCHAR(255),
110 request_time CHAR(28),
111 status SMALLINT UNSIGNED,
112 bytes_sent SMALLINT UNSIGNED,
113 referer VARCHAR(255),
115 request_duration FLOAT
117 CREATE INDEX log_time ON accesslog (time_stamp);
118 CREATE INDEX log_host ON accesslog (remote_host);
119 -- create extra indices on demand (usually referer. see plugin/AccessLogSql)