1 -- MySQL dump 10.13 Distrib 5.1.41, for Win32 (ia32)
3 -- Host: localhost Database: test_wiki
4 -- ------------------------------------------------------
5 -- Server version 5.1.41
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19 -- Table structure for table `mw_archive`
22 DROP TABLE IF EXISTS `mw_archive`
;
23 /*!40101 SET @saved_cs_client = @@character_set_client */;
24 /*!40101 SET character_set_client = utf8 */;
25 CREATE TABLE `mw_archive`
(
26 `ar_namespace`
int(11) NOT NULL DEFAULT '0',
27 `ar_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
28 `ar_text` mediumblob
NOT NULL,
29 `ar_comment` tinyblob
NOT NULL,
30 `ar_user`
int(10) unsigned
NOT NULL DEFAULT '0',
31 `ar_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
32 `ar_timestamp`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
33 `ar_minor_edit`
tinyint(4) NOT NULL DEFAULT '0',
34 `ar_flags` tinyblob
NOT NULL,
35 `ar_rev_id`
int(10) unsigned
DEFAULT NULL,
36 `ar_text_id`
int(10) unsigned
DEFAULT NULL,
37 `ar_deleted`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
38 `ar_len`
int(10) unsigned
DEFAULT NULL,
39 `ar_page_id`
int(10) unsigned
DEFAULT NULL,
40 `ar_parent_id`
int(10) unsigned
DEFAULT NULL,
41 KEY `name_title_timestamp`
(`ar_namespace`
,`ar_title`
,`ar_timestamp`
),
42 KEY `usertext_timestamp`
(`ar_user_text`
,`ar_timestamp`
),
43 KEY `ar_page_revid`
(`ar_namespace`
,`ar_title`
,`ar_rev_id`
)
44 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
45 /*!40101 SET character_set_client = @saved_cs_client */;
48 -- Dumping data for table `mw_archive`
51 LOCK TABLES `mw_archive`
WRITE;
52 /*!40000 ALTER TABLE `mw_archive` DISABLE KEYS */;
53 /*!40000 ALTER TABLE `mw_archive` ENABLE KEYS */;
57 -- Table structure for table `mw_category`
60 DROP TABLE IF EXISTS `mw_category`
;
61 /*!40101 SET @saved_cs_client = @@character_set_client */;
62 /*!40101 SET character_set_client = utf8 */;
63 CREATE TABLE `mw_category`
(
64 `cat_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
65 `cat_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
66 `cat_pages`
int(11) NOT NULL DEFAULT '0',
67 `cat_subcats`
int(11) NOT NULL DEFAULT '0',
68 `cat_files`
int(11) NOT NULL DEFAULT '0',
69 `cat_hidden`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
70 PRIMARY KEY (`cat_id`
),
71 UNIQUE KEY `cat_title`
(`cat_title`
),
72 KEY `cat_pages`
(`cat_pages`
)
73 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
74 /*!40101 SET character_set_client = @saved_cs_client */;
77 -- Dumping data for table `mw_category`
80 LOCK TABLES `mw_category`
WRITE;
81 /*!40000 ALTER TABLE `mw_category` DISABLE KEYS */;
82 /*!40000 ALTER TABLE `mw_category` ENABLE KEYS */;
86 -- Table structure for table `mw_categorylinks`
89 DROP TABLE IF EXISTS `mw_categorylinks`
;
90 /*!40101 SET @saved_cs_client = @@character_set_client */;
91 /*!40101 SET character_set_client = utf8 */;
92 CREATE TABLE `mw_categorylinks`
(
93 `cl_from`
int(10) unsigned
NOT NULL DEFAULT '0',
94 `cl_to`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
95 `cl_sortkey`
varbinary(230) NOT NULL DEFAULT '',
96 `cl_sortkey_prefix`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
97 `cl_timestamp`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
98 `cl_collation`
varbinary(32) NOT NULL DEFAULT '',
99 `cl_type`
enum('page','subcat','file') NOT NULL DEFAULT 'page',
100 UNIQUE KEY `cl_from`
(`cl_from`
,`cl_to`
),
101 KEY `cl_sortkey`
(`cl_to`
,`cl_type`
,`cl_sortkey`
,`cl_from`
),
102 KEY `cl_timestamp`
(`cl_to`
,`cl_timestamp`
),
103 KEY `cl_collation`
(`cl_collation`
)
104 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
105 /*!40101 SET character_set_client = @saved_cs_client */;
108 -- Dumping data for table `mw_categorylinks`
111 LOCK TABLES `mw_categorylinks`
WRITE;
112 /*!40000 ALTER TABLE `mw_categorylinks` DISABLE KEYS */;
113 /*!40000 ALTER TABLE `mw_categorylinks` ENABLE KEYS */;
117 -- Table structure for table `mw_change_tag`
120 DROP TABLE IF EXISTS `mw_change_tag`
;
121 /*!40101 SET @saved_cs_client = @@character_set_client */;
122 /*!40101 SET character_set_client = utf8 */;
123 CREATE TABLE `mw_change_tag`
(
124 `ct_rc_id`
int(11) DEFAULT NULL,
125 `ct_log_id`
int(11) DEFAULT NULL,
126 `ct_rev_id`
int(11) DEFAULT NULL,
127 `ct_tag`
varchar(255) NOT NULL,
129 UNIQUE KEY `change_tag_rc_tag`
(`ct_rc_id`
,`ct_tag`
),
130 UNIQUE KEY `change_tag_log_tag`
(`ct_log_id`
,`ct_tag`
),
131 UNIQUE KEY `change_tag_rev_tag`
(`ct_rev_id`
,`ct_tag`
),
132 KEY `change_tag_tag_id`
(`ct_tag`
,`ct_rc_id`
,`ct_rev_id`
,`ct_log_id`
)
133 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
134 /*!40101 SET character_set_client = @saved_cs_client */;
137 -- Dumping data for table `mw_change_tag`
140 LOCK TABLES `mw_change_tag`
WRITE;
141 /*!40000 ALTER TABLE `mw_change_tag` DISABLE KEYS */;
142 /*!40000 ALTER TABLE `mw_change_tag` ENABLE KEYS */;
146 -- Table structure for table `mw_external_user`
149 DROP TABLE IF EXISTS `mw_external_user`
;
150 /*!40101 SET @saved_cs_client = @@character_set_client */;
151 /*!40101 SET character_set_client = utf8 */;
152 CREATE TABLE `mw_external_user`
(
153 `eu_local_id`
int(10) unsigned
NOT NULL,
154 `eu_external_id`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
155 PRIMARY KEY (`eu_local_id`
),
156 UNIQUE KEY `eu_external_id`
(`eu_external_id`
)
157 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
158 /*!40101 SET character_set_client = @saved_cs_client */;
161 -- Dumping data for table `mw_external_user`
164 LOCK TABLES `mw_external_user`
WRITE;
165 /*!40000 ALTER TABLE `mw_external_user` DISABLE KEYS */;
166 /*!40000 ALTER TABLE `mw_external_user` ENABLE KEYS */;
170 -- Table structure for table `mw_externallinks`
173 DROP TABLE IF EXISTS `mw_externallinks`
;
174 /*!40101 SET @saved_cs_client = @@character_set_client */;
175 /*!40101 SET character_set_client = utf8 */;
176 CREATE TABLE `mw_externallinks`
(
177 `el_from`
int(10) unsigned
NOT NULL DEFAULT '0',
178 `el_to`
blob NOT NULL,
179 `el_index`
blob NOT NULL,
180 KEY `el_from`
(`el_from`
,`el_to`
(40)),
181 KEY `el_to`
(`el_to`
(60),`el_from`
),
182 KEY `el_index`
(`el_index`
(60))
183 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
184 /*!40101 SET character_set_client = @saved_cs_client */;
187 -- Dumping data for table `mw_externallinks`
190 LOCK TABLES `mw_externallinks`
WRITE;
191 /*!40000 ALTER TABLE `mw_externallinks` DISABLE KEYS */;
192 INSERT INTO `mw_externallinks`
VALUES (1,'http://meta.wikimedia.org/wiki/Help:Contents','http://org.wikimedia.meta./wiki/Help:Contents'),(1,'http://www.mediawiki.org/wiki/Manual:Configuration_settings','http://org.mediawiki.www./wiki/Manual:Configuration_settings'),(1,'http://www.mediawiki.org/wiki/Manual:FAQ','http://org.mediawiki.www./wiki/Manual:FAQ'),(1,'https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce','https://org.wikimedia.lists./mailman/listinfo/mediawiki-announce');
193 /*!40000 ALTER TABLE `mw_externallinks` ENABLE KEYS */;
197 -- Table structure for table `mw_filearchive`
200 DROP TABLE IF EXISTS `mw_filearchive`
;
201 /*!40101 SET @saved_cs_client = @@character_set_client */;
202 /*!40101 SET character_set_client = utf8 */;
203 CREATE TABLE `mw_filearchive`
(
204 `fa_id`
int(11) NOT NULL AUTO_INCREMENT
,
205 `fa_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
206 `fa_archive_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
DEFAULT '',
207 `fa_storage_group`
varbinary(16) DEFAULT NULL,
208 `fa_storage_key`
varbinary(64) DEFAULT '',
209 `fa_deleted_user`
int(11) DEFAULT NULL,
210 `fa_deleted_timestamp`
binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
211 `fa_deleted_reason`
text,
212 `fa_size`
int(10) unsigned
DEFAULT '0',
213 `fa_width`
int(11) DEFAULT '0',
214 `fa_height`
int(11) DEFAULT '0',
215 `fa_metadata` mediumblob
,
216 `fa_bits`
int(11) DEFAULT '0',
217 `fa_media_type`
enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
218 `fa_major_mime`
enum('unknown','application','audio','image','text','video','message','model','multipart') DEFAULT 'unknown',
219 `fa_minor_mime`
varbinary(100) DEFAULT 'unknown',
220 `fa_description` tinyblob
,
221 `fa_user`
int(10) unsigned
DEFAULT '0',
222 `fa_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
DEFAULT NULL,
223 `fa_timestamp`
binary(14) DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
224 `fa_deleted`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
225 PRIMARY KEY (`fa_id`
),
226 KEY `fa_name`
(`fa_name`
,`fa_timestamp`
),
227 KEY `fa_storage_group`
(`fa_storage_group`
,`fa_storage_key`
),
228 KEY `fa_deleted_timestamp`
(`fa_deleted_timestamp`
),
229 KEY `fa_user_timestamp`
(`fa_user_text`
,`fa_timestamp`
)
230 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
231 /*!40101 SET character_set_client = @saved_cs_client */;
234 -- Dumping data for table `mw_filearchive`
237 LOCK TABLES `mw_filearchive`
WRITE;
238 /*!40000 ALTER TABLE `mw_filearchive` DISABLE KEYS */;
239 /*!40000 ALTER TABLE `mw_filearchive` ENABLE KEYS */;
243 -- Table structure for table `mw_hitcounter`
246 DROP TABLE IF EXISTS `mw_hitcounter`
;
247 /*!40101 SET @saved_cs_client = @@character_set_client */;
248 /*!40101 SET character_set_client = utf8 */;
249 CREATE TABLE `mw_hitcounter`
(
250 `hc_id`
int(10) unsigned
NOT NULL
251 ) ENGINE
=MEMORY
DEFAULT CHARSET
=latin1 MAX_ROWS
=25000;
252 /*!40101 SET character_set_client = @saved_cs_client */;
255 -- Dumping data for table `mw_hitcounter`
258 LOCK TABLES `mw_hitcounter`
WRITE;
259 /*!40000 ALTER TABLE `mw_hitcounter` DISABLE KEYS */;
260 /*!40000 ALTER TABLE `mw_hitcounter` ENABLE KEYS */;
264 -- Table structure for table `mw_image`
267 DROP TABLE IF EXISTS `mw_image`
;
268 /*!40101 SET @saved_cs_client = @@character_set_client */;
269 /*!40101 SET character_set_client = utf8 */;
270 CREATE TABLE `mw_image`
(
271 `img_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
272 `img_size`
int(10) unsigned
NOT NULL DEFAULT '0',
273 `img_width`
int(11) NOT NULL DEFAULT '0',
274 `img_height`
int(11) NOT NULL DEFAULT '0',
275 `img_metadata` mediumblob
NOT NULL,
276 `img_bits`
int(11) NOT NULL DEFAULT '0',
277 `img_media_type`
enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
278 `img_major_mime`
enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL DEFAULT 'unknown',
279 `img_minor_mime`
varbinary(100) NOT NULL DEFAULT 'unknown',
280 `img_description` tinyblob
NOT NULL,
281 `img_user`
int(10) unsigned
NOT NULL DEFAULT '0',
282 `img_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
283 `img_timestamp`
varbinary(14) NOT NULL DEFAULT '',
284 `img_sha1`
varbinary(32) NOT NULL DEFAULT '',
285 PRIMARY KEY (`img_name`
),
286 KEY `img_usertext_timestamp`
(`img_user_text`
,`img_timestamp`
),
287 KEY `img_size`
(`img_size`
),
288 KEY `img_timestamp`
(`img_timestamp`
),
289 KEY `img_sha1`
(`img_sha1`
)
290 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
291 /*!40101 SET character_set_client = @saved_cs_client */;
294 -- Dumping data for table `mw_image`
297 LOCK TABLES `mw_image`
WRITE;
298 /*!40000 ALTER TABLE `mw_image` DISABLE KEYS */;
299 INSERT INTO `mw_image`
VALUES ('Wikipedia-logo-v2-de.png',21479,135,155,'a:3:{s:10:\"frameCount\";i:0;s:9:\"loopCount\";i:1;s:8:\"duration\";d:0;}',8,'BITMAP','image','png','',1,'WikiSysop','20110101145907','op7jnibw9b0v4vi4gt48snpf9971bag');
300 /*!40000 ALTER TABLE `mw_image` ENABLE KEYS */;
304 -- Table structure for table `mw_imagelinks`
307 DROP TABLE IF EXISTS `mw_imagelinks`
;
308 /*!40101 SET @saved_cs_client = @@character_set_client */;
309 /*!40101 SET character_set_client = utf8 */;
310 CREATE TABLE `mw_imagelinks`
(
311 `il_from`
int(10) unsigned
NOT NULL DEFAULT '0',
312 `il_to`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
313 UNIQUE KEY `il_from`
(`il_from`
,`il_to`
),
314 UNIQUE KEY `il_to`
(`il_to`
,`il_from`
)
315 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
316 /*!40101 SET character_set_client = @saved_cs_client */;
319 -- Dumping data for table `mw_imagelinks`
322 LOCK TABLES `mw_imagelinks`
WRITE;
323 /*!40000 ALTER TABLE `mw_imagelinks` DISABLE KEYS */;
324 /*!40000 ALTER TABLE `mw_imagelinks` ENABLE KEYS */;
328 -- Table structure for table `mw_interwiki`
331 DROP TABLE IF EXISTS `mw_interwiki`
;
332 /*!40101 SET @saved_cs_client = @@character_set_client */;
333 /*!40101 SET character_set_client = utf8 */;
334 CREATE TABLE `mw_interwiki`
(
335 `iw_prefix`
varchar(32) NOT NULL,
336 `iw_url`
blob NOT NULL,
337 `iw_api`
blob NOT NULL,
338 `iw_wikiid`
varchar(64) NOT NULL,
339 `iw_local`
tinyint(1) NOT NULL,
340 `iw_trans`
tinyint(4) NOT NULL DEFAULT '0',
341 UNIQUE KEY `iw_prefix`
(`iw_prefix`
)
342 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
343 /*!40101 SET character_set_client = @saved_cs_client */;
346 -- Dumping data for table `mw_interwiki`
349 LOCK TABLES `mw_interwiki`
WRITE;
350 /*!40000 ALTER TABLE `mw_interwiki` DISABLE KEYS */;
351 INSERT INTO `mw_interwiki`
VALUES ('acronym','http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=$1','','',0,0),('advogato','http://www.advogato.org/$1','','',0,0),('annotationwiki','http://www.seedwiki.com/page.cfm?wikiid=368&doc=$1','','',0,0),('arxiv','http://www.arxiv.org/abs/$1','','',0,0),('c2find','http://c2.com/cgi/wiki?FindPage&value=$1','','',0,0),('cache','http://www.google.com/search?q=cache:$1','','',0,0),('commons','http://commons.wikimedia.org/wiki/$1','','',0,0),('corpknowpedia','http://corpknowpedia.org/wiki/index.php/$1','','',0,0),('dictionary','http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1','','',0,0),('disinfopedia','http://www.disinfopedia.org/wiki.phtml?title=$1','','',0,0),('docbook','http://wiki.docbook.org/topic/$1','','',0,0),('doi','http://dx.doi.org/$1','','',0,0),('drumcorpswiki','http://www.drumcorpswiki.com/index.php/$1','','',0,0),('dwjwiki','http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1','','',0,0),('elibre','http://enciclopedia.us.es/index.php/$1','','',0,0),('emacswiki','http://www.emacswiki.org/cgi-bin/wiki.pl?$1','','',0,0),('foldoc','http://foldoc.org/?$1','','',0,0),('foxwiki','http://fox.wikis.com/wc.dll?Wiki~$1','','',0,0),('freebsdman','http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1','','',0,0),('gej','http://www.esperanto.de/cgi-bin/aktivikio/wiki.pl?$1','','',0,0),('gentoo-wiki','http://gentoo-wiki.com/$1','','',0,0),('google','http://www.google.com/search?q=$1','','',0,0),('googlegroups','http://groups.google.com/groups?q=$1','','',0,0),('hammondwiki','http://www.dairiki.org/HammondWiki/$1','','',0,0),('hewikisource','http://he.wikisource.org/wiki/$1','','',1,0),('hrwiki','http://www.hrwiki.org/index.php/$1','','',0,0),('imdb','http://us.imdb.com/Title?$1','','',0,0),('jargonfile','http://sunir.org/apps/meta.pl?wiki=JargonFile&redirect=$1','','',0,0),('jspwiki','http://www.jspwiki.org/wiki/$1','','',0,0),('keiki','http://kei.ki/en/$1','','',0,0),('kmwiki','http://kmwiki.wikispaces.com/$1','','',0,0),('linuxwiki','http://linuxwiki.de/$1','','',0,0),('lojban','http://www.lojban.org/tiki/tiki-index.php?page=$1','','',0,0),('lqwiki','http://wiki.linuxquestions.org/wiki/$1','','',0,0),('lugkr','http://lug-kr.sourceforge.net/cgi-bin/lugwiki.pl?$1','','',0,0),('mathsongswiki','http://SeedWiki.com/page.cfm?wikiid=237&doc=$1','','',0,0),('meatball','http://www.usemod.com/cgi-bin/mb.pl?$1','','',0,0),('mediawikiwiki','http://www.mediawiki.org/wiki/$1','','',0,0),('mediazilla','https://bugzilla.wikimedia.org/$1','','',1,0),('memoryalpha','http://www.memory-alpha.org/en/index.php/$1','','',0,0),('metawiki','http://sunir.org/apps/meta.pl?$1','','',0,0),('metawikipedia','http://meta.wikimedia.org/wiki/$1','','',0,0),('moinmoin','http://purl.net/wiki/moin/$1','','',0,0),('mozillawiki','http://wiki.mozilla.org/index.php/$1','','',0,0),('mw','http://www.mediawiki.org/wiki/$1','','',0,0),('oeis','http://www.research.att.com/cgi-bin/access.cgi/as/njas/sequences/eisA.cgi?Anum=$1','','',0,0),('openfacts','http://openfacts.berlios.de/index.phtml?title=$1','','',0,0),('openwiki','http://openwiki.com/?$1','','',0,0),('pmeg','http://www.bertilow.com/pmeg/$1.php','','',0,0),('ppr','http://c2.com/cgi/wiki?$1','','',0,0),('pythoninfo','http://wiki.python.org/moin/$1','','',0,0),('rfc','http://www.rfc-editor.org/rfc/rfc$1.txt','','',0,0),('s23wiki','http://is-root.de/wiki/index.php/$1','','',0,0),('seattlewiki','http://seattle.wikia.com/wiki/$1','','',0,0),('seattlewireless','http://seattlewireless.net/?$1','','',0,0),('senseislibrary','http://senseis.xmp.net/?$1','','',0,0),('sourceforge','http://sourceforge.net/$1','','',0,0),('squeak','http://wiki.squeak.org/squeak/$1','','',0,0),('susning','http://www.susning.nu/$1','','',0,0),('svgwiki','http://wiki.svg.org/$1','','',0,0),('tavi','http://tavi.sourceforge.net/$1','','',0,0),('tejo','http://www.tejo.org/vikio/$1','','',0,0),('theopedia','http://www.theopedia.com/$1','','',0,0),('tmbw','http://www.tmbw.net/wiki/$1','','',0,0),('tmnet','http://www.technomanifestos.net/?$1','','',0,0),('tmwiki','http://www.EasyTopicMaps.com/?page=$1','','',0,0),('twiki','http://twiki.org/cgi-bin/view/$1','','',0,0),('uea','http://www.tejo.org/uea/$1','','',0,0),('unreal','http://wiki.beyondunreal.com/wiki/$1','','',0,0),('usemod','http://www.usemod.com/cgi-bin/wiki.pl?$1','','',0,0),('vinismo','http://vinismo.com/en/$1','','',0,0),('webseitzwiki','http://webseitz.fluxent.com/wiki/$1','','',0,0),('why','http://clublet.com/c/c/why?$1','','',0,0),('wiki','http://c2.com/cgi/wiki?$1','','',0,0),('wikia','http://www.wikia.com/wiki/$1','','',0,0),('wikibooks','http://en.wikibooks.org/wiki/$1','','',1,0),('wikicities','http://www.wikia.com/wiki/$1','','',0,0),('wikif1','http://www.wikif1.org/$1','','',0,0),('wikihow','http://www.wikihow.com/$1','','',0,0),('wikimedia','http://wikimediafoundation.org/wiki/$1','','',0,0),('wikinews','http://en.wikinews.org/wiki/$1','','',1,0),('wikinfo','http://www.wikinfo.org/index.php/$1','','',0,0),('wikipedia','http://en.wikipedia.org/wiki/$1','','',1,0),('wikiquote','http://en.wikiquote.org/wiki/$1','','',1,0),('wikisource','http://wikisource.org/wiki/$1','','',1,0),('wikispecies','http://species.wikimedia.org/wiki/$1','','',1,0),('wikitravel','http://wikitravel.org/en/$1','','',0,0),('wikiversity','http://en.wikiversity.org/wiki/$1','','',1,0),('wikt','http://en.wiktionary.org/wiki/$1','','',1,0),('wiktionary','http://en.wiktionary.org/wiki/$1','','',1,0),('wlug','http://www.wlug.org.nz/$1','','',0,0),('zwiki','http://zwiki.org/$1','','',0,0),('zzz wiki','http://wiki.zzz.ee/index.php/$1','','',0,0);
352 /*!40000 ALTER TABLE `mw_interwiki` ENABLE KEYS */;
356 -- Table structure for table `mw_ipblocks`
359 DROP TABLE IF EXISTS `mw_ipblocks`
;
360 /*!40101 SET @saved_cs_client = @@character_set_client */;
361 /*!40101 SET character_set_client = utf8 */;
362 CREATE TABLE `mw_ipblocks`
(
363 `ipb_id`
int(11) NOT NULL AUTO_INCREMENT
,
364 `ipb_address` tinyblob
NOT NULL,
365 `ipb_user`
int(10) unsigned
NOT NULL DEFAULT '0',
366 `ipb_by`
int(10) unsigned
NOT NULL DEFAULT '0',
367 `ipb_by_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
368 `ipb_reason` tinyblob
NOT NULL,
369 `ipb_timestamp`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
370 `ipb_auto`
tinyint(1) NOT NULL DEFAULT '0',
371 `ipb_anon_only`
tinyint(1) NOT NULL DEFAULT '0',
372 `ipb_create_account`
tinyint(1) NOT NULL DEFAULT '1',
373 `ipb_enable_autoblock`
tinyint(1) NOT NULL DEFAULT '1',
374 `ipb_expiry`
varbinary(14) NOT NULL DEFAULT '',
375 `ipb_range_start` tinyblob
NOT NULL,
376 `ipb_range_end` tinyblob
NOT NULL,
377 `ipb_deleted`
tinyint(1) NOT NULL DEFAULT '0',
378 `ipb_block_email`
tinyint(1) NOT NULL DEFAULT '0',
379 `ipb_allow_usertalk`
tinyint(1) NOT NULL DEFAULT '0',
380 PRIMARY KEY (`ipb_id`
),
381 UNIQUE KEY `ipb_address`
(`ipb_address`
(255),`ipb_user`
,`ipb_auto`
,`ipb_anon_only`
),
382 KEY `ipb_user`
(`ipb_user`
),
383 KEY `ipb_range`
(`ipb_range_start`
(8),`ipb_range_end`
(8)),
384 KEY `ipb_timestamp`
(`ipb_timestamp`
),
385 KEY `ipb_expiry`
(`ipb_expiry`
)
386 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
387 /*!40101 SET character_set_client = @saved_cs_client */;
390 -- Dumping data for table `mw_ipblocks`
393 LOCK TABLES `mw_ipblocks`
WRITE;
394 /*!40000 ALTER TABLE `mw_ipblocks` DISABLE KEYS */;
395 /*!40000 ALTER TABLE `mw_ipblocks` ENABLE KEYS */;
399 -- Table structure for table `mw_iwlinks`
402 DROP TABLE IF EXISTS `mw_iwlinks`
;
403 /*!40101 SET @saved_cs_client = @@character_set_client */;
404 /*!40101 SET character_set_client = utf8 */;
405 CREATE TABLE `mw_iwlinks`
(
406 `iwl_from`
int(10) unsigned
NOT NULL DEFAULT '0',
407 `iwl_prefix`
varbinary(20) NOT NULL DEFAULT '',
408 `iwl_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
409 UNIQUE KEY `iwl_from`
(`iwl_from`
,`iwl_prefix`
,`iwl_title`
),
410 UNIQUE KEY `iwl_prefix_title_from`
(`iwl_prefix`
,`iwl_title`
,`iwl_from`
)
411 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
412 /*!40101 SET character_set_client = @saved_cs_client */;
415 -- Dumping data for table `mw_iwlinks`
418 LOCK TABLES `mw_iwlinks`
WRITE;
419 /*!40000 ALTER TABLE `mw_iwlinks` DISABLE KEYS */;
420 /*!40000 ALTER TABLE `mw_iwlinks` ENABLE KEYS */;
424 -- Table structure for table `mw_job`
427 DROP TABLE IF EXISTS `mw_job`
;
428 /*!40101 SET @saved_cs_client = @@character_set_client */;
429 /*!40101 SET character_set_client = utf8 */;
430 CREATE TABLE `mw_job`
(
431 `job_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
432 `job_cmd`
varbinary(60) NOT NULL DEFAULT '',
433 `job_namespace`
int(11) NOT NULL,
434 `job_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
435 `job_params`
blob NOT NULL,
436 PRIMARY KEY (`job_id`
),
437 KEY `job_cmd`
(`job_cmd`
,`job_namespace`
,`job_title`
,`job_params`
(128))
438 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
439 /*!40101 SET character_set_client = @saved_cs_client */;
442 -- Dumping data for table `mw_job`
445 LOCK TABLES `mw_job`
WRITE;
446 /*!40000 ALTER TABLE `mw_job` DISABLE KEYS */;
447 /*!40000 ALTER TABLE `mw_job` ENABLE KEYS */;
451 -- Table structure for table `mw_l10n_cache`
454 DROP TABLE IF EXISTS `mw_l10n_cache`
;
455 /*!40101 SET @saved_cs_client = @@character_set_client */;
456 /*!40101 SET character_set_client = utf8 */;
457 CREATE TABLE `mw_l10n_cache`
(
458 `lc_lang`
varbinary(32) NOT NULL,
459 `lc_key`
varchar(255) NOT NULL,
460 `lc_value` mediumblob
NOT NULL,
461 KEY `lc_lang_key`
(`lc_lang`
,`lc_key`
)
462 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
463 /*!40101 SET character_set_client = @saved_cs_client */;
466 -- Table structure for table `mw_langlinks`
469 DROP TABLE IF EXISTS `mw_langlinks`
;
470 /*!40101 SET @saved_cs_client = @@character_set_client */;
471 /*!40101 SET character_set_client = utf8 */;
472 CREATE TABLE `mw_langlinks`
(
473 `ll_from`
int(10) unsigned
NOT NULL DEFAULT '0',
474 `ll_lang`
varbinary(20) NOT NULL DEFAULT '',
475 `ll_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
476 UNIQUE KEY `ll_from`
(`ll_from`
,`ll_lang`
),
477 KEY `ll_lang`
(`ll_lang`
,`ll_title`
)
478 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
479 /*!40101 SET character_set_client = @saved_cs_client */;
482 -- Dumping data for table `mw_langlinks`
485 LOCK TABLES `mw_langlinks`
WRITE;
486 /*!40000 ALTER TABLE `mw_langlinks` DISABLE KEYS */;
487 /*!40000 ALTER TABLE `mw_langlinks` ENABLE KEYS */;
491 -- Table structure for table `mw_log_search`
494 DROP TABLE IF EXISTS `mw_log_search`
;
495 /*!40101 SET @saved_cs_client = @@character_set_client */;
496 /*!40101 SET character_set_client = utf8 */;
497 CREATE TABLE `mw_log_search`
(
498 `ls_field`
varbinary(32) NOT NULL,
499 `ls_value`
varchar(255) NOT NULL,
500 `ls_log_id`
int(10) unsigned
NOT NULL DEFAULT '0',
501 UNIQUE KEY `ls_field_val`
(`ls_field`
,`ls_value`
,`ls_log_id`
),
502 KEY `ls_log_id`
(`ls_log_id`
)
503 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
504 /*!40101 SET character_set_client = @saved_cs_client */;
507 -- Dumping data for table `mw_log_search`
510 LOCK TABLES `mw_log_search`
WRITE;
511 /*!40000 ALTER TABLE `mw_log_search` DISABLE KEYS */;
512 /*!40000 ALTER TABLE `mw_log_search` ENABLE KEYS */;
516 -- Table structure for table `mw_logging`
519 DROP TABLE IF EXISTS `mw_logging`
;
520 /*!40101 SET @saved_cs_client = @@character_set_client */;
521 /*!40101 SET character_set_client = utf8 */;
522 CREATE TABLE `mw_logging`
(
523 `log_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
524 `log_type`
varbinary(32) NOT NULL DEFAULT '',
525 `log_action`
varbinary(32) NOT NULL DEFAULT '',
526 `log_timestamp`
binary(14) NOT NULL DEFAULT '19700101000000',
527 `log_user`
int(10) unsigned
NOT NULL DEFAULT '0',
528 `log_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
529 `log_namespace`
int(11) NOT NULL DEFAULT '0',
530 `log_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
531 `log_page`
int(10) unsigned
DEFAULT NULL,
532 `log_comment`
varchar(255) NOT NULL DEFAULT '',
533 `log_params`
blob NOT NULL,
534 `log_deleted`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
535 PRIMARY KEY (`log_id`
),
536 KEY `type_time`
(`log_type`
,`log_timestamp`
),
537 KEY `user_time`
(`log_user`
,`log_timestamp`
),
538 KEY `page_time`
(`log_namespace`
,`log_title`
,`log_timestamp`
),
539 KEY `times`
(`log_timestamp`
),
540 KEY `log_user_type_time`
(`log_user`
,`log_type`
,`log_timestamp`
),
541 KEY `log_page_id_time`
(`log_page`
,`log_timestamp`
)
542 ) ENGINE
=InnoDB AUTO_INCREMENT
=2 DEFAULT CHARSET
=latin1
;
543 /*!40101 SET character_set_client = @saved_cs_client */;
546 -- Dumping data for table `mw_logging`
549 LOCK TABLES `mw_logging`
WRITE;
550 /*!40000 ALTER TABLE `mw_logging` DISABLE KEYS */;
551 INSERT INTO `mw_logging`
VALUES (1,'upload','upload','20110101145907',1,'WikiSysop',6,'Wikipedia-logo-v2-de.png',0,'','',0);
552 /*!40000 ALTER TABLE `mw_logging` ENABLE KEYS */;
556 -- Table structure for table `mw_math`
559 DROP TABLE IF EXISTS `mw_math`
;
560 /*!40101 SET @saved_cs_client = @@character_set_client */;
561 /*!40101 SET character_set_client = utf8 */;
562 CREATE TABLE `mw_math`
(
563 `math_inputhash`
varbinary(16) NOT NULL,
564 `math_outputhash`
varbinary(16) NOT NULL,
565 `math_html_conservativeness`
tinyint(4) NOT NULL,
568 UNIQUE KEY `math_inputhash`
(`math_inputhash`
)
569 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
570 /*!40101 SET character_set_client = @saved_cs_client */;
573 -- Dumping data for table `mw_math`
576 LOCK TABLES `mw_math`
WRITE;
577 /*!40000 ALTER TABLE `mw_math` DISABLE KEYS */;
578 /*!40000 ALTER TABLE `mw_math` ENABLE KEYS */;
582 -- Table structure for table `mw_module_deps`
585 DROP TABLE IF EXISTS `mw_module_deps`
;
586 /*!40101 SET @saved_cs_client = @@character_set_client */;
587 /*!40101 SET character_set_client = utf8 */;
588 CREATE TABLE `mw_module_deps`
(
589 `md_module`
varbinary(255) NOT NULL,
590 `md_skin`
varbinary(32) NOT NULL,
591 `md_deps` mediumblob
NOT NULL,
592 UNIQUE KEY `md_module_skin`
(`md_module`
,`md_skin`
)
593 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
594 /*!40101 SET character_set_client = @saved_cs_client */;
597 -- Dumping data for table `mw_module_deps`
600 LOCK TABLES `mw_module_deps`
WRITE;
601 /*!40000 ALTER TABLE `mw_module_deps` DISABLE KEYS */;
602 INSERT INTO `mw_module_deps`
VALUES ('mediawiki.legacy.shared','chick','[\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/feed-icon.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/remove.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/add.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/ajax-loader.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/spinner.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question-hover.gif\"]'),('mediawiki.legacy.shared','monobook','[\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/feed-icon.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/remove.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/add.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/ajax-loader.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/spinner.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question-hover.gif\"]'),('mediawiki.legacy.shared','myskin','[\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/feed-icon.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/remove.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/add.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/ajax-loader.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/spinner.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question-hover.gif\"]'),('mediawiki.legacy.shared','simple','[\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/feed-icon.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/remove.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/add.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/ajax-loader.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/spinner.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question-hover.gif\"]'),('mediawiki.legacy.shared','vector','[\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/feed-icon.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/remove.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/add.png\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/ajax-loader.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/spinner.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question.gif\",\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/common\\/images\\/help-question-hover.gif\"]'),('skins.monobook','monobook','{\"0\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/headbg.jpg\",\"1\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/bullet.gif\",\"2\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/external-ltr.png\",\"3\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/lock_icon.gif\",\"4\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/mail_icon.gif\",\"5\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/news_icon.png\",\"6\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/file_icon.gif\",\"7\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/discussionitem_icon.gif\",\"8\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/audio.png\",\"9\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/video.png\",\"10\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/document.png\",\"12\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/monobook\\/user.gif\"}'),('skins.vector','vector','{\"0\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/page-base.png\",\"1\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/border.png\",\"2\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/page-fade.png\",\"4\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/tab-break.png\",\"5\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/tab-normal-fade.png\",\"6\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/tab-current-fade.png\",\"8\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/arrow-down-icon.png\",\"11\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/search-fade.png\",\"12\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/portal-break.png\",\"14\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/preferences-break.png\",\"16\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/preferences-fade.png\",\"17\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/preferences-base.png\",\"18\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/bullet-icon.png\",\"19\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/external-link-ltr-icon.png\",\"20\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/lock-icon.png\",\"21\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/mail-icon.png\",\"22\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/news-icon.png\",\"23\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/file-icon.png\",\"24\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/talk-icon.png\",\"25\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/audio-icon.png\",\"26\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/video-icon.png\",\"27\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/document-icon.png\",\"28\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/user-icon.png\",\"29\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/watch-icons.png\",\"30\":\"C:\\\\mediawiki_dev\\\\htdocs\\\\phase3\\/skins\\/vector\\/images\\/watch-icon-loading.gif\"}');
603 /*!40000 ALTER TABLE `mw_module_deps` ENABLE KEYS */;
607 -- Table structure for table `mw_msg_resource`
610 DROP TABLE IF EXISTS `mw_msg_resource`
;
611 /*!40101 SET @saved_cs_client = @@character_set_client */;
612 /*!40101 SET character_set_client = utf8 */;
613 CREATE TABLE `mw_msg_resource`
(
614 `mr_resource`
varbinary(255) NOT NULL,
615 `mr_lang`
varbinary(32) NOT NULL,
616 `mr_blob` mediumblob
NOT NULL,
617 `mr_timestamp`
binary(14) NOT NULL,
618 UNIQUE KEY `mr_resource_lang`
(`mr_resource`
,`mr_lang`
)
619 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
620 /*!40101 SET character_set_client = @saved_cs_client */;
623 -- Dumping data for table `mw_msg_resource`
626 LOCK TABLES `mw_msg_resource`
WRITE;
627 /*!40000 ALTER TABLE `mw_msg_resource` DISABLE KEYS */;
628 INSERT INTO `mw_msg_resource`
VALUES ('jquery.checkboxShiftClick','en','{}','20110101145449'),('jquery.client','en','{}','20110101145449'),('jquery.cookie','en','{}','20110101145449'),('jquery.makeCollapsible','en','{\"collapsible-expand\":\"Expand\",\"collapsible-collapse\":\"Collapse\"}','20110101145449'),('jquery.placeholder','en','{}','20110101145449'),('mediawiki.action.watch.ajax','en','{}','20110101145627'),('mediawiki.language','en','{}','20110101145449'),('mediawiki.legacy.ajax','en','{\"watch\":\"Watch\",\"unwatch\":\"Unwatch\",\"watching\":\"Watching...\",\"unwatching\":\"Unwatching...\",\"tooltip-ca-watch\":\"Add this page to your watchlist\",\"tooltip-ca-unwatch\":\"Remove this page from your watchlist\"}','20110101145449'),('mediawiki.legacy.edit','en','{}','20110101145631'),('mediawiki.legacy.htmlform','en','{}','20110101145631'),('mediawiki.legacy.upload','en','{}','20110101145631'),('mediawiki.legacy.wikibits','en','{\"showtoc\":\"show\",\"hidetoc\":\"hide\"}','20110101145449'),('mediawiki.special.upload','en','{\"widthheight\":\"$1\\u00d7$2\",\"size-bytes\":\"$1 B\",\"size-kilobytes\":\"$1 KB\",\"size-megabytes\":\"$1 MB\",\"size-gigabytes\":\"$1 GB\"}','20110101145631'),('mediawiki.util','en','{}','20110101145449');
629 /*!40000 ALTER TABLE `mw_msg_resource` ENABLE KEYS */;
633 -- Table structure for table `mw_msg_resource_links`
636 DROP TABLE IF EXISTS `mw_msg_resource_links`
;
637 /*!40101 SET @saved_cs_client = @@character_set_client */;
638 /*!40101 SET character_set_client = utf8 */;
639 CREATE TABLE `mw_msg_resource_links`
(
640 `mrl_resource`
varbinary(255) NOT NULL,
641 `mrl_message`
varbinary(255) NOT NULL,
642 UNIQUE KEY `mrl_message_resource`
(`mrl_message`
,`mrl_resource`
)
643 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
644 /*!40101 SET character_set_client = @saved_cs_client */;
647 -- Dumping data for table `mw_msg_resource_links`
650 LOCK TABLES `mw_msg_resource_links`
WRITE;
651 /*!40000 ALTER TABLE `mw_msg_resource_links` DISABLE KEYS */;
652 INSERT INTO `mw_msg_resource_links`
VALUES ('jquery.makeCollapsible','collapsible-collapse'),('jquery.makeCollapsible','collapsible-expand'),('mediawiki.legacy.wikibits','hidetoc'),('mediawiki.legacy.wikibits','showtoc'),('mediawiki.special.upload','size-bytes'),('mediawiki.special.upload','size-gigabytes'),('mediawiki.special.upload','size-kilobytes'),('mediawiki.special.upload','size-megabytes'),('mediawiki.legacy.ajax','tooltip-ca-unwatch'),('mediawiki.legacy.ajax','tooltip-ca-watch'),('mediawiki.legacy.ajax','unwatch'),('mediawiki.legacy.ajax','unwatching'),('mediawiki.legacy.ajax','watch'),('mediawiki.legacy.ajax','watching'),('mediawiki.special.upload','widthheight');
653 /*!40000 ALTER TABLE `mw_msg_resource_links` ENABLE KEYS */;
657 -- Table structure for table `mw_objectcache`
660 DROP TABLE IF EXISTS `mw_objectcache`
;
661 /*!40101 SET @saved_cs_client = @@character_set_client */;
662 /*!40101 SET character_set_client = utf8 */;
663 CREATE TABLE `mw_objectcache`
(
664 `keyname`
varbinary(255) NOT NULL DEFAULT '',
666 `exptime` datetime
DEFAULT NULL,
667 PRIMARY KEY (`keyname`
),
668 KEY `exptime`
(`exptime`
)
669 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
670 /*!40101 SET character_set_client = @saved_cs_client */;
673 -- Table structure for table `mw_oldimage`
676 DROP TABLE IF EXISTS `mw_oldimage`
;
677 /*!40101 SET @saved_cs_client = @@character_set_client */;
678 /*!40101 SET character_set_client = utf8 */;
679 CREATE TABLE `mw_oldimage`
(
680 `oi_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
681 `oi_archive_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
682 `oi_size`
int(10) unsigned
NOT NULL DEFAULT '0',
683 `oi_width`
int(11) NOT NULL DEFAULT '0',
684 `oi_height`
int(11) NOT NULL DEFAULT '0',
685 `oi_bits`
int(11) NOT NULL DEFAULT '0',
686 `oi_description` tinyblob
NOT NULL,
687 `oi_user`
int(10) unsigned
NOT NULL DEFAULT '0',
688 `oi_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
689 `oi_timestamp`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
690 `oi_metadata` mediumblob
NOT NULL,
691 `oi_media_type`
enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') DEFAULT NULL,
692 `oi_major_mime`
enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL DEFAULT 'unknown',
693 `oi_minor_mime`
varbinary(100) NOT NULL DEFAULT 'unknown',
694 `oi_deleted`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
695 `oi_sha1`
varbinary(32) NOT NULL DEFAULT '',
696 KEY `oi_usertext_timestamp`
(`oi_user_text`
,`oi_timestamp`
),
697 KEY `oi_name_timestamp`
(`oi_name`
,`oi_timestamp`
),
698 KEY `oi_name_archive_name`
(`oi_name`
,`oi_archive_name`
(14)),
699 KEY `oi_sha1`
(`oi_sha1`
)
700 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
701 /*!40101 SET character_set_client = @saved_cs_client */;
704 -- Dumping data for table `mw_oldimage`
707 LOCK TABLES `mw_oldimage`
WRITE;
708 /*!40000 ALTER TABLE `mw_oldimage` DISABLE KEYS */;
709 /*!40000 ALTER TABLE `mw_oldimage` ENABLE KEYS */;
713 -- Table structure for table `mw_page`
716 DROP TABLE IF EXISTS `mw_page`
;
717 /*!40101 SET @saved_cs_client = @@character_set_client */;
718 /*!40101 SET character_set_client = utf8 */;
719 CREATE TABLE `mw_page`
(
720 `page_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
721 `page_namespace`
int(11) NOT NULL,
722 `page_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
723 `page_restrictions` tinyblob
NOT NULL,
724 `page_counter`
bigint(20) unsigned
NOT NULL DEFAULT '0',
725 `page_is_redirect`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
726 `page_is_new`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
727 `page_random`
double unsigned
NOT NULL,
728 `page_touched`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
729 `page_latest`
int(10) unsigned
NOT NULL,
730 `page_len`
int(10) unsigned
NOT NULL,
731 PRIMARY KEY (`page_id`
),
732 UNIQUE KEY `name_title`
(`page_namespace`
,`page_title`
),
733 KEY `page_random`
(`page_random`
),
734 KEY `page_len`
(`page_len`
)
735 ) ENGINE
=InnoDB AUTO_INCREMENT
=3 DEFAULT CHARSET
=latin1
;
736 /*!40101 SET character_set_client = @saved_cs_client */;
739 -- Dumping data for table `mw_page`
742 LOCK TABLES `mw_page`
WRITE;
743 /*!40000 ALTER TABLE `mw_page` DISABLE KEYS */;
744 INSERT INTO `mw_page`
VALUES (1,0,'Main_Page','',20,0,1,0.334989576352,'20101230131547',1,438),(2,6,'Wikipedia-logo-v2-de.png','',1,0,1,0.130954524087,'20110101145907',2,0);
745 /*!40000 ALTER TABLE `mw_page` ENABLE KEYS */;
749 -- Table structure for table `mw_page_props`
752 DROP TABLE IF EXISTS `mw_page_props`
;
753 /*!40101 SET @saved_cs_client = @@character_set_client */;
754 /*!40101 SET character_set_client = utf8 */;
755 CREATE TABLE `mw_page_props`
(
756 `pp_page`
int(11) NOT NULL,
757 `pp_propname`
varbinary(60) NOT NULL,
758 `pp_value`
blob NOT NULL,
759 UNIQUE KEY `pp_page_propname`
(`pp_page`
,`pp_propname`
)
760 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
761 /*!40101 SET character_set_client = @saved_cs_client */;
764 -- Dumping data for table `mw_page_props`
767 LOCK TABLES `mw_page_props`
WRITE;
768 /*!40000 ALTER TABLE `mw_page_props` DISABLE KEYS */;
769 /*!40000 ALTER TABLE `mw_page_props` ENABLE KEYS */;
773 -- Table structure for table `mw_page_restrictions`
776 DROP TABLE IF EXISTS `mw_page_restrictions`
;
777 /*!40101 SET @saved_cs_client = @@character_set_client */;
778 /*!40101 SET character_set_client = utf8 */;
779 CREATE TABLE `mw_page_restrictions`
(
780 `pr_page`
int(11) NOT NULL,
781 `pr_type`
varbinary(60) NOT NULL,
782 `pr_level`
varbinary(60) NOT NULL,
783 `pr_cascade`
tinyint(4) NOT NULL,
784 `pr_user`
int(11) DEFAULT NULL,
785 `pr_expiry`
varbinary(14) DEFAULT NULL,
786 `pr_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
787 PRIMARY KEY (`pr_id`
),
788 UNIQUE KEY `pr_pagetype`
(`pr_page`
,`pr_type`
),
789 KEY `pr_typelevel`
(`pr_type`
,`pr_level`
),
790 KEY `pr_level`
(`pr_level`
),
791 KEY `pr_cascade`
(`pr_cascade`
)
792 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
793 /*!40101 SET character_set_client = @saved_cs_client */;
796 -- Dumping data for table `mw_page_restrictions`
799 LOCK TABLES `mw_page_restrictions`
WRITE;
800 /*!40000 ALTER TABLE `mw_page_restrictions` DISABLE KEYS */;
801 /*!40000 ALTER TABLE `mw_page_restrictions` ENABLE KEYS */;
805 -- Table structure for table `mw_pagelinks`
808 DROP TABLE IF EXISTS `mw_pagelinks`
;
809 /*!40101 SET @saved_cs_client = @@character_set_client */;
810 /*!40101 SET character_set_client = utf8 */;
811 CREATE TABLE `mw_pagelinks`
(
812 `pl_from`
int(10) unsigned
NOT NULL DEFAULT '0',
813 `pl_namespace`
int(11) NOT NULL DEFAULT '0',
814 `pl_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
815 UNIQUE KEY `pl_from`
(`pl_from`
,`pl_namespace`
,`pl_title`
),
816 UNIQUE KEY `pl_namespace`
(`pl_namespace`
,`pl_title`
,`pl_from`
)
817 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
818 /*!40101 SET character_set_client = @saved_cs_client */;
821 -- Dumping data for table `mw_pagelinks`
824 LOCK TABLES `mw_pagelinks`
WRITE;
825 /*!40000 ALTER TABLE `mw_pagelinks` DISABLE KEYS */;
826 /*!40000 ALTER TABLE `mw_pagelinks` ENABLE KEYS */;
830 -- Table structure for table `mw_protected_titles`
833 DROP TABLE IF EXISTS `mw_protected_titles`
;
834 /*!40101 SET @saved_cs_client = @@character_set_client */;
835 /*!40101 SET character_set_client = utf8 */;
836 CREATE TABLE `mw_protected_titles`
(
837 `pt_namespace`
int(11) NOT NULL,
838 `pt_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
839 `pt_user`
int(10) unsigned
NOT NULL,
840 `pt_reason` tinyblob
,
841 `pt_timestamp`
binary(14) NOT NULL,
842 `pt_expiry`
varbinary(14) NOT NULL DEFAULT '',
843 `pt_create_perm`
varbinary(60) NOT NULL,
844 UNIQUE KEY `pt_namespace_title`
(`pt_namespace`
,`pt_title`
),
845 KEY `pt_timestamp`
(`pt_timestamp`
)
846 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
847 /*!40101 SET character_set_client = @saved_cs_client */;
850 -- Dumping data for table `mw_protected_titles`
853 LOCK TABLES `mw_protected_titles`
WRITE;
854 /*!40000 ALTER TABLE `mw_protected_titles` DISABLE KEYS */;
855 /*!40000 ALTER TABLE `mw_protected_titles` ENABLE KEYS */;
859 -- Table structure for table `mw_querycache`
862 DROP TABLE IF EXISTS `mw_querycache`
;
863 /*!40101 SET @saved_cs_client = @@character_set_client */;
864 /*!40101 SET character_set_client = utf8 */;
865 CREATE TABLE `mw_querycache`
(
866 `qc_type`
varbinary(32) NOT NULL,
867 `qc_value`
int(10) unsigned
NOT NULL DEFAULT '0',
868 `qc_namespace`
int(11) NOT NULL DEFAULT '0',
869 `qc_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
870 KEY `qc_type`
(`qc_type`
,`qc_value`
)
871 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
872 /*!40101 SET character_set_client = @saved_cs_client */;
875 -- Dumping data for table `mw_querycache`
878 LOCK TABLES `mw_querycache`
WRITE;
879 /*!40000 ALTER TABLE `mw_querycache` DISABLE KEYS */;
880 /*!40000 ALTER TABLE `mw_querycache` ENABLE KEYS */;
884 -- Table structure for table `mw_querycache_info`
887 DROP TABLE IF EXISTS `mw_querycache_info`
;
888 /*!40101 SET @saved_cs_client = @@character_set_client */;
889 /*!40101 SET character_set_client = utf8 */;
890 CREATE TABLE `mw_querycache_info`
(
891 `qci_type`
varbinary(32) NOT NULL DEFAULT '',
892 `qci_timestamp`
binary(14) NOT NULL DEFAULT '19700101000000',
893 UNIQUE KEY `qci_type`
(`qci_type`
)
894 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
895 /*!40101 SET character_set_client = @saved_cs_client */;
898 -- Dumping data for table `mw_querycache_info`
901 LOCK TABLES `mw_querycache_info`
WRITE;
902 /*!40000 ALTER TABLE `mw_querycache_info` DISABLE KEYS */;
903 /*!40000 ALTER TABLE `mw_querycache_info` ENABLE KEYS */;
907 -- Table structure for table `mw_querycachetwo`
910 DROP TABLE IF EXISTS `mw_querycachetwo`
;
911 /*!40101 SET @saved_cs_client = @@character_set_client */;
912 /*!40101 SET character_set_client = utf8 */;
913 CREATE TABLE `mw_querycachetwo`
(
914 `qcc_type`
varbinary(32) NOT NULL,
915 `qcc_value`
int(10) unsigned
NOT NULL DEFAULT '0',
916 `qcc_namespace`
int(11) NOT NULL DEFAULT '0',
917 `qcc_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
918 `qcc_namespacetwo`
int(11) NOT NULL DEFAULT '0',
919 `qcc_titletwo`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
920 KEY `qcc_type`
(`qcc_type`
,`qcc_value`
),
921 KEY `qcc_title`
(`qcc_type`
,`qcc_namespace`
,`qcc_title`
),
922 KEY `qcc_titletwo`
(`qcc_type`
,`qcc_namespacetwo`
,`qcc_titletwo`
)
923 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
924 /*!40101 SET character_set_client = @saved_cs_client */;
927 -- Dumping data for table `mw_querycachetwo`
930 LOCK TABLES `mw_querycachetwo`
WRITE;
931 /*!40000 ALTER TABLE `mw_querycachetwo` DISABLE KEYS */;
932 /*!40000 ALTER TABLE `mw_querycachetwo` ENABLE KEYS */;
936 -- Table structure for table `mw_recentchanges`
939 DROP TABLE IF EXISTS `mw_recentchanges`
;
940 /*!40101 SET @saved_cs_client = @@character_set_client */;
941 /*!40101 SET character_set_client = utf8 */;
942 CREATE TABLE `mw_recentchanges`
(
943 `rc_id`
int(11) NOT NULL AUTO_INCREMENT
,
944 `rc_timestamp`
varbinary(14) NOT NULL DEFAULT '',
945 `rc_cur_time`
varbinary(14) NOT NULL DEFAULT '',
946 `rc_user`
int(10) unsigned
NOT NULL DEFAULT '0',
947 `rc_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL,
948 `rc_namespace`
int(11) NOT NULL DEFAULT '0',
949 `rc_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
950 `rc_comment`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
951 `rc_minor`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
952 `rc_bot`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
953 `rc_new`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
954 `rc_cur_id`
int(10) unsigned
NOT NULL DEFAULT '0',
955 `rc_this_oldid`
int(10) unsigned
NOT NULL DEFAULT '0',
956 `rc_last_oldid`
int(10) unsigned
NOT NULL DEFAULT '0',
957 `rc_type`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
958 `rc_moved_to_ns`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
959 `rc_moved_to_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
960 `rc_patrolled`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
961 `rc_ip`
varbinary(40) NOT NULL DEFAULT '',
962 `rc_old_len`
int(11) DEFAULT NULL,
963 `rc_new_len`
int(11) DEFAULT NULL,
964 `rc_deleted`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
965 `rc_logid`
int(10) unsigned
NOT NULL DEFAULT '0',
966 `rc_log_type`
varbinary(255) DEFAULT NULL,
967 `rc_log_action`
varbinary(255) DEFAULT NULL,
969 PRIMARY KEY (`rc_id`
),
970 KEY `rc_timestamp`
(`rc_timestamp`
),
971 KEY `rc_namespace_title`
(`rc_namespace`
,`rc_title`
),
972 KEY `rc_cur_id`
(`rc_cur_id`
),
973 KEY `new_name_timestamp`
(`rc_new`
,`rc_namespace`
,`rc_timestamp`
),
974 KEY `rc_ip`
(`rc_ip`
),
975 KEY `rc_ns_usertext`
(`rc_namespace`
,`rc_user_text`
),
976 KEY `rc_user_text`
(`rc_user_text`
,`rc_timestamp`
)
977 ) ENGINE
=InnoDB AUTO_INCREMENT
=3 DEFAULT CHARSET
=latin1
;
978 /*!40101 SET character_set_client = @saved_cs_client */;
981 -- Dumping data for table `mw_recentchanges`
984 LOCK TABLES `mw_recentchanges`
WRITE;
985 /*!40000 ALTER TABLE `mw_recentchanges` DISABLE KEYS */;
986 INSERT INTO `mw_recentchanges`
VALUES (1,'20101230131547','20101230131547',0,'MediaWiki Default',0,'Main_Page','',0,0,1,1,1,0,1,0,'',0,'::1',0,438,0,0,NULL,'',''),(2,'20110101145907','20110101145907',1,'WikiSysop',6,'Wikipedia-logo-v2-de.png','',0,0,0,0,0,0,3,0,'',1,'::1',NULL,NULL,0,1,'upload','upload','');
987 /*!40000 ALTER TABLE `mw_recentchanges` ENABLE KEYS */;
991 -- Table structure for table `mw_redirect`
994 DROP TABLE IF EXISTS `mw_redirect`
;
995 /*!40101 SET @saved_cs_client = @@character_set_client */;
996 /*!40101 SET character_set_client = utf8 */;
997 CREATE TABLE `mw_redirect`
(
998 `rd_from`
int(10) unsigned
NOT NULL DEFAULT '0',
999 `rd_namespace`
int(11) NOT NULL DEFAULT '0',
1000 `rd_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
1001 `rd_interwiki`
varchar(32) DEFAULT NULL,
1002 `rd_fragment`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
DEFAULT NULL,
1003 PRIMARY KEY (`rd_from`
),
1004 KEY `rd_ns_title`
(`rd_namespace`
,`rd_title`
,`rd_from`
)
1005 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1006 /*!40101 SET character_set_client = @saved_cs_client */;
1009 -- Dumping data for table `mw_redirect`
1012 LOCK TABLES `mw_redirect`
WRITE;
1013 /*!40000 ALTER TABLE `mw_redirect` DISABLE KEYS */;
1014 /*!40000 ALTER TABLE `mw_redirect` ENABLE KEYS */;
1018 -- Table structure for table `mw_revision`
1021 DROP TABLE IF EXISTS `mw_revision`
;
1022 /*!40101 SET @saved_cs_client = @@character_set_client */;
1023 /*!40101 SET character_set_client = utf8 */;
1024 CREATE TABLE `mw_revision`
(
1025 `rev_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
1026 `rev_page`
int(10) unsigned
NOT NULL,
1027 `rev_text_id`
int(10) unsigned
NOT NULL,
1028 `rev_comment` tinyblob
NOT NULL,
1029 `rev_user`
int(10) unsigned
NOT NULL DEFAULT '0',
1030 `rev_user_text`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
1031 `rev_timestamp`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1032 `rev_minor_edit`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
1033 `rev_deleted`
tinyint(3) unsigned
NOT NULL DEFAULT '0',
1034 `rev_len`
int(10) unsigned
DEFAULT NULL,
1035 `rev_parent_id`
int(10) unsigned
DEFAULT NULL,
1036 PRIMARY KEY (`rev_id`
),
1037 UNIQUE KEY `rev_page_id`
(`rev_page`
,`rev_id`
),
1038 KEY `rev_timestamp`
(`rev_timestamp`
),
1039 KEY `page_timestamp`
(`rev_page`
,`rev_timestamp`
),
1040 KEY `user_timestamp`
(`rev_user`
,`rev_timestamp`
),
1041 KEY `usertext_timestamp`
(`rev_user_text`
,`rev_timestamp`
)
1042 ) ENGINE
=InnoDB AUTO_INCREMENT
=3 DEFAULT CHARSET
=latin1 MAX_ROWS
=10000000 AVG_ROW_LENGTH
=1024;
1043 /*!40101 SET character_set_client = @saved_cs_client */;
1046 -- Dumping data for table `mw_revision`
1049 LOCK TABLES `mw_revision`
WRITE;
1050 /*!40000 ALTER TABLE `mw_revision` DISABLE KEYS */;
1051 INSERT INTO `mw_revision`
VALUES (1,1,1,'',0,'MediaWiki Default','20101230131547',0,0,438,0),(2,2,2,'',1,'WikiSysop','20110101145907',0,0,0,0);
1052 /*!40000 ALTER TABLE `mw_revision` ENABLE KEYS */;
1056 -- Table structure for table `mw_searchindex`
1059 DROP TABLE IF EXISTS `mw_searchindex`
;
1060 /*!40101 SET @saved_cs_client = @@character_set_client */;
1061 /*!40101 SET character_set_client = utf8 */;
1062 CREATE TABLE `mw_searchindex`
(
1063 `si_page`
int(10) unsigned
NOT NULL,
1064 `si_title`
varchar(255) NOT NULL DEFAULT '',
1065 `si_text` mediumtext
NOT NULL,
1066 UNIQUE KEY `si_page`
(`si_page`
),
1067 FULLTEXT
KEY `si_title`
(`si_title`
),
1068 FULLTEXT
KEY `si_text`
(`si_text`
)
1069 ) ENGINE
=MyISAM
DEFAULT CHARSET
=latin1
;
1070 /*!40101 SET character_set_client = @saved_cs_client */;
1073 -- Dumping data for table `mw_searchindex`
1076 LOCK TABLES `mw_searchindex`
WRITE;
1077 /*!40000 ALTER TABLE `mw_searchindex` DISABLE KEYS */;
1078 INSERT INTO `mw_searchindex`
VALUES (1,'main page',' mediawiki hasu800 been successfully installed. consult theu800 user user\'su800 guide foru800 information onu800 using theu800 wiki software. getting started getting started getting started configuration settings list mediawiki faqu800 mediawiki release mailing list '),(2,'wikipedia-logo-v2u800-deu800u82epngu800',' ');
1079 /*!40000 ALTER TABLE `mw_searchindex` ENABLE KEYS */;
1083 -- Table structure for table `mw_site_stats`
1086 DROP TABLE IF EXISTS `mw_site_stats`
;
1087 /*!40101 SET @saved_cs_client = @@character_set_client */;
1088 /*!40101 SET character_set_client = utf8 */;
1089 CREATE TABLE `mw_site_stats`
(
1090 `ss_row_id`
int(10) unsigned
NOT NULL,
1091 `ss_total_views`
bigint(20) unsigned
DEFAULT '0',
1092 `ss_total_edits`
bigint(20) unsigned
DEFAULT '0',
1093 `ss_good_articles`
bigint(20) unsigned
DEFAULT '0',
1094 `ss_total_pages`
bigint(20) DEFAULT '-1',
1095 `ss_users`
bigint(20) DEFAULT '-1',
1096 `ss_active_users`
bigint(20) DEFAULT '-1',
1097 `ss_admins`
int(11) DEFAULT '-1',
1098 `ss_images`
int(11) DEFAULT '0',
1099 UNIQUE KEY `ss_row_id`
(`ss_row_id`
)
1100 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1101 /*!40101 SET character_set_client = @saved_cs_client */;
1104 -- Dumping data for table `mw_site_stats`
1107 LOCK TABLES `mw_site_stats`
WRITE;
1108 /*!40000 ALTER TABLE `mw_site_stats` DISABLE KEYS */;
1109 /*!40000 ALTER TABLE `mw_site_stats` ENABLE KEYS */;
1113 -- Table structure for table `mw_tag_summary`
1116 DROP TABLE IF EXISTS `mw_tag_summary`
;
1117 /*!40101 SET @saved_cs_client = @@character_set_client */;
1118 /*!40101 SET character_set_client = utf8 */;
1119 CREATE TABLE `mw_tag_summary`
(
1120 `ts_rc_id`
int(11) DEFAULT NULL,
1121 `ts_log_id`
int(11) DEFAULT NULL,
1122 `ts_rev_id`
int(11) DEFAULT NULL,
1123 `ts_tags`
blob NOT NULL,
1124 UNIQUE KEY `tag_summary_rc_id`
(`ts_rc_id`
),
1125 UNIQUE KEY `tag_summary_log_id`
(`ts_log_id`
),
1126 UNIQUE KEY `tag_summary_rev_id`
(`ts_rev_id`
)
1127 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1128 /*!40101 SET character_set_client = @saved_cs_client */;
1131 -- Dumping data for table `mw_tag_summary`
1134 LOCK TABLES `mw_tag_summary`
WRITE;
1135 /*!40000 ALTER TABLE `mw_tag_summary` DISABLE KEYS */;
1136 /*!40000 ALTER TABLE `mw_tag_summary` ENABLE KEYS */;
1140 -- Table structure for table `mw_templatelinks`
1143 DROP TABLE IF EXISTS `mw_templatelinks`
;
1144 /*!40101 SET @saved_cs_client = @@character_set_client */;
1145 /*!40101 SET character_set_client = utf8 */;
1146 CREATE TABLE `mw_templatelinks`
(
1147 `tl_from`
int(10) unsigned
NOT NULL DEFAULT '0',
1148 `tl_namespace`
int(11) NOT NULL DEFAULT '0',
1149 `tl_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
1150 UNIQUE KEY `tl_from`
(`tl_from`
,`tl_namespace`
,`tl_title`
),
1151 UNIQUE KEY `tl_namespace`
(`tl_namespace`
,`tl_title`
,`tl_from`
)
1152 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1153 /*!40101 SET character_set_client = @saved_cs_client */;
1156 -- Dumping data for table `mw_templatelinks`
1159 LOCK TABLES `mw_templatelinks`
WRITE;
1160 /*!40000 ALTER TABLE `mw_templatelinks` DISABLE KEYS */;
1161 /*!40000 ALTER TABLE `mw_templatelinks` ENABLE KEYS */;
1165 -- Table structure for table `mw_text`
1168 DROP TABLE IF EXISTS `mw_text`
;
1169 /*!40101 SET @saved_cs_client = @@character_set_client */;
1170 /*!40101 SET character_set_client = utf8 */;
1171 CREATE TABLE `mw_text`
(
1172 `old_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
1173 `old_text` mediumblob
NOT NULL,
1174 `old_flags` tinyblob
NOT NULL,
1175 PRIMARY KEY (`old_id`
)
1176 ) ENGINE
=InnoDB AUTO_INCREMENT
=3 DEFAULT CHARSET
=latin1 MAX_ROWS
=10000000 AVG_ROW_LENGTH
=10240;
1177 /*!40101 SET character_set_client = @saved_cs_client */;
1180 -- Dumping data for table `mw_text`
1183 LOCK TABLES `mw_text`
WRITE;
1184 /*!40000 ALTER TABLE `mw_text` DISABLE KEYS */;
1185 INSERT INTO `mw_text`
VALUES (1,'\'\'\'MediaWiki has been successfully installed.\'\'\'\n\nConsult the [http://meta.wikimedia.org/wiki/Help:Contents User\'s Guide] for information on using the wiki software.\n\n== Getting started ==\n* [http://www.mediawiki.org/wiki/Manual:Configuration_settings Configuration settings list]\n* [http://www.mediawiki.org/wiki/Manual:FAQ MediaWiki FAQ]\n* [https://lists.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki release mailing list]','utf-8'),(2,'','utf-8');
1186 /*!40000 ALTER TABLE `mw_text` ENABLE KEYS */;
1190 -- Table structure for table `mw_trackbacks`
1193 DROP TABLE IF EXISTS `mw_trackbacks`
;
1194 /*!40101 SET @saved_cs_client = @@character_set_client */;
1195 /*!40101 SET character_set_client = utf8 */;
1196 CREATE TABLE `mw_trackbacks`
(
1197 `tb_id`
int(11) NOT NULL AUTO_INCREMENT
,
1198 `tb_page`
int(11) DEFAULT NULL,
1199 `tb_title`
varchar(255) NOT NULL,
1200 `tb_url`
blob NOT NULL,
1202 `tb_name`
varchar(255) DEFAULT NULL,
1203 PRIMARY KEY (`tb_id`
),
1204 KEY `tb_page`
(`tb_page`
)
1205 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1206 /*!40101 SET character_set_client = @saved_cs_client */;
1209 -- Dumping data for table `mw_trackbacks`
1212 LOCK TABLES `mw_trackbacks`
WRITE;
1213 /*!40000 ALTER TABLE `mw_trackbacks` DISABLE KEYS */;
1214 /*!40000 ALTER TABLE `mw_trackbacks` ENABLE KEYS */;
1218 -- Table structure for table `mw_transcache`
1221 DROP TABLE IF EXISTS `mw_transcache`
;
1222 /*!40101 SET @saved_cs_client = @@character_set_client */;
1223 /*!40101 SET character_set_client = utf8 */;
1224 CREATE TABLE `mw_transcache`
(
1225 `tc_url`
varbinary(255) NOT NULL,
1227 `tc_time`
binary(14) NOT NULL,
1228 UNIQUE KEY `tc_url_idx`
(`tc_url`
)
1229 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1230 /*!40101 SET character_set_client = @saved_cs_client */;
1233 -- Dumping data for table `mw_transcache`
1236 LOCK TABLES `mw_transcache`
WRITE;
1237 /*!40000 ALTER TABLE `mw_transcache` DISABLE KEYS */;
1238 /*!40000 ALTER TABLE `mw_transcache` ENABLE KEYS */;
1242 -- Table structure for table `mw_updatelog`
1245 DROP TABLE IF EXISTS `mw_updatelog`
;
1246 /*!40101 SET @saved_cs_client = @@character_set_client */;
1247 /*!40101 SET character_set_client = utf8 */;
1248 CREATE TABLE `mw_updatelog`
(
1249 `ul_key`
varchar(255) NOT NULL,
1251 PRIMARY KEY (`ul_key`
)
1252 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1253 /*!40101 SET character_set_client = @saved_cs_client */;
1256 -- Dumping data for table `mw_updatelog`
1259 LOCK TABLES `mw_updatelog`
WRITE;
1260 /*!40000 ALTER TABLE `mw_updatelog` DISABLE KEYS */;
1261 /*!40000 ALTER TABLE `mw_updatelog` ENABLE KEYS */;
1265 -- Table structure for table `mw_user`
1268 DROP TABLE IF EXISTS `mw_user`
;
1269 /*!40101 SET @saved_cs_client = @@character_set_client */;
1270 /*!40101 SET character_set_client = utf8 */;
1271 CREATE TABLE `mw_user`
(
1272 `user_id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
1273 `user_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
1274 `user_real_name`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
1275 `user_password` tinyblob
NOT NULL,
1276 `user_newpassword` tinyblob
NOT NULL,
1277 `user_newpass_time`
binary(14) DEFAULT NULL,
1278 `user_email` tinytext
NOT NULL,
1279 `user_options`
blob NOT NULL,
1280 `user_touched`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1281 `user_token`
binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1282 `user_email_authenticated`
binary(14) DEFAULT NULL,
1283 `user_email_token`
binary(32) DEFAULT NULL,
1284 `user_email_token_expires`
binary(14) DEFAULT NULL,
1285 `user_registration`
binary(14) DEFAULT NULL,
1286 `user_editcount`
int(11) DEFAULT NULL,
1287 PRIMARY KEY (`user_id`
),
1288 UNIQUE KEY `user_name`
(`user_name`
),
1289 KEY `user_email_token`
(`user_email_token`
)
1290 ) ENGINE
=InnoDB AUTO_INCREMENT
=2 DEFAULT CHARSET
=latin1
;
1291 /*!40101 SET character_set_client = @saved_cs_client */;
1294 -- Dumping data for table `mw_user`
1297 LOCK TABLES `mw_user`
WRITE;
1298 /*!40000 ALTER TABLE `mw_user` DISABLE KEYS */;
1299 INSERT INTO `mw_user`
VALUES (1,'WikiSysop','',':B:b1373470:f7e87db0c9596055f39a1225b0c31508','',NULL,'','','20110101145912','de4ddde7c4eef6e3609f4287324a0a18',NULL,'\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,'20101230131547',1);
1300 /*!40000 ALTER TABLE `mw_user` ENABLE KEYS */;
1304 -- Table structure for table `mw_user_groups`
1307 DROP TABLE IF EXISTS `mw_user_groups`
;
1308 /*!40101 SET @saved_cs_client = @@character_set_client */;
1309 /*!40101 SET character_set_client = utf8 */;
1310 CREATE TABLE `mw_user_groups`
(
1311 `ug_user`
int(10) unsigned
NOT NULL DEFAULT '0',
1312 `ug_group`
varbinary(16) NOT NULL DEFAULT '',
1313 UNIQUE KEY `ug_user_group`
(`ug_user`
,`ug_group`
),
1314 KEY `ug_group`
(`ug_group`
)
1315 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1316 /*!40101 SET character_set_client = @saved_cs_client */;
1319 -- Dumping data for table `mw_user_groups`
1322 LOCK TABLES `mw_user_groups`
WRITE;
1323 /*!40000 ALTER TABLE `mw_user_groups` DISABLE KEYS */;
1324 INSERT INTO `mw_user_groups`
VALUES (1,'bureaucrat'),(1,'sysop');
1325 /*!40000 ALTER TABLE `mw_user_groups` ENABLE KEYS */;
1329 -- Table structure for table `mw_user_newtalk`
1332 DROP TABLE IF EXISTS `mw_user_newtalk`
;
1333 /*!40101 SET @saved_cs_client = @@character_set_client */;
1334 /*!40101 SET character_set_client = utf8 */;
1335 CREATE TABLE `mw_user_newtalk`
(
1336 `user_id`
int(11) NOT NULL DEFAULT '0',
1337 `user_ip`
varbinary(40) NOT NULL DEFAULT '',
1338 `user_last_timestamp`
binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
1339 KEY `user_id`
(`user_id`
),
1340 KEY `user_ip`
(`user_ip`
)
1341 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1342 /*!40101 SET character_set_client = @saved_cs_client */;
1345 -- Dumping data for table `mw_user_newtalk`
1348 LOCK TABLES `mw_user_newtalk`
WRITE;
1349 /*!40000 ALTER TABLE `mw_user_newtalk` DISABLE KEYS */;
1350 /*!40000 ALTER TABLE `mw_user_newtalk` ENABLE KEYS */;
1354 -- Table structure for table `mw_user_properties`
1357 DROP TABLE IF EXISTS `mw_user_properties`
;
1358 /*!40101 SET @saved_cs_client = @@character_set_client */;
1359 /*!40101 SET character_set_client = utf8 */;
1360 CREATE TABLE `mw_user_properties`
(
1361 `up_user`
int(11) NOT NULL,
1362 `up_property`
varbinary(32) NOT NULL,
1364 UNIQUE KEY `user_properties_user_property`
(`up_user`
,`up_property`
),
1365 KEY `user_properties_property`
(`up_property`
)
1366 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1367 /*!40101 SET character_set_client = @saved_cs_client */;
1370 -- Dumping data for table `mw_user_properties`
1373 LOCK TABLES `mw_user_properties`
WRITE;
1374 /*!40000 ALTER TABLE `mw_user_properties` DISABLE KEYS */;
1375 /*!40000 ALTER TABLE `mw_user_properties` ENABLE KEYS */;
1379 -- Table structure for table `mw_valid_tag`
1382 DROP TABLE IF EXISTS `mw_valid_tag`
;
1383 /*!40101 SET @saved_cs_client = @@character_set_client */;
1384 /*!40101 SET character_set_client = utf8 */;
1385 CREATE TABLE `mw_valid_tag`
(
1386 `vt_tag`
varchar(255) NOT NULL,
1387 PRIMARY KEY (`vt_tag`
)
1388 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1389 /*!40101 SET character_set_client = @saved_cs_client */;
1392 -- Dumping data for table `mw_valid_tag`
1395 LOCK TABLES `mw_valid_tag`
WRITE;
1396 /*!40000 ALTER TABLE `mw_valid_tag` DISABLE KEYS */;
1397 /*!40000 ALTER TABLE `mw_valid_tag` ENABLE KEYS */;
1401 -- Table structure for table `mw_watchlist`
1404 DROP TABLE IF EXISTS `mw_watchlist`
;
1405 /*!40101 SET @saved_cs_client = @@character_set_client */;
1406 /*!40101 SET character_set_client = utf8 */;
1407 CREATE TABLE `mw_watchlist`
(
1408 `wl_user`
int(10) unsigned
NOT NULL,
1409 `wl_namespace`
int(11) NOT NULL DEFAULT '0',
1410 `wl_title`
varchar(255) CHARACTER SET latin1
COLLATE latin1_bin
NOT NULL DEFAULT '',
1411 `wl_notificationtimestamp`
varbinary(14) DEFAULT NULL,
1412 UNIQUE KEY `wl_user`
(`wl_user`
,`wl_namespace`
,`wl_title`
),
1413 KEY `namespace_title`
(`wl_namespace`
,`wl_title`
)
1414 ) ENGINE
=InnoDB
DEFAULT CHARSET
=latin1
;
1415 /*!40101 SET character_set_client = @saved_cs_client */;
1418 -- Dumping data for table `mw_watchlist`
1421 LOCK TABLES `mw_watchlist`
WRITE;
1422 /*!40000 ALTER TABLE `mw_watchlist` DISABLE KEYS */;
1423 /*!40000 ALTER TABLE `mw_watchlist` ENABLE KEYS */;
1425 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1427 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1428 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1429 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1430 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1431 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1432 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1433 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1435 -- Dump completed on 2011-01-01 16:01:26