USE `test`; -- MySQL dump 10.13 Distrib 5.5.16, for Win32 (x86) -- -- Host: dev-mysql1.dev.cognito.co.uk Database: test -- ------------------------------------------------------ -- Server version 5.5.21-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!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 `RawData2` -- DROP TABLE IF EXISTS `RawData2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `RawData2` ( `id` int(11) NOT NULL DEFAULT '0', `customer_id` int(11) NOT NULL, `org_struct_id` int(11) NOT NULL, `org_struct_version_id` int(11) NOT NULL, `org_struct_name` varchar(100) NOT NULL, `org_struct_type_id` int(11) NOT NULL, `created_date_time` datetime DEFAULT NULL, `deleted_date_time` datetime DEFAULT NULL, `start_date_time` datetime NOT NULL, `end_date_time` datetime DEFAULT NULL, `lft` int(11) NOT NULL, `rgt` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `RawData2` -- LOCK TABLES `RawData2` WRITE; /*!40000 ALTER TABLE `RawData2` DISABLE KEYS */; INSERT INTO `RawData2` VALUES (1,1,1,1,'root',1,'2012-04-02 10:04:26',NULL,'2012-04-02 10:04:26',NULL,1,124),(2,1,2,2,'UK',2,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,2,123),(3,1,11,11,'Region 1',3,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,3,26),(4,1,12,12,'Region 2',3,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,27,50),(5,1,13,13,'Region 3',3,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,51,74),(6,1,14,14,'Region 4',3,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,75,98),(7,1,15,15,'Region 5',3,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,99,122),(8,1,101,101,'Depot 1',4,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,4,25),(9,1,102,102,'Depot 2',4,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,28,49),(10,1,103,103,'Depot 3',4,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,52,73),(11,1,104,104,'Depot 4',4,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,76,97),(12,1,105,105,'Depot 5',4,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,100,121),(13,1,1001,1001,'Team 1',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,5,6),(14,1,1002,1002,'Team 2',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,7,8),(15,1,1003,1003,'Team 3',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,9,10),(16,1,1004,1004,'Team 4',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,11,12),(17,1,1005,1005,'Team 5',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,13,14),(18,1,1006,1006,'Team 6',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,15,16),(19,1,1007,1007,'Team 7',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,17,18),(20,1,1008,1008,'Team 8',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,19,20),(21,1,1009,1009,'Team 9',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,21,22),(22,1,1010,1010,'Team 10',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,23,24),(23,1,1011,1011,'Team 11',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,29,30),(24,1,1012,1012,'Team 12',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,31,32),(25,1,1013,1013,'Team 13',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,33,34),(26,1,1014,1014,'Team 14',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,35,36),(27,1,1015,1015,'Team 15',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,37,38),(28,1,1016,1016,'Team 16',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,39,40),(29,1,1017,1017,'Team 17',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,41,42),(30,1,1018,1018,'Team 18',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,43,44),(31,1,1019,1019,'Team 19',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,45,46),(32,1,1020,1020,'Team 20',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,47,48),(33,1,1021,1021,'Team 21',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,53,54),(34,1,1022,1022,'Team 22',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,55,56),(35,1,1023,1023,'Team 23',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,57,58),(36,1,1024,1024,'Team 24',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,59,60),(37,1,1025,1025,'Team 25',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,61,62),(38,1,1026,1026,'Team 26',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,63,64),(39,1,1027,1027,'Team 27',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,65,66),(40,1,1028,1028,'Team 28',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,67,68),(41,1,1029,1029,'Team 29',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,69,70),(42,1,1030,1030,'Team 30',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,71,72),(43,1,1031,1031,'Team 31',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,77,78),(44,1,1032,1032,'Team 32',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,79,80),(45,1,1033,1033,'Team 33',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,81,82),(46,1,1034,1034,'Team 34',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,83,84),(47,1,1035,1035,'Team 35',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,85,86),(48,1,1036,1036,'Team 36',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,87,88),(49,1,1037,1037,'Team 37',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,89,90),(50,1,1038,1038,'Team 38',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,91,92),(51,1,1039,1039,'Team 39',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,93,94),(52,1,1040,1040,'Team 40',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,95,96),(53,1,1041,1041,'Team 41',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,101,102),(54,1,1042,1042,'Team 42',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,103,104),(55,1,1043,1043,'Team 43',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,105,106),(56,1,1044,1044,'Team 44',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,107,108),(57,1,1045,1045,'Team 45',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,109,110),(58,1,1046,1046,'Team 46',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,111,112),(59,1,1047,1047,'Team 47',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,113,114),(60,1,1048,1048,'Team 48',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,115,116),(61,1,1049,1049,'Team 49',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,117,118),(62,1,1050,1050,'Team 50',7,'2012-04-02 10:04:27',NULL,'2011-01-01 00:00:00',NULL,119,120); /*!40000 ALTER TABLE `RawData2` ENABLE KEYS */; UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2012-04-03 13:50:35