Add table revision to test data.

git-svn-id: http://www.winterrodeln.org/svn/wradmin/trunk@2731 7aebc617-e5e2-0310-91dc-80fb5f6d2477

diff --git a/tests/testdb.sql b/tests/testdb.sql
index 233282d16e8c16b6ca388a00ccc088a9ec5e9f46..ec9e9fe8b6e6643a722b8bdf513801c92f332736 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -161,6 +161,81 @@ INSERT INTO categorylinks VALUES (1804,'In_Arbeit',0x4841554E4F4C44,'2015-01-03
 INSERT INTO categorylinks VALUES (1804,'Rodelbahn',0x4841554E4F4C44,'2015-01-03 22:57:41','',0x757070657263617365,'page');
 
 
+--
+-- Table structure for table `revision`
+--
+
+DROP TABLE IF EXISTS revision;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE revision (
+  rev_id int(10) unsigned NOT NULL AUTO_INCREMENT,
+  rev_page int(10) unsigned NOT NULL,
+  rev_text_id int(10) unsigned NOT NULL,
+  rev_comment varbinary(767) NOT NULL,
+  rev_user int(10) unsigned NOT NULL DEFAULT '0',
+  rev_user_text varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+  rev_timestamp binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+  rev_minor_edit tinyint(3) unsigned NOT NULL DEFAULT '0',
+  rev_deleted tinyint(3) unsigned NOT NULL DEFAULT '0',
+  rev_len int(10) unsigned DEFAULT NULL,
+  rev_parent_id int(10) unsigned DEFAULT NULL,
+  rev_sha1 varbinary(32) NOT NULL DEFAULT '',
+  rev_content_format varbinary(64) DEFAULT NULL,
+  rev_content_model varbinary(32) DEFAULT NULL,
+  PRIMARY KEY (rev_page,rev_id),
+  UNIQUE KEY rev_id (rev_id),
+  KEY rev_timestamp (rev_timestamp),
+  KEY page_timestamp (rev_page,rev_timestamp),
+  KEY user_timestamp (rev_user,rev_timestamp),
+  KEY usertext_timestamp (rev_user_text,rev_timestamp),
+  KEY page_user_timestamp (rev_page,rev_user,rev_timestamp)
+) ENGINE=MyISAM AUTO_INCREMENT=12721 DEFAULT CHARSET=utf8 MAX_ROWS=10000000 AVG_ROW_LENGTH=1024;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `revision`
+--
+
+INSERT INTO revision VALUES (3683,360,3595,0x506F736974696F6E2065696E676566C3BC6774,1,'Philipp',0x3230313031323237323230303430,0,0,1371,3307,0x306735746E637569686B6D3633696D6C6C78756B30397564726866746A726E,NULL,NULL);
+INSERT INTO revision VALUES (4150,837,4053,0x277B7B496E204172626569747D7D2720766F72616E67657374656C6C742E,72,'Phibot',0x3230313130313234323033353133,1,0,447,3704,0x69326E663268376830796777633872627972357169616A6C3877687A617873,NULL,NULL);
+INSERT INTO revision VALUES (4153,879,4056,0x277B7B496E204172626569747D7D2720766F72616E67657374656C6C742E,72,'Phibot',0x3230313130313234323033353234,1,0,502,3919,0x716D646566737862707465326F7233363836376C36386A756C6F323964656A,NULL,NULL);
+INSERT INTO revision VALUES (5527,357,5412,0x277B7B4B65696E2047617374686175736265617566747261677465727D7D272067656CC3B6736368742E,72,'Phibot',0x3230313131323034313130303231,1,0,1099,5432,0x6E316132637363617571367075346536663332366D77373379323036337865,NULL,NULL);
+INSERT INTO revision VALUES (5965,361,5844,0x466F746F20617573676574617573636874,31,'Georg',0x3230313230323232323233383032,0,0,1517,5573,0x72667032787433346574386269706D307A39683468623170617A3070327133,NULL,NULL);
+INSERT INTO revision VALUES (6983,358,6844,0x47617374726F4C696665204C696E6B20656E746665726E74202865722066756E6B74696F6E6965727465206E69636874206D656872292E,72,'Phibot',0x3230313231313234313735363538,1,0,1600,3475,0x62683076393533306F64656968747A777373346F786C74746E326F6B646C6E,NULL,NULL);
+INSERT INTO revision VALUES (9070,395,8907,0x446965206E657565203C726F64656C6261686E746162656C6C653E20697374206E756E20696D2045696E7361747A203A2D29,1,'Philipp',0x3230313430313136323131343336,0,0,381,8552,0x313079777265326C356B3363727934663470713871717165716A6264366E72,NULL,NULL);
+INSERT INTO revision VALUES (9074,839,8911,0x446965206E657565203C726F64656C6261686E746162656C6C653E20697374206E756E20696D2045696E7361747A203A2D29,1,'Philipp',0x3230313430313136323132353139,0,0,597,4163,0x6C74343275353969376B6A76356D65626E33747A336B326B61337366307766,NULL,NULL);
+INSERT INTO revision VALUES (9075,1354,8912,0x446965206E657565203C726F64656C6261686E746162656C6C653E20697374206E756E20696D2045696E7361747A203A2D29,1,'Philipp',0x3230313430313136323132363539,0,0,566,8238,0x376B686A7A736A74616B6F6974616C64337035777537676835346631326177,NULL,NULL);
+INSERT INTO revision VALUES (9076,396,8913,0x446965206E657565203C726F64656C6261686E746162656C6C653E20697374206E756E20696D2045696E7361747A203A2D29,1,'Philipp',0x3230313430313136323132393434,0,0,366,8896,0x6B317A7A6E3672643072336F6339737874643963303272756D6E6C366D3830,NULL,NULL);
+INSERT INTO revision VALUES (9077,1353,8914,0x446965206E657565203C726F64656C6261686E746162656C6C653E20697374206E756E20696D2045696E7361747A203A2D29,1,'Philipp',0x3230313430313136323133333533,0,0,835,8891,0x397077646A7574723569756C7769303279767A7670656C66346F686F776578,NULL,NULL);
+INSERT INTO revision VALUES (9183,356,8719,0x5068696C697070207665727363686F62205365697465205B5B4B6C6F737465726761737468617573204D617269612057616C64726173745D5D206E616368205B5B4D617269612057616C647261737420284B6C6F737465726761737468617573295D5D3A205B5B557365723A476572616C645D5D3A202244696520536569746520736F6C6C74652061756620224D617269612057616C647261737420284B6C6F737465726761737468617573292220756D62656E616E6E742077657264656E2C2064616D69742073696520696D206170686162657469736368656E205665727A656963686E6973206175636820676566756E64656E20776972642E22,1,'Philipp',0x3230313430313237323133393137,1,0,1826,8880,0x667668656B70726B627974676634366338346B6E783363673233346A677867,NULL,NULL);
+INSERT INTO revision VALUES (9272,365,9103,0x4B617465676F726965206765C3A46E646572742E,1,'Philipp',0x3230313430323032323032303038,1,0,1311,9250,0x667A3078686376377666736F693736356C6A6A3378643439317A3462356B71,NULL,NULL);
+INSERT INTO revision VALUES (10320,881,10143,0x4C696E6B207A7520687474703A2F2F7777772E726F64656C6E2D7363687765697A2E63682F2065696E676566C3BC67742E,1,'Philipp',0x3230313430353230303834373439,0,0,694,10157,0x316C6E767178666D31786F737738336C68356178316E6D706670783074766E,NULL,NULL);
+INSERT INTO revision VALUES (10597,835,10413,0x4C696E6B20617566205469726F6C2D41746C617320526F64656C6261686E656E,14,'Bany-tyrol',0x3230313430393039323130313337,1,0,762,9073,0x307776786E6C30736E6C3575716C67766F743235747577673669316E693939,NULL,NULL);
+INSERT INTO revision VALUES (10675,836,10489,0x576569746572652053C3BC647469726F6C6572204261686E656E2022496E20417262656974222028506F736974696F6E732D4B6F6F7264696E6174656E206665686C656E2061626572206E6F636829,14,'Bany-tyrol',0x3230313431303235313430383239,1,0,729,9503,0x306C71633739763161646D71756961346938326F6533706833353063693575,NULL,NULL);
+INSERT INTO revision VALUES (10822,926,10634,0x506172616D6574657220224B6F7272656B747572203D205365697465222062656920566F726C6167652022427574746F6E6C6569737465222065696E676566C3BC67742E,72,'Phibot',0x3230313431313235323130363336,1,0,6123,10154,0x336C726A673936667069776B33676E746B6872306166666D66356865383761,NULL,NULL);
+INSERT INTO revision VALUES (10945,833,10757,0x4C696E6B732064617A75,14,'Bany-tyrol',0x3230313431313236313835333139,1,0,1221,9080,0x74646838636B656C776D6E6B636A77337A646D32636E7775336232776E6269,NULL,NULL);
+INSERT INTO revision VALUES (10986,397,10796,0x22496E2041726265697422207A65696774206E756E206E7572206D656872204E6F72647469726F6C2028697374206E756E20616C7320526567696F6E20696E2064657220526567696F6E656E646174656E62616E6B2076657266C3BC67626172292E,1,'Philipp',0x3230313431323033323330323432,1,0,1466,10596,0x6F797379676273306A74656F386A7732616B6A637369697732683538716173,NULL,NULL);
+INSERT INTO revision VALUES (11026,882,10836,0x5472656E6E756E672053747562616974616C2F5769707074616C,14,'Bany-tyrol',0x3230313431323130323132363136,1,0,1531,9078,0x6C377A6E666E7A716B77383630396E68687672717A766467787A306B71396B,NULL,NULL);
+INSERT INTO revision VALUES (11258,1804,11067,0x48616C74657374656C6C652065696E676566C3BC67742E,1,'Philipp',0x3230313530313037323135303532,0,0,4441,11257,0x746E6B3935646C31796E31777273306363653168716A7A337875303278756C,NULL,NULL);
+INSERT INTO revision VALUES (11394,793,11203,0x436974796275732066C3A4687274206A65747A742074C3A4676C6963683B20496E666F20766F6E2048722E20476F676C2F5072616E746E657220416C6D2E2044616E6B6521,14,'Bany-tyrol',0x3230313530313231323235303035,1,0,4508,10867,0x736F6E7133676C633462636B70686663383730306574616233337336337838,NULL,NULL);
+INSERT INTO revision VALUES (11442,283,11251,0x566572616C746574656E204C696E6B2065727365747A742E,1,'Philipp',0x3230313530313236323235303339,1,0,5537,7929,0x64306636346F6C39683667756161677163756D6F626B3277797A6B6D6E6767,NULL,NULL);
+INSERT INTO revision VALUES (11469,362,11278,'',23,'Sven',0x3230313530323032313030323036,0,0,2030,11468,0x337A6466616631687962666765346C746D306A676374707161396436346F61,NULL,NULL);
+INSERT INTO revision VALUES (11782,834,11586,0x42657A69726B202D3E20526567696F6E2028617566204772756E6420766F6E20466565646261636B206461737320526F64656C6261686E656E20696E2066616C736368656E2042657A69726B656E207665727A656963686E65742073696E64292E,1,'Philipp',0x3230313630313034323030353338,0,0,1085,11086,0x636B3276707876336D72713973706C37693373736D716E3130696C65796A69,NULL,NULL);
+INSERT INTO revision VALUES (11892,363,11689,0x4C696E6B73206175736765746175736368742E,1,'Philipp',0x3230313630313132323030343435,1,0,1196,11727,0x306C3779666B6F6B6572716D6D6679343332696E6E37713568367976353770,NULL,NULL);
+INSERT INTO revision VALUES (12078,237,11875,0x4C696E6B207A7520496D7072657373696F6E656E2065696E676566C3BC67742E,1,'Philipp',0x3230313630323237323233353532,0,0,5844,11349,0x6436393972786F79617468616C366C7074657A77716262376B7765636C376B,NULL,NULL);
+INSERT INTO revision VALUES (12172,880,11969,0x2F2A20323220526F64656C6261686E656E20696E204E6965646572C3B6737465727265696368202A2F,110,'Mitterhofer',0x3230313631313138313632323238,0,0,801,9072,0x6E6964376F7A797670763636696E62686B316C6638643764716E6130747630,NULL,NULL);
+INSERT INTO revision VALUES (12211,364,12008,0x466F746F20617573676574617573636874202864616E6B65205B5B557365723A54686F6D61735D5D20756E64204D617274696E2047756767656E6265726765722E,1,'Philipp',0x3230313631313238323035383135,0,0,1343,7069,0x74696371326A7262697168353978316B7A67326169367164376E76746F7177,NULL,NULL);
+INSERT INTO revision VALUES (12260,1417,12056,0x5765626175736B756E6674206B6F72726967696572742E,1,'Philipp',0x3230313631323038313633373331,1,0,9027,12236,0x7375707832757561756A647A646D63316E37346A74736F337A7731766F6333,NULL,NULL);
+INSERT INTO revision VALUES (12306,838,12101,0x48696572206269747465206B65696E65204B6F6E74616B74696E666F73207A75204761737462657472696562656E202D2D3E20496E666F20646972656B742062656920646572205365697465206465732048657265626E657220416C6D776972742065696E676574726167656E2E,14,'Bany-tyrol',0x3230313631323231323131333538,1,0,2449,12304,0x636A6E796F636864796E63716F69796F71783179637439343973786E74646C,NULL,NULL);
+INSERT INTO revision VALUES (12312,251,12106,0x486F6D65706167652D4C696E6B20646572204A756966656E616C6D,14,'Bany-tyrol',0x3230313631323232323332303536,1,0,6609,11915,0x6F6F746B656571677176703739786E6C70387A6D357131377A77347271796E,NULL,NULL);
+INSERT INTO revision VALUES (12403,5,12193,0x46616872706C616E20526F64656C627573204178616D6572204C697A756D,104,'Simon04',0x3230313730313039313032383234,0,0,8351,10752,0x6D6C716D353068323669776878666B6E336A74776E3468343372336D717133,NULL,NULL);
+INSERT INTO revision VALUES (12404,761,12194,0x46616872706C616E20526F64656C627573204178616D6572204C697A756D,104,'Simon04',0x3230313730313039313032393535,0,0,5975,11486,0x6B30696C7A30373468316D7A38676C6C6F387A666D796B3172696B656E7972,NULL,NULL);
+INSERT INTO revision VALUES (12438,359,12224,0x536372697074206861747465206B65696E6520467265756465206D69742064656D20466F726D6174206465722054656C65666F6E2D4E722E20696E206465722052422D426F78,14,'Bany-tyrol',0x3230313730313131313931363336,1,0,1469,12396,0x357A76356563756873726F646179337235373478706C6B37306B32697A766E,NULL,NULL);
+INSERT INTO revision VALUES (12495,228,12277,0x53747265636B656E66C3BC6872756E6720646572204C696E696520353930206B6F72726967696572742E,72,'Phibot',0x3230313730313134323135363132,1,0,6254,12490,0x6161636779686438666E78327734306F32727A7177636F366B643531333436,NULL,NULL);
+INSERT INTO revision VALUES (12515,355,12295,0x4C61757420526F64656C6261686E62657269636874206E69636874206D656872207261756368667265692E,1,'Philipp',0x3230313730313137323132383539,0,0,1951,11921,0x69656D697763666866347463796D316B77367A62653566357363656C796870,NULL,NULL);
+
+
 --
 -- Table structure for table `wrreport`
 --