tests/data/sql/3.0.0.sql
-- MySQL dump 10.15 Distrib 10.0.21-MariaDB, for osx10.11 (x86_64)
--
-- Host: 127.0.0.1 Database: luya_env_phpunit
-- ------------------------------------------------------
-- Server version 10.3.4-MariaDB-10.3.4+maria~jessie
/*!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 `admin_auth`
--
DROP TABLE IF EXISTS `admin_auth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_auth` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`alias_name` varchar(60) NOT NULL,
`module_name` varchar(60) NOT NULL,
`is_crud` tinyint(1) DEFAULT 0,
`route` varchar(200) DEFAULT NULL,
`api` varchar(200) DEFAULT NULL,
`pool` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_route` (`route`),
KEY `index_api` (`api`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_auth`
--
LOCK TABLES `admin_auth` WRITE;
/*!40000 ALTER TABLE `admin_auth` DISABLE KEYS */;
INSERT INTO `admin_auth` VALUES (1,'module_permission_page_blocks','cmsadmin',1,'0','api-cms-navitempageblockitem',NULL),(2,'menu_group_item_env_container','cmsadmin',1,'0','api-cms-navcontainer',NULL),(3,'menu_group_item_env_layouts','cmsadmin',1,'0','api-cms-layout',NULL),(4,'menu_group_item_env_redirections','cmsadmin',1,'0','api-cms-redirect',NULL),(5,'menu_group_item_elements_group','cmsadmin',1,'0','api-cms-blockgroup',NULL),(6,'menu_group_item_elements_blocks','cmsadmin',1,'0','api-cms-block',NULL),(7,'module_permission_add_new_page','cmsadmin',0,'cmsadmin/page/create','0',NULL),(8,'module_permission_update_pages','cmsadmin',0,'cmsadmin/page/update','0',NULL),(9,'module_permission_delete_pages','cmsadmin',0,'cmsadmin/page/delete','0',NULL),(10,'module_permission_edit_drafts','cmsadmin',0,'cmsadmin/page/drafts','0',NULL),(11,'menu_group_item_env_config','cmsadmin',0,'cmsadmin/config/index','0',NULL),(12,'menu_node_cms','cmsadmin',0,'cmsadmin/default/index','0',NULL),(13,'menu_group_item_env_permission','cmsadmin',0,'cmsadmin/permission/index','0',NULL),(14,'menu_access_item_user','admin',1,'0','api-admin-user',NULL),(15,'menu_access_item_group','admin',1,'0','api-admin-group',NULL),(16,'menu_system_item_config','admin',1,'0','api-admin-config',NULL),(17,'menu_system_item_language','admin',1,'0','api-admin-lang',NULL),(18,'menu_system_item_tags','admin',1,'0','api-admin-tag',NULL),(19,'menu_system_logger','admin',1,'0','api-admin-logger',NULL),(20,'menu_images_item_effects','admin',1,'0','api-admin-effect',NULL),(21,'menu_images_item_filters','admin',1,'0','api-admin-filter',NULL),(22,'Machines','admin',1,'0','api-admin-proxymachine',NULL),(23,'Builds','admin',1,'0','api-admin-proxybuild',NULL),(24,'menu_node_filemanager','admin',0,'admin/storage/index','0',NULL);
/*!40000 ALTER TABLE `admin_auth` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_config`
--
DROP TABLE IF EXISTS `admin_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_config` (
`name` varchar(80) NOT NULL,
`value` varchar(255) NOT NULL,
`is_system` tinyint(1) DEFAULT 1,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `index_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_config`
--
LOCK TABLES `admin_config` WRITE;
/*!40000 ALTER TABLE `admin_config` DISABLE KEYS */;
INSERT INTO `admin_config` VALUES ('100genericBlockUpdate','1',1,1),('last_import_timestamp','1513077719',1,2),('setup_command_timestamp','1513077719',1,3);
/*!40000 ALTER TABLE `admin_config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_group`
--
DROP TABLE IF EXISTS `admin_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`text` text DEFAULT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_group`
--
LOCK TABLES `admin_group` WRITE;
/*!40000 ALTER TABLE `admin_group` DISABLE KEYS */;
INSERT INTO `admin_group` VALUES (1,'Administrator','Administrator Accounts have full access to all Areas and can create, update and delete all data records.',0);
/*!40000 ALTER TABLE `admin_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_group_auth`
--
DROP TABLE IF EXISTS `admin_group_auth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_group_auth` (
`group_id` int(11) DEFAULT NULL,
`auth_id` int(11) DEFAULT NULL,
`crud_create` smallint(4) DEFAULT NULL,
`crud_update` smallint(4) DEFAULT NULL,
`crud_delete` smallint(4) DEFAULT NULL,
KEY `index_group_id` (`group_id`),
KEY `index_auth_id` (`auth_id`),
KEY `index_group_id_auth_id` (`group_id`,`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_group_auth`
--
LOCK TABLES `admin_group_auth` WRITE;
/*!40000 ALTER TABLE `admin_group_auth` DISABLE KEYS */;
INSERT INTO `admin_group_auth` VALUES (1,1,1,1,1),(1,2,1,1,1),(1,3,1,1,1),(1,4,1,1,1),(1,5,1,1,1),(1,6,1,1,1),(1,7,1,1,1),(1,8,1,1,1),(1,9,1,1,1),(1,10,1,1,1),(1,11,1,1,1),(1,12,1,1,1),(1,13,1,1,1),(1,14,1,1,1),(1,15,1,1,1),(1,16,1,1,1),(1,17,1,1,1),(1,18,1,1,1),(1,19,1,1,1),(1,20,1,1,1),(1,21,1,1,1),(1,22,1,1,1),(1,23,1,1,1),(1,24,1,1,1);
/*!40000 ALTER TABLE `admin_group_auth` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_lang`
--
DROP TABLE IF EXISTS `admin_lang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_lang` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`short_code` varchar(15) DEFAULT NULL,
`is_default` tinyint(1) DEFAULT 0,
`is_deleted` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `index_short_code` (`short_code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_lang`
--
LOCK TABLES `admin_lang` WRITE;
/*!40000 ALTER TABLE `admin_lang` DISABLE KEYS */;
INSERT INTO `admin_lang` VALUES (1,'English','en',1,0),(2,'Deutsch','de',0,0);
/*!40000 ALTER TABLE `admin_lang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_logger`
--
DROP TABLE IF EXISTS `admin_logger`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_logger` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT NULL,
`message` text NOT NULL,
`type` int(11) NOT NULL,
`trace_file` varchar(255) DEFAULT NULL,
`trace_line` varchar(255) DEFAULT NULL,
`trace_function` varchar(255) DEFAULT NULL,
`trace_function_args` text DEFAULT NULL,
`group_identifier` varchar(255) DEFAULT NULL,
`group_identifier_index` int(11) DEFAULT NULL,
`get` text DEFAULT NULL,
`post` text DEFAULT NULL,
`session` text DEFAULT NULL,
`server` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_logger`
--
LOCK TABLES `admin_logger` WRITE;
/*!40000 ALTER TABLE `admin_logger` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_logger` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_ngrest_log`
--
DROP TABLE IF EXISTS `admin_ngrest_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_ngrest_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp_create` int(11) NOT NULL,
`route` varchar(80) NOT NULL,
`api` varchar(80) NOT NULL,
`is_update` tinyint(1) DEFAULT 0,
`is_insert` tinyint(1) DEFAULT 0,
`attributes_json` text NOT NULL,
`attributes_diff_json` text DEFAULT NULL,
`pk_value` varchar(255) DEFAULT NULL,
`table_name` varchar(255) DEFAULT NULL,
`is_delete` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_ngrest_log`
--
LOCK TABLES `admin_ngrest_log` WRITE;
/*!40000 ALTER TABLE `admin_ngrest_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_ngrest_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_property`
--
DROP TABLE IF EXISTS `admin_property`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_property` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_name` varchar(120) DEFAULT NULL,
`var_name` varchar(40) NOT NULL,
`class_name` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `var_name` (`var_name`),
KEY `index_var_name` (`var_name`),
KEY `index_class_name` (`class_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_property`
--
LOCK TABLES `admin_property` WRITE;
/*!40000 ALTER TABLE `admin_property` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_property` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_proxy_build`
--
DROP TABLE IF EXISTS `admin_proxy_build`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_proxy_build` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`machine_id` int(11) NOT NULL,
`timestamp` int(11) NOT NULL,
`build_token` varchar(255) NOT NULL,
`config` text NOT NULL,
`is_complet` tinyint(1) DEFAULT 0,
`expiration_time` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `build_token` (`build_token`),
KEY `index_machine_id` (`machine_id`),
KEY `index_build_token` (`build_token`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_proxy_build`
--
LOCK TABLES `admin_proxy_build` WRITE;
/*!40000 ALTER TABLE `admin_proxy_build` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_proxy_build` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_proxy_machine`
--
DROP TABLE IF EXISTS `admin_proxy_machine`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_proxy_machine` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`access_token` varchar(255) NOT NULL,
`identifier` varchar(255) NOT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
`is_disabled` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `identifier` (`identifier`),
KEY `index_access_token` (`access_token`),
KEY `index_identifier` (`identifier`),
KEY `index_is_deleted` (`is_deleted`),
KEY `index_identifier_is_deleted` (`identifier`,`is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_proxy_machine`
--
LOCK TABLES `admin_proxy_machine` WRITE;
/*!40000 ALTER TABLE `admin_proxy_machine` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_proxy_machine` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_queue`
--
DROP TABLE IF EXISTS `admin_queue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_queue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`channel` varchar(255) NOT NULL,
`job` blob NOT NULL,
`pushed_at` int(11) NOT NULL,
`ttr` int(11) NOT NULL,
`delay` int(11) NOT NULL DEFAULT 0,
`priority` int(11) unsigned NOT NULL DEFAULT 1024,
`reserved_at` int(11) DEFAULT NULL,
`attempt` int(11) DEFAULT NULL,
`done_at` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `channel` (`channel`),
KEY `reserved_at` (`reserved_at`),
KEY `priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_queue`
--
LOCK TABLES `admin_queue` WRITE;
/*!40000 ALTER TABLE `admin_queue` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_queue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_queue_log`
--
DROP TABLE IF EXISTS `admin_queue_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_queue_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`queue_id` int(11) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`push_timestamp` int(11) NOT NULL,
`run_timestamp` int(11) DEFAULT NULL,
`end_timestamp` int(11) DEFAULT NULL,
`is_error` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `queue_id` (`queue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_queue_log`
--
LOCK TABLES `admin_queue_log` WRITE;
/*!40000 ALTER TABLE `admin_queue_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_queue_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_scheduler`
--
DROP TABLE IF EXISTS `admin_scheduler`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_scheduler` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model_class` varchar(255) NOT NULL,
`primary_key` varchar(255) NOT NULL,
`target_attribute_name` varchar(255) NOT NULL,
`new_attribute_value` varchar(255) NOT NULL,
`old_attribute_value` varchar(255) DEFAULT NULL,
`schedule_timestamp` int(11) NOT NULL,
`is_done` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_scheduler`
--
LOCK TABLES `admin_scheduler` WRITE;
/*!40000 ALTER TABLE `admin_scheduler` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_scheduler` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_search_data`
--
DROP TABLE IF EXISTS `admin_search_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_search_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp_create` int(11) NOT NULL,
`query` varchar(255) NOT NULL,
`num_rows` int(11) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_search_data`
--
LOCK TABLES `admin_search_data` WRITE;
/*!40000 ALTER TABLE `admin_search_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_search_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_storage_effect`
--
DROP TABLE IF EXISTS `admin_storage_effect`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_storage_effect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(100) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`imagine_name` varchar(255) DEFAULT NULL,
`imagine_json_params` text DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identifier` (`identifier`),
KEY `index_identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_storage_effect`
--
LOCK TABLES `admin_storage_effect` WRITE;
/*!40000 ALTER TABLE `admin_storage_effect` DISABLE KEYS */;
INSERT INTO `admin_storage_effect` VALUES (1,'thumbnail','Thumbnail','thumbnail','{\"vars\":[{\"var\":\"width\",\"label\":\"Breit in Pixel\"},{\"var\":\"height\",\"label\":\"Hoehe in Pixel\"},{\"var\":\"mode\",\"label\":\"outbound or inset\"},{\"var\":\"saveOptions\",\"label\":\"save options\"}]}'),(2,'crop','Crop','crop','{\"vars\":[{\"var\":\"width\",\"label\":\"Breit in Pixel\"},{\"var\":\"height\",\"label\":\"Hoehe in Pixel\"},{\"var\":\"saveOptions\",\"label\":\"save options\"}]}');
/*!40000 ALTER TABLE `admin_storage_effect` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_storage_file`
--
DROP TABLE IF EXISTS `admin_storage_file`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_storage_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_hidden` tinyint(1) DEFAULT 0,
`folder_id` int(11) DEFAULT 0,
`name_original` varchar(255) DEFAULT NULL,
`name_new` varchar(255) DEFAULT NULL,
`name_new_compound` varchar(255) DEFAULT NULL,
`mime_type` varchar(255) DEFAULT NULL,
`extension` varchar(255) DEFAULT NULL,
`hash_file` varchar(255) DEFAULT NULL,
`hash_name` varchar(255) DEFAULT NULL,
`upload_timestamp` int(11) DEFAULT NULL,
`file_size` int(11) DEFAULT 0,
`upload_user_id` int(11) DEFAULT 0,
`is_deleted` tinyint(1) DEFAULT 0,
`passthrough_file` tinyint(1) DEFAULT 0,
`passthrough_file_password` varchar(40) DEFAULT NULL,
`passthrough_file_stats` int(11) DEFAULT 0,
`caption` text DEFAULT NULL,
`inline_disposition` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `admin_storage_file_index1` (`folder_id`,`is_hidden`,`is_deleted`,`name_original`),
KEY `admin_storage_file_index2` (`is_deleted`,`id`),
KEY `index_upload_user_id` (`upload_user_id`),
KEY `index_id_hash_name_is_deleted` (`id`,`hash_name`,`is_deleted`),
KEY `index_name_new_compound` (`name_new_compound`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_storage_file`
--
LOCK TABLES `admin_storage_file` WRITE;
/*!40000 ALTER TABLE `admin_storage_file` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_storage_file` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_storage_filter`
--
DROP TABLE IF EXISTS `admin_storage_filter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_storage_filter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(100) NOT NULL,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `identifier` (`identifier`),
KEY `index_identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_storage_filter`
--
LOCK TABLES `admin_storage_filter` WRITE;
/*!40000 ALTER TABLE `admin_storage_filter` DISABLE KEYS */;
INSERT INTO `admin_storage_filter` VALUES (1,'large-crop','Crop large (800x800)'),(2,'large-thumbnail','Thumbnail large (800xnull)'),(3,'medium-crop','Crop medium (300x300)'),(4,'medium-thumbnail','Thumbnail medium (300xnull)'),(5,'small-crop','Crop small (100x100)'),(6,'small-landscape','Landscape small (150x50)'),(7,'small-thumbnail','Thumbnail small (100xnull)'),(8,'tiny-crop','Crop tiny (40x40)'),(9,'tiny-thumbnail','Thumbnail tiny (40xnull)');
/*!40000 ALTER TABLE `admin_storage_filter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_storage_filter_chain`
--
DROP TABLE IF EXISTS `admin_storage_filter_chain`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_storage_filter_chain` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sort_index` int(11) DEFAULT NULL,
`filter_id` int(11) DEFAULT NULL,
`effect_id` int(11) DEFAULT NULL,
`effect_json_values` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_filter_id` (`filter_id`),
KEY `index_effect_id` (`effect_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_storage_filter_chain`
--
LOCK TABLES `admin_storage_filter_chain` WRITE;
/*!40000 ALTER TABLE `admin_storage_filter_chain` DISABLE KEYS */;
INSERT INTO `admin_storage_filter_chain` VALUES (1,NULL,1,1,'{\"width\":800,\"height\":800}'),(2,NULL,2,1,'{\"width\":800,\"height\":null}'),(3,NULL,3,1,'{\"width\":300,\"height\":300}'),(4,NULL,4,1,'{\"width\":300,\"height\":null}'),(5,NULL,5,1,'{\"width\":100,\"height\":100}'),(6,NULL,6,1,'{\"width\":150,\"height\":50}'),(7,NULL,7,1,'{\"width\":100,\"height\":null}'),(8,NULL,8,1,'{\"width\":40,\"height\":40}'),(9,NULL,9,1,'{\"width\":40,\"height\":null}');
/*!40000 ALTER TABLE `admin_storage_filter_chain` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_storage_folder`
--
DROP TABLE IF EXISTS `admin_storage_folder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_storage_folder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`timestamp_create` int(11) DEFAULT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_storage_folder`
--
LOCK TABLES `admin_storage_folder` WRITE;
/*!40000 ALTER TABLE `admin_storage_folder` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_storage_folder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_storage_image`
--
DROP TABLE IF EXISTS `admin_storage_image`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_storage_image` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file_id` int(11) DEFAULT NULL,
`filter_id` int(11) DEFAULT NULL,
`resolution_width` int(11) DEFAULT NULL,
`resolution_height` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `admin_storage_image_index1` (`file_id`),
KEY `index_filter_id` (`filter_id`),
KEY `index_file_id_filter_id` (`file_id`,`filter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_storage_image`
--
LOCK TABLES `admin_storage_image` WRITE;
/*!40000 ALTER TABLE `admin_storage_image` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_storage_image` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_tag`
--
DROP TABLE IF EXISTS `admin_tag`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_tag` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL,
`translation` text DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_tag`
--
LOCK TABLES `admin_tag` WRITE;
/*!40000 ALTER TABLE `admin_tag` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_tag` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_tag_relation`
--
DROP TABLE IF EXISTS `admin_tag_relation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_tag_relation` (
`tag_id` int(11) NOT NULL,
`table_name` varchar(120) NOT NULL,
`pk_id` int(11) NOT NULL,
PRIMARY KEY (`tag_id`,`table_name`,`pk_id`),
KEY `index_tag_id` (`tag_id`),
KEY `index_table_name` (`table_name`),
KEY `index_pk_id` (`pk_id`),
KEY `index_table_name_pk_id` (`table_name`,`pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_tag_relation`
--
LOCK TABLES `admin_tag_relation` WRITE;
/*!40000 ALTER TABLE `admin_tag_relation` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_tag_relation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user`
--
DROP TABLE IF EXISTS `admin_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) DEFAULT NULL,
`lastname` varchar(255) DEFAULT NULL,
`title` smallint(1) DEFAULT NULL,
`email` varchar(120) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`password_salt` varchar(255) DEFAULT NULL,
`auth_token` varchar(190) DEFAULT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
`secure_token` varchar(40) DEFAULT NULL,
`secure_token_timestamp` int(11) DEFAULT 0,
`force_reload` tinyint(1) DEFAULT 0,
`settings` text DEFAULT NULL,
`cookie_token` varchar(255) DEFAULT NULL,
`is_api_user` tinyint(1) DEFAULT 0,
`api_rate_limit` int(11) DEFAULT NULL,
`api_allowed_ips` varchar(255) DEFAULT NULL,
`api_last_activity` int(11) DEFAULT NULL,
`email_verification_token` varchar(40) DEFAULT NULL,
`email_verification_token_timestamp` int(11) DEFAULT NULL,
`login_attempt` int(11) DEFAULT NULL,
`login_attempt_lock_expiration` int(11) DEFAULT NULL,
`is_request_logger_enabled` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `auth_token` (`auth_token`),
KEY `index_email` (`email`),
KEY `index_auth_token` (`auth_token`),
KEY `index_is_deleted_auth_token` (`is_deleted`,`auth_token`),
KEY `index_is_deleted_id` (`is_deleted`,`id`),
KEY `index_api_last_activity_id` (`api_last_activity`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user`
--
LOCK TABLES `admin_user` WRITE;
/*!40000 ALTER TABLE `admin_user` DISABLE KEYS */;
INSERT INTO `admin_user` VALUES (1,'John','Doe',1,'test@luya.io','$2y$13$7TZy10K41AwgkIjn51OwFuHnafecDt.B5w/2RrA9frxExOh6biWRG','sWuayGA8P5PlEQBUirj0-BTdKimgQSj1',NULL,0,NULL,0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `admin_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user_auth_notification`
--
DROP TABLE IF EXISTS `admin_user_auth_notification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user_auth_notification` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`auth_id` int(11) NOT NULL,
`is_muted` tinyint(1) DEFAULT 0,
`model_latest_pk_value` varchar(255) DEFAULT NULL,
`model_class` varchar(255) DEFAULT NULL,
`created_at` int(11) DEFAULT NULL,
`updated_at` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `auth_id` (`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user_auth_notification`
--
LOCK TABLES `admin_user_auth_notification` WRITE;
/*!40000 ALTER TABLE `admin_user_auth_notification` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_user_auth_notification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user_group`
--
DROP TABLE IF EXISTS `admin_user_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`),
KEY `index_group_id` (`group_id`),
KEY `index_user_id_group_id` (`user_id`,`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user_group`
--
LOCK TABLES `admin_user_group` WRITE;
/*!40000 ALTER TABLE `admin_user_group` DISABLE KEYS */;
INSERT INTO `admin_user_group` VALUES (1,1,1);
/*!40000 ALTER TABLE `admin_user_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user_login`
--
DROP TABLE IF EXISTS `admin_user_login`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user_login` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp_create` int(11) NOT NULL,
`auth_token` varchar(120) NOT NULL,
`ip` varchar(45) NOT NULL,
`is_destroyed` tinyint(1) DEFAULT 1,
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`),
KEY `index_ip` (`ip`),
KEY `index_auth_token` (`auth_token`),
KEY `index_is_destroyed` (`is_destroyed`),
KEY `index_user_id_timestamp_create` (`user_id`,`timestamp_create`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user_login`
--
LOCK TABLES `admin_user_login` WRITE;
/*!40000 ALTER TABLE `admin_user_login` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_user_login` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user_online`
--
DROP TABLE IF EXISTS `admin_user_online`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user_online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`last_timestamp` int(11) NOT NULL,
`invoken_route` varchar(120) NOT NULL,
`lock_pk` varchar(255) DEFAULT NULL,
`lock_table` varchar(255) DEFAULT NULL,
`lock_translation` varchar(255) DEFAULT NULL,
`lock_translation_args` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user_online`
--
LOCK TABLES `admin_user_online` WRITE;
/*!40000 ALTER TABLE `admin_user_online` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_user_online` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `admin_user_request`
--
DROP TABLE IF EXISTS `admin_user_request`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user_request` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp` int(11) NOT NULL,
`request_url` varchar(255) NOT NULL,
`request_method` varchar(255) NOT NULL,
`response_time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_admin_user_admin_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_user_request`
--
LOCK TABLES `admin_user_request` WRITE;
/*!40000 ALTER TABLE `admin_user_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin_user_request` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_block`
--
DROP TABLE IF EXISTS `cms_block`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_block` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`class` varchar(255) NOT NULL,
`is_disabled` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `index_group_id` (`group_id`),
KEY `index_class` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_block`
--
LOCK TABLES `cms_block` WRITE;
/*!40000 ALTER TABLE `cms_block` DISABLE KEYS */;
INSERT INTO `cms_block` VALUES (1,1,'\\luya\\cms\\frontend\\blocks\\HtmlBlock',0),(2,1,'\\luya\\cms\\frontend\\blocks\\ModuleBlock',0);
/*!40000 ALTER TABLE `cms_block` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_block_group`
--
DROP TABLE IF EXISTS `cms_block_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_block_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
`identifier` varchar(120) NOT NULL,
`created_timestamp` int(11) DEFAULT 0,
`class` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_block_group`
--
LOCK TABLES `cms_block_group` WRITE;
/*!40000 ALTER TABLE `cms_block_group` DISABLE KEYS */;
INSERT INTO `cms_block_group` VALUES (1,'block_group_dev_elements',0,'development-group',1513077718,'\\luya\\cms\\frontend\\blockgroups\\DevelopmentGroup');
/*!40000 ALTER TABLE `cms_block_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_config`
--
DROP TABLE IF EXISTS `cms_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_config` (
`name` varchar(80) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_config`
--
LOCK TABLES `cms_config` WRITE;
/*!40000 ALTER TABLE `cms_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_layout`
--
DROP TABLE IF EXISTS `cms_layout`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_layout` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`json_config` text DEFAULT NULL,
`view_file` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_layout`
--
LOCK TABLES `cms_layout` WRITE;
/*!40000 ALTER TABLE `cms_layout` DISABLE KEYS */;
INSERT INTO `cms_layout` VALUES (1,'Main','{\"placeholders\":[[{\"label\":\"Content\",\"var\":\"content\"}]]}','main.php'),(2,'Sidebar','{\"placeholders\":[[{\"label\":\"Content\",\"var\":\"content\"},{\"label\":\"Sidebar\",\"var\":\"sidebar\"}]]}','sidebar.php');
/*!40000 ALTER TABLE `cms_layout` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_log`
--
DROP TABLE IF EXISTS `cms_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT 0,
`is_insertion` tinyint(1) DEFAULT 0,
`is_update` tinyint(1) DEFAULT 0,
`is_deletion` tinyint(1) DEFAULT 0,
`timestamp` int(11) NOT NULL,
`message` varchar(255) DEFAULT NULL,
`data_json` text DEFAULT NULL,
`table_name` varchar(120) DEFAULT NULL,
`row_id` int(11) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_log`
--
LOCK TABLES `cms_log` WRITE;
/*!40000 ALTER TABLE `cms_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav`
--
DROP TABLE IF EXISTS `cms_nav`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nav_container_id` int(11) NOT NULL,
`parent_nav_id` int(11) NOT NULL,
`sort_index` int(11) NOT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
`is_hidden` tinyint(1) DEFAULT 0,
`is_home` tinyint(1) DEFAULT 0,
`is_offline` tinyint(1) DEFAULT 0,
`is_draft` tinyint(1) DEFAULT 0,
`layout_file` varchar(255) DEFAULT NULL,
`publish_from` int(11) DEFAULT NULL,
`publish_till` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_nav_container` (`nav_container_id`),
KEY `index_parent_nav_id` (`parent_nav_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav`
--
LOCK TABLES `cms_nav` WRITE;
/*!40000 ALTER TABLE `cms_nav` DISABLE KEYS */;
INSERT INTO `cms_nav` VALUES (1,1,0,1,0,0,1,0,0,NULL,NULL,NULL),(2,1,0,2,0,0,0,0,0,NULL,NULL,NULL),(3,1,0,3,0,0,0,0,0,NULL,NULL,NULL),(4,1,0,4,0,0,0,0,0,NULL,NULL,NULL),(5,1,0,5,0,0,0,0,0,NULL,NULL,NULL),(6,1,0,6,0,0,0,0,0,NULL,NULL,NULL),(7,1,0,7,0,0,0,0,0,NULL,NULL,NULL),(8,1,2,1,0,0,0,0,0,NULL,NULL,NULL),(9,1,2,2,0,0,0,0,0,NULL,NULL,NULL),(10,1,2,3,0,0,0,0,0,NULL,NULL,NULL),(11,1,2,4,0,0,0,0,0,NULL,NULL,NULL),(12,1,2,5,0,0,0,0,0,NULL,NULL,NULL),(13,1,2,6,0,0,0,0,0,NULL,NULL,NULL),(14,1,0,8,0,0,0,0,0,NULL,NULL,NULL),(15,1,0,9,0,0,0,0,0,NULL,NULL,NULL),(16,1,0,10,0,0,0,0,0,NULL,NULL,NULL),(17,1,0,11,0,0,0,0,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `cms_nav` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_container`
--
DROP TABLE IF EXISTS `cms_nav_container`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_container` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(180) NOT NULL,
`alias` varchar(180) NOT NULL,
`is_deleted` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_container`
--
LOCK TABLES `cms_nav_container` WRITE;
/*!40000 ALTER TABLE `cms_nav_container` DISABLE KEYS */;
INSERT INTO `cms_nav_container` VALUES (1,'Default Container','default',0);
/*!40000 ALTER TABLE `cms_nav_container` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_item`
--
DROP TABLE IF EXISTS `cms_nav_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_item` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nav_id` int(11) NOT NULL,
`lang_id` int(11) NOT NULL,
`nav_item_type` int(11) NOT NULL,
`nav_item_type_id` int(11) NOT NULL,
`create_user_id` int(11) NOT NULL,
`update_user_id` int(11) NOT NULL,
`timestamp_create` int(11) DEFAULT 0,
`timestamp_update` int(11) DEFAULT 0,
`title` varchar(180) NOT NULL,
`alias` varchar(80) NOT NULL,
`description` text DEFAULT NULL,
`keywords` text DEFAULT NULL,
`title_tag` varchar(255) DEFAULT NULL,
`image_id` int(11) DEFAULT 0,
`is_url_strict_parsing_disabled` int(11) DEFAULT 0,
`is_cacheable` int(11) DEFAULT 0,
PRIMARY KEY (`id`),
KEY `index_alias` (`alias`),
KEY `index_nav_id` (`nav_id`),
KEY `index_lang_id` (`lang_id`),
KEY `index_nav_item_type_id` (`nav_item_type_id`),
KEY `index_create_user_id` (`create_user_id`),
KEY `index_update_user_id` (`update_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_item`
--
LOCK TABLES `cms_nav_item` WRITE;
/*!40000 ALTER TABLE `cms_nav_item` DISABLE KEYS */;
INSERT INTO `cms_nav_item` VALUES
(1,1,1,1,1,1,1,1513077719,0,'Homepage','homepage',NULL,NULL,NULL,0,0,0),
(2,2,1,1,2,1,1,1513077719,0,'Page 1','page1','Description of Page 1',NULL,NULL,0,0,0),
(3,3,1,1,3,1,1,1513077719,0,'Page 2','page2','Description of Page 2',NULL,NULL,0,0,0),
(4,4,1,1,4,1,1,1513077719,0,'Page 3','page3','Description of Page 3',NULL,NULL,0,0,0),
(5,5,1,1,5,1,1,1513077719,0,'Page 4','page4','Description of Page 4',NULL,NULL,0,0,0),
(6,6,1,1,6,1,1,1513077719,0,'Page 5','page5','Description of Page 5',NULL,NULL,0,0,0),
(7,7,1,1,7,1,1,1513077719,0,'Page 6','page6','Description of Page 6',NULL,NULL,0,0,0),
(8,8,1,1,8,1,1,1513077719,0,'Page 1','p1-page1','Description of Page 1',NULL,NULL,0,0,0),
(9,9,1,1,9,1,1,1513077720,0,'Page 2','p1-page2','Description of Page 2',NULL,NULL,0,0,0),
(10,10,1,1,10,1,1,1513077720,0,'Page 3','p1-page3','Description of Page 3',NULL,NULL,0,0,0),
(11,11,1,1,11,1,1,1513077720,0,'Page 4','p1-page4','Description of Page 4',NULL,NULL,0,0,0),
(12,12,1,1,12,1,1,1513077720,0,'Page 5','p1-page5','Description of Page 5',NULL,NULL,0,0,0),
(13,13,1,1,13,1,1,1513077720,0,'Page 6','p1-page6','Description of Page 6',NULL,NULL,0,0,0),
(14,14,1,3,1,1,1,1513077720,0,'Redirect to Page 1','redirect-1','Description of Redirect to Page 1',NULL,NULL,0,0,0),
(15,15,1,3,2,1,1,1513077720,0,'Redirect to Page 2','redirect-2','Description of Redirect to Page 2',NULL,NULL,0,0,0),
(16,16,1,3,3,1,1,1513077720,0,'Redirect to Sub Page 2','redirect-3','Description of Redirect to Sub Page 2',NULL,NULL,0,0,0),
(17,17,1,3,4,1,1,1513077720,0,'Redirect to luya.io','redirect-4','Description of Redirect to luya.io',NULL,NULL,0,0,0);
/*!40000 ALTER TABLE `cms_nav_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_item_module`
--
DROP TABLE IF EXISTS `cms_nav_item_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_item_module` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_name` varchar(255) NOT NULL,
`controller_name` varchar(255) DEFAULT NULL,
`action_name` varchar(255) DEFAULT NULL,
`action_params` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_item_module`
--
LOCK TABLES `cms_nav_item_module` WRITE;
/*!40000 ALTER TABLE `cms_nav_item_module` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_nav_item_module` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_item_page`
--
DROP TABLE IF EXISTS `cms_nav_item_page`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_item_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`layout_id` int(11) NOT NULL,
`nav_item_id` int(11) NOT NULL,
`timestamp_create` int(11) NOT NULL,
`create_user_id` int(11) NOT NULL,
`version_alias` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_layout_id` (`layout_id`),
KEY `index_nav_item_id` (`nav_item_id`),
KEY `index_create_user_id` (`create_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_item_page`
--
LOCK TABLES `cms_nav_item_page` WRITE;
/*!40000 ALTER TABLE `cms_nav_item_page` DISABLE KEYS */;
INSERT INTO `cms_nav_item_page` VALUES (1,1,1,1513077719,1,'Initial'),(2,1,2,1513077719,1,'Initial'),(3,1,3,1513077719,1,'Initial'),(4,1,4,1513077719,1,'Initial'),(5,1,5,1513077719,1,'Initial'),(6,1,6,1513077719,1,'Initial'),(7,1,7,1513077719,1,'Initial'),(8,1,8,1513077719,1,'Initial'),(9,1,9,1513077719,1,'Initial'),(10,1,10,1513077720,1,'Initial'),(11,1,11,1513077720,1,'Initial'),(12,1,12,1513077720,1,'Initial'),(13,1,13,1513077720,1,'Initial');
/*!40000 ALTER TABLE `cms_nav_item_page` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_item_page_block_item`
--
DROP TABLE IF EXISTS `cms_nav_item_page_block_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_item_page_block_item` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`block_id` int(11) NOT NULL,
`placeholder_var` varchar(80) NOT NULL,
`nav_item_page_id` int(11) DEFAULT NULL,
`prev_id` int(11) DEFAULT NULL,
`json_config_values` text DEFAULT NULL,
`json_config_cfg_values` text DEFAULT NULL,
`is_dirty` tinyint(1) DEFAULT 0,
`create_user_id` int(11) DEFAULT 0,
`update_user_id` int(11) DEFAULT 0,
`timestamp_create` int(11) DEFAULT 0,
`timestamp_update` int(11) DEFAULT 0,
`sort_index` int(11) DEFAULT 0,
`is_hidden` tinyint(1) DEFAULT 0,
`variation` varchar(255) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_block_id` (`block_id`),
KEY `index_placeholder_var` (`placeholder_var`),
KEY `index_nav_item_page_id` (`nav_item_page_id`),
KEY `index_prev_id` (`prev_id`),
KEY `index_create_user_id` (`create_user_id`),
KEY `index_update_user_id` (`update_user_id`),
KEY `index_nipi_pv_pi_ih_si` (`nav_item_page_id`,`placeholder_var`,`prev_id`,`is_hidden`,`sort_index`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_item_page_block_item`
--
LOCK TABLES `cms_nav_item_page_block_item` WRITE;
/*!40000 ALTER TABLE `cms_nav_item_page_block_item` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_nav_item_page_block_item` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_item_redirect`
--
DROP TABLE IF EXISTS `cms_nav_item_redirect`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_item_redirect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
`target` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_item_redirect`
--
LOCK TABLES `cms_nav_item_redirect` WRITE;
/*!40000 ALTER TABLE `cms_nav_item_redirect` DISABLE KEYS */;
INSERT INTO `cms_nav_item_redirect` VALUES (1,1,'2',''),(2,1,'3',''),(3,1,'8',''),(4,2,'https://luya.io','');
/*!40000 ALTER TABLE `cms_nav_item_redirect` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_permission`
--
DROP TABLE IF EXISTS `cms_nav_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_permission` (
`group_id` int(11) NOT NULL,
`nav_id` int(11) NOT NULL,
`inheritance` tinyint(1) DEFAULT 0,
KEY `index_group_id` (`group_id`),
KEY `index_nav_id` (`nav_id`),
KEY `index_group_id_nav_id` (`group_id`,`nav_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_permission`
--
LOCK TABLES `cms_nav_permission` WRITE;
/*!40000 ALTER TABLE `cms_nav_permission` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_nav_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_nav_property`
--
DROP TABLE IF EXISTS `cms_nav_property`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_nav_property` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nav_id` int(11) NOT NULL,
`admin_prop_id` int(11) NOT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_nav_id` (`nav_id`),
KEY `index_admin_prop_id` (`admin_prop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_nav_property`
--
LOCK TABLES `cms_nav_property` WRITE;
/*!40000 ALTER TABLE `cms_nav_property` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_nav_property` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_redirect`
--
DROP TABLE IF EXISTS `cms_redirect`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_redirect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`timestamp_create` int(11) DEFAULT NULL,
`catch_path` varchar(255) NOT NULL,
`redirect_path` varchar(255) NOT NULL,
`redirect_status_code` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_redirect`
--
LOCK TABLES `cms_redirect` WRITE;
/*!40000 ALTER TABLE `cms_redirect` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_redirect` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cms_theme`
--
DROP TABLE IF EXISTS `cms_theme`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cms_theme` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_active` tinyint(1) NOT NULL DEFAULT 0,
`base_path` varchar(255) NOT NULL,
`json_config` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `base_path` (`base_path`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cms_theme`
--
LOCK TABLES `cms_theme` WRITE;
/*!40000 ALTER TABLE `cms_theme` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_theme` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_config`
--
DROP TABLE IF EXISTS `estore_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) DEFAULT NULL,
`type` varchar(30) NOT NULL DEFAULT 'text',
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_config`
--
LOCK TABLES `estore_config` WRITE;
/*!40000 ALTER TABLE `estore_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_currency`
--
DROP TABLE IF EXISTS `estore_currency`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_currency` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`is_base` tinyint(1) DEFAULT 0,
`iso` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`value` float NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `iso` (`iso`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_currency`
--
LOCK TABLES `estore_currency` WRITE;
/*!40000 ALTER TABLE `estore_currency` DISABLE KEYS */;
INSERT INTO `estore_currency` VALUES (1,0,'AFN','Afghan Afghani',1),(2,0,'ALL','Albanian Lek',1),(3,0,'DZD','Algerian Dinar',1),(4,0,'AOA','Angolan Kwanza',1),(5,0,'ARS','Argentine Peso',1),(6,0,'AMD','Armenian Dram',1),(7,0,'AWG','Aruban Florin',1),(8,0,'AUD','Australian Dollar',1),(9,0,'AZN','Azerbaijani Manat',1),(10,0,'AZM','Azerbaijani Manat (1993–2006)',1),(11,0,'BSD','Bahamian Dollar',1),(12,0,'BHD','Bahraini Dinar',1),(13,0,'BDT','Bangladeshi Taka',1),(14,0,'BBD','Barbadian Dollar',1),(15,0,'BYR','Belarusian Ruble',1),(16,0,'BZD','Belize Dollar',1),(17,0,'BMD','Bermudan Dollar',1),(18,0,'BTN','Bhutanese Ngultrum',1),(19,0,'BOB','Bolivian Boliviano',1),(20,0,'BAM','Bosnia-Herzegovina Convertible Mark',1),(21,0,'BWP','Botswanan Pula',1),(22,0,'BRL','Brazilian Real',1),(23,0,'GBP','British Pound Sterling',1),(24,0,'BND','Brunei Dollar',1),(25,0,'BGN','Bulgarian Lev',1),(26,0,'BUK','Burmese Kyat',1),(27,0,'BIF','Burundian Franc',1),(28,0,'XOF','CFA Franc BCEAO',1),(29,0,'XPF','CFP Franc',1),(30,0,'KHR','Cambodian Riel',1),(31,0,'CAD','Canadian Dollar',1),(32,0,'CVE','Cape Verdean Escudo',1),(33,0,'KYD','Cayman Islands Dollar',1),(34,0,'CLP','Chilean Peso',1),(35,0,'CNY','Chinese Yuan',1),(36,0,'COP','Colombian Peso',1),(37,0,'KMF','Comorian Franc',1),(38,0,'CDF','Congolese Franc',1),(39,0,'CRC','Costa Rican Colón',1),(40,0,'HRK','Croatian Kuna',1),(41,0,'CUP','Cuban Peso',1),(42,0,'CZK','Czech Republic Koruna',1),(43,0,'DKK','Danish Krone',1),(44,0,'DJF','Djiboutian Franc',1),(45,0,'DOP','Dominican Peso',1),(46,0,'XCD','East Caribbean Dollar',1),(47,0,'EGP','Egyptian Pound',1),(48,0,'GQE','Equatorial Guinean Ekwele',1),(49,0,'ERN','Eritrean Nakfa',1),(50,0,'EEK','Estonian Kroon',1),(51,0,'ETB','Ethiopian Birr',1),(52,1,'EUR','Euro',1),(53,0,'FKP','Falkland Islands Pound',1),(54,0,'FJD','Fijian Dollar',1),(55,0,'GMD','Gambian Dalasi',1),(56,0,'GEK','Georgian Kupon Larit',1),(57,0,'GEL','Georgian Lari',1),(58,0,'GHS','Ghanaian Cedi',1),(59,0,'GIP','Gibraltar Pound',1),(60,0,'GTQ','Guatemalan Quetzal',1),(61,0,'GNF','Guinean Franc',1),(62,0,'GYD','Guyanaese Dollar',1),(63,0,'HTG','Haitian Gourde',1),(64,0,'HNL','Honduran Lempira',1),(65,0,'HKD','Hong Kong Dollar',1),(66,0,'HUF','Hungarian Forint',1),(67,0,'ISK','Icelandic Króna',1),(68,0,'INR','Indian Rupee',1),(69,0,'IDR','Indonesian Rupiah',1),(70,0,'IRR','Iranian Rial',1),(71,0,'IQD','Iraqi Dinar',1),(72,0,'ILS','Israeli New Sheqel',1),(73,0,'JMD','Jamaican Dollar',1),(74,0,'JPY','Japanese Yen',1),(75,0,'JOD','Jordanian Dinar',1),(76,0,'KZT','Kazakhstani Tenge',1),(77,0,'KES','Kenyan Shilling',1),(78,0,'KWD','Kuwaiti Dinar',1),(79,0,'KGS','Kyrgystani Som',1),(80,0,'LAK','Laotian Kip',1),(81,0,'LVL','Latvian Lats',1),(82,0,'LBP','Lebanese Pound',1),(83,0,'LSL','Lesotho Loti',1),(84,0,'LRD','Liberian Dollar',1),(85,0,'LYD','Libyan Dinar',1),(86,0,'LTL','Lithuanian Litas',1),(87,0,'MOP','Macanese Pataca',1),(88,0,'MKD','Macedonian Denar',1),(89,0,'MGA','Malagasy Ariary',1),(90,0,'MWK','Malawian Kwacha',1),(91,0,'MYR','Malaysian Ringgit',1),(92,0,'MVR','Maldivian Rufiyaa',1),(93,0,'MRO','Mauritanian Ouguiya',1),(94,0,'MUR','Mauritian Rupee',1),(95,0,'MXN','Mexican Peso',1),(96,0,'MDL','Moldovan Leu',1),(97,0,'MNT','Mongolian Tugrik',1),(98,0,'MAD','Moroccan Dirham',1),(99,0,'MZN','Mozambican Metical',1),(100,0,'MMK','Myanmar Kyat',1),(101,0,'NAD','Namibian Dollar',1),(102,0,'NPR','Nepalese Rupee',1),(103,0,'ANG','Netherlands Antillean Guilder',1),(104,0,'TWD','New Taiwan Dollar',1),(105,0,'NZD','New Zealand Dollar',1),(106,0,'NIC','Nicaraguan Córdoba (1988–1991)',1),(107,0,'NGN','Nigerian Naira',1),(108,0,'KPW','North Korean Won',1),(109,0,'NOK','Norwegian Krone',1),(110,0,'OMR','Omani Rial',1),(111,0,'PKR','Pakistani Rupee',1),(112,0,'PAB','Panamanian Balboa',1),(113,0,'PGK','Papua New Guinean Kina',1),(114,0,'PYG','Paraguayan Guarani',1),(115,0,'PEN','Peruvian Nuevo Sol',1),(116,0,'PHP','Philippine Peso',1),(117,0,'PLN','Polish Zloty',1),(118,0,'QAR','Qatari Rial',1),(119,0,'RHD','Rhodesian Dollar',1),(120,0,'RON','Romanian Leu',1),(121,0,'ROL','Romanian Leu (1952–2006)',1),(122,0,'RUB','Russian Ruble',1),(123,0,'RWF','Rwandan Franc',1),(124,0,'SHP','Saint Helena Pound',1),(125,0,'SVC','Salvadoran Colón',1),(126,0,'WST','Samoan Tala',1),(127,0,'SAR','Saudi Riyal',1),(128,0,'RSD','Serbian Dinar',1),(129,0,'SCR','Seychellois Rupee',1),(130,0,'SLL','Sierra Leonean Leone',1),(131,0,'SGD','Singapore Dollar',1),(132,0,'SKK','Slovak Koruna',1),(133,0,'SBD','Solomon Islands Dollar',1),(134,0,'SOS','Somali Shilling',1),(135,0,'ZAR','South African Rand',1),(136,0,'KRW','South Korean Won',1),(137,0,'LKR','Sri Lankan Rupee',1),(138,0,'SDG','Sudanese Pound',1),(139,0,'SRD','Surinamese Dollar',1),(140,0,'SZL','Swazi Lilangeni',1),(141,0,'SEK','Swedish Krona',1),(142,0,'CHF','Swiss Franc',1),(143,0,'SYP','Syrian Pound',1),(144,0,'STD','São Tomé and Príncipe Dobra',1),(145,0,'TJS','Tajikistani Somoni',1),(146,0,'TZS','Tanzanian Shilling',1),(147,0,'THB','Thai Baht',1),(148,0,'TOP','Tongan Pa´anga',1),(149,0,'TTD','Trinidad and Tobago Dollar',1),(150,0,'TND','Tunisian Dinar',1),(151,0,'TRY','Turkish Lira',1),(152,0,'TRL','Turkish Lira (1922–2005)',1),(153,0,'TMM','Turkmenistani Manat (1993–2009)',1),(154,0,'USD','US Dollar',1),(155,0,'UGX','Ugandan Shilling',1),(156,0,'UAH','Ukrainian Hryvnia',1),(157,0,'AED','United Arab Emirates Dirham',1),(158,0,'UYU','Uruguayan Peso',1),(159,0,'UZS','Uzbekistan Som',1),(160,0,'VUV','Vanuatu Vatu',1),(161,0,'VEF','Venezuelan Bolívar',1),(162,0,'VEB','Venezuelan Bolívar (1871–2008)',1),(163,0,'VND','Vietnamese Dong',1),(164,0,'CHE','WIR Euro',1),(165,0,'CHW','WIR Franc',1),(166,0,'YER','Yemeni Rial',1),(167,0,'ZMK','Zambian Kwacha (1968–2012)',1),(168,0,'ZWD','Zimbabwean Dollar (1980–2008)',1);
/*!40000 ALTER TABLE `estore_currency` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_group`
--
DROP TABLE IF EXISTS `estore_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_group_id` int(11) DEFAULT 0,
`cover_image_id` int(11) DEFAULT NULL,
`images_list` text DEFAULT NULL,
`name` text NOT NULL,
`teaser` text DEFAULT NULL,
`text` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_group`
--
LOCK TABLES `estore_group` WRITE;
/*!40000 ALTER TABLE `estore_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_producer`
--
DROP TABLE IF EXISTS `estore_producer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_producer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_producer`
--
LOCK TABLES `estore_producer` WRITE;
/*!40000 ALTER TABLE `estore_producer` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_producer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_product`
--
DROP TABLE IF EXISTS `estore_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`type` smallint(6) NOT NULL DEFAULT 0 COMMENT '0 = simple, 1 = configurable, 2 = virtual',
`visibility` smallint(6) NOT NULL DEFAULT 1,
`sku` varchar(255) DEFAULT NULL,
`qty_available` int(11) DEFAULT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_product`
--
LOCK TABLES `estore_product` WRITE;
/*!40000 ALTER TABLE `estore_product` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_product` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_product_attribute_value`
--
DROP TABLE IF EXISTS `estore_product_attribute_value`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_product_attribute_value` (
`product_id` int(11) NOT NULL,
`set_id` int(11) NOT NULL,
`attribute_id` int(11) NOT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`product_id`,`attribute_id`,`set_id`),
KEY `estore_product_attribute_value_set_id_fk` (`set_id`),
KEY `estore_product_attribute_value_attribute_id_fk` (`attribute_id`),
CONSTRAINT `estore_product_attribute_value_attribute_id_fk` FOREIGN KEY (`attribute_id`) REFERENCES `estore_set_attribute` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `estore_product_attribute_value_product_id_fk` FOREIGN KEY (`product_id`) REFERENCES `estore_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `estore_product_attribute_value_set_id_fk` FOREIGN KEY (`set_id`) REFERENCES `estore_set` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_product_attribute_value`
--
LOCK TABLES `estore_product_attribute_value` WRITE;
/*!40000 ALTER TABLE `estore_product_attribute_value` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_product_attribute_value` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_product_group_ref`
--
DROP TABLE IF EXISTS `estore_product_group_ref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_product_group_ref` (
`group_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
PRIMARY KEY (`group_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_product_group_ref`
--
LOCK TABLES `estore_product_group_ref` WRITE;
/*!40000 ALTER TABLE `estore_product_group_ref` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_product_group_ref` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_product_price`
--
DROP TABLE IF EXISTS `estore_product_price`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_product_price` (
`product_id` int(11) NOT NULL,
`currency_id` int(11) NOT NULL,
`qty` int(11) NOT NULL COMMENT '0 = which means this price counts independent about how many items u have in your basket | 10 = When you hvae 10 or more items in your basket, this price is used to calculate for each item.',
`price` float NOT NULL,
PRIMARY KEY (`product_id`,`currency_id`,`qty`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_product_price`
--
LOCK TABLES `estore_product_price` WRITE;
/*!40000 ALTER TABLE `estore_product_price` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_product_price` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_product_set_ref`
--
DROP TABLE IF EXISTS `estore_product_set_ref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_product_set_ref` (
`product_id` int(11) NOT NULL,
`set_id` int(11) NOT NULL,
PRIMARY KEY (`product_id`,`set_id`),
KEY `estore_product_set_ref_set_id_fk` (`set_id`),
CONSTRAINT `estore_product_set_ref_product_id_fk` FOREIGN KEY (`product_id`) REFERENCES `estore_product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `estore_product_set_ref_set_id_fk` FOREIGN KEY (`set_id`) REFERENCES `estore_set` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_product_set_ref`
--
LOCK TABLES `estore_product_set_ref` WRITE;
/*!40000 ALTER TABLE `estore_product_set_ref` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_product_set_ref` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_set`
--
DROP TABLE IF EXISTS `estore_set`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_set` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_set`
--
LOCK TABLES `estore_set` WRITE;
/*!40000 ALTER TABLE `estore_set` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_set` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_set_attribute`
--
DROP TABLE IF EXISTS `estore_set_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_set_attribute` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) DEFAULT NULL,
`input` varchar(255) NOT NULL,
`code` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`values` text DEFAULT NULL,
`is_i18n` tinyint(1) DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_set_attribute`
--
LOCK TABLES `estore_set_attribute` WRITE;
/*!40000 ALTER TABLE `estore_set_attribute` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_set_attribute` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estore_set_attribute_ref`
--
DROP TABLE IF EXISTS `estore_set_attribute_ref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estore_set_attribute_ref` (
`set_id` int(11) NOT NULL,
`attribute_id` int(11) NOT NULL,
PRIMARY KEY (`set_id`,`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estore_set_attribute_ref`
--
LOCK TABLES `estore_set_attribute_ref` WRITE;
/*!40000 ALTER TABLE `estore_set_attribute_ref` DISABLE KEYS */;
/*!40000 ALTER TABLE `estore_set_attribute_ref` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migration`
--
DROP TABLE IF EXISTS `migration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migration` (
`version` varchar(180) NOT NULL,
`apply_time` int(11) DEFAULT NULL,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migration`
--
LOCK TABLES `migration` WRITE;
/*!40000 ALTER TABLE `migration` DISABLE KEYS */;
INSERT INTO `migration` VALUES ('m000000_000000_base',1513077715),('m141104_104622_admin_group',1513077715),('m141104_104631_admin_user_group',1513077715),('m141104_114809_admin_user',1513077716),('m141203_121042_admin_lang',1513077716),('m141203_143052_cms_cat',1513077716),('m141203_143059_cms_nav',1513077716),('m141203_143111_cms_nav_item',1513077716),('m141208_134038_cms_nav_item_page',1513077716),('m150106_095003_cms_layout',1513077716),('m150108_154017_cms_block',1513077716),('m150108_155009_cms_nav_item_page_block_item',1513077716),('m150122_125429_cms_nav_item_module',1513077716),('m150204_144806_news_article',1567056495),('m150205_141350_block_group',1513077716),('m150304_152220_admin_storage_folder',1513077716),('m150304_152238_admin_storage_file',1513077716),('m150304_152244_admin_storage_filter',1513077716),('m150304_152250_admin_storage_effect',1513077716),('m150304_152256_admin_storage_image',1513077716),('m150309_142652_admin_storage_filter_chain',1513077716),('m150323_125407_admin_auth',1513077716),('m150323_132625_admin_group_auth',1513077716),('m150331_125022_admin_ngrest_log',1513077716),('m150428_095829_news_cat',1567056495),('m150615_094744_admin_user_login',1513077716),('m150617_200836_admin_user_online',1513077716),('m150626_084948_admin_search_data',1513077716),('m150915_081559_admin_config',1513077716),('m150924_112309_cms_nav_prop',1513077717),('m150924_120914_admin_prop',1513077717),('m151012_072207_cms_log',1513077717),('m151022_143429_cms_nav_item_redirect',1513077717),('m151026_161841_admin_tag',1513077717),('m160629_092417_cmspermissiontable',1513077717),('m160915_081618_create_admin_logger_table',1513077717),('m161212_084323_add_teaser_field',1567056496),('m161219_150240_admin_lang_soft_delete',1513077717),('m161220_183300_lcp_base_tables',1513077717),('m170116_120553_cms_block_variation_field',1513077717),('m170131_104109_user_model_updates',1513077717),('m170218_215610_cms_nav_layout_file',1513077717),('m170301_084325_cms_config',1513077717),('m170515_115236_basetables',1567056497),('m170619_103728_cms_blocksettings',1513077717),('m170926_144137_add_admin_user_session_id_column',1513077718),('m170926_164913_add_ngrest_log_diff_data',1513077718),('m171003_065811_add_class_column_to_block_group_table',1513077718),('m171009_083835_add_admin_user_login_destroy_info',1513077718),('m171121_170909_add_publish_at_date',1513077718),('m171129_104706_config_add_system_type',1513077718),('m171206_113949_cms_redirection_table',1513077718),('m180123_070338_SchedulerJob',1567056497),('m180214_134657_system_user_ngrest_deletion',1567056497),('m180317_170227_ScheduleJobType',1567056497),('m180326_170839_file_disposition',1567056497),('m180412_092824_user_security_columns_v12',1567056498),('m180527_225613_user_login_ipv6',1567056498),('m180619_134519_indexes',1567056498),('m180723_120432_indexes',1567056500),('m180723_123237_indexes',1567056501),('m181018_195533_basecurrencies',1567056501),('m181020_182244_config',1567056501),('m181023_135132_scheduler',1567056502),('m181113_120432_user_index',1567056502),('m190219_142706_og_image',1567056585),('m190220_105505_cms_redirect_target_field',1567056631),('m190227_123549_cms_nav_item_strict_url_parsing',1567056651),('m190327_140741_auth_pool_field',1567056655),('m190508_142342_admin_user_api_request',1567056655),('m190521_145029_admin_user_notification',1567056655),('m190529_123549_cms_nav_item_module_route_and_params',1567056656),('m190728_084936_cms_theme',1567056656),('m311024_135132_tag',1567056656);
/*!40000 ALTER TABLE `migration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_article`
--
DROP TABLE IF EXISTS `news_article`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text DEFAULT NULL,
`text` text DEFAULT NULL,
`cat_id` int(11) DEFAULT 0,
`image_id` int(11) DEFAULT 0,
`image_list` text DEFAULT NULL,
`file_list` text DEFAULT NULL,
`create_user_id` int(11) DEFAULT 0,
`update_user_id` int(11) DEFAULT 0,
`timestamp_create` int(11) DEFAULT 0,
`timestamp_update` int(11) DEFAULT 0,
`timestamp_display_from` int(11) DEFAULT 0,
`timestamp_display_until` int(11) DEFAULT 0,
`is_deleted` tinyint(1) DEFAULT 0,
`is_display_limit` tinyint(1) DEFAULT 0,
`teaser_text` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_article`
--
LOCK TABLES `news_article` WRITE;
/*!40000 ALTER TABLE `news_article` DISABLE KEYS */;
/*!40000 ALTER TABLE `news_article` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news_cat`
--
DROP TABLE IF EXISTS `news_cat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news_cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `news_cat`
--
LOCK TABLES `news_cat` WRITE;
/*!40000 ALTER TABLE `news_cat` DISABLE KEYS */;
/*!40000 ALTER TABLE `news_cat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `scheduler_job`
--
DROP TABLE IF EXISTS `scheduler_job`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scheduler_job` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`class` varchar(255) NOT NULL,
`schedule` varchar(255) NOT NULL,
`last_run` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`log` text DEFAULT NULL,
`options` text DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `scheduler_job`
--
LOCK TABLES `scheduler_job` WRITE;
/*!40000 ALTER TABLE `scheduler_job` DISABLE KEYS */;
/*!40000 ALTER TABLE `scheduler_job` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `scheduler_job_type`
--
DROP TABLE IF EXISTS `scheduler_job_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scheduler_job_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`class` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `scheduler_job_type`
--
LOCK TABLES `scheduler_job_type` WRITE;
/*!40000 ALTER TABLE `scheduler_job_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `scheduler_job_type` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!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 2019-08-29 7:33:52