· 6 years ago · Aug 28, 2019, 09:36 PM
1-- MySQL dump 10.13 Distrib 5.7.27, for Linux (x86_64)
2--
3-- Host: localhost Database: magento
4-- ------------------------------------------------------
5-- Server version 5.7.27-0ubuntu0.18.04.1
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 utf8 */;
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 `firebear_export_history`
20--
21
22DROP TABLE IF EXISTS `firebear_export_history`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `firebear_export_history` (
26 `history_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'History Id',
27 `job_id` int(11) NOT NULL COMMENT 'Job Id',
28 `started_at` timestamp NULL DEFAULT NULL COMMENT 'Started',
29 `finished_at` timestamp NULL DEFAULT NULL COMMENT 'Finished',
30 `type` varchar(100) DEFAULT NULL COMMENT 'Type',
31 `file` varchar(255) NOT NULL COMMENT 'Exported File',
32 `temp_file` text COMMENT 'Temp file export',
33 PRIMARY KEY (`history_id`),
34 KEY `FIREBEAR_EXPORT_HISTORY_HISTORY_ID` (`history_id`),
35 KEY `FIREBEAR_EXPORT_HISTORY_JOB_ID_FIREBEAR_EXPORT_JOBS_ENTITY_ID` (`job_id`),
36 CONSTRAINT `FIREBEAR_EXPORT_HISTORY_JOB_ID_FIREBEAR_EXPORT_JOBS_ENTITY_ID` FOREIGN KEY (`job_id`) REFERENCES `firebear_export_jobs` (`entity_id`) ON DELETE CASCADE
37) ENGINE=InnoDB AUTO_INCREMENT=39437 DEFAULT CHARSET=utf8 COMMENT='Export Jobs';
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Table structure for table `firebear_export_jobs`
42--
43
44DROP TABLE IF EXISTS `firebear_export_jobs`;
45/*!40101 SET @saved_cs_client = @@character_set_client */;
46/*!40101 SET character_set_client = utf8 */;
47CREATE TABLE `firebear_export_jobs` (
48 `entity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Job Id',
49 `title` varchar(255) NOT NULL COMMENT 'Title',
50 `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Job Active',
51 `cron` varchar(100) DEFAULT NULL COMMENT 'Cron schedule',
52 `frequency` varchar(10) NOT NULL COMMENT 'Frequency',
53 `entity` varchar(100) NOT NULL COMMENT 'Entity Type',
54 `behavior_data` text NOT NULL COMMENT 'Behavior Data (json)',
55 `export_source` text NOT NULL COMMENT 'Export Source',
56 `source_data` text NOT NULL COMMENT 'Source Data (json)',
57 `file_updated_at` timestamp NULL DEFAULT NULL COMMENT 'File Updated At',
58 `xslt` longblob COMMENT 'Xslt',
59 PRIMARY KEY (`entity_id`)
60) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='File Updated At';
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Table structure for table `firebear_export_jobs_event`
65--
66
67DROP TABLE IF EXISTS `firebear_export_jobs_event`;
68/*!40101 SET @saved_cs_client = @@character_set_client */;
69/*!40101 SET character_set_client = utf8 */;
70CREATE TABLE `firebear_export_jobs_event` (
71 `job_id` int(11) NOT NULL COMMENT 'Job Id',
72 `event` varchar(255) NOT NULL COMMENT 'Event name',
73 PRIMARY KEY (`job_id`,`event`),
74 KEY `FIREBEAR_EXPORT_JOBS_EVENT_EVENT` (`event`),
75 CONSTRAINT `FIREBEAR_EXPORT_JOBS_EVENT_JOB_ID_FIREBEAR_EXPORT_JOBS_ENTITY_ID` FOREIGN KEY (`job_id`) REFERENCES `firebear_export_jobs` (`entity_id`) ON DELETE CASCADE
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Export job event';
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Table structure for table `firebear_import_history`
81--
82
83DROP TABLE IF EXISTS `firebear_import_history`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `firebear_import_history` (
87 `history_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'History Id',
88 `job_id` int(11) NOT NULL COMMENT 'Job Id',
89 `started_at` timestamp NULL DEFAULT NULL COMMENT 'Started',
90 `finished_at` timestamp NULL DEFAULT NULL COMMENT 'Finished',
91 `type` varchar(100) DEFAULT NULL COMMENT 'Type',
92 `file` varchar(255) NOT NULL COMMENT 'Imported File',
93 PRIMARY KEY (`history_id`),
94 KEY `FIREBEAR_IMPORT_HISTORY_HISTORY_ID` (`history_id`),
95 KEY `FIREBEAR_IMPORT_HISTORY_JOB_ID_FIREBEAR_IMPORT_JOBS_ENTITY_ID` (`job_id`),
96 CONSTRAINT `FIREBEAR_IMPORT_HISTORY_JOB_ID_FIREBEAR_IMPORT_JOBS_ENTITY_ID` FOREIGN KEY (`job_id`) REFERENCES `firebear_import_jobs` (`entity_id`) ON DELETE CASCADE
97) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8 COMMENT='Export Jobs';
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Table structure for table `firebear_import_job_mapping`
102--
103
104DROP TABLE IF EXISTS `firebear_import_job_mapping`;
105/*!40101 SET @saved_cs_client = @@character_set_client */;
106/*!40101 SET character_set_client = utf8 */;
107CREATE TABLE `firebear_import_job_mapping` (
108 `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
109 `job_id` int(11) NOT NULL COMMENT 'Job Id',
110 `attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Magento Attribute Id',
111 `special_attribute` varchar(255) DEFAULT NULL COMMENT 'Special System Attribute',
112 `import_code` varchar(255) DEFAULT NULL COMMENT 'Import Attribute Code',
113 `default_value` varchar(255) DEFAULT NULL COMMENT 'Default Value',
114 `custom` smallint(6) DEFAULT '0' COMMENT 'Default Value',
115 PRIMARY KEY (`entity_id`),
116 UNIQUE KEY `IMPORT_JOB_MAPPING_JOB_ID_ATTRIBUTE_ID` (`job_id`,`attribute_id`),
117 KEY `IMPORT_JOB_MAPPING_JOB_ID` (`job_id`),
118 KEY `IMPORT_JOB_MAPPING_ATTRIBUTE_ID` (`attribute_id`),
119 CONSTRAINT `IMPORT_JOB_MAPPING_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
120 CONSTRAINT `IMPORT_JOB_MAPPING_JOB_ID_IMPORT_JOBS_ENTITY_ID` FOREIGN KEY (`job_id`) REFERENCES `firebear_import_jobs` (`entity_id`) ON DELETE CASCADE
121) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='Import Attributes Mapping';
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Table structure for table `firebear_import_jobs`
126--
127
128DROP TABLE IF EXISTS `firebear_import_jobs`;
129/*!40101 SET @saved_cs_client = @@character_set_client */;
130/*!40101 SET character_set_client = utf8 */;
131CREATE TABLE `firebear_import_jobs` (
132 `entity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Job Id',
133 `title` varchar(255) NOT NULL COMMENT 'Title',
134 `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Job Active',
135 `cron` varchar(100) DEFAULT NULL COMMENT 'Cron schedule',
136 `frequency` varchar(10) NOT NULL COMMENT 'Frequency',
137 `entity` varchar(100) NOT NULL COMMENT 'Entity Type',
138 `behavior_data` text NOT NULL COMMENT 'Behavior Data (json)',
139 `import_source` varchar(100) NOT NULL COMMENT 'Import Source',
140 `source_data` text NOT NULL COMMENT 'Source Data (json)',
141 `file_updated_at` timestamp NULL DEFAULT NULL COMMENT 'File Updated At',
142 `mapping` blob COMMENT 'mapping field',
143 `price_rules` blob COMMENT 'Price rules',
144 `xslt` longblob COMMENT 'Xslt',
145 PRIMARY KEY (`entity_id`)
146) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='File Updated At';
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Table structure for table `firebear_importexport_importdata`
151--
152
153DROP TABLE IF EXISTS `firebear_importexport_importdata`;
154/*!40101 SET @saved_cs_client = @@character_set_client */;
155/*!40101 SET character_set_client = utf8 */;
156CREATE TABLE `firebear_importexport_importdata` (
157 `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
158 `entity` varchar(50) NOT NULL COMMENT 'Entity',
159 `behavior` varchar(10) NOT NULL DEFAULT 'append' COMMENT 'Behavior',
160 `subentity` varchar(50) DEFAULT NULL COMMENT 'SubEntity',
161 `file` varchar(50) DEFAULT NULL COMMENT 'File',
162 `job_id` int(11) NOT NULL COMMENT 'Job Id',
163 `data` longtext COMMENT 'Data',
164 PRIMARY KEY (`id`),
165 KEY `FK_9AF4AC7F682E8FAAE2A91E723745CB33` (`job_id`),
166 CONSTRAINT `FK_9AF4AC7F682E8FAAE2A91E723745CB33` FOREIGN KEY (`job_id`) REFERENCES `firebear_import_jobs` (`entity_id`) ON DELETE CASCADE
167) ENGINE=InnoDB AUTO_INCREMENT=14458 DEFAULT CHARSET=utf8 COMMENT='Firebear Import Data Table';
168/*!40101 SET character_set_client = @saved_cs_client */;
169/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
170
171/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
172/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
173/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
174/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
175/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
176/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
177/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
178
179-- Dump completed on 2019-08-16 14:20:20