source: npl/webapps/mediawiki/mediawiki.sql @ 0105685

gcc484ntopperl-5.22
Last change on this file since 0105685 was c5c522c, checked in by Edwin Eefting <edwin@datux.nl>, 8 years ago

initial commit, transferred from cleaned syn3 svn tree
  • Property mode set to 100644
File size: 41.9 KB
Line 
1-- MySQL dump 10.9
2--
3-- Host: localhost    Database: mediawiki
4-- ------------------------------------------------------
5-- Server version       4.1.22
6
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/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15
16--
17-- Table structure for table `mw_archive`
18--
19
20
21
22CREATE DATABASE `mediawiki` ;
23
24USE `mediawiki` ;
25
26DROP TABLE IF EXISTS `mw_archive`;
27CREATE TABLE `mw_archive` (
28  `ar_namespace` int(11) NOT NULL default '0',
29  `ar_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
30  `ar_text` mediumblob NOT NULL,
31  `ar_comment` tinyblob NOT NULL,
32  `ar_user` int(5) unsigned NOT NULL default '0',
33  `ar_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
34  `ar_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
35  `ar_minor_edit` tinyint(1) NOT NULL default '0',
36  `ar_flags` tinyblob NOT NULL,
37  `ar_rev_id` int(8) unsigned default NULL,
38  `ar_text_id` int(8) unsigned default NULL,
39  `ar_deleted` tinyint(1) unsigned NOT NULL default '0',
40  `ar_len` int(8) unsigned default NULL,
41  KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44--
45-- Dumping data for table `mw_archive`
46--
47
48LOCK TABLES `mw_archive` WRITE;
49/*!40000 ALTER TABLE `mw_archive` DISABLE KEYS */;
50/*!40000 ALTER TABLE `mw_archive` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `mw_categorylinks`
55--
56
57DROP TABLE IF EXISTS `mw_categorylinks`;
58CREATE TABLE `mw_categorylinks` (
59  `cl_from` int(8) unsigned NOT NULL default '0',
60  `cl_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
61  `cl_sortkey` varchar(86) character set latin1 collate latin1_bin NOT NULL default '',
62  `cl_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
63  UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
64  KEY `cl_sortkey` (`cl_to`,`cl_sortkey`),
65  KEY `cl_timestamp` (`cl_to`,`cl_timestamp`)
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67
68--
69-- Dumping data for table `mw_categorylinks`
70--
71
72LOCK TABLES `mw_categorylinks` WRITE;
73/*!40000 ALTER TABLE `mw_categorylinks` DISABLE KEYS */;
74/*!40000 ALTER TABLE `mw_categorylinks` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `mw_externallinks`
79--
80
81DROP TABLE IF EXISTS `mw_externallinks`;
82CREATE TABLE `mw_externallinks` (
83  `el_from` int(8) unsigned NOT NULL default '0',
84  `el_to` blob NOT NULL,
85  `el_index` blob NOT NULL,
86  KEY `el_from` (`el_from`,`el_to`(40)),
87  KEY `el_to` (`el_to`(60),`el_from`),
88  KEY `el_index` (`el_index`(60))
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90
91--
92-- Dumping data for table `mw_externallinks`
93--
94
95LOCK TABLES `mw_externallinks` WRITE;
96/*!40000 ALTER TABLE `mw_externallinks` DISABLE KEYS */;
97/*!40000 ALTER TABLE `mw_externallinks` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `mw_filearchive`
102--
103
104DROP TABLE IF EXISTS `mw_filearchive`;
105CREATE TABLE `mw_filearchive` (
106  `fa_id` int(11) NOT NULL auto_increment,
107  `fa_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
108  `fa_archive_name` varchar(255) character set latin1 collate latin1_bin default '',
109  `fa_storage_group` varchar(16) default NULL,
110  `fa_storage_key` varchar(64) character set latin1 collate latin1_bin default '',
111  `fa_deleted_user` int(11) default NULL,
112  `fa_deleted_timestamp` varchar(14) character set latin1 collate latin1_bin default '',
113  `fa_deleted_reason` text,
114  `fa_size` int(8) unsigned default '0',
115  `fa_width` int(5) default '0',
116  `fa_height` int(5) default '0',
117  `fa_metadata` mediumblob,
118  `fa_bits` int(3) default '0',
119  `fa_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
120  `fa_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') default 'unknown',
121  `fa_minor_mime` varchar(32) default 'unknown',
122  `fa_description` tinyblob,
123  `fa_user` int(5) unsigned default '0',
124  `fa_user_text` varchar(255) character set latin1 collate latin1_bin default NULL,
125  `fa_timestamp` varchar(14) character set latin1 collate latin1_bin default '',
126  `fa_deleted` tinyint(1) unsigned NOT NULL default '0',
127  PRIMARY KEY  (`fa_id`),
128  KEY `fa_name` (`fa_name`,`fa_timestamp`),
129  KEY `fa_storage_group` (`fa_storage_group`,`fa_storage_key`),
130  KEY `fa_deleted_timestamp` (`fa_deleted_timestamp`),
131  KEY `fa_deleted_user` (`fa_deleted_user`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133
134--
135-- Dumping data for table `mw_filearchive`
136--
137
138LOCK TABLES `mw_filearchive` WRITE;
139/*!40000 ALTER TABLE `mw_filearchive` DISABLE KEYS */;
140/*!40000 ALTER TABLE `mw_filearchive` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `mw_hitcounter`
145--
146
147DROP TABLE IF EXISTS `mw_hitcounter`;
148CREATE TABLE `mw_hitcounter` (
149  `hc_id` int(10) unsigned NOT NULL default '0'
150) ENGINE=HEAP DEFAULT CHARSET=latin1 MAX_ROWS=25000;
151
152--
153-- Dumping data for table `mw_hitcounter`
154--
155
156LOCK TABLES `mw_hitcounter` WRITE;
157/*!40000 ALTER TABLE `mw_hitcounter` DISABLE KEYS */;
158/*!40000 ALTER TABLE `mw_hitcounter` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `mw_image`
163--
164
165DROP TABLE IF EXISTS `mw_image`;
166CREATE TABLE `mw_image` (
167  `img_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
168  `img_size` int(8) unsigned NOT NULL default '0',
169  `img_width` int(5) NOT NULL default '0',
170  `img_height` int(5) NOT NULL default '0',
171  `img_metadata` mediumblob NOT NULL,
172  `img_bits` int(3) NOT NULL default '0',
173  `img_media_type` enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') default NULL,
174  `img_major_mime` enum('unknown','application','audio','image','text','video','message','model','multipart') NOT NULL default 'unknown',
175  `img_minor_mime` varchar(32) NOT NULL default 'unknown',
176  `img_description` tinyblob NOT NULL,
177  `img_user` int(5) unsigned NOT NULL default '0',
178  `img_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
179  `img_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
180  PRIMARY KEY  (`img_name`),
181  KEY `img_size` (`img_size`),
182  KEY `img_timestamp` (`img_timestamp`)
183) ENGINE=InnoDB DEFAULT CHARSET=latin1;
184
185--
186-- Dumping data for table `mw_image`
187--
188
189LOCK TABLES `mw_image` WRITE;
190/*!40000 ALTER TABLE `mw_image` DISABLE KEYS */;
191/*!40000 ALTER TABLE `mw_image` ENABLE KEYS */;
192UNLOCK TABLES;
193
194--
195-- Table structure for table `mw_imagelinks`
196--
197
198DROP TABLE IF EXISTS `mw_imagelinks`;
199CREATE TABLE `mw_imagelinks` (
200  `il_from` int(8) unsigned NOT NULL default '0',
201  `il_to` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
202  UNIQUE KEY `il_from` (`il_from`,`il_to`),
203  KEY `il_to` (`il_to`,`il_from`)
204) ENGINE=InnoDB DEFAULT CHARSET=latin1;
205
206--
207-- Dumping data for table `mw_imagelinks`
208--
209
210LOCK TABLES `mw_imagelinks` WRITE;
211/*!40000 ALTER TABLE `mw_imagelinks` DISABLE KEYS */;
212/*!40000 ALTER TABLE `mw_imagelinks` ENABLE KEYS */;
213UNLOCK TABLES;
214
215--
216-- Table structure for table `mw_interwiki`
217--
218
219DROP TABLE IF EXISTS `mw_interwiki`;
220CREATE TABLE `mw_interwiki` (
221  `iw_prefix` char(32) NOT NULL default '',
222  `iw_url` char(127) NOT NULL default '',
223  `iw_local` tinyint(1) NOT NULL default '0',
224  `iw_trans` tinyint(1) NOT NULL default '0',
225  UNIQUE KEY `iw_prefix` (`iw_prefix`)
226) ENGINE=InnoDB DEFAULT CHARSET=latin1;
227
228--
229-- Dumping data for table `mw_interwiki`
230--
231
232LOCK TABLES `mw_interwiki` WRITE;
233/*!40000 ALTER TABLE `mw_interwiki` DISABLE KEYS */;
234INSERT INTO `mw_interwiki` VALUES ('abbenormal','http://www.ourpla.net/cgi-bin/pikie.cgi?$1',0,0),('acadwiki','http://xarch.tu-graz.ac.at/autocad/wiki/$1',0,0),('acronym','http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=$1',0,0),('advogato','http://www.advogato.org/$1',0,0),('aiwiki','http://www.ifi.unizh.ch/ailab/aiwiki/aiw.cgi?$1',0,0),('alife','http://news.alife.org/wiki/index.php?$1',0,0),('annotation','http://bayle.stanford.edu/crit/nph-med.cgi/$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),('aspienetwiki','http://aspie.mela.de/Wiki/index.php?title=$1',0,0),('bemi','http://bemi.free.fr/vikio/index.php?$1',0,0),('benefitswiki','http://www.benefitslink.com/cgi-bin/wiki.cgi?$1',0,0),('brasilwiki','http://rio.ifi.unizh.ch/brasilienwiki/index.php/$1',0,0),('bridgeswiki','http://c2.com/w2/bridges/$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),('ciscavate','http://ciscavate.org/index.php/$1',0,0),('cliki','http://ww.telent.net/cliki/$1',0,0),('cmwiki','http://www.ourpla.net/cgi-bin/wiki.pl?$1',0,0),('codersbase','http://www.codersbase.com/$1',0,0),('commons','http://commons.wikimedia.org/wiki/$1',0,0),('consciousness','http://teadvus.inspiral.org/',0,0),('corpknowpedia','http://corpknowpedia.org/wiki/index.php/$1',0,0),('creationmatters','http://www.ourpla.net/cgi-bin/wiki.pl?$1',0,0),('dejanews','http://www.deja.com/=dnc/getdoc.xp?AN=$1',0,0),('demokraatia','http://wiki.demokraatia.ee/',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),('diveintoosx','http://diveintoosx.org/$1',0,0),('docbook','http://docbook.org/wiki/moin.cgi/$1',0,0),('dolphinwiki','http://www.object-arts.com/wiki/html/Dolphin/$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),('echei','http://www.ikso.net/cgi-bin/wiki.pl?$1',0,0),('ecxei','http://www.ikso.net/cgi-bin/wiki.pl?$1',0,0),('efnetceewiki','http://purl.net/wiki/c/$1',0,0),('efnetcppwiki','http://purl.net/wiki/cpp/$1',0,0),('efnetpythonwiki','http://purl.net/wiki/python/$1',0,0),('efnetxmlwiki','http://purl.net/wiki/xml/$1',0,0),('elibre','http://enciclopedia.us.es/index.php/$1',0,0),('eljwiki','http://elj.sourceforge.net/phpwiki/index.php/$1',0,0),('emacswiki','http://www.emacswiki.org/cgi-bin/wiki.pl?$1',0,0),('eokulturcentro','http://esperanto.toulouse.free.fr/wakka.php?wiki=$1',0,0),('evowiki','http://www.evowiki.org/index.php/$1',0,0),('eĉei','http://www.ikso.net/cgi-bin/wiki.pl?$1',0,0),('finalempire','http://final-empire.sourceforge.net/cgi-bin/wiki.pl?$1',0,0),('firstwiki','http://firstwiki.org/index.php/$1',0,0),('foldoc','http://www.foldoc.org/foldoc/foldoc.cgi?$1',0,0),('foxwiki','http://fox.wikis.com/wc.dll?Wiki~$1',0,0),('fr.be','http://fr.wikinations.be/$1',0,0),('fr.ca','http://fr.ca.wikinations.org/$1',0,0),('fr.fr','http://fr.fr.wikinations.org/$1',0,0),('fr.org','http://fr.wikinations.org/$1',0,0),('freebsdman','http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1',0,0),('gamewiki','http://gamewiki.org/wiki/index.php/$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),('globalvoices','http://cyber.law.harvard.edu/dyn/globalvoices/wiki/$1',0,0),('gmailwiki','http://www.gmailwiki.com/index.php/$1',0,0),('google','http://www.google.com/search?q=$1',0,0),('googlegroups','http://groups.google.com/groups?q=$1',0,0),('gotamac','http://www.got-a-mac.org/$1',0,0),('greencheese','http://www.greencheese.org/$1',0,0),('hammondwiki','http://www.dairiki.org/HammondWiki/index.php3?$1',0,0),('haribeau','http://wiki.haribeau.de/cgi-bin/wiki.pl?$1',0,0),('herzkinderwiki','http://www.herzkinderinfo.de/Mediawiki/index.php/$1',0,0),('hewikisource','http://he.wikisource.org/wiki/$1',1,0),('hrwiki','http://www.hrwiki.org/index.php/$1',0,0),('iawiki','http://www.IAwiki.net/$1',0,0),('imdb','http://us.imdb.com/Title?$1',0,0),('infosecpedia','http://www.infosecpedia.org/pedia/index.php/$1',0,0),('jargonfile','http://sunir.org/apps/meta.pl?wiki=JargonFile&redirect=$1',0,0),('jefo','http://www.esperanto-jeunes.org/vikio/index.php?$1',0,0),('jiniwiki','http://www.cdegroot.com/cgi-bin/jini?$1',0,0),('jspwiki','http://www.ecyrd.com/JSPWiki/Wiki.jsp?page=$1',0,0),('kerimwiki','http://wiki.oxus.net/$1',0,0),('kmwiki','http://www.voght.com/cgi-bin/pywiki?$1',0,0),('knowhow','http://www2.iro.umontreal.ca/~paquetse/cgi-bin/wiki.cgi?$1',0,0),('lanifexwiki','http://opt.lanifex.com/cgi-bin/wiki.pl?$1',0,0),('lasvegaswiki','http://wiki.gmnow.com/index.php/$1',0,0),('linuxwiki','http://www.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),('lutherwiki','http://www.lutheranarchives.com/mw/index.php/$1',0,0),('mathsongswiki','http://SeedWiki.com/page.cfm?wikiid=237&doc=$1',0,0),('mbtest','http://www.usemod.com/cgi-bin/mbtest.pl?$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','http://bugzilla.wikipedia.org/$1',1,0),('memoryalpha','http://www.memory-alpha.org/en/index.php/$1',0,0),('metaweb','http://www.metaweb.com/wiki/wiki.phtml?title=$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),('muweb','http://www.dunstable.com/scripts/MuWebWeb?$1',0,0),('netvillage','http://www.netbros.com/?$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),('opera7wiki','http://nontroppo.org/wiki/$1',0,0),('orgpatterns','http://www.bell-labs.com/cgi-user/OrgPatterns/OrgPatterns?$1',0,0),('osi reference model','http://wiki.tigma.ee/',0,0),('pangalacticorg','http://www.pangalactic.org/Wiki/$1',0,0),('patwiki','http://gauss.ffii.org/$1',0,0),('personaltelco','http://www.personaltelco.net/index.cgi/$1',0,0),('phpwiki','http://phpwiki.sourceforge.net/phpwiki/index.php?$1',0,0),('pikie','http://pikie.darktech.org/cgi/pikie?$1',0,0),('pmeg','http://www.bertilow.com/pmeg/$1.php',0,0),('ppr','http://c2.com/cgi/wiki?$1',0,0),('purlnet','http://purl.oclc.org/NET/$1',0,0),('pythoninfo','http://www.python.org/cgi-bin/moinmoin/$1',0,0),('pythonwiki','http://www.pythonwiki.de/$1',0,0),('pywiki','http://www.voght.com/cgi-bin/pywiki?$1',0,0),('raec','http://www.raec.clacso.edu.ar:8080/raec/Members/raecpedia/$1',0,0),('revo','http://purl.org/NET/voko/revo/art/$1.html',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),('scoutpedia','http://www.scoutpedia.info/index.php/$1',0,0),('seapig','http://www.seapig.org/$1',0,0),('seattlewiki','http://seattlewiki.org/wiki/$1',0,0),('seattlewireless','http://seattlewireless.net/?$1',0,0),('seeds','http://www.IslandSeeds.org/wiki/$1',0,0),('senseislibrary','http://senseis.xmp.net/?$1',0,0),('shakti','http://cgi.algonet.se/htbin/cgiwrap/pgd/ShaktiWiki/$1',0,0),('slashdot','http://slashdot.org/article.pl?sid=$1',0,0),('smikipedia','http://www.smikipedia.org/$1',0,0),('sockwiki','http://wiki.socklabs.com/$1',0,0),('sourceforge','http://sourceforge.net/$1',0,0),('squeak','http://minnow.cc.gatech.edu/squeak/$1',0,0),('strikiwiki','http://ch.twi.tudelft.nl/~mostert/striki/teststriki.pl?$1',0,0),('susning','http://www.susning.nu/$1',0,0),('svgwiki','http://www.protocol7.com/svg-wiki/default.asp?$1',0,0),('tavi','http://tavi.sourceforge.net/$1',0,0),('tejo','http://www.tejo.org/vikio/$1',0,0),('terrorwiki','http://www.liberalsagainstterrorism.com/wiki/index.php/$1',0,0),('theopedia','http://www.theopedia.com/$1',0,0),('tmbw','http://www.tmbw.net/wiki/index.php/$1',0,0),('tmnet','http://www.technomanifestos.net/?$1',0,0),('tmwiki','http://www.EasyTopicMaps.com/?page=$1',0,0),('turismo','http://www.tejo.org/turismo/$1',0,0),('twiki','http://twiki.org/cgi-bin/view/$1',0,0),('twistedwiki','http://purl.net/wiki/twisted/$1',0,0),('uea','http://www.tejo.org/uea/$1',0,0),('unreal','http://wiki.beyondunreal.com/wiki/$1',0,0),('ursine','http://wiki.ursine.ca/$1',0,0),('usej','http://www.tejo.org/usej/$1',0,0),('usemod','http://www.usemod.com/cgi-bin/wiki.pl?$1',0,0),('visualworks','http://wiki.cs.uiuc.edu/VisualWorks/$1',0,0),('warpedview','http://www.warpedview.com/index.php/$1',0,0),('webdevwikinl','http://www.promo-it.nl/WebDevWiki/index.php?page=$1',0,0),('webisodes','http://www.webisodes.org/$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.wikicities.com/index.php/$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',0,0),('wikinfo','http://www.wikinfo.org/wiki.php?title=$1',0,0),('wikipedia','http://en.wikipedia.org/wiki/$1',1,0),('wikiquote','http://en.wikiquote.org/wiki/$1',1,0),('wikisource','http://sources.wikipedia.org/wiki/$1',1,0),('wikispecies','http://species.wikipedia.org/wiki/$1',1,0),('wikitravel','http://wikitravel.org/en/$1',0,0),('wikiworld','http://WikiWorld.com/wiki/index.php/$1',0,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),('wlwiki','http://winslowslair.supremepixels.net/wiki/index.php/$1',0,0),('ypsieyeball','http://sknkwrks.dyndns.org:1957/writewiki/wiki.pl?$1',0,0),('zwiki','http://www.zwiki.org/$1',0,0),('zzz wiki','http://wiki.zzz.ee/',0,0);
235/*!40000 ALTER TABLE `mw_interwiki` ENABLE KEYS */;
236UNLOCK TABLES;
237
238--
239-- Table structure for table `mw_ipblocks`
240--
241
242DROP TABLE IF EXISTS `mw_ipblocks`;
243CREATE TABLE `mw_ipblocks` (
244  `ipb_id` int(8) NOT NULL auto_increment,
245  `ipb_address` tinyblob NOT NULL,
246  `ipb_user` int(8) unsigned NOT NULL default '0',
247  `ipb_by` int(8) unsigned NOT NULL default '0',
248  `ipb_reason` tinyblob NOT NULL,
249  `ipb_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
250  `ipb_auto` tinyint(1) NOT NULL default '0',
251  `ipb_anon_only` tinyint(1) NOT NULL default '0',
252  `ipb_create_account` tinyint(1) NOT NULL default '1',
253  `ipb_enable_autoblock` tinyint(1) NOT NULL default '1',
254  `ipb_expiry` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
255  `ipb_range_start` tinyblob NOT NULL,
256  `ipb_range_end` tinyblob NOT NULL,
257  `ipb_deleted` tinyint(1) NOT NULL default '0',
258  PRIMARY KEY  (`ipb_id`),
259  UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
260  KEY `ipb_user` (`ipb_user`),
261  KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
262  KEY `ipb_timestamp` (`ipb_timestamp`),
263  KEY `ipb_expiry` (`ipb_expiry`)
264) ENGINE=InnoDB DEFAULT CHARSET=latin1;
265
266--
267-- Dumping data for table `mw_ipblocks`
268--
269
270LOCK TABLES `mw_ipblocks` WRITE;
271/*!40000 ALTER TABLE `mw_ipblocks` DISABLE KEYS */;
272/*!40000 ALTER TABLE `mw_ipblocks` ENABLE KEYS */;
273UNLOCK TABLES;
274
275--
276-- Table structure for table `mw_job`
277--
278
279DROP TABLE IF EXISTS `mw_job`;
280CREATE TABLE `mw_job` (
281  `job_id` int(9) unsigned NOT NULL auto_increment,
282  `job_cmd` varchar(255) NOT NULL default '',
283  `job_namespace` int(11) NOT NULL default '0',
284  `job_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
285  `job_params` blob NOT NULL,
286  PRIMARY KEY  (`job_id`),
287  KEY `job_cmd` (`job_cmd`,`job_namespace`,`job_title`)
288) ENGINE=InnoDB DEFAULT CHARSET=latin1;
289
290--
291-- Dumping data for table `mw_job`
292--
293
294LOCK TABLES `mw_job` WRITE;
295/*!40000 ALTER TABLE `mw_job` DISABLE KEYS */;
296/*!40000 ALTER TABLE `mw_job` ENABLE KEYS */;
297UNLOCK TABLES;
298
299--
300-- Table structure for table `mw_langlinks`
301--
302
303DROP TABLE IF EXISTS `mw_langlinks`;
304CREATE TABLE `mw_langlinks` (
305  `ll_from` int(8) unsigned NOT NULL default '0',
306  `ll_lang` varchar(10) character set latin1 collate latin1_bin NOT NULL default '',
307  `ll_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
308  UNIQUE KEY `ll_from` (`ll_from`,`ll_lang`),
309  KEY `ll_lang` (`ll_lang`,`ll_title`)
310) ENGINE=InnoDB DEFAULT CHARSET=latin1;
311
312--
313-- Dumping data for table `mw_langlinks`
314--
315
316LOCK TABLES `mw_langlinks` WRITE;
317/*!40000 ALTER TABLE `mw_langlinks` DISABLE KEYS */;
318/*!40000 ALTER TABLE `mw_langlinks` ENABLE KEYS */;
319UNLOCK TABLES;
320
321--
322-- Table structure for table `mw_logging`
323--
324
325DROP TABLE IF EXISTS `mw_logging`;
326CREATE TABLE `mw_logging` (
327  `log_type` varchar(10) NOT NULL default '',
328  `log_action` varchar(10) NOT NULL default '',
329  `log_timestamp` varchar(14) NOT NULL default '19700101000000',
330  `log_user` int(10) unsigned NOT NULL default '0',
331  `log_namespace` int(11) NOT NULL default '0',
332  `log_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
333  `log_comment` varchar(255) NOT NULL default '',
334  `log_params` blob NOT NULL,
335  `log_id` int(10) unsigned NOT NULL auto_increment,
336  `log_deleted` tinyint(1) unsigned NOT NULL default '0',
337  PRIMARY KEY  (`log_id`),
338  KEY `type_time` (`log_type`,`log_timestamp`),
339  KEY `user_time` (`log_user`,`log_timestamp`),
340  KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`),
341  KEY `times` (`log_timestamp`)
342) ENGINE=InnoDB DEFAULT CHARSET=latin1;
343
344--
345-- Dumping data for table `mw_logging`
346--
347
348LOCK TABLES `mw_logging` WRITE;
349/*!40000 ALTER TABLE `mw_logging` DISABLE KEYS */;
350/*!40000 ALTER TABLE `mw_logging` ENABLE KEYS */;
351UNLOCK TABLES;
352
353--
354-- Table structure for table `mw_math`
355--
356
357DROP TABLE IF EXISTS `mw_math`;
358CREATE TABLE `mw_math` (
359  `math_inputhash` varchar(16) NOT NULL default '',
360  `math_outputhash` varchar(16) NOT NULL default '',
361  `math_html_conservativeness` tinyint(1) NOT NULL default '0',
362  `math_html` text,
363  `math_mathml` text,
364  UNIQUE KEY `math_inputhash` (`math_inputhash`)
365) ENGINE=InnoDB DEFAULT CHARSET=latin1;
366
367--
368-- Dumping data for table `mw_math`
369--
370
371LOCK TABLES `mw_math` WRITE;
372/*!40000 ALTER TABLE `mw_math` DISABLE KEYS */;
373/*!40000 ALTER TABLE `mw_math` ENABLE KEYS */;
374UNLOCK TABLES;
375
376--
377-- Table structure for table `mw_objectcache`
378--
379
380DROP TABLE IF EXISTS `mw_objectcache`;
381CREATE TABLE `mw_objectcache` (
382  `keyname` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
383  `value` mediumblob,
384  `exptime` datetime default NULL,
385  UNIQUE KEY `keyname` (`keyname`),
386  KEY `exptime` (`exptime`)
387) ENGINE=InnoDB DEFAULT CHARSET=latin1;
388
389--
390-- Dumping data for table `mw_objectcache`
391--
392
393LOCK TABLES `mw_objectcache` WRITE;
394/*!40000 ALTER TABLE `mw_objectcache` DISABLE KEYS */;
395/*!40000 ALTER TABLE `mw_objectcache` ENABLE KEYS */;
396UNLOCK TABLES;
397
398--
399-- Table structure for table `mw_oldimage`
400--
401
402DROP TABLE IF EXISTS `mw_oldimage`;
403CREATE TABLE `mw_oldimage` (
404  `oi_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
405  `oi_archive_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
406  `oi_size` int(8) unsigned NOT NULL default '0',
407  `oi_width` int(5) NOT NULL default '0',
408  `oi_height` int(5) NOT NULL default '0',
409  `oi_bits` int(3) NOT NULL default '0',
410  `oi_description` tinyblob NOT NULL,
411  `oi_user` int(5) unsigned NOT NULL default '0',
412  `oi_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
413  `oi_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
414  KEY `oi_name` (`oi_name`(10))
415) ENGINE=InnoDB DEFAULT CHARSET=latin1;
416
417--
418-- Dumping data for table `mw_oldimage`
419--
420
421LOCK TABLES `mw_oldimage` WRITE;
422/*!40000 ALTER TABLE `mw_oldimage` DISABLE KEYS */;
423/*!40000 ALTER TABLE `mw_oldimage` ENABLE KEYS */;
424UNLOCK TABLES;
425
426--
427-- Table structure for table `mw_page`
428--
429
430DROP TABLE IF EXISTS `mw_page`;
431CREATE TABLE `mw_page` (
432  `page_id` int(8) unsigned NOT NULL auto_increment,
433  `page_namespace` int(11) NOT NULL default '0',
434  `page_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
435  `page_restrictions` tinyblob NOT NULL,
436  `page_counter` bigint(20) unsigned NOT NULL default '0',
437  `page_is_redirect` tinyint(1) unsigned NOT NULL default '0',
438  `page_is_new` tinyint(1) unsigned NOT NULL default '0',
439  `page_random` double unsigned NOT NULL default '0',
440  `page_touched` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
441  `page_latest` int(8) unsigned NOT NULL default '0',
442  `page_len` int(8) unsigned NOT NULL default '0',
443  PRIMARY KEY  (`page_id`),
444  UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
445  KEY `page_random` (`page_random`),
446  KEY `page_len` (`page_len`)
447) ENGINE=InnoDB DEFAULT CHARSET=latin1;
448
449--
450-- Dumping data for table `mw_page`
451--
452
453LOCK TABLES `mw_page` WRITE;
454/*!40000 ALTER TABLE `mw_page` DISABLE KEYS */;
455INSERT INTO `mw_page` VALUES (1,0,'Hoofdpagina','',0,0,0,0.750326321276,'20070627135321',1,454);
456/*!40000 ALTER TABLE `mw_page` ENABLE KEYS */;
457UNLOCK TABLES;
458
459--
460-- Table structure for table `mw_page_restrictions`
461--
462
463DROP TABLE IF EXISTS `mw_page_restrictions`;
464CREATE TABLE `mw_page_restrictions` (
465  `pr_page` int(8) NOT NULL default '0',
466  `pr_type` varchar(255) NOT NULL default '',
467  `pr_level` varchar(255) NOT NULL default '',
468  `pr_cascade` tinyint(4) NOT NULL default '0',
469  `pr_user` int(8) default NULL,
470  `pr_expiry` varchar(14) character set latin1 collate latin1_bin default NULL,
471  `pr_id` int(10) unsigned NOT NULL auto_increment,
472  PRIMARY KEY  (`pr_page`,`pr_type`),
473  UNIQUE KEY `pr_id` (`pr_id`),
474  KEY `pr_page` (`pr_page`),
475  KEY `pr_typelevel` (`pr_type`,`pr_level`),
476  KEY `pr_level` (`pr_level`),
477  KEY `pr_cascade` (`pr_cascade`)
478) ENGINE=InnoDB DEFAULT CHARSET=latin1;
479
480--
481-- Dumping data for table `mw_page_restrictions`
482--
483
484LOCK TABLES `mw_page_restrictions` WRITE;
485/*!40000 ALTER TABLE `mw_page_restrictions` DISABLE KEYS */;
486/*!40000 ALTER TABLE `mw_page_restrictions` ENABLE KEYS */;
487UNLOCK TABLES;
488
489--
490-- Table structure for table `mw_pagelinks`
491--
492
493DROP TABLE IF EXISTS `mw_pagelinks`;
494CREATE TABLE `mw_pagelinks` (
495  `pl_from` int(8) unsigned NOT NULL default '0',
496  `pl_namespace` int(11) NOT NULL default '0',
497  `pl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
498  UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`),
499  KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`)
500) ENGINE=InnoDB DEFAULT CHARSET=latin1;
501
502--
503-- Dumping data for table `mw_pagelinks`
504--
505
506LOCK TABLES `mw_pagelinks` WRITE;
507/*!40000 ALTER TABLE `mw_pagelinks` DISABLE KEYS */;
508/*!40000 ALTER TABLE `mw_pagelinks` ENABLE KEYS */;
509UNLOCK TABLES;
510
511--
512-- Table structure for table `mw_querycache`
513--
514
515DROP TABLE IF EXISTS `mw_querycache`;
516CREATE TABLE `mw_querycache` (
517  `qc_type` char(32) NOT NULL default '',
518  `qc_value` int(5) unsigned NOT NULL default '0',
519  `qc_namespace` int(11) NOT NULL default '0',
520  `qc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
521  KEY `qc_type` (`qc_type`,`qc_value`)
522) ENGINE=InnoDB DEFAULT CHARSET=latin1;
523
524--
525-- Dumping data for table `mw_querycache`
526--
527
528LOCK TABLES `mw_querycache` WRITE;
529/*!40000 ALTER TABLE `mw_querycache` DISABLE KEYS */;
530/*!40000 ALTER TABLE `mw_querycache` ENABLE KEYS */;
531UNLOCK TABLES;
532
533--
534-- Table structure for table `mw_querycache_info`
535--
536
537DROP TABLE IF EXISTS `mw_querycache_info`;
538CREATE TABLE `mw_querycache_info` (
539  `qci_type` varchar(32) NOT NULL default '',
540  `qci_timestamp` varchar(14) NOT NULL default '19700101000000',
541  UNIQUE KEY `qci_type` (`qci_type`)
542) ENGINE=InnoDB DEFAULT CHARSET=latin1;
543
544--
545-- Dumping data for table `mw_querycache_info`
546--
547
548LOCK TABLES `mw_querycache_info` WRITE;
549/*!40000 ALTER TABLE `mw_querycache_info` DISABLE KEYS */;
550/*!40000 ALTER TABLE `mw_querycache_info` ENABLE KEYS */;
551UNLOCK TABLES;
552
553--
554-- Table structure for table `mw_querycachetwo`
555--
556
557DROP TABLE IF EXISTS `mw_querycachetwo`;
558CREATE TABLE `mw_querycachetwo` (
559  `qcc_type` char(32) NOT NULL default '',
560  `qcc_value` int(5) unsigned NOT NULL default '0',
561  `qcc_namespace` int(11) NOT NULL default '0',
562  `qcc_title` char(255) character set latin1 collate latin1_bin NOT NULL default '',
563  `qcc_namespacetwo` int(11) NOT NULL default '0',
564  `qcc_titletwo` char(255) character set latin1 collate latin1_bin NOT NULL default '',
565  KEY `qcc_type` (`qcc_type`,`qcc_value`),
566  KEY `qcc_title` (`qcc_type`,`qcc_namespace`,`qcc_title`),
567  KEY `qcc_titletwo` (`qcc_type`,`qcc_namespacetwo`,`qcc_titletwo`)
568) ENGINE=InnoDB DEFAULT CHARSET=latin1;
569
570--
571-- Dumping data for table `mw_querycachetwo`
572--
573
574LOCK TABLES `mw_querycachetwo` WRITE;
575/*!40000 ALTER TABLE `mw_querycachetwo` DISABLE KEYS */;
576/*!40000 ALTER TABLE `mw_querycachetwo` ENABLE KEYS */;
577UNLOCK TABLES;
578
579--
580-- Table structure for table `mw_recentchanges`
581--
582
583DROP TABLE IF EXISTS `mw_recentchanges`;
584CREATE TABLE `mw_recentchanges` (
585  `rc_id` int(8) NOT NULL auto_increment,
586  `rc_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
587  `rc_cur_time` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
588  `rc_user` int(10) unsigned NOT NULL default '0',
589  `rc_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
590  `rc_namespace` int(11) NOT NULL default '0',
591  `rc_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
592  `rc_comment` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
593  `rc_minor` tinyint(3) unsigned NOT NULL default '0',
594  `rc_bot` tinyint(3) unsigned NOT NULL default '0',
595  `rc_new` tinyint(3) unsigned NOT NULL default '0',
596  `rc_cur_id` int(10) unsigned NOT NULL default '0',
597  `rc_this_oldid` int(10) unsigned NOT NULL default '0',
598  `rc_last_oldid` int(10) unsigned NOT NULL default '0',
599  `rc_type` tinyint(3) unsigned NOT NULL default '0',
600  `rc_moved_to_ns` tinyint(3) unsigned NOT NULL default '0',
601  `rc_moved_to_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
602  `rc_patrolled` tinyint(3) unsigned NOT NULL default '0',
603  `rc_ip` varchar(15) NOT NULL default '',
604  `rc_old_len` int(10) default NULL,
605  `rc_new_len` int(10) default NULL,
606  `rc_deleted` tinyint(1) unsigned NOT NULL default '0',
607  `rc_logid` int(10) unsigned NOT NULL default '0',
608  `rc_log_type` varchar(255) character set latin1 collate latin1_bin default NULL,
609  `rc_log_action` varchar(255) character set latin1 collate latin1_bin default NULL,
610  `rc_params` blob NOT NULL,
611  PRIMARY KEY  (`rc_id`),
612  KEY `rc_timestamp` (`rc_timestamp`),
613  KEY `rc_namespace_title` (`rc_namespace`,`rc_title`),
614  KEY `rc_cur_id` (`rc_cur_id`),
615  KEY `new_name_timestamp` (`rc_new`,`rc_namespace`,`rc_timestamp`),
616  KEY `rc_ip` (`rc_ip`),
617  KEY `rc_ns_usertext` (`rc_namespace`,`rc_user_text`),
618  KEY `rc_user_text` (`rc_user_text`,`rc_timestamp`)
619) ENGINE=InnoDB DEFAULT CHARSET=latin1;
620
621--
622-- Dumping data for table `mw_recentchanges`
623--
624
625LOCK TABLES `mw_recentchanges` WRITE;
626/*!40000 ALTER TABLE `mw_recentchanges` DISABLE KEYS */;
627/*!40000 ALTER TABLE `mw_recentchanges` ENABLE KEYS */;
628UNLOCK TABLES;
629
630--
631-- Table structure for table `mw_redirect`
632--
633
634DROP TABLE IF EXISTS `mw_redirect`;
635CREATE TABLE `mw_redirect` (
636  `rd_from` int(8) unsigned NOT NULL default '0',
637  `rd_namespace` int(11) NOT NULL default '0',
638  `rd_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
639  PRIMARY KEY  (`rd_from`),
640  KEY `rd_ns_title` (`rd_namespace`,`rd_title`,`rd_from`)
641) ENGINE=InnoDB DEFAULT CHARSET=latin1;
642
643--
644-- Dumping data for table `mw_redirect`
645--
646
647LOCK TABLES `mw_redirect` WRITE;
648/*!40000 ALTER TABLE `mw_redirect` DISABLE KEYS */;
649/*!40000 ALTER TABLE `mw_redirect` ENABLE KEYS */;
650UNLOCK TABLES;
651
652--
653-- Table structure for table `mw_revision`
654--
655
656DROP TABLE IF EXISTS `mw_revision`;
657CREATE TABLE `mw_revision` (
658  `rev_id` int(8) unsigned NOT NULL auto_increment,
659  `rev_page` int(8) unsigned NOT NULL default '0',
660  `rev_text_id` int(8) unsigned NOT NULL default '0',
661  `rev_comment` tinyblob NOT NULL,
662  `rev_user` int(5) unsigned NOT NULL default '0',
663  `rev_user_text` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
664  `rev_timestamp` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
665  `rev_minor_edit` tinyint(1) unsigned NOT NULL default '0',
666  `rev_deleted` tinyint(1) unsigned NOT NULL default '0',
667  `rev_len` int(8) unsigned default NULL,
668  `rev_parent_id` int(8) unsigned default NULL,
669  PRIMARY KEY  (`rev_page`,`rev_id`),
670  UNIQUE KEY `rev_id` (`rev_id`),
671  KEY `rev_timestamp` (`rev_timestamp`),
672  KEY `page_timestamp` (`rev_page`,`rev_timestamp`),
673  KEY `user_timestamp` (`rev_user`,`rev_timestamp`),
674  KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
675) ENGINE=InnoDB DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024;
676
677--
678-- Dumping data for table `mw_revision`
679--
680
681LOCK TABLES `mw_revision` WRITE;
682/*!40000 ALTER TABLE `mw_revision` DISABLE KEYS */;
683INSERT INTO `mw_revision` VALUES (1,1,1,'',0,'MediaWiki default','20070627135321',0,0,454,NULL);
684/*!40000 ALTER TABLE `mw_revision` ENABLE KEYS */;
685UNLOCK TABLES;
686
687--
688-- Table structure for table `mw_searchindex`
689--
690
691DROP TABLE IF EXISTS `mw_searchindex`;
692CREATE TABLE `mw_searchindex` (
693  `si_page` int(8) unsigned NOT NULL default '0',
694  `si_title` varchar(255) NOT NULL default '',
695  `si_text` mediumtext NOT NULL,
696  UNIQUE KEY `si_page` (`si_page`),
697  FULLTEXT KEY `si_title` (`si_title`),
698  FULLTEXT KEY `si_text` (`si_text`)
699) ENGINE=MyISAM DEFAULT CHARSET=latin1;
700
701--
702-- Dumping data for table `mw_searchindex`
703--
704
705LOCK TABLES `mw_searchindex` WRITE;
706/*!40000 ALTER TABLE `mw_searchindex` DISABLE KEYS */;
707/*!40000 ALTER TABLE `mw_searchindex` ENABLE KEYS */;
708UNLOCK TABLES;
709
710--
711-- Table structure for table `mw_site_stats`
712--
713
714DROP TABLE IF EXISTS `mw_site_stats`;
715CREATE TABLE `mw_site_stats` (
716  `ss_row_id` int(8) unsigned NOT NULL default '0',
717  `ss_total_views` bigint(20) unsigned default '0',
718  `ss_total_edits` bigint(20) unsigned default '0',
719  `ss_good_articles` bigint(20) unsigned default '0',
720  `ss_total_pages` bigint(20) default '-1',
721  `ss_users` bigint(20) default '-1',
722  `ss_admins` int(10) default '-1',
723  `ss_images` int(10) default '0',
724  UNIQUE KEY `ss_row_id` (`ss_row_id`)
725) ENGINE=InnoDB DEFAULT CHARSET=latin1;
726
727--
728-- Dumping data for table `mw_site_stats`
729--
730
731LOCK TABLES `mw_site_stats` WRITE;
732/*!40000 ALTER TABLE `mw_site_stats` DISABLE KEYS */;
733INSERT INTO `mw_site_stats` VALUES (1,0,0,0,-1,-1,-1,0);
734/*!40000 ALTER TABLE `mw_site_stats` ENABLE KEYS */;
735UNLOCK TABLES;
736
737--
738-- Table structure for table `mw_templatelinks`
739--
740
741DROP TABLE IF EXISTS `mw_templatelinks`;
742CREATE TABLE `mw_templatelinks` (
743  `tl_from` int(8) unsigned NOT NULL default '0',
744  `tl_namespace` int(11) NOT NULL default '0',
745  `tl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
746  UNIQUE KEY `tl_from` (`tl_from`,`tl_namespace`,`tl_title`),
747  KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`)
748) ENGINE=InnoDB DEFAULT CHARSET=latin1;
749
750--
751-- Dumping data for table `mw_templatelinks`
752--
753
754LOCK TABLES `mw_templatelinks` WRITE;
755/*!40000 ALTER TABLE `mw_templatelinks` DISABLE KEYS */;
756/*!40000 ALTER TABLE `mw_templatelinks` ENABLE KEYS */;
757UNLOCK TABLES;
758
759--
760-- Table structure for table `mw_text`
761--
762
763DROP TABLE IF EXISTS `mw_text`;
764CREATE TABLE `mw_text` (
765  `old_id` int(8) unsigned NOT NULL auto_increment,
766  `old_text` mediumblob NOT NULL,
767  `old_flags` tinyblob NOT NULL,
768  PRIMARY KEY  (`old_id`)
769) ENGINE=InnoDB DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=10240;
770
771--
772-- Dumping data for table `mw_text`
773--
774
775LOCK TABLES `mw_text` WRITE;
776/*!40000 ALTER TABLE `mw_text` DISABLE KEYS */;
777INSERT INTO `mw_text` VALUES (1,'= Welkom bij de Mediawiki installatie op uw Syn-3 server =
778
779Raadpleeg de [http://meta.wikimedia.org/wiki/Help:Contents handleiding] voor informatie over het gebruik van de wikisoftware.
780
781U kunt zich aanmelden met uw standaard inlognaam en wachtwoord. (Die u ook voor uw Windows aanmelding, agenda en email gebruikt)
782
783De administrator heeft extra rechten en kan andere gebruikers ook rechten toekennen via [[Speciaal:Gebruikerrechten]].
784
785Het menu aan de linker kant kunt u als administrator wijzigen via [[MediaWiki:Sidebar]].
786
787== Geadvanceerde hulp ==
788
789* [http://www.mediawiki.org/wiki/Help:Configuration_settings Lijst met instellingen]
790* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]
791* [http://mail.wikimedia.org/mailman/listinfo/mediawiki-announce MediaWiki mailinglijst voor nieuwe versies]
792','utf-8');
793/*!40000 ALTER TABLE `mw_text` ENABLE KEYS */;
794UNLOCK TABLES;
795
796--
797-- Table structure for table `mw_trackbacks`
798--
799
800DROP TABLE IF EXISTS `mw_trackbacks`;
801CREATE TABLE `mw_trackbacks` (
802  `tb_id` int(11) NOT NULL auto_increment,
803  `tb_page` int(11) default NULL,
804  `tb_title` varchar(255) NOT NULL default '',
805  `tb_url` varchar(255) NOT NULL default '',
806  `tb_ex` text,
807  `tb_name` varchar(255) default NULL,
808  PRIMARY KEY  (`tb_id`),
809  KEY `tb_page` (`tb_page`)
810) ENGINE=InnoDB DEFAULT CHARSET=latin1;
811
812--
813-- Dumping data for table `mw_trackbacks`
814--
815
816LOCK TABLES `mw_trackbacks` WRITE;
817/*!40000 ALTER TABLE `mw_trackbacks` DISABLE KEYS */;
818/*!40000 ALTER TABLE `mw_trackbacks` ENABLE KEYS */;
819UNLOCK TABLES;
820
821--
822-- Table structure for table `mw_transcache`
823--
824
825DROP TABLE IF EXISTS `mw_transcache`;
826CREATE TABLE `mw_transcache` (
827  `tc_url` varchar(255) NOT NULL default '',
828  `tc_contents` text,
829  `tc_time` int(11) NOT NULL default '0',
830  UNIQUE KEY `tc_url_idx` (`tc_url`)
831) ENGINE=InnoDB DEFAULT CHARSET=latin1;
832
833--
834-- Dumping data for table `mw_transcache`
835--
836
837LOCK TABLES `mw_transcache` WRITE;
838/*!40000 ALTER TABLE `mw_transcache` DISABLE KEYS */;
839/*!40000 ALTER TABLE `mw_transcache` ENABLE KEYS */;
840UNLOCK TABLES;
841
842--
843-- Table structure for table `mw_user`
844--
845
846DROP TABLE IF EXISTS `mw_user`;
847CREATE TABLE `mw_user` (
848  `user_id` int(5) unsigned NOT NULL auto_increment,
849  `user_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
850  `user_real_name` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
851  `user_password` tinyblob NOT NULL,
852  `user_newpassword` tinyblob NOT NULL,
853  `user_newpass_time` varchar(14) character set latin1 collate latin1_bin default NULL,
854  `user_email` tinytext NOT NULL,
855  `user_options` blob NOT NULL,
856  `user_touched` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
857  `user_token` varchar(32) character set latin1 collate latin1_bin NOT NULL default '',
858  `user_email_authenticated` varchar(14) character set latin1 collate latin1_bin default NULL,
859  `user_email_token` varchar(32) character set latin1 collate latin1_bin default NULL,
860  `user_email_token_expires` varchar(14) character set latin1 collate latin1_bin default NULL,
861  `user_registration` varchar(14) character set latin1 collate latin1_bin default NULL,
862  `user_editcount` int(11) default NULL,
863  PRIMARY KEY  (`user_id`),
864  UNIQUE KEY `user_name` (`user_name`),
865  KEY `user_email_token` (`user_email_token`)
866) ENGINE=InnoDB DEFAULT CHARSET=latin1;
867
868--
869-- Dumping data for table `mw_user`
870--
871
872LOCK TABLES `mw_user` WRITE;
873/*!40000 ALTER TABLE `mw_user` DISABLE KEYS */;
874INSERT INTO `mw_user` VALUES (1,'Administrator','','2ff5c1d8b73a9a4241e98cedf69ef35d','',NULL,'','quickbar=1\nunderline=2\ncols=80\nrows=25\nsearchlimit=20\ncontextlines=5\ncontextchars=50\nskin=\nmath=1\nrcdays=7\nrclimit=50\nwllimit=250\nhighlightbroken=1\nstubthreshold=0\npreviewontop=1\neditsection=1\neditsectiononrightclick=0\nshowtoc=1\nshowtoolbar=1\ndate=default\nimagesize=2\nthumbsize=2\nrememberpassword=0\nenotifwatchlistpages=0\nenotifusertalkpages=1\nenotifminoredits=0\nenotifrevealaddr=0\nshownumberswatching=1\nfancysig=0\nexternaleditor=0\nexternaldiff=0\nshowjumplinks=1\nnumberheadings=0\nuselivepreview=0\nwatchlistdays=3\nvariant=nl\nlanguage=nl\nsearchNs0=1','20070627135326','19c5d82754c8fe5c9b759fd5180549d0',NULL,NULL,NULL,'20070627135320',0);
875/*!40000 ALTER TABLE `mw_user` ENABLE KEYS */;
876UNLOCK TABLES;
877
878--
879-- Table structure for table `mw_user_groups`
880--
881
882DROP TABLE IF EXISTS `mw_user_groups`;
883CREATE TABLE `mw_user_groups` (
884  `ug_user` int(5) unsigned NOT NULL default '0',
885  `ug_group` char(16) NOT NULL default '',
886  PRIMARY KEY  (`ug_user`,`ug_group`),
887  KEY `ug_group` (`ug_group`)
888) ENGINE=InnoDB DEFAULT CHARSET=latin1;
889
890--
891-- Dumping data for table `mw_user_groups`
892--
893
894LOCK TABLES `mw_user_groups` WRITE;
895/*!40000 ALTER TABLE `mw_user_groups` DISABLE KEYS */;
896INSERT INTO `mw_user_groups` VALUES (1,'bureaucrat'),(1,'sysop');
897/*!40000 ALTER TABLE `mw_user_groups` ENABLE KEYS */;
898UNLOCK TABLES;
899
900--
901-- Table structure for table `mw_user_newtalk`
902--
903
904DROP TABLE IF EXISTS `mw_user_newtalk`;
905CREATE TABLE `mw_user_newtalk` (
906  `user_id` int(5) NOT NULL default '0',
907  `user_ip` varchar(40) NOT NULL default '',
908  KEY `user_id` (`user_id`),
909  KEY `user_ip` (`user_ip`)
910) ENGINE=InnoDB DEFAULT CHARSET=latin1;
911
912--
913-- Dumping data for table `mw_user_newtalk`
914--
915
916LOCK TABLES `mw_user_newtalk` WRITE;
917/*!40000 ALTER TABLE `mw_user_newtalk` DISABLE KEYS */;
918/*!40000 ALTER TABLE `mw_user_newtalk` ENABLE KEYS */;
919UNLOCK TABLES;
920
921--
922-- Table structure for table `mw_watchlist`
923--
924
925DROP TABLE IF EXISTS `mw_watchlist`;
926CREATE TABLE `mw_watchlist` (
927  `wl_user` int(5) unsigned NOT NULL default '0',
928  `wl_namespace` int(11) NOT NULL default '0',
929  `wl_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
930  `wl_notificationtimestamp` varchar(14) character set latin1 collate latin1_bin default NULL,
931  UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`),
932  KEY `namespace_title` (`wl_namespace`,`wl_title`)
933) ENGINE=InnoDB DEFAULT CHARSET=latin1;
934
935--
936-- Dumping data for table `mw_watchlist`
937--
938
939LOCK TABLES `mw_watchlist` WRITE;
940/*!40000 ALTER TABLE `mw_watchlist` DISABLE KEYS */;
941/*!40000 ALTER TABLE `mw_watchlist` ENABLE KEYS */;
942UNLOCK TABLES;
943
944/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
945/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
946/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
947/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
948/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
949/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
950/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
951
Note: See TracBrowser for help on using the repository browser.