1 CREATE TABLE /*$wgDBprefix*/user (
2 user_id INTEGER PRIMARY KEY AUTOINCREMENT,
3 user_name varchar(255) default '',
4 user_real_name varchar(255) default '',
5 user_password tinyblob ,
6 user_newpassword tinyblob ,
7 user_newpass_time BLOB,
10 user_touched BLOB default '',
11 user_token BLOB default '',
12 user_email_authenticated BLOB,
13 user_email_token BLOB,
14 user_email_token_expires BLOB,
15 user_registration BLOB,
16 user_editcount int) /*$wgDBTableOptions*/;
18 CREATE TABLE /*$wgDBprefix*/user_groups (
19 ug_user INTEGER default '0',
20 ug_group varBLOB default '') /*$wgDBTableOptions*/;
22 CREATE TABLE /*$wgDBprefix*/user_newtalk (
23 user_id INTEGER default '0',
24 user_ip varBLOB default '',
25 user_last_timestamp BLOB default '') /*$wgDBTableOptions*/;
27 CREATE TABLE /*$wgDBprefix*/page (
28 page_id INTEGER PRIMARY KEY AUTOINCREMENT,
29 page_namespace INTEGER ,
30 page_title varchar(255) ,
31 page_restrictions tinyblob ,
32 page_counter bigint default '0',
33 page_is_redirect tinyint default '0',
34 page_is_new tinyint default '0',
36 page_touched BLOB default '',
38 page_len INTEGER ) /*$wgDBTableOptions*/;
40 CREATE TABLE /*$wgDBprefix*/revision (
41 rev_id INTEGER PRIMARY KEY AUTOINCREMENT,
44 rev_comment tinyblob ,
45 rev_user INTEGER default '0',
46 rev_user_text varchar(255) default '',
47 rev_timestamp BLOB default '',
48 rev_minor_edit tinyint default '0',
49 rev_deleted tinyint default '0',
51 rev_parent_id INTEGER default NULL) /*$wgDBTableOptions*/ ;
53 CREATE TABLE /*$wgDBprefix*/text (
54 old_id INTEGER PRIMARY KEY AUTOINCREMENT,
56 old_flags tinyblob ) /*$wgDBTableOptions*/ ;
58 CREATE TABLE /*$wgDBprefix*/archive (
59 ar_namespace INTEGER default '0',
60 ar_title varchar(255) default '',
63 ar_user INTEGER default '0',
64 ar_user_text varchar(255) ,
65 ar_timestamp BLOB default '',
66 ar_minor_edit tinyint default '0',
70 ar_deleted tinyint default '0',
73 ar_parent_id INTEGER default NULL) /*$wgDBTableOptions*/;
75 CREATE TABLE /*$wgDBprefix*/pagelinks (
76 pl_from INTEGER default '0',
77 pl_namespace INTEGER default '0',
78 pl_title varchar(255) default '') /*$wgDBTableOptions*/;
80 CREATE TABLE /*$wgDBprefix*/templatelinks (
81 tl_from INTEGER default '0',
82 tl_namespace INTEGER default '0',
83 tl_title varchar(255) default '') /*$wgDBTableOptions*/;
85 CREATE TABLE /*$wgDBprefix*/imagelinks (
86 il_from INTEGER default '0',
87 il_to varchar(255) default '') /*$wgDBTableOptions*/;
89 CREATE TABLE /*$wgDBprefix*/categorylinks (
90 cl_from INTEGER default '0',
91 cl_to varchar(255) default '',
92 cl_sortkey varchar(70) default '',
93 cl_timestamp timestamp ) /*$wgDBTableOptions*/;
95 CREATE TABLE /*$wgDBprefix*/category (
96 cat_id INTEGER PRIMARY KEY AUTOINCREMENT,
97 cat_title varchar(255) ,
98 cat_pages INTEGER signed default 0,
99 cat_subcats INTEGER signed default 0,
100 cat_files INTEGER signed default 0,
101 cat_hidden tinyint default 0) /*$wgDBTableOptions*/;
103 CREATE TABLE /*$wgDBprefix*/externallinks (
104 el_from INTEGER default '0',
106 el_index blob ) /*$wgDBTableOptions*/;
108 CREATE TABLE /*$wgDBprefix*/langlinks (
109 ll_from INTEGER default '0',
110 ll_lang varBLOB default '',
111 ll_title varchar(255) default '') /*$wgDBTableOptions*/;
113 CREATE TABLE /*$wgDBprefix*/site_stats (
115 ss_total_views bigint default '0',
116 ss_total_edits bigint default '0',
117 ss_good_articles bigint default '0',
118 ss_total_pages bigint default '-1',
119 ss_users bigint default '-1',
120 ss_admins INTEGER default '-1',
121 ss_images INTEGER default '0') /*$wgDBTableOptions*/;
123 CREATE TABLE /*$wgDBprefix*/hitcounter (
127 CREATE TABLE /*$wgDBprefix*/ipblocks (
128 ipb_id INTEGER PRIMARY KEY AUTOINCREMENT,
129 ipb_address tinyblob ,
130 ipb_user INTEGER default '0',
131 ipb_by INTEGER default '0',
132 ipb_by_text varchar(255) default '',
133 ipb_reason tinyblob ,
134 ipb_timestamp BLOB default '',
135 ipb_auto bool default 0,
136 ipb_anon_only bool default 0,
137 ipb_create_account bool default 1,
138 ipb_enable_autoblock bool default '1',
139 ipb_expiry varBLOB default '',
140 ipb_range_start tinyblob ,
141 ipb_range_end tinyblob ,
142 ipb_deleted bool default 0,
143 ipb_block_email bool default 0) /*$wgDBTableOptions*/;
145 CREATE TABLE /*$wgDBprefix*/image (
146 img_name varchar(255) default '',
147 img_size INTEGER default '0',
148 img_width INTEGER default '0',
149 img_height INTEGER default '0',
150 img_metadata mediumblob ,
151 img_bits INTEGER default '0',
152 img_media_type TEXT default NULL,
153 img_major_mime TEXT default "unknown",
154 img_minor_mime varBLOB default "unknown",
155 img_description tinyblob ,
156 img_user INTEGER default '0',
157 img_user_text varchar(255) ,
158 img_timestamp varBLOB default '',
159 img_sha1 varBLOB default '') /*$wgDBTableOptions*/;
161 CREATE TABLE /*$wgDBprefix*/oldimage (
162 oi_name varchar(255) default '',
163 oi_archive_name varchar(255) default '',
164 oi_size INTEGER default 0,
165 oi_width INTEGER default 0,
166 oi_height INTEGER default 0,
167 oi_bits INTEGER default 0,
168 oi_description tinyblob ,
169 oi_user INTEGER default '0',
170 oi_user_text varchar(255) ,
171 oi_timestamp BLOB default '',
172 oi_metadata mediumblob ,
173 oi_media_type TEXT default NULL,
174 oi_major_mime TEXT default "unknown",
175 oi_minor_mime varBLOB default "unknown",
176 oi_deleted tinyint default '0',
177 oi_sha1 varBLOB default '') /*$wgDBTableOptions*/;
179 CREATE TABLE /*$wgDBprefix*/filearchive (
180 fa_id INTEGER PRIMARY KEY AUTOINCREMENT,
181 fa_name varchar(255) default '',
182 fa_archive_name varchar(255) default '',
183 fa_storage_group varBLOB,
184 fa_storage_key varBLOB default '',
186 fa_deleted_timestamp BLOB default '',
187 fa_deleted_reason text,
188 fa_size INTEGER default '0',
189 fa_width INTEGER default '0',
190 fa_height INTEGER default '0',
191 fa_metadata mediumblob,
192 fa_bits INTEGER default '0',
193 fa_media_type TEXT default NULL,
194 fa_major_mime TEXT default "unknown",
195 fa_minor_mime varBLOB default "unknown",
196 fa_description tinyblob,
197 fa_user INTEGER default '0',
198 fa_user_text varchar(255) ,
199 fa_timestamp BLOB default '',
200 fa_deleted tinyint default '0') /*$wgDBTableOptions*/;
202 CREATE TABLE /*$wgDBprefix*/recentchanges (
203 rc_id INTEGER PRIMARY KEY AUTOINCREMENT,
204 rc_timestamp varBLOB default '',
205 rc_cur_time varBLOB default '',
206 rc_user INTEGER default '0',
207 rc_user_text varchar(255) ,
208 rc_namespace INTEGER default '0',
209 rc_title varchar(255) default '',
210 rc_comment varchar(255) default '',
211 rc_minor tinyint default '0',
212 rc_bot tinyint default '0',
213 rc_new tinyint default '0',
214 rc_cur_id INTEGER default '0',
215 rc_this_oldid INTEGER default '0',
216 rc_last_oldid INTEGER default '0',
217 rc_type tinyint default '0',
218 rc_moved_to_ns tinyint default '0',
219 rc_moved_to_title varchar(255) default '',
220 rc_patrolled tinyint default '0',
221 rc_ip varBLOB default '',
224 rc_deleted tinyint default '0',
225 rc_logid INTEGER default '0',
226 rc_log_type varBLOB NULL default NULL,
227 rc_log_action varBLOB NULL default NULL,
228 rc_params blob NULL) /*$wgDBTableOptions*/;
230 CREATE TABLE /*$wgDBprefix*/watchlist (
232 wl_namespace INTEGER default '0',
233 wl_title varchar(255) default '',
234 wl_notificationtimestamp varBLOB) /*$wgDBTableOptions*/;
236 CREATE TABLE /*$wgDBprefix*/math (
237 math_inputhash varBLOB ,
238 math_outputhash varBLOB ,
239 math_html_conservativeness tinyint ,
241 math_mathml text) /*$wgDBTableOptions*/;
243 CREATE TABLE /*$wgDBprefix*/searchindex (
245 si_title varchar(255) default '',
246 si_text mediumtext ) ;
248 CREATE TABLE /*$wgDBprefix*/interwiki (
249 iw_prefix varchar(32) ,
252 iw_trans tinyint default 0) /*$wgDBTableOptions*/;
254 CREATE TABLE /*$wgDBprefix*/querycache (
256 qc_value INTEGER default '0',
257 qc_namespace INTEGER default '0',
258 qc_title varchar(255) default '') /*$wgDBTableOptions*/;
260 CREATE TABLE /*$wgDBprefix*/objectcache (
261 keyname varBLOB default '',
263 exptime datetime) /*$wgDBTableOptions*/;
265 CREATE TABLE /*$wgDBprefix*/transcache (
268 tc_time INTEGER ) /*$wgDBTableOptions*/;
270 CREATE TABLE /*$wgDBprefix*/logging (
271 log_id INTEGER PRIMARY KEY AUTOINCREMENT,
272 log_type varBLOB default '',
273 log_action varBLOB default '',
274 log_timestamp BLOB default '19700101000000',
275 log_user INTEGER default 0,
276 log_namespace INTEGER default 0,
277 log_title varchar(255) default '',
278 log_comment varchar(255) default '',
280 log_deleted tinyint default '0') /*$wgDBTableOptions*/;
282 CREATE TABLE /*$wgDBprefix*/trackbacks (
283 tb_id INTEGER PRIMARY KEY AUTOINCREMENT,
284 tb_page INTEGER REFERENCES /*$wgDBprefix*/page(page_id) ON DELETE CASCADE,
285 tb_title varchar(255) ,
288 tb_name varchar(255)) /*$wgDBTableOptions*/;
290 CREATE TABLE /*$wgDBprefix*/job (
291 job_id INTEGER PRIMARY KEY AUTOINCREMENT,
292 job_cmd varBLOB default '',
293 job_namespace INTEGER ,
294 job_title varchar(255) ,
295 job_params blob ) /*$wgDBTableOptions*/;
297 CREATE TABLE /*$wgDBprefix*/querycache_info (
298 qci_type varBLOB default '',
299 qci_timestamp BLOB default '19700101000000') /*$wgDBTableOptions*/;
301 CREATE TABLE /*$wgDBprefix*/redirect (
302 rd_from INTEGER default '0',
303 rd_namespace INTEGER default '0',
304 rd_title varchar(255) default '') /*$wgDBTableOptions*/;
306 CREATE TABLE /*$wgDBprefix*/querycachetwo (
308 qcc_value INTEGER default '0',
309 qcc_namespace INTEGER default '0',
310 qcc_title varchar(255) default '',
311 qcc_namespacetwo INTEGER default '0',
312 qcc_titletwo varchar(255) default '') /*$wgDBTableOptions*/;
314 CREATE TABLE /*$wgDBprefix*/page_restrictions (
319 pr_user INTEGER NULL,
320 pr_expiry varBLOB NULL,
321 pr_id INTEGER PRIMARY KEY AUTOINCREMENT) /*$wgDBTableOptions*/;
323 CREATE TABLE /*$wgDBprefix*/protected_titles (
324 pt_namespace INTEGER ,
325 pt_title varchar(255) ,
329 pt_expiry varBLOB default '',
330 pt_create_perm varBLOB ) /*$wgDBTableOptions*/;
332 CREATE TABLE /*$wgDBprefix*/page_props (
334 pp_propname varBLOB ,
335 pp_value blob ) /*$wgDBTableOptions*/;
337 CREATE TABLE /*$wgDBprefix*/updatelog (
338 ul_key varchar(255) ) /*$wgDBTableOptions*/;