Add table categorylinks to test data.

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

diff --git a/tests/testdb.sql b/tests/testdb.sql
index fda4b449c1d6c685f34e8538e8d0180507e15b33..233282d16e8c16b6ca388a00ccc088a9ec5e9f46 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -89,6 +89,78 @@ INSERT INTO page VALUES (1353,0,'Stubaital_Wipptal','',0,0,0.681565462273,0x3230
 INSERT INTO page VALUES (1354,0,'Seefeld_Leutasch','',0,0,0.983349633505,0x3230313730343231313632363231,9075,566,NULL,NULL,NULL);
 
 
+
+--
+-- Table structure for table `categorylinks`
+--
+
+DROP TABLE IF EXISTS categorylinks;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE categorylinks (
+  cl_from int(10) unsigned NOT NULL DEFAULT '0',
+  cl_to varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+  cl_sortkey varbinary(230) NOT NULL DEFAULT '',
+  cl_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  cl_sortkey_prefix varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+  cl_collation varbinary(32) NOT NULL DEFAULT '',
+  cl_type enum('page','subcat','file') NOT NULL DEFAULT 'page',
+  UNIQUE KEY cl_from (cl_from,cl_to),
+  KEY cl_timestamp (cl_to,cl_timestamp),
+  KEY cl_sortkey (cl_to,cl_type,cl_sortkey,cl_from),
+  KEY cl_collation_ext (cl_collation,cl_to,cl_type,cl_from)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `categorylinks`
+--
+
+INSERT INTO categorylinks VALUES (5,'Rodelbahn',0x4249524749545A455220414C4D2028564F4D204144454C53484F4629,'2008-09-25 19:42:54','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (228,'Rodelbahn',0x4252414E44535441545420414C4D,'2008-10-31 18:20:02','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (237,'Rodelbahn',0x474C454952534348414C4D,'2008-10-31 18:20:28','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (251,'Rodelbahn',0x4A554946454E414C4D,'2008-10-31 18:20:51','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (283,'Rodelbahn',0x534348415454454E4C4147414E54,'2008-10-31 18:21:50','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (355,'Gasthaus',0x4B454D4154455220414C4D2028474153544841555329,'2008-10-31 19:10:23','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (356,'Gasthaus',0x4D415249412057414C445241535420284B4C4F53544552474153544841555329,'2008-10-31 19:10:24','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (357,'Gasthaus',0x4B52494E4E454E414C50452028474153544841555329,'2008-10-31 19:10:25','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (357,'In_Arbeit',0x4B52494E4E454E414C50452028474153544841555329,'2008-10-31 19:45:43','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (358,'Gasthaus',0x4C41525354494720414C4D2028474153544841555329,'2008-10-31 19:10:27','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (359,'Gasthaus',0x4C45484E42455247484155532028474153544841555329,'2008-10-31 19:10:28','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (360,'Gasthaus',0x4C4945434854454E535445494E484155532028474153544841555329,'2008-10-31 19:10:30','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (361,'Gasthaus',0x4C494E44415545522048C39C5454452028474153544841555329,'2008-10-31 19:10:31','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (362,'Gasthaus',0x4D4549C39F4E455220484155532028474153544841555329,'2008-10-31 19:10:32','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (363,'Gasthaus',0x4D494C44455241554E20414C4D2028474153544841555329,'2015-11-07 22:25:03','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (363,'In_Arbeit',0x4D494C44455241554E20414C4D2028474153544841555329,'2015-11-07 22:25:03','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (364,'Gasthaus',0x4D4F4F4E4C494748542D424152,'2008-10-31 19:10:36','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (365,'Gasthaus_(geschlossen)',0x4D5554544552455220414C4D2028474153544841555329,'2014-02-02 19:20:08','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (395,'Region',0x564F5241524C42455247,'2008-10-31 20:47:36','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (396,'Region',0x5354454945524D41524B,'2008-10-31 20:47:50','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (397,'Region',0x5449524F4C,'2008-10-31 20:48:05','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (761,'Rodelbahn',0x504C454953454E48C39C545445204158414D4552204C495A554D,'2010-03-16 12:06:13','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (793,'Rodelbahn',0x5052414E544E455220414C4D,'2010-06-18 12:04:41','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (833,'Region',0x5449524F4C204F4245524C414E44,'2010-12-30 09:44:11','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (834,'Region',0x5449524F4C20554E5445524C414E44,'2010-12-30 09:45:32','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (835,'Region',0x4F53545449524F4C,'2010-12-30 09:49:40','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (836,'Region',0x53C39C445449524F4C,'2010-12-30 09:56:18','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (837,'In_Arbeit',0x4BC384524E54454E,'2010-12-30 10:02:16','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (837,'Region',0x4BC384524E54454E,'2010-12-30 10:02:16','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (838,'Region',0x4E4F52445449524F4C,'2014-11-23 17:29:35','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (839,'In_Arbeit',0x53414C5A42555247,'2010-12-30 10:05:57','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (839,'Region',0x53414C5A42555247,'2010-12-30 10:05:57','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (879,'In_Arbeit',0x4F424552C396535445525245494348,'2011-01-17 18:59:44','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (879,'Region',0x4F424552C396535445525245494348,'2011-01-17 18:59:44','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (880,'Region',0x4E4945444552C396535445525245494348,'2011-01-17 19:04:25','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (881,'Region',0x5343485745495A,'2011-01-17 19:10:11','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (882,'Region',0x494E4E53425255434B,'2011-01-17 19:12:43','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (926,'Rodelbahn',0x48C39C484E4552535049454C,'2011-02-06 18:31:18','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (1353,'Region',0x53545542414954414C205749505054414C,'2013-11-24 09:02:31','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (1354,'Region',0x53454546454C44204C45555441534348,'2013-11-24 18:42:35','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (1417,'Rodelbahn',0x4752494E44454C57414C44202D204649525354,'2014-01-10 12:22:17','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (1804,'In_Arbeit',0x4841554E4F4C44,'2015-01-03 22:57:41','',0x757070657263617365,'page');
+INSERT INTO categorylinks VALUES (1804,'Rodelbahn',0x4841554E4F4C44,'2015-01-03 22:57:41','',0x757070657263617365,'page');
+
+
 --
 -- Table structure for table `wrreport`
 --