QGpqcCms

1-- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64)
2--
3-- Host: mysql-cld.petrosoft.apps    Database: sap_mapping
4-- ------------------------------------------------------
5-- Server version	5.5.30
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `migration_versions`
20--
21
22DROP TABLE IF EXISTS `migration_versions`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `migration_versions` (
26  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
27  PRIMARY KEY (`version`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
29/*!40101 SET character_set_client = @saved_cs_client */;
30
31--
32-- Dumping data for table `migration_versions`
33--
34
35LOCK TABLES `migration_versions` WRITE;
36/*!40000 ALTER TABLE `migration_versions` DISABLE KEYS */;
37INSERT INTO `migration_versions` VALUES ('20170914063430'),('20171012091516'),('20171023071739'),('20171128074717'),('20171219212646'),('20171226225357');
38/*!40000 ALTER TABLE `migration_versions` ENABLE KEYS */;
39UNLOCK TABLES;
40
41--
42-- Table structure for table `sap_mapping`
43--
44
45DROP TABLE IF EXISTS `sap_mapping`;
46/*!40101 SET @saved_cs_client     = @@character_set_client */;
47/*!40101 SET character_set_client = utf8 */;
48CREATE TABLE `sap_mapping` (
49  `id` int(11) NOT NULL AUTO_INCREMENT,
50  `company_id` int(11) NOT NULL,
51  `dbname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
52  PRIMARY KEY (`id`),
53  UNIQUE KEY `company_id_idx` (`company_id`),
54  CONSTRAINT `FK_9A4D3B1B979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `sap_mapping_company` (`id`)
55) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58--
59-- Dumping data for table `sap_mapping`
60--
61
62LOCK TABLES `sap_mapping` WRITE;
63/*!40000 ALTER TABLE `sap_mapping` DISABLE KEYS */;
64INSERT INTO `sap_mapping` VALUES (130,130,'SG_EN_DEMO'),(197,197,'SG_GR_DEMO');
65/*!40000 ALTER TABLE `sap_mapping` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `sap_mapping_company`
70--
71
72DROP TABLE IF EXISTS `sap_mapping_company`;
73/*!40101 SET @saved_cs_client     = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `sap_mapping_company` (
76  `id` int(11) NOT NULL,
77  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
78  PRIMARY KEY (`id`),
79  UNIQUE KEY `UNIQ_983212E4BF396750` (`id`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
81/*!40101 SET character_set_client = @saved_cs_client */;
82
83--
84-- Dumping data for table `sap_mapping_company`
85--
86
87LOCK TABLES `sap_mapping_company` WRITE;
88/*!40000 ALTER TABLE `sap_mapping_company` DISABLE KEYS */;
89INSERT INTO `sap_mapping_company` VALUES (130,'SG 2 Energy LLC'),(197,'SGII GROUP LLC');
90/*!40000 ALTER TABLE `sap_mapping_company` ENABLE KEYS */;
91UNLOCK TABLES;
92
93--
94-- Table structure for table `sap_mapping_location`
95--
96
97DROP TABLE IF EXISTS `sap_mapping_location`;
98/*!40101 SET @saved_cs_client     = @@character_set_client */;
99/*!40101 SET character_set_client = utf8 */;
100CREATE TABLE `sap_mapping_location` (
101  `id` int(11) NOT NULL AUTO_INCREMENT,
102  `company_id` int(11) DEFAULT NULL,
103  `location_id` int(11) NOT NULL,
104  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
105  PRIMARY KEY (`id`),
106  UNIQUE KEY `location_id_idx` (`location_id`),
107  KEY `IDX_1F4D7EB0979B1AD6` (`company_id`),
108  CONSTRAINT `FK_1F4D7EB0979B1AD6` FOREIGN KEY (`company_id`) REFERENCES `sap_mapping_company` (`id`) ON DELETE SET NULL
109) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `sap_mapping_location`
114--
115
116LOCK TABLES `sap_mapping_location` WRITE;
117/*!40000 ALTER TABLE `sap_mapping_location` DISABLE KEYS */;
118INSERT INTO `sap_mapping_location` VALUES (1,197,82,NULL),(2,197,93,NULL),(3,197,94,NULL),(4,197,95,NULL),(5,197,96,NULL),(6,197,1146,NULL),(7,197,1147,NULL),(8,197,1177,NULL),(9,197,1179,NULL),(10,197,1181,NULL),(11,197,1488,NULL),(12,197,1511,NULL),(13,197,1135,NULL),(14,130,1322,NULL);
119/*!40000 ALTER TABLE `sap_mapping_location` ENABLE KEYS */;
120UNLOCK TABLES;
121/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
122
123/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
124/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
125/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
126/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
127/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
128/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
129/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
130
131-- Dump completed on 2018-02-15  8:58:52