From: philipp Date: Wed, 1 Nov 2017 22:07:35 +0000 (+0000) Subject: Add table page to test data. X-Git-Url: https://git.toastfreeware.priv.at/philipp/winterrodeln/wradmin.git/commitdiff_plain/8b3f0695c82f30330a22843a3bfe388499dcaa33 Add table page to test data. git-svn-id: http://www.winterrodeln.org/svn/wradmin/trunk@2729 7aebc617-e5e2-0310-91dc-80fb5f6d2477 --- 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` --