summaryrefslogtreecommitdiff
path: root/tests/phpunit/data/db/sqlite/tables-1.13.sql
blob: 66847ab1790a50bd3ca6894e7e7b1ac467781e52 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
-- This is a copy of SQLite schema from MediaWiki 1.13 used for updater testing

CREATE TABLE /*$wgDBprefix*/user (
  user_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  user_name varchar(255)   default '',
  user_real_name varchar(255)   default '',
  user_password tinyblob ,
  user_newpassword tinyblob ,
  user_newpass_time BLOB,
  user_email tinytext ,
  user_options blob ,
  user_touched BLOB  default '',
  user_token BLOB  default '',
  user_email_authenticated BLOB,
  user_email_token BLOB,
  user_email_token_expires BLOB,
  user_registration BLOB,
  user_editcount int) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/user_groups (
  ug_user INTEGER  default '0',
  ug_group varBLOB  default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/user_newtalk (
  user_id INTEGER  default '0',
  user_ip varBLOB  default '',
  user_last_timestamp BLOB  default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/page (
  page_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  page_namespace INTEGER ,
  page_title varchar(255)  ,
  page_restrictions tinyblob ,
  page_counter bigint  default '0',
  page_is_redirect tinyint  default '0',
  page_is_new tinyint  default '0',
  page_random real ,
  page_touched BLOB  default '',
  page_latest INTEGER ,
  page_len INTEGER ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/revision (
  rev_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  rev_page INTEGER ,
  rev_text_id INTEGER ,
  rev_comment tinyblob ,
  rev_user INTEGER  default '0',
  rev_user_text varchar(255)   default '',
  rev_timestamp BLOB  default '',
  rev_minor_edit tinyint  default '0',
  rev_deleted tinyint  default '0',
  rev_len int,
  rev_parent_id INTEGER default NULL) /*$wgDBTableOptions*/  ;

CREATE TABLE /*$wgDBprefix*/text (
  old_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  old_text mediumblob ,
  old_flags tinyblob ) /*$wgDBTableOptions*/  ;

CREATE TABLE /*$wgDBprefix*/archive (
  ar_namespace INTEGER  default '0',
  ar_title varchar(255)   default '',
  ar_text mediumblob ,
  ar_comment tinyblob ,
  ar_user INTEGER  default '0',
  ar_user_text varchar(255)  ,
  ar_timestamp BLOB  default '',
  ar_minor_edit tinyint  default '0',
  ar_flags tinyblob ,
  ar_rev_id int,
  ar_text_id int,
  ar_deleted tinyint  default '0',
  ar_len int,
  ar_page_id int,
  ar_parent_id INTEGER default NULL) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/pagelinks (
  pl_from INTEGER  default '0',
  pl_namespace INTEGER  default '0',
  pl_title varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/templatelinks (
  tl_from INTEGER  default '0',
  tl_namespace INTEGER  default '0',
  tl_title varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/imagelinks (
  il_from INTEGER  default '0',
  il_to varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/categorylinks (
  cl_from INTEGER  default '0',
  cl_to varchar(255)   default '',
  cl_sortkey varchar(70)   default '',
  cl_timestamp timestamp ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/category (
  cat_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  cat_title varchar(255)  ,
  cat_pages INTEGER signed  default 0,
  cat_subcats INTEGER signed  default 0,
  cat_files INTEGER signed  default 0,
  cat_hidden tinyint  default 0) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/externallinks (
  el_from INTEGER  default '0',
  el_to blob ,
  el_index blob ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/langlinks (
  ll_from INTEGER  default '0',
  ll_lang varBLOB  default '',
  ll_title varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/site_stats (
  ss_row_id INTEGER ,
  ss_total_views bigint default '0',
  ss_total_edits bigint default '0',
  ss_good_articles bigint default '0',
  ss_total_pages bigint default '-1',
  ss_users bigint default '-1',
  ss_admins INTEGER default '-1',
  ss_images INTEGER default '0') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/hitcounter (
  hc_id INTEGER
)  ;

CREATE TABLE /*$wgDBprefix*/ipblocks (
  ipb_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  ipb_address tinyblob ,
  ipb_user INTEGER  default '0',
  ipb_by INTEGER  default '0',
  ipb_by_text varchar(255)   default '',
  ipb_reason tinyblob ,
  ipb_timestamp BLOB  default '',
  ipb_auto bool  default 0,
  ipb_anon_only bool  default 0,
  ipb_create_account bool  default 1,
  ipb_enable_autoblock bool  default '1',
  ipb_expiry varBLOB  default '',
  ipb_range_start tinyblob ,
  ipb_range_end tinyblob ,
  ipb_deleted bool  default 0,
  ipb_block_email bool  default 0) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/image (
  img_name varchar(255)   default '',
  img_size INTEGER  default '0',
  img_width INTEGER  default '0',
  img_height INTEGER  default '0',
  img_metadata mediumblob ,
  img_bits INTEGER  default '0',
  img_media_type TEXT default NULL,
  img_major_mime TEXT  default "unknown",
  img_minor_mime varBLOB  default "unknown",
  img_description tinyblob ,
  img_user INTEGER  default '0',
  img_user_text varchar(255)  ,
  img_timestamp varBLOB  default '',
  img_sha1 varBLOB  default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/oldimage (
  oi_name varchar(255)   default '',
  oi_archive_name varchar(255)   default '',
  oi_size INTEGER  default 0,
  oi_width INTEGER  default 0,
  oi_height INTEGER  default 0,
  oi_bits INTEGER  default 0,
  oi_description tinyblob ,
  oi_user INTEGER  default '0',
  oi_user_text varchar(255)  ,
  oi_timestamp BLOB  default '',
  oi_metadata mediumblob ,
  oi_media_type TEXT default NULL,
  oi_major_mime TEXT  default "unknown",
  oi_minor_mime varBLOB  default "unknown",
  oi_deleted tinyint  default '0',
  oi_sha1 varBLOB  default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/filearchive (
  fa_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  fa_name varchar(255)   default '',
  fa_archive_name varchar(255)  default '',
  fa_storage_group varBLOB,
  fa_storage_key varBLOB default '',
  fa_deleted_user int,
  fa_deleted_timestamp BLOB default '',
  fa_deleted_reason text,
  fa_size INTEGER default '0',
  fa_width INTEGER default '0',
  fa_height INTEGER default '0',
  fa_metadata mediumblob,
  fa_bits INTEGER default '0',
  fa_media_type TEXT default NULL,
  fa_major_mime TEXT default "unknown",
  fa_minor_mime varBLOB default "unknown",
  fa_description tinyblob,
  fa_user INTEGER default '0',
  fa_user_text varchar(255) ,
  fa_timestamp BLOB default '',
  fa_deleted tinyint  default '0') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/recentchanges (
  rc_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  rc_timestamp varBLOB  default '',
  rc_cur_time varBLOB  default '',
  rc_user INTEGER  default '0',
  rc_user_text varchar(255)  ,
  rc_namespace INTEGER  default '0',
  rc_title varchar(255)   default '',
  rc_comment varchar(255)   default '',
  rc_minor tinyint  default '0',
  rc_bot tinyint  default '0',
  rc_new tinyint  default '0',
  rc_cur_id INTEGER  default '0',
  rc_this_oldid INTEGER  default '0',
  rc_last_oldid INTEGER  default '0',
  rc_type tinyint  default '0',
  rc_moved_to_ns tinyint  default '0',
  rc_moved_to_title varchar(255)   default '',
  rc_patrolled tinyint  default '0',
  rc_ip varBLOB  default '',
  rc_old_len int,
  rc_new_len int,
  rc_deleted tinyint  default '0',
  rc_logid INTEGER  default '0',
  rc_log_type varBLOB NULL default NULL,
  rc_log_action varBLOB NULL default NULL,
  rc_params blob NULL) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/watchlist (
  wl_user INTEGER ,
  wl_namespace INTEGER  default '0',
  wl_title varchar(255)   default '',
  wl_notificationtimestamp varBLOB) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/math (
  math_inputhash varBLOB ,
  math_outputhash varBLOB ,
  math_html_conservativeness tinyint ,
  math_html text,
  math_mathml text) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/searchindex (
  si_page INTEGER ,
  si_title varchar(255)  default '',
  si_text mediumtext ) ;

CREATE TABLE /*$wgDBprefix*/interwiki (
  iw_prefix varchar(32) ,
  iw_url blob ,
  iw_local bool ,
  iw_trans tinyint  default 0) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/querycache (
  qc_type varBLOB ,
  qc_value INTEGER  default '0',
  qc_namespace INTEGER  default '0',
  qc_title varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/objectcache (
  keyname varBLOB  default '',
  value mediumblob,
  exptime datetime) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/transcache (
  tc_url varBLOB ,
  tc_contents text,
  tc_time INTEGER ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/logging (
  log_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  log_type varBLOB  default '',
  log_action varBLOB  default '',
  log_timestamp BLOB  default '19700101000000',
  log_user INTEGER  default 0,
  log_namespace INTEGER  default 0,
  log_title varchar(255)   default '',
  log_comment varchar(255)  default '',
  log_params blob ,
  log_deleted tinyint  default '0') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/trackbacks (
  tb_id INTEGER PRIMARY KEY AUTOINCREMENT,
  tb_page INTEGER REFERENCES /*$wgDBprefix*/page(page_id) ON DELETE CASCADE,
  tb_title varchar(255) ,
  tb_url blob ,
  tb_ex text,
  tb_name varchar(255)) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/job (
  job_id INTEGER  PRIMARY KEY AUTOINCREMENT,
  job_cmd varBLOB  default '',
  job_namespace INTEGER ,
  job_title varchar(255)  ,
  job_params blob ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/querycache_info (
  qci_type varBLOB  default '',
  qci_timestamp BLOB  default '19700101000000') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/redirect (
  rd_from INTEGER  default '0',
  rd_namespace INTEGER  default '0',
  rd_title varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/querycachetwo (
  qcc_type varBLOB ,
  qcc_value INTEGER  default '0',
  qcc_namespace INTEGER  default '0',
  qcc_title varchar(255)   default '',
  qcc_namespacetwo INTEGER  default '0',
  qcc_titletwo varchar(255)   default '') /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/page_restrictions (
  pr_page INTEGER ,
  pr_type varBLOB ,
  pr_level varBLOB ,
  pr_cascade tinyint ,
  pr_user INTEGER NULL,
  pr_expiry varBLOB NULL,
  pr_id INTEGER  PRIMARY KEY AUTOINCREMENT) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/protected_titles (
  pt_namespace INTEGER ,
  pt_title varchar(255)  ,
  pt_user INTEGER ,
  pt_reason tinyblob,
  pt_timestamp BLOB ,
  pt_expiry varBLOB  default '',
  pt_create_perm varBLOB ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/page_props (
  pp_page INTEGER ,
  pp_propname varBLOB ,
  pp_value blob ) /*$wgDBTableOptions*/;

CREATE TABLE /*$wgDBprefix*/updatelog (
  ul_key varchar(255) ) /*$wgDBTableOptions*/;