1 CREATE TABLE /*$wgDBprefix*/user (
2 user_id
int NOT NULL IDENTITY(1,1),
3 user_name
varchar(255) NOT NULL default '',
4 user_real_name
varchar(255) NOT NULL default '',
5 user_password
text NOT NULL,
6 user_newpassword
text NOT NULL,
7 user_newpass_time
varchar(5) NULL,
8 user_email
text NOT NULL,
9 user_options
text NOT NULL,
10 user_touched
varchar(5) NOT NULL default '',
11 user_token
varchar(10) NOT NULL default '',
12 user_email_authenticated
varchar(5) NULL,
13 user_email_token
varchar(10) NULL,
14 user_email_token_expires
varchar(5) NULL,
15 user_registration
varchar(5) NULL,
20 CREATE TABLE /*$wgDBprefix*/user_groups (
21 ug_user
int NOT NULL default '0',
22 ug_group
varchar(5) NOT NULL default '',
23 PRIMARY KEY (ug_user
,ug_group
)
26 CREATE TABLE /*$wgDBprefix*/user_newtalk (
27 user_id
int NOT NULL default '0',
28 user_ip
varchar(13) NOT NULL default '',
29 user_last_timestamp
varchar(5) NOT NULL default ''
32 CREATE TABLE /*$wgDBprefix*/page (
33 page_id
int NOT NULL IDENTITY(1,1),
34 page_namespace
int NOT NULL,
35 page_title
varchar(255) NOT NULL,
36 page_restrictions
text NOT NULL,
37 page_counter
bigint NOT NULL default '0',
38 page_is_redirect tinyint
NOT NULL default '0',
39 page_is_new tinyint
NOT NULL default '0',
40 page_random
real NOT NULL,
41 page_touched
varchar(5) NOT NULL default '',
42 page_latest
int NOT NULL,
43 page_len
int NOT NULL,
47 CREATE TABLE /*$wgDBprefix*/revision (
48 rev_id
int NOT NULL IDENTITY(1,1),
49 rev_page
int NOT NULL,
50 rev_text_id
int NOT NULL,
51 rev_comment
text NOT NULL,
52 rev_user
int NOT NULL default '0',
53 rev_user_text
varchar(255) NOT NULL default '',
54 rev_timestamp
varchar(5) NOT NULL default '',
55 rev_minor_edit tinyint
NOT NULL default '0',
56 rev_deleted tinyint
NOT NULL default '0',
58 rev_parent_id
int default NULL,
59 PRIMARY KEY (rev_page
, rev_id
)
62 CREATE TABLE /*$wgDBprefix*/text (
63 old_id
int NOT NULL IDENTITY(1,1),
64 old_text
text NOT NULL,
65 old_flags
text NOT NULL,
69 CREATE TABLE /*$wgDBprefix*/archive (
70 ar_namespace
int NOT NULL default '0',
71 ar_title
varchar(255) NOT NULL default '',
72 ar_text
text NOT NULL,
73 ar_comment
text NOT NULL,
74 ar_user
int NOT NULL default '0',
75 ar_user_text
varchar(255) NOT NULL,
76 ar_timestamp
varchar(5) NOT NULL default '',
77 ar_minor_edit tinyint
NOT NULL default '0',
78 ar_flags
text NOT NULL,
81 ar_deleted tinyint
NOT NULL default '0',
84 ar_parent_id
int default NULL
87 CREATE TABLE /*$wgDBprefix*/pagelinks (
88 pl_from
int NOT NULL default '0',
89 pl_namespace
int NOT NULL default '0',
90 pl_title
varchar(255) NOT NULL default ''
93 CREATE TABLE /*$wgDBprefix*/templatelinks (
94 tl_from
int NOT NULL default '0',
95 tl_namespace
int NOT NULL default '0',
96 tl_title
varchar(255) NOT NULL default ''
99 CREATE TABLE /*$wgDBprefix*/imagelinks (
100 il_from
int NOT NULL default '0',
101 il_to
varchar(255) NOT NULL default ''
104 CREATE TABLE /*$wgDBprefix*/categorylinks (
105 cl_from
int NOT NULL default '0',
106 cl_to
varchar(255) NOT NULL default '',
107 cl_sortkey
varchar(70) NOT NULL default '',
108 cl_timestamp
timestamp NOT NULL
111 CREATE TABLE /*$wgDBprefix*/category (
112 cat_id
int NOT NULL IDENTITY(1,1),
113 cat_title
varchar(255) NOT NULL,
114 cat_pages
int NOT NULL default 0,
115 cat_subcats
int NOT NULL default 0,
116 cat_files
int NOT NULL default 0,
117 cat_hidden tinyint
NOT NULL default 0,
121 CREATE TABLE /*$wgDBprefix*/externallinks (
122 el_from
int NOT NULL default '0',
124 el_index
text NOT NULL
127 CREATE TABLE /*$wgDBprefix*/langlinks (
128 ll_from
int NOT NULL default '0',
129 ll_lang
varchar(7) NOT NULL default '',
130 ll_title
varchar(255) NOT NULL default ''
133 CREATE TABLE /*$wgDBprefix*/site_stats (
134 ss_row_id
int NOT NULL,
135 ss_total_views
bigint default '0',
136 ss_total_edits
bigint default '0',
137 ss_good_articles
bigint default '0',
138 ss_total_pages
bigint default '-1',
139 ss_users
bigint default '-1',
140 ss_admins
int default '-1',
141 ss_images
int default '0'
144 CREATE TABLE /*$wgDBprefix*/hitcounter (
148 CREATE TABLE /*$wgDBprefix*/ipblocks (
149 ipb_id
int NOT NULL IDENTITY(1,1),
150 ipb_address
text NOT NULL,
151 ipb_user
int NOT NULL default '0',
152 ipb_by
int NOT NULL default '0',
153 ipb_by_text
varchar(255) NOT NULL default '',
154 ipb_reason
text NOT NULL,
155 ipb_timestamp
varchar(5) NOT NULL default '',
156 ipb_auto
bit NOT NULL default 0,
157 ipb_anon_only
bit NOT NULL default 0,
158 ipb_create_account
bit NOT NULL default 1,
159 ipb_enable_autoblock
bit NOT NULL default '1',
160 ipb_expiry
varchar(5) NOT NULL default '',
161 ipb_range_start
text NOT NULL,
162 ipb_range_end
text NOT NULL,
163 ipb_deleted
bit NOT NULL default 0,
164 ipb_block_email
bit NOT NULL default 0,
168 CREATE TABLE /*$wgDBprefix*/image (
169 img_name
varchar(255) NOT NULL default '',
170 img_size
int NOT NULL default '0',
171 img_width
int NOT NULL default '0',
172 img_height
int NOT NULL default '0',
173 img_metadata
text NOT NULL,
174 img_bits
int NOT NULL default '0',
175 img_media_type
TEXT default NULL,
176 img_major_mime
TEXT NOT NULL default "unknown",
177 img_minor_mime
varchar(10) NOT NULL default "unknown",
178 img_description
text NOT NULL,
179 img_user
int NOT NULL default '0',
180 img_user_text
varchar(255) NOT NULL,
181 img_timestamp
varchar(5) NOT NULL default '',
182 img_sha1
varchar(10) NOT NULL default '',
183 PRIMARY KEY (img_name
)
186 CREATE TABLE /*$wgDBprefix*/oldimage (
187 oi_name
varchar(255) NOT NULL default '',
188 oi_archive_name
varchar(255) NOT NULL default '',
189 oi_size
int NOT NULL default 0,
190 oi_width
int NOT NULL default 0,
191 oi_height
int NOT NULL default 0,
192 oi_bits
int NOT NULL default 0,
193 oi_description
text NOT NULL,
194 oi_user
int NOT NULL default '0',
195 oi_user_text
varchar(255) NOT NULL,
196 oi_timestamp
varchar(5) NOT NULL default '',
197 oi_metadata
text NOT NULL,
198 oi_media_type
TEXT default NULL,
199 oi_major_mime
TEXT NOT NULL default "unknown",
200 oi_minor_mime
varchar(10) NOT NULL default "unknown",
201 oi_deleted tinyint
NOT NULL default '0',
202 oi_sha1
varchar(10) NOT NULL default ''
205 CREATE TABLE /*$wgDBprefix*/filearchive (
206 fa_id
int NOT NULL IDENTITY(1,1),
207 fa_name
varchar(255) NOT NULL default '',
208 fa_archive_name
varchar(255) NULL default '',
209 fa_storage_group
varchar(5) NULL,
210 fa_storage_key
varchar(17) NULL default '',
212 fa_deleted_timestamp
varchar(5) NULL default '',
213 fa_deleted_reason
text,
214 fa_size
int default '0',
215 fa_width
int default '0',
216 fa_height
int default '0',
218 fa_bits
int default '0',
219 fa_media_type
TEXT default NULL,
220 fa_major_mime
TEXT default "unknown",
221 fa_minor_mime
varchar(10) NULL default "unknown",
223 fa_user
int default '0',
224 fa_user_text
varchar(255) NULL,
225 fa_timestamp
varchar(5) NULL default '',
226 fa_deleted tinyint
NOT NULL default '0',
230 CREATE TABLE /*$wgDBprefix*/recentchanges (
231 rc_id
int NOT NULL IDENTITY(1,1),
232 rc_timestamp
varchar(5) NOT NULL default '',
233 rc_cur_time
varchar(5) NOT NULL default '',
234 rc_user
int NOT NULL default '0',
235 rc_user_text
varchar(255) NOT NULL,
236 rc_namespace
int NOT NULL default '0',
237 rc_title
varchar(255) NOT NULL default '',
238 rc_comment
varchar(255) NOT NULL default '',
239 rc_minor tinyint
NOT NULL default '0',
240 rc_bot tinyint
NOT NULL default '0',
241 rc_new tinyint
NOT NULL default '0',
242 rc_cur_id
int NOT NULL default '0',
243 rc_this_oldid
int NOT NULL default '0',
244 rc_last_oldid
int NOT NULL default '0',
245 rc_type tinyint
NOT NULL default '0',
246 rc_moved_to_ns tinyint
NOT NULL default '0',
247 rc_moved_to_title
varchar(255) NOT NULL default '',
248 rc_patrolled tinyint
NOT NULL default '0',
249 rc_ip
varchar(13) NOT NULL default '',
252 rc_deleted tinyint
NOT NULL default '0',
253 rc_logid
int NOT NULL default '0',
254 rc_log_type
varchar(17) NULL default NULL,
255 rc_log_action
varchar(17) NULL default NULL,
260 CREATE TABLE /*$wgDBprefix*/watchlist (
261 wl_user
int NOT NULL,
262 wl_namespace
int NOT NULL default '0',
263 wl_title
varchar(255) NOT NULL default '',
264 wl_notificationtimestamp
varchar(5) NULL
267 CREATE TABLE /*$wgDBprefix*/math (
268 math_inputhash
varchar(5) NOT NULL,
269 math_outputhash
varchar(5) NOT NULL,
270 math_html_conservativeness tinyint
NOT NULL,
275 CREATE TABLE /*$wgDBprefix*/searchindex (
276 si_page
int NOT NULL,
277 si_title
varchar(255) NOT NULL default '',
278 si_text
text NOT NULL
281 CREATE TABLE /*$wgDBprefix*/interwiki (
282 iw_prefix
varchar(32) NOT NULL,
283 iw_url
text NOT NULL,
284 iw_local
bit NOT NULL,
285 iw_trans tinyint
NOT NULL default 0
288 CREATE TABLE /*$wgDBprefix*/querycache (
289 qc_type
varchar(10) NOT NULL,
290 qc_value
int NOT NULL default '0',
291 qc_namespace
int NOT NULL default '0',
292 qc_title
varchar(255) NOT NULL default ''
295 CREATE TABLE /*$wgDBprefix*/objectcache (
296 keyname
varchar(17) NOT NULL default '',
301 CREATE TABLE /*$wgDBprefix*/transcache (
302 tc_url
varchar(17) NOT NULL,
307 CREATE TABLE /*$wgDBprefix*/logging (
308 log_id
int NOT NULL IDENTITY(1,1),
309 log_type
varchar(4) NOT NULL default '',
310 log_action
varchar(4) NOT NULL default '',
311 log_timestamp
varchar(5) NOT NULL default '19700101000000',
312 log_user
int NOT NULL default 0,
313 log_namespace
int NOT NULL default 0,
314 log_title
varchar(255) NOT NULL default '',
315 log_comment
varchar(255) NOT NULL default '',
316 log_params
text NOT NULL,
317 log_deleted tinyint
NOT NULL default '0',
321 CREATE TABLE /*$wgDBprefix*/trackbacks (
322 tb_id
int IDENTITY(1,1),
323 tb_page
int REFERENCES /*$wgDBprefix*/page(page_id
) ON DELETE CASCADE,
324 tb_title
varchar(255) NOT NULL,
325 tb_url
text NOT NULL,
327 tb_name
varchar(255) NULL,
331 CREATE TABLE /*$wgDBprefix*/job (
332 job_id
int NOT NULL IDENTITY(1,1),
333 job_cmd
varchar(17) NOT NULL default '',
334 job_namespace
int NOT NULL,
335 job_title
varchar(255) NOT NULL,
336 job_params
text NOT NULL,
340 CREATE TABLE /*$wgDBprefix*/querycache_info (
341 qci_type
varchar(10) NOT NULL default '',
342 qci_timestamp
varchar(5) NOT NULL default '19700101000000'
345 CREATE TABLE /*$wgDBprefix*/redirect (
346 rd_from
int NOT NULL default '0',
347 rd_namespace
int NOT NULL default '0',
348 rd_title
varchar(255) NOT NULL default '',
349 PRIMARY KEY (rd_from
)
352 CREATE TABLE /*$wgDBprefix*/querycachetwo (
353 qcc_type
varchar(10) NOT NULL,
354 qcc_value
int NOT NULL default '0',
355 qcc_namespace
int NOT NULL default '0',
356 qcc_title
varchar(255) NOT NULL default '',
357 qcc_namespacetwo
int NOT NULL default '0',
358 qcc_titletwo
varchar(255) NOT NULL default ''
361 CREATE TABLE /*$wgDBprefix*/page_restrictions (
362 pr_page
int NOT NULL,
363 pr_type
varchar(17) NOT NULL,
364 pr_level
varchar(17) NOT NULL,
365 pr_cascade tinyint
NOT NULL,
367 pr_expiry
varchar(5) NULL,
368 pr_id
int NOT NULL IDENTITY(1,1),
369 PRIMARY KEY (pr_page
,pr_type
)
372 CREATE TABLE /*$wgDBprefix*/protected_titles (
373 pt_namespace
int NOT NULL,
374 pt_title
varchar(255) NOT NULL,
375 pt_user
int NOT NULL,
377 pt_timestamp
varchar(5) NOT NULL,
378 pt_expiry
varchar(5) NOT NULL default '',
379 pt_create_perm
varchar(17) NOT NULL,
380 PRIMARY KEY (pt_namespace
,pt_title
)
383 CREATE TABLE /*$wgDBprefix*/page_props (
384 pp_page
int NOT NULL,
385 pp_propname
varchar(17) NOT NULL,
386 pp_value
text NOT NULL,
387 PRIMARY KEY (pp_page
,pp_propname
)
390 CREATE TABLE /*$wgDBprefix*/updatelog (
391 ul_key
varchar(255) NOT NULL,