X-Git-Url: https://git.toastfreeware.priv.at/philipp/winterrodeln/wradmin.git/blobdiff_plain/4276369f5f2d964157b78e3bfa8a291eb937d6cc..8b3f0695c82f30330a22843a3bfe388499dcaa33:/tests/testdb.sql

diff --git a/tests/testdb.sql b/tests/testdb.sql
index d175a43..fda4b44 100644
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -15,6 +15,80 @@
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
+
+
+--
+-- Table structure for table `page`
+--
+
+DROP TABLE IF EXISTS page;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `page` (
+  page_id int(10) unsigned NOT NULL AUTO_INCREMENT,
+  page_namespace int(11) NOT NULL,
+  page_title varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+  page_restrictions tinyblob NOT NULL,
+  page_is_redirect tinyint(3) unsigned NOT NULL DEFAULT '0',
+  page_is_new tinyint(3) unsigned NOT NULL DEFAULT '0',
+  page_random double unsigned NOT NULL,
+  page_touched binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+  page_latest int(10) unsigned NOT NULL,
+  page_len int(10) unsigned NOT NULL,
+  page_content_model varbinary(32) DEFAULT NULL,
+  page_links_updated varbinary(14) DEFAULT NULL,
+  page_lang varbinary(35) DEFAULT NULL,
+  PRIMARY KEY (page_id),
+  UNIQUE KEY name_title (page_namespace,page_title),
+  KEY page_random (page_random),
+  KEY page_len (page_len),
+  KEY page_redirect_namespace_len (page_is_redirect,page_namespace,page_len)
+) ENGINE=MyISAM AUTO_INCREMENT=2083 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `page`
+--
+
+INSERT INTO page VALUES (5,0,'Birgitzer_Alm_(vom_Adelshof)','',0,0,0.245395658322,0x3230313730343231313632363231,12403,8351,0x77696B6974657874,0x3230313730313039313133343437,NULL);
+INSERT INTO page VALUES (228,0,'Brandstatt_Alm','',0,0,0.420865595755,0x3230313730333235323230363132,12495,6254,0x77696B6974657874,0x3230313730313134323135363236,NULL);
+INSERT INTO page VALUES (237,0,'Gleirschalm','',0,0,0.267926731142,0x3230313730333236323132353238,12078,5844,0x77696B6974657874,0x3230313730313039313133343433,NULL);
+INSERT INTO page VALUES (251,0,'Juifenalm','',0,0,0.320622258017,0x3230313730333230323231373038,12312,6609,0x77696B6974657874,0x3230313730313039313133353438,NULL);
+INSERT INTO page VALUES (283,0,'Schattenlagant','',0,0,0.925867554414,0x3230313730323236313330323031,11442,5537,0x77696B6974657874,0x3230313630313130323031393331,NULL);
+INSERT INTO page VALUES (761,0,'PleisenhÃ¼tte_Axamer_Lizum','',0,0,0.33473706828,0x3230313730333236303430333539,12404,5975,0x77696B6974657874,0x3230313730313039313133323033,NULL);
+INSERT INTO page VALUES (793,0,'Prantner_Alm','',0,0,0.975670831008,0x3230313730333139313735363037,11394,4508,0x77696B6974657874,0x3230313630313130323030363339,NULL);
+INSERT INTO page VALUES (926,0,'HÃ¼hnerspiel','',0,0,0.87216336172,0x3230313730313239313730323530,10822,6123,0x77696B6974657874,0x3230313630313130323031353433,NULL);
+INSERT INTO page VALUES (1417,0,'Grindelwald_-_First','',0,0,0.640240649077,0x3230313730333239323332343439,12260,9027,0x77696B6974657874,0x3230313631323038313633373431,NULL);
+INSERT INTO page VALUES (1804,0,'Haunold','',0,0,0.202512472779,0x3230313730333232303630373538,11258,4441,0x77696B6974657874,0x3230313730313137323132363532,NULL);
+INSERT INTO page VALUES (355,0,'Kemater_Alm_(Gasthaus)','',0,0,0.770945735412,0x3230313730313137323132383539,12515,1951,0x77696B6974657874,0x3230313730313137323132393130,NULL);
+INSERT INTO page VALUES (356,0,'Maria_Waldrast_(Klostergasthaus)','',0,0,0.021824966909,0x3230313530393038313930303331,9183,1826,NULL,0x3230313530393038323031313338,NULL);
+INSERT INTO page VALUES (357,0,'Krinnenalpe_(Gasthaus)','',0,0,0.422007001783,0x3230313730313132323034393131,5527,1099,NULL,0x3230313730313137323133303435,NULL);
+INSERT INTO page VALUES (358,0,'Larstig_Alm_(Gasthaus)','',0,0,0.746338456577,0x3230313530393038313930303331,6983,1600,NULL,0x3230313530393038323031363531,NULL);
+INSERT INTO page VALUES (359,0,'Lehnberghaus_(Gasthaus)','',0,0,0.79085762362,0x3230313730313131313931363336,12438,1469,0x77696B6974657874,0x3230313730313131313931363338,NULL);
+INSERT INTO page VALUES (360,0,'Liechtensteinhaus_(Gasthaus)','',0,0,0.226321696251,0x3230313530393038313930303331,3683,1371,NULL,0x3230313530393038313935323436,NULL);
+INSERT INTO page VALUES (361,0,'Lindauer_HÃ¼tte_(Gasthaus)','',0,0,0.9573146328,0x3230313530393038313930303331,5965,1517,NULL,0x3230313530393038313933373231,NULL);
+INSERT INTO page VALUES (362,0,'MeiÃner_Haus_(Gasthaus)','',0,0,0.990841043284,0x3230313530393038313930303331,11469,2030,0x77696B6974657874,0x3230313530393038313935393239,NULL);
+INSERT INTO page VALUES (363,0,'Milderaun_Alm_(Gasthaus)','',0,0,0.590452460099,0x3230313630313132323030343435,11892,1196,0x77696B6974657874,0x3230313630313132323030343435,NULL);
+INSERT INTO page VALUES (364,0,'Moonlight-Bar','',0,0,0.26113951404,0x3230313631313238323035383135,12211,1343,0x77696B6974657874,0x3230313631313238323130353239,NULL);
+INSERT INTO page VALUES (365,0,'Mutterer_Alm_(Gasthaus)','',0,0,0.601568574877,0x3230313530393038313930303331,9272,1311,NULL,0x3230313530393038313931373436,NULL);
+INSERT INTO page VALUES (395,0,'Vorarlberg','',0,0,0.329166337552,0x3230313730343231313632363231,9070,381,NULL,NULL,NULL);
+INSERT INTO page VALUES (396,0,'Steiermark','',0,0,0.419857416536,0x3230313730343231313632363231,9076,366,NULL,NULL,NULL);
+INSERT INTO page VALUES (397,0,'Tirol','',0,0,0.896511648088,0x3230313730373130323131383530,10986,1466,0x77696B6974657874,0x3230313431323033323330323432,NULL);
+INSERT INTO page VALUES (833,0,'Tirol_Oberland','',0,0,0.295231042657,0x3230313730343231313632363231,10945,1221,0x77696B6974657874,0x3230313431313236313835333139,NULL);
+INSERT INTO page VALUES (834,0,'Tirol_Unterland','',0,0,0.698035112516,0x3230313730343231313632363231,11782,1085,0x77696B6974657874,0x3230313630313034323030353337,NULL);
+INSERT INTO page VALUES (835,0,'Osttirol','',0,0,0.247561928582,0x3230313730343231313632363231,10597,762,0x77696B6974657874,0x3230313430393039323130313336,NULL);
+INSERT INTO page VALUES (836,0,'SÃ¼dtirol','',0,0,0.461877854356,0x3230313730343231313632363231,10675,729,0x77696B6974657874,0x3230313431313036313531313032,NULL);
+INSERT INTO page VALUES (837,0,'KÃ¤rnten','',0,0,0.597744706979,0x3230313730343231313632363231,4150,447,NULL,NULL,NULL);
+INSERT INTO page VALUES (838,0,'Nordtirol','',0,0,0.936588774986,0x3230313730343231313632363231,12306,2449,0x77696B6974657874,0x3230313631323231323131343433,NULL);
+INSERT INTO page VALUES (839,0,'Salzburg','',0,0,0.497455784328,0x3230313730343231313632363231,9074,597,NULL,NULL,NULL);
+INSERT INTO page VALUES (879,0,'OberÃ¶sterreich','',0,0,0.833904954222,0x3230313730343231313632363231,4153,502,NULL,NULL,NULL);
+INSERT INTO page VALUES (880,0,'NiederÃ¶sterreich','',0,0,0.183306500609,0x3230313730343231313632363231,12172,801,0x77696B6974657874,0x3230313631313138313632323330,NULL);
+INSERT INTO page VALUES (881,0,'Schweiz','',0,0,0.442140848848,0x3230313730353135323132393336,10320,694,NULL,NULL,NULL);
+INSERT INTO page VALUES (882,0,'Innsbruck','',0,0,0.729341263059,0x3230313730343231313632363231,11026,1531,0x77696B6974657874,0x3230313431323130323132363135,NULL);
+INSERT INTO page VALUES (1353,0,'Stubaital_Wipptal','',0,0,0.681565462273,0x3230313730343231313632363231,9077,835,NULL,NULL,NULL);
+INSERT INTO page VALUES (1354,0,'Seefeld_Leutasch','',0,0,0.983349633505,0x3230313730343231313632363231,9075,566,NULL,NULL,NULL);
+
+
 --
 -- Table structure for table `wrreport`
 --
