Add table user to test data.

[philipp/winterrodeln/wradmin.git] / tests / testdb.sql

diff --git a/tests/testdb.sql b/tests/testdb.sql
index f310196e7ff6483148eb46fd52b649107ecf090f..90e5d1b2b3c32c75aca9dcb1a15f5fe0e928d5c6 100644 (file)
--- a/tests/testdb.sql
+++ b/tests/testdb.sql
@@ -508,6 +508,103 @@ INSERT INTO wrinncache VALUES (361,'Lindauer_Hütte_(Gasthaus)',47.034436,9.8356
 INSERT INTO wrinncache VALUES (362,'Meißner_Haus_(Gasthaus)',47.208367,11.488682,1720,'Sven Deppe',NULL,1,'65 Schlafplätze',0,1,NULL,NULL,NULL,'http://www.meissner-haus.at/','info@meissner-haus.at','+43-512-377697','Gasthaus_Meißner_Haus_02.jpg','[[Meißner Haus]]',0);
 INSERT INTO wrinncache VALUES (363,'Milderaun_Alm_(Gasthaus)',47.08768,11.257011,1675,'Milderaunalm OG',NULL,NULL,NULL,NULL,NULL,1,'Ja',NULL,'Nein','dez.testarossa@a1.net','+43-699-10036813','Gasthaus_Milderaun_Alm_01.jpg','[[Milderaun]]; [[Milderaun (kürzer)]]',1);
 INSERT INTO wrinncache VALUES (364,'Moonlight-Bar',47.495677136,12.197686555,720,'Gabi Schroll',NULL,0,NULL,1,1,0,NULL,'bob; T-Mobile A; orange AT; 3 AT','http://www.moonlightbar-soell.com/','schroll.gabi@aon.at','+43-664-4036006','Moonlight-Bar 2016-01-18.jpg','[[Söll - Hexenritt]]; [[Söll - Mondrodelbahn]]',0);
+
+
+
+--
+-- Table structure for table `wrregioncache`
+--
+
+DROP TABLE IF EXISTS wrregioncache;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE wrregioncache (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  region_id int(11) DEFAULT NULL,
+  page_id int(11) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY region_id (region_id),
+  CONSTRAINT wrregioncache_ibfk_1 FOREIGN KEY (region_id) REFERENCES wrregion (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=49147 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `wrregioncache`
+--
+INSERT INTO wrregioncache VALUES (48522,4,5);
+INSERT INTO wrregioncache VALUES (48523,5,5);
+INSERT INTO wrregioncache VALUES (48524,27,5);
+INSERT INTO wrregioncache VALUES (48525,28,5);
+INSERT INTO wrregioncache VALUES (48537,4,228);
+INSERT INTO wrregioncache VALUES (48538,25,228);
+INSERT INTO wrregioncache VALUES (48539,28,228);
+INSERT INTO wrregioncache VALUES (48565,2,237);
+INSERT INTO wrregioncache VALUES (48566,3,237);
+INSERT INTO wrregioncache VALUES (48567,4,237);
+INSERT INTO wrregioncache VALUES (48568,9,237);
+INSERT INTO wrregioncache VALUES (48569,28,237);
+INSERT INTO wrregioncache VALUES (48615,2,251);
+INSERT INTO wrregioncache VALUES (48616,3,251);
+INSERT INTO wrregioncache VALUES (48617,4,251);
+INSERT INTO wrregioncache VALUES (48618,9,251);
+INSERT INTO wrregioncache VALUES (48619,28,251);
+INSERT INTO wrregioncache VALUES (48718,10,283);
+INSERT INTO wrregioncache VALUES (48846,4,761);
+INSERT INTO wrregioncache VALUES (48847,5,761);
+INSERT INTO wrregioncache VALUES (48848,27,761);
+INSERT INTO wrregioncache VALUES (48849,28,761);
+INSERT INTO wrregioncache VALUES (48854,4,793);
+INSERT INTO wrregioncache VALUES (48855,12,793);
+INSERT INTO wrregioncache VALUES (48891,4,926);
+INSERT INTO wrregioncache VALUES (48892,12,926);
+INSERT INTO wrregioncache VALUES (48893,26,926);
+INSERT INTO wrregioncache VALUES (49023,22,1417);
+INSERT INTO wrregioncache VALUES (49124,4,1804);
+INSERT INTO wrregioncache VALUES (49125,12,1804);
+
+
+--
+-- Table structure for table `user`
+--
+
+DROP TABLE IF EXISTS `user`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user` (
+  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+  `user_real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+  `user_password` tinyblob NOT NULL,
+  `user_newpassword` tinyblob NOT NULL,
+  `user_newpass_time` binary(14) DEFAULT NULL,
+  `user_email` tinytext NOT NULL,
+  `user_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+  `user_token` binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
+  `user_email_authenticated` binary(14) DEFAULT NULL,
+  `user_email_token` binary(32) DEFAULT NULL,
+  `user_email_token_expires` binary(14) DEFAULT NULL,
+  `user_registration` binary(14) DEFAULT NULL,
+  `user_editcount` int(11) DEFAULT NULL,
+  `user_password_expires` varbinary(14) DEFAULT NULL,
+  PRIMARY KEY (`user_id`),
+  UNIQUE KEY `user_name` (`user_name`),
+  KEY `user_email_token` (`user_email_token`),
+  KEY `user_email` (`user_email`(50))
+) ENGINE=MyISAM AUTO_INCREMENT=505 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `user`
+--
+
+/*!40000 ALTER TABLE `user` DISABLE KEYS */;
+INSERT INTO `user` VALUES (0,'Anonymous','','','','\0\0\0\0\0\0\0\0\0\0\0\0\0\0','','20080922211544','\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,'\0\0\0\0\0\0\0\0\0\0\0\0\0\0','\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,NULL);
+INSERT INTO `user` VALUES (2,'RedirectBot','','','','20080925192203','','20120902200108','ea19a572ecaf2a6d5934b153e52c3ab9','20120902200103',NULL,'20120902200103','20080925192203',1,NULL);
+INSERT INTO `user` VALUES (504,'Johndoe','John Doe',':pbkdf2:sha512:30000:64:hvqT9kNNazXmOigsCc4ewQ==:hytd5I3h38y7jVmqXrv6IKD1zzJYp8ZrUyodInP49VbtKWfQAOYvhmbVFCdl7JK/suPmFLKbe309/jlta2Gk4A==','',NULL,'john.doe@example.com','20191129090658','f0a018e0cf3384411373d83b212128f0',NULL,'bdb23486b4efcab13063fabacc109bae','20191206090650','20191129090650',0,NULL);
+/*!40000 ALTER TABLE `user` ENABLE KEYS */;
+
+
+
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;