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*/;