Yy2v0W9s

1DROP TABLE IF EXISTS `planning_users`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `planning_users` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `project_id` char(13) DEFAULT NULL,
7  `task_id` char(13) DEFAULT NULL,
8  `center_id` int(10) unsigned NOT NULL,
9  `january` float DEFAULT NULL,
10  `february` float DEFAULT NULL,
11  `march` float DEFAULT NULL,
12  `april` float DEFAULT NULL,
13  `may` float DEFAULT NULL,
14  `june` float DEFAULT NULL,
15  `july` float DEFAULT NULL,
16  `august` float DEFAULT NULL,
17  `september` float DEFAULT NULL,
18  `october` float DEFAULT NULL,
19  `november` float DEFAULT NULL,
20  `december` float DEFAULT NULL,
21  `active` int(1) NOT NULL DEFAULT '1',
22  PRIMARY KEY (`id`),
23  UNIQUE KEY `task_id_UNIQUE` (`task_id`)
24) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
25/*!40101 SET character_set_client = @saved_cs_client */;
26
27--
28-- Dumping data for table `planning_users`
29--
30
31LOCK TABLES `planning_users` WRITE;
32/*!40000 ALTER TABLE `planning_users` DISABLE KEYS */;
33INSERT INTO `planning_users` VALUES (1,'gnu593ng93u4b','n348gub343',6950249,1.051,1.051,1.051,1.051,1.051,1.051,1.051,1.051,1.051,1.051,1.051,1.051,1);
34/*!40000 ALTER TABLE `planning_users` ENABLE KEYS */;
35UNLOCK TABLES;
36
37--
38-- Table structure for table `planning_projects`
39--
40
41DROP TABLE IF EXISTS `planning_projects`;
42/*!40101 SET @saved_cs_client     = @@character_set_client */;
43/*!40101 SET character_set_client = utf8 */;
44CREATE TABLE `planning_projects` (
45  `id` int(11) NOT NULL AUTO_INCREMENT,
46  `project_id` char(13) DEFAULT NULL,
47  `project_number` varchar(50) DEFAULT NULL,
48  `project_name` varchar(50) DEFAULT NULL,
49  `owner_center_id` int(10) unsigned NOT NULL,
50  `active` int(1) NOT NULL DEFAULT '1',
51  PRIMARY KEY (`id`),
52  UNIQUE KEY `unique_id_UNIQUE` (`project_id`)
53) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
54/*!40101 SET character_set_client = @saved_cs_client */;
55
56--
57-- Dumping data for table `planning_projects`
58--
59
60LOCK TABLES `planning_projects` WRITE;
61/*!40000 ALTER TABLE `planning_projects` DISABLE KEYS */;
62INSERT INTO `planning_projects` VALUES (1,'gnu593ng93u4b','AEWC-04-254','New Cool Project',1,1);
63/*!40000 ALTER TABLE `planning_projects` ENABLE KEYS */;
64UNLOCK TABLES;
65
66--
67-- Table structure for table `planning_tasks`
68--
69
70DROP TABLE IF EXISTS `planning_tasks`;
71/*!40101 SET @saved_cs_client     = @@character_set_client */;
72/*!40101 SET character_set_client = utf8 */;
73CREATE TABLE `planning_tasks` (
74  `id` int(11) NOT NULL AUTO_INCREMENT,
75  `project_id` char(13) DEFAULT NULL,
76  `task_id` char(13) DEFAULT NULL,
77  `task_name` varchar(50) DEFAULT NULL,
78  `active` int(1) NOT NULL DEFAULT '1',
79  PRIMARY KEY (`id`),
80  UNIQUE KEY `unique_id_UNIQUE` (`project_id`),
81  UNIQUE KEY `project_id_UNIQUE` (`project_id`),
82  UNIQUE KEY `task_id_UNIQUE` (`task_id`)
83) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `planning_tasks`
88--
89
90LOCK TABLES `planning_tasks` WRITE;
91/*!40000 ALTER TABLE `planning_tasks` DISABLE KEYS */;
92INSERT INTO `planning_tasks` VALUES (1,'gnu593ng93u4b','n348gub343','First Task',1);
93/*!40000 ALTER TABLE `planning_tasks` ENABLE KEYS */;
94UNLOCK TABLES;