-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `2407uch`
--

-- --------------------------------------------------------

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `auth_assignment`
--

CREATE TABLE `auth_assignment` (
  `item_name` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL,
  `created_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_assignment`
--

INSERT INTO `auth_assignment` (`item_name`, `user_id`, `created_at`) VALUES
('Admin', '1', 1486036625);

-- --------------------------------------------------------

--
-- Table structure for table `auth_item`
--

CREATE TABLE `auth_item` (
  `name` varchar(64) NOT NULL,
  `type` int(11) NOT NULL,
  `description` text,
  `rule_name` varchar(64) DEFAULT NULL,
  `data` text,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_item`
--

INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES
('/*', 2, '', '', '', 1486032111, 1486032111),
('Admin', 1, '', '', '', 1486031763, 1486031763),
('administration_module', 2, '', '', '', 1486036233, 1678126713),
('blog_create', 2, '', '', '', 1683122734, 1683122734),
('blog_delete', 2, '', '', '', 1683122752, 1683122752),
('blog_list', 2, '', '', '', 1683122758, 1683122758),
('blog_module', 2, '', '', '', 1683122724, 1683122724),
('blog_update', 2, '', '', '', 1683122743, 1683122743),
('category_archive', 2, '', '', '', 1486034662, 1486034662),
('category_create', 2, '', '', '', 1486034642, 1486034642),
('category_delete', 2, '', '', '', 1486034655, 1486034655),
('category_list', 2, '', '', '', 1486034635, 1486034635),
('category_module', 2, '', '', '', 1486034627, 1486034627),
('category_update', 2, '', '', '', 1486034649, 1486034649),
('category_view', 2, '', '', '', 1486034895, 1486034895),
('form_create', 2, '', '', '', 1486628055, 1486628055),
('form_delete', 2, '', '', '', 1486628099, 1486628099),
('form_list', 2, '', '', '', 1486628105, 1486628105),
('form_module', 2, '', '', '', 1486627711, 1486627711),
('form_update', 2, '', '', '', 1486628130, 1486628130),
('form_view', 2, '', '', '', 1486628093, 1486628093),
('gallery_archive', 2, '', '', '', 1486034043, 1486034043),
('gallery_create', 2, '', '', '', 1486034015, 1486034015),
('gallery_delete', 2, '', '', '', 1486034028, 1486034028),
('gallery_list', 2, '', '', '', 1486033867, 1486033867),
('gallery_module', 2, '', '', '', 1486034000, 1486034000),
('gallery_update', 2, '', '', '', 1486034022, 1486034022),
('gallery_view', 2, '', '', '', 1486034036, 1486034036),
('job_create', 2, '', '', '', 1683122627, 1683122627),
('job_delete', 2, '', '', '', 1683122642, 1683122642),
('job_list', 2, '', '', '', 1683122621, 1683122621),
('job_module', 2, '', '', '', 1683122612, 1683122612),
('job_update', 2, '', '', '', 1683122633, 1683122633),
('mail_subscriber', 2, '', '', '', 1683209809, 1683209809),
('menu_module', 2, '', '', '', 1486035475, 1486035475),
('page_archive', 2, '', '', '', 1486033027, 1486033027),
('page_copy', 2, '', '', '', 1486033678, 1486033678),
('page_create', 2, '', '', '', 1486032854, 1486032854),
('page_delete', 2, '', '', '', 1486032868, 1486032868),
('page_list', 2, '', '', '', 1486032881, 1486032881),
('page_module', 2, '', '', '', 1486032846, 1486032846),
('page_update', 2, '', '', '', 1486032860, 1486032860),
('page_view', 2, '', '', '', 1486033501, 1486033501),
('product_archive', 2, '', '', '', 1486035005, 1486035005),
('product_copy', 2, '', '', '', 1486035248, 1486035248),
('product_create', 2, '', '', '', 1486034977, 1486034977),
('product_delete', 2, '', '', '', 1486034992, 1486034992),
('product_list', 2, '', '', '', 1486034970, 1486034970),
('product_module', 2, '', '', '', 1486034960, 1486034960),
('product_update', 2, '', '', '', 1486034984, 1486034984),
('product_view', 2, '', '', '', 1486034998, 1486034998),
('settings_module', 2, '', '', '', 1486036037, 1486036037),
('subscriber_create', 2, '', '', '', 1683209782, 1683209782),
('subscriber_delete', 2, '', '', '', 1683209865, 1683209865),
('subscriber_module', 2, '', '', '', 1683209772, 1683209772),
('tag_archived', 2, '', '', '', 1679143034, 1679143034),
('tag_create', 2, '', '', '', 1679142983, 1679142983),
('tag_list', 2, '', '', '', 1679143007, 1679143007),
('tag_module', 2, '', '', '', 1508393038, 1508393038),
('tag_update', 2, '', '', '', 1679142998, 1679142998),
('tag_view', 2, '', '', '', 1679143016, 1679143016),
('type_create', 2, '', '', '', 1486035653, 1486035653),
('type_delete', 2, '', '', '', 1486035666, 1486035666),
('type_list', 2, '', '', '', 1486035647, 1486035647),
('type_module', 2, '', '', '', 1486035637, 1486035637),
('type_update', 2, '', '', '', 1486035660, 1486035660),
('type_view', 2, '', '', '', 1486035674, 1486035674),
('user_create', 2, '', '', '', 1486032333, 1486032478),
('user_delete', 2, '', '', '', 1486032552, 1486032552),
('user_list', 2, '', '', '', 1486032296, 1486032363),
('user_module', 2, '', '', '', 1486031494, 1486031494),
('user_update', 2, '', '', '', 1486032427, 1486032427),
('variation_create', 2, '', '', '', 1486035284, 1486035284),
('variation_delete', 2, '', '', '', 1486035299, 1486035299),
('variation_module', 2, '', '', '', 1486035355, 1486035355),
('variation_update', 2, '', '', '', 1486035291, 1486035291);

-- --------------------------------------------------------

--
-- Table structure for table `auth_item_child`
--

CREATE TABLE `auth_item_child` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_item_child`
--

INSERT INTO `auth_item_child` (`parent`, `child`) VALUES
('Admin', '/*'),
('Admin', 'administration_module'),
('Admin', 'blog_module'),
('Admin', 'category_module'),
('Admin', 'form_module'),
('Admin', 'gallery_module'),
('Admin', 'job_module'),
('Admin', 'menu_module'),
('Admin', 'page_module'),
('Admin', 'product_module'),
('Admin', 'settings_module'),
('Admin', 'subscriber_module'),
('Admin', 'tag_module'),
('Admin', 'type_module'),
('Admin', 'user_module'),
('Admin', 'variation_module'),
('blog_module', 'blog_create'),
('blog_module', 'blog_delete'),
('blog_module', 'blog_list'),
('blog_module', 'blog_update'),
('category_module', 'category_archive'),
('category_module', 'category_create'),
('category_module', 'category_delete'),
('category_module', 'category_list'),
('category_module', 'category_update'),
('category_module', 'category_view'),
('form_module', 'form_create'),
('form_module', 'form_delete'),
('form_module', 'form_list'),
('form_module', 'form_update'),
('form_module', 'form_view'),
('gallery_module', 'gallery_archive'),
('gallery_module', 'gallery_create'),
('gallery_module', 'gallery_delete'),
('gallery_module', 'gallery_list'),
('gallery_module', 'gallery_update'),
('gallery_module', 'gallery_view'),
('job_module', 'job_create'),
('job_module', 'job_delete'),
('job_module', 'job_list'),
('job_module', 'job_update'),
('page_module', 'page_archive'),
('page_module', 'page_copy'),
('page_module', 'page_create'),
('page_module', 'page_delete'),
('page_module', 'page_list'),
('page_module', 'page_update'),
('page_module', 'page_view'),
('product_module', 'product_archive'),
('product_module', 'product_copy'),
('product_module', 'product_create'),
('product_module', 'product_delete'),
('product_module', 'product_list'),
('product_module', 'product_update'),
('product_module', 'product_view'),
('subscriber_module', 'mail_subscriber'),
('subscriber_module', 'subscriber_create'),
('subscriber_module', 'subscriber_delete'),
('tag_module', 'tag_archived'),
('tag_module', 'tag_create'),
('tag_module', 'tag_list'),
('tag_module', 'tag_update'),
('tag_module', 'tag_view'),
('type_module', 'type_create'),
('type_module', 'type_delete'),
('type_module', 'type_list'),
('type_module', 'type_update'),
('type_module', 'type_view'),
('user_module', 'user_create'),
('user_module', 'user_delete'),
('user_module', 'user_list'),
('user_module', 'user_update'),
('variation_module', 'variation_create'),
('variation_module', 'variation_delete'),
('variation_module', 'variation_update');

-- --------------------------------------------------------

--
-- Table structure for table `auth_rule`
--

CREATE TABLE `auth_rule` (
  `name` varchar(64) NOT NULL,
  `data` text,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `title` varchar(100) NOT NULL,
  `page_ids` varchar(255) DEFAULT NULL,
  `section_ids` varchar(255) DEFAULT NULL,
  `category_ids` varchar(255) DEFAULT NULL,
  `product_ids` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `banner_post`
--

CREATE TABLE `banner_post` (
  `id` int(11) NOT NULL,
  `banner_id` int(11) NOT NULL,
  `post_name` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `text` text,
  `type` text,
  `duration` varchar(255) DEFAULT NULL,
  `paths` text,
  `link` text,
  `tag` text,
  `bg_color` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `subtitle` text,
  `link` text,
  `date` date DEFAULT NULL,
  `body` longtext,
  `status` int(11) DEFAULT '0',
  `sort_order` int(11) DEFAULT NULL,
  `title_tag` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `og_title` varchar(255) DEFAULT NULL,
  `og_description` text,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `type` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `is_featured` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `description` text,
  `image_size` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `is_archived` tinyint(1) DEFAULT '0',
  `title_tag` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `og_title` varchar(255) DEFAULT NULL,
  `og_description` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `identifier` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `category_self_rel`
--

CREATE TABLE `category_self_rel` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `parent_category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `extra_field`
--

CREATE TABLE `extra_field` (
  `id` int(11) NOT NULL,
  `group` varchar(255) DEFAULT NULL,
  `page_id` varchar(255) DEFAULT NULL,
  `section_id` varchar(255) DEFAULT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `parent_page_id` int(11) DEFAULT NULL,
  `item_key` varchar(255) DEFAULT NULL,
  `item_value` text,
  `label` varchar(255) DEFAULT NULL,
  `hint` varchar(255) DEFAULT NULL,
  `field_type` varchar(255) DEFAULT NULL,
  `options` text,
  `order` int(11) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `extra_field_values`
--

CREATE TABLE `extra_field_values` (
  `id` int(11) NOT NULL,
  `identifier_type` varchar(255) DEFAULT NULL,
  `identifier_id` int(11) DEFAULT NULL,
  `field_key` varchar(255) DEFAULT NULL,
  `field_value` text,
  `trans_type` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `form_fields`
--

CREATE TABLE `form_fields` (
  `id` int(11) NOT NULL,
  `form_id` int(11) DEFAULT NULL,
  `field_key` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `placeholder` varchar(255) DEFAULT NULL,
  `hint` varchar(255) DEFAULT NULL,
  `field_type` varchar(255) DEFAULT NULL,
  `options` text,
  `validators` text,
  `template` text,
  `sort_order` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `form_fields`
--

INSERT INTO `form_fields` (`id`, `form_id`, `field_key`, `label`, `placeholder`, `hint`, `field_type`, `options`, `validators`, `template`, `sort_order`) VALUES
(6, 1, 'first_name', 'Name', 'First Name', '', 'textInput', '', 'required, string', '<div class=\"form-row\">\r\n                        <div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input type=\"text\" class=\"form-control\" placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\" />\r\n                        </div>', 1),
(7, 1, 'email', 'Email Address', 'Email', '', 'textInput', '', 'required, email', '\r\n<div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input\r\n                              type=\"email\"\r\n                              class=\"form-control\"\r\n                              placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                           />\r\n                        </div>', 3),
(8, 1, 'phone', 'Phone Number', 'Phone Number', '', 'textInput', '', 'string,required', ' <div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input\r\n                              type=\"number\"\r\n                              class=\"form-control\"\r\n                             placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                           />\r\n                        </div>', 4),
(9, 1, 'message', 'Message', 'Your Message', '', 'textArea', '', 'string', '<div class=\"form-group col-sm-12 anim fade-up\">\r\n                           <textarea\r\n                              class=\"form-control form-control \"\r\n                             placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                              id=\"\"\r\n                              cols=\"30\"\r\n                              rows=\"5\"\r\n                           ></textarea>\r\n                        </div>', 6),
(11, 2, 'first_name', 'Name', 'Name', '', 'textInput', '', 'required, string', '<div class=\"form-row\">\r\n                        <div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input type=\"text\" class=\"form-control\" placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\" />\r\n                        </div>', 1),
(12, 2, 'email', 'Email Address', 'Email', '', 'textInput', '', 'required, email', '<div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input\r\n                              type=\"email\"\r\n                              class=\"form-control\"\r\n                              placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                           />\r\n                        </div>', 3),
(13, 2, 'phone', 'Phone', 'Phone Number', '', 'textInput', '', 'string,required', ' <div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input\r\n                              type=\"number\"\r\n                              class=\"form-control form-control\"\r\n                             placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                           />\r\n                        </div>', 4),
(14, 2, 'position', 'Position', 'Position', '', 'textInput', '', 'string,required', '<div class=\"form-group col-sm-12 anim fade-up\">\r\n                           <input type=\"text\" class=\"form-control job-position\" placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\" />\r\n                        </div>', 5),
(15, 2, 'file', 'CV', '', '', 'fileInput', '', 'string', '<div class=\"modal-butons\">\r\n                                 <div class=\"form-group upload_cv_inner\" data-text=\"Attach CV\">\r\n                                    <input\r\n                                       type=\"file\"\r\n                                       class=\"form-control file-input file-upload-field\"\r\n                                       name=\"file\"\r\n                                       placeholder=\"{{placeholder}}\"\r\n                                    />\r\n                                 </div>', 7),
(16, 1, 'last_name', 'Last Name', 'Last Name', '', 'textInput', '', 'string, required', '<div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input type=\"text\" class=\"form-control\" placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\" />\r\n                        </div>', 2),
(17, 1, 'reason', 'Contact Reason', 'Contact Reason', '', 'dropDownList', ':Your Reason for Contacting,Meeting:Meeting,Visit Office:Visit Office,Project Discussion:Project Discussion', 'string', '<div class=\"Select form-group col-sm-12 anim fade-up\">\r\n                           <select class=\"form-control\" name=\"Dynamicform[{{name}}]\">\r\n                              {{options}}\r\n                           </select>\r\n                        </div>', 5),
(18, 2, 'last_name', 'Last Name', 'Last Name', '', 'textInput', '', 'string, required', '<div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input type=\"text\" class=\"form-control\" placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\" />\r\n                        </div>', 2),
(19, 2, 'message', 'Message', 'Your Message', '', 'textArea', '', 'string', '<div class=\"form-group col-sm-12 anim fade-up\">\r\n                           <textarea\r\n                              class=\"form-control form-control \"\r\n                             placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                              id=\"\"\r\n                              cols=\"30\"\r\n                              rows=\"5\"\r\n                           ></textarea>\r\n                        </div>', 6),
(20, 6, 'name', 'Name', 'Name', '', 'textInput', '', 'required, string', '<div class=\"form-row\">\r\n                        <div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input type=\"text\" class=\"form-control\" placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\" />\r\n                        </div>', 1),
(22, 6, 'email', 'Email Address', 'Email', '', 'textInput', '', 'required, email', '\r\n<div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input\r\n                              type=\"email\"\r\n                              class=\"form-control\"\r\n                              placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                           />\r\n                        </div>', 3),
(23, 6, 'phone', 'Phone Number', 'Phone Number', '', 'textInput', '', 'string,required', ' <div class=\"form-group col-md-6 anim fade-up\">\r\n                           <input\r\n                              type=\"number\"\r\n                              class=\"form-control\"\r\n                             placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                           />\r\n                        </div>', 4),
(25, 6, 'message', 'Message', 'Your Message', '', 'textArea', '', 'string', '<div class=\"form-group col-sm-12 anim fade-up\">\r\n                           <textarea\r\n                              class=\"form-control form-control \"\r\n                             placeholder=\" {{placeholder}}\" name=\"Dynamicform[{{name}}]\"\r\n                              id=\"\"\r\n                              cols=\"30\"\r\n                              rows=\"5\"\r\n                           ></textarea>\r\n                        </div>', 6);

-- --------------------------------------------------------

--
-- Table structure for table `form_list`
--

CREATE TABLE `form_list` (
  `id` int(11) NOT NULL,
  `form_name` varchar(255) NOT NULL,
  `form_id` varchar(255) DEFAULT NULL,
  `send_to` text,
  `cc` text,
  `bcc` text,
  `subject` varchar(255) DEFAULT NULL,
  `from_name` varchar(255) DEFAULT NULL,
  `from_email` varchar(255) DEFAULT NULL,
  `reply_mail` int(11) DEFAULT '0',
  `form_class` varchar(255) DEFAULT NULL,
  `button_class` varchar(255) DEFAULT NULL,
  `submit_button_template` text,
  `submit_button_inner_template` text,
  `success_template` text,
  `error_template` text,
  `success_error_position` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `form_list`
--

INSERT INTO `form_list` (`id`, `form_name`, `form_id`, `send_to`, `cc`, `bcc`, `subject`, `from_name`, `from_email`, `reply_mail`, `form_class`, `button_class`, `submit_button_template`, `submit_button_inner_template`, `success_template`, `error_template`, `success_error_position`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'Contact Form', 'contact-form', 'taposhi@dcastalia.com', '', '', 'Contact Form ', 'Dcastalia Limited', 'info@testdomian.com', 1, '', 'dc-btn anim fade-up', '<div class=\"btn-section\">\r\n                           {{button}}\r\n                        </div>\r\n                     </div>', '<span>\r\nSubmit Message\r\n</span>', '<div class=\"form-message-container\">\r\n  <div class=\"form-message-body\">\r\n  </div>\r\n</div>', '<div class=\"form-message-container\">\r\n  <div class=\"form-message-body\">\r\n  </div>\r\n</div>', 'top', '2023-02-20 14:29:17', '2023-05-08 08:00:51', 1, 1),
(2, 'Career Form', 'career-form', 'info@testdomian.com', '', '', 'Contact Form ', 'Dcastalia Limited', 'info@testdomian.com', 1, '', 'dc-btn anim fade-up', '                        {{button}}\r\n                    </div>\r\n</div>', '<span>Submit</span>', '<div class=\"form-message-container  {{wrapper_class}}\">\r\n  <div class=\"form-message-body\">\r\n  </div>\r\n</div>', '<div class=\"form-message-container {{wrapper_class}}\">\r\n  <div class=\"form-message-body\">\r\n  </div>\r\n</div>', 'top', '2023-03-13 23:36:34', '2023-05-08 13:41:33', 1, 1),
(6, 'General Form', 'general-form', 'user@mail.com', '', '', 'Contact Form ', 'EasyUp CMS', 'info@mail.com', 1, '', 'dc-btn anim fade-up', '<div class=\"btn-section\">\r\n                           {{button}}\r\n                        </div>\r\n                     </div>', '<span>\r\nSubmit Message\r\n</span>', '<div class=\"form-message-container\">\r\n  <div class=\"form-message-body\">\r\n  </div>\r\n</div>', '<div class=\"form-message-container\">\r\n  <div class=\"form-message-body\">\r\n  </div>\r\n</div>', 'top', '2023-05-27 09:53:40', '2023-05-27 03:54:41', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `form_submitted`
--

CREATE TABLE `form_submitted` (
  `id` int(11) NOT NULL,
  `form_id` varchar(255) DEFAULT NULL,
  `form_name` varchar(255) DEFAULT NULL,
  `form_actual_id` int(11) DEFAULT NULL,
  `form_subject` varchar(255) DEFAULT NULL,
  `sent_to` text,
  `sent_options` text,
  `sent_data` text,
  `attachment` text,
  `is_seen` tinyint(4) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `page_ids` varchar(100) DEFAULT NULL,
  `section_ids` varchar(100) DEFAULT NULL,
  `category_ids` varchar(100) DEFAULT NULL,
  `product_ids` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `identifier` varchar(255) DEFAULT NULL,
  `template` varchar(255) DEFAULT NULL,
  `image_size` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `is_archived` tinyint(1) DEFAULT '0',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `gallery_post`
--

CREATE TABLE `gallery_post` (
  `id` int(11) NOT NULL,
  `gallery_id` int(11) NOT NULL,
  `post_name` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `text` text,
  `type` text,
  `duration` varchar(255) DEFAULT NULL,
  `paths` text,
  `link` text,
  `tag` text,
  `bg_color` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `global_settings`
--

CREATE TABLE `global_settings` (
  `id` int(11) NOT NULL,
  `order` int(11) DEFAULT NULL,
  `item_key` varchar(255) DEFAULT NULL,
  `item_value` text,
  `label` varchar(255) DEFAULT NULL,
  `hint` varchar(255) DEFAULT NULL,
  `field_type` varchar(255) DEFAULT NULL,
  `options` text,
  `input_type` varchar(100) DEFAULT NULL,
  `pattern` varchar(100) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `global_settings`
--

INSERT INTO `global_settings` (`id`, `order`, `item_key`, `item_value`, `label`, `hint`, `field_type`, `options`, `input_type`, `pattern`, `group`, `updated_at`, `updated_by`) VALUES
(1, 1, 'site_title', 'EasyUp Multipurpose Website CMS & API', 'Site Title', '', 'textInput', '', NULL, NULL, 'General Settings', '2023-06-10 11:41:17', 0),
(2, 2, 'slogan', '', 'Company Slogan', '', 'textInput', '', NULL, NULL, 'General Settings', '2023-04-20 06:12:45', 0),
(3, 3, 'info_email', '', 'Info Email', 'Enter valid email address', 'textInput', '', 'email', NULL, 'General Settings', '2023-06-11 13:18:30', 0),
(4, 4, 'career_email', '', 'Career Email', 'Enter valid email address', 'textInput', '', 'email', NULL, 'General Settings', '2023-06-11 13:18:32', 0),
(5, 5, 'contact_email', 'info@testdomian.com', 'Contact Email', 'Enter valid email address', 'textInput', '', 'email', NULL, 'General Settings', '2023-06-11 13:18:34', 0),
(6, 6, 'office_location', 'House 91, Road 04, Block B, Banani, Dhaka 1213, Bangladesh', 'Office Location Address', '', 'textInput', '', NULL, NULL, 'General Settings', '2023-05-08 10:17:37', 0),
(7, 7, 'office_phone', '+880 1400 999 666', 'Office Phone', 'Example: +880 1200 000 001, +880 1200 000 002', 'textInput', '', NULL, '[0-9+\\- ,]+', 'General Settings', '2023-06-11 13:19:19', 0),
(8, 8, 'office_fax', '', 'Office Fax', 'Example: +1-907-555-1234, +1-907-555-4567', 'textInput', '', NULL, '[0-9+\\- ,]+', 'General Settings', '2023-06-11 13:19:28', 0),
(9, 9, 'logo_light', '', 'Logo Light', '', 'fileInput', '', NULL, NULL, 'General Settings', '2023-06-10 13:41:40', 0),
(10, 9, 'logo_dark', '', 'Logo Light', '', 'fileInput', '', NULL, NULL, 'General Settings', '2023-05-26 08:19:55', 0),
(11, 10, 'favicon', '', 'FAV Icon', '', 'fileInput', '', NULL, NULL, 'General Settings', '2023-05-23 13:34:17', 0),
(12, 11, 'brochure', NULL, 'Company Brochure', '', 'fileInput', '', NULL, NULL, 'Documents', '2023-06-10 13:40:24', 0),
(13, 12, 'copyright_text', '© 2023 EasyUp is Proudly Powered by', 'Copyright Text', '', 'textInput', '', NULL, NULL, 'General Settings', '2023-06-11 11:36:10', 0),
(14, 1, 'facebook', 'https://www.facebook.com', 'Facebook Link', 'Enter valid URL', 'textInput', '', 'url', NULL, 'Social Settings', '2023-06-11 13:24:31', 0),
(15, 1, 'youtube', 'https://www.youtube.com', 'Youtube Link', 'Enter valid URL', 'textInput', '', 'url', NULL, 'Social Settings', '2023-06-11 13:19:44', 0),
(16, 1, 'linkedin', 'https://www.linkedin.com', 'Linked In Link', 'Enter valid URL', 'textInput', '', 'url', NULL, 'Social Settings', '2023-06-11 13:19:47', 0),
(17, 1, 'instagram', 'https://www.instagram.com', 'Instagram Link', 'Enter valid URL', 'textInput', '', 'url', NULL, 'Social Settings', '2023-06-11 13:19:49', 0),
(18, 1, 'twitter', 'https://twitter.com', 'Twitter Link', 'Enter valid URL', 'textInput', '', 'url', NULL, 'Social Settings', '2023-06-11 13:19:51', 0),
(19, 1, 'image_size', '[\"Actual size\"]', 'Image sizes', '', 'checkBox', '', NULL, NULL, 'Image Settings', '0000-00-00 00:00:00', 0),
(20, 1, 'images_sizes', '[{\"label\":\"Banner\",\"width\":\"100\",\"height\":\"100\"},{\"label\":\"Thumb\",\"width\":\"200\",\"height\":\"200\"},{\"label\":\"Background\",\"width\":\"300\",\"height\":\"300\"}]', 'Images sizes', '', 'textInput', '', NULL, NULL, 'Image sizes settings', '2022-09-16 03:27:02', 0),
(21, 1, 'compression_ratio', '100', 'Image compresion rate', 'in %', 'textInput', '', 'number', NULL, 'Image settings', '2023-06-11 13:14:00', 0),
(22, 11, 'image_weight', '1', 'Max Image Size', 'Unit : MB', 'textInput', '', 'number', NULL, 'Image Settings', '2023-06-11 13:27:30', 0),
(23, 11, 'image_ext', 'png,svg,jpg,pdf,jpeg', 'Image Extensions', 'Example: jpg,png,pdf', 'textInput', '', NULL, '[a-zA-Z,\\s]+', 'Image Settings', '2023-06-11 13:20:10', 0),
(24, 0, 'thumb', '', 'Thumb', '', 'checkBox', '', NULL, NULL, 'All Image/Files Fields', '2023-03-13 08:45:30', 2),
(25, 0, 'banner', '', 'Banner', '', 'checkBox', '', NULL, NULL, 'All Image/Files Fields', '2023-03-13 08:45:30', 2),
(26, 0, 'background', '', 'Background', '', 'checkBox', '', NULL, NULL, 'All Image/Files Fields', '2023-03-13 08:45:30', 2),
(27, 11, 'manual', '', 'Manual', '', 'fileInput', '', NULL, NULL, 'Documents', '2023-06-10 13:40:01', 0),
(28, 11, 'sitemap', '', 'Sitemap', '', 'fileInput', '', NULL, NULL, 'Documents', '2023-06-10 13:39:57', 0),
(29, 11, 'robots', '', 'Robots.txt', '', 'fileInput', '', NULL, NULL, 'Documents', '2023-04-20 06:11:40', 0),
(30, 11, 'google_map', '', 'Google Map Key', '', 'textInput', '', NULL, NULL, 'API', '2023-04-20 06:11:03', 0),
(31, 0, 'default_template', '', 'Default Templete', '', 'fileInput', '', NULL, NULL, 'Page Templates', '2022-03-17 07:00:52', 2),
(32, NULL, 'front_theme', 'website', 'Frontend Theme', '', 'radio', '{\"website\":\"Website\"}', NULL, NULL, 'Theme settings', '2023-05-04 08:19:00', NULL),
(58, 0, 'icon', '', 'Icon', '', 'checkBox', '', NULL, NULL, 'All Image/Files Fields', '2023-03-13 08:45:30', 2);

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `overview` text,
  `description` longtext,
  `date` date DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `mailing_queue`
--

CREATE TABLE `mailing_queue` (
  `id` int(11) NOT NULL,
  `email` text,
  `subject` text,
  `body` longtext,
  `status` tinyint(4) DEFAULT '1',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `identifier_type` varchar(255) DEFAULT NULL,
  `identifier_id` int(11) DEFAULT NULL,
  `short_title` varchar(255) DEFAULT NULL,
  `short_desc` text,
  `img_alt` text,
  `color_code` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `cloud_path` varchar(255) DEFAULT NULL,
  `img_name` varchar(255) DEFAULT NULL,
  `ext` varchar(255) DEFAULT NULL,
  `available_sizes` text,
  `size` varchar(255) DEFAULT NULL,
  `dimension` varchar(255) DEFAULT NULL,
  `device` varchar(100) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `media_fields`
--

CREATE TABLE `media_fields` (
  `id` int(11) NOT NULL,
  `media_id` int(11) NOT NULL,
  `field_key` varchar(255) DEFAULT NULL,
  `field_value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `lang` varchar(100) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `status` tinyint(4) DEFAULT '0',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `menu_rels`
--

CREATE TABLE `menu_rels` (
  `id` int(11) NOT NULL,
  `menu_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT '0',
  `item_title` varchar(255) DEFAULT NULL,
  `item_type` varchar(255) DEFAULT NULL,
  `item_desc` text,
  `item_url` text,
  `item_target` varchar(100) DEFAULT NULL,
  `item_icon` varchar(100) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id` int(11) NOT NULL,
  `parent_page_id` varchar(100) DEFAULT NULL,
  `page_section` tinyint(4) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `short_desc` text,
  `description` text,
  `image_size` varchar(255) DEFAULT NULL,
  `identifier` varchar(255) DEFAULT NULL,
  `template` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `is_archived` tinyint(1) DEFAULT '0',
  `title_tag` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `og_title` varchar(255) DEFAULT NULL,
  `og_description` text,
  `preview` varchar(225) DEFAULT NULL,
  `instructions` text,
  `child_of` int(11) DEFAULT NULL,
  `update_type` varchar(255) DEFAULT NULL,
  `visit_count` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `page_gallery_rel`
--

CREATE TABLE `page_gallery_rel` (
  `id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  `gallery_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `page_post`
--

CREATE TABLE `page_post` (
  `id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `subtitle` text,
  `short_desc` text,
  `description` text,
  `sort_order` int(11) DEFAULT '0',
  `template` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `page_self_rels`
--

CREATE TABLE `page_self_rels` (
  `id` int(11) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  `parent_page_id` int(11) DEFAULT '0',
  `page_section` tinyint(4) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `category_id` varchar(100) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `subtitle` text,
  `short_desc` text,
  `description` text,
  `price` float(11,2) DEFAULT '0.00',
  `image_size` varchar(255) DEFAULT NULL,
  `is_featured` int(11) DEFAULT '0',
  `is_archived` tinyint(1) DEFAULT '0',
  `is_copy` tinyint(4) DEFAULT '0',
  `identifier` varchar(255) DEFAULT NULL,
  `template` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `feature_sort_order` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '1',
  `title_tag` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `og_title` varchar(255) DEFAULT NULL,
  `og_description` text,
  `preview` varchar(225) DEFAULT NULL,
  `instructions` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `product_attribute`
--

CREATE TABLE `product_attribute` (
  `id` int(11) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `parent` varchar(255) DEFAULT NULL,
  `item_key` varchar(255) DEFAULT NULL,
  `item_value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `product_category_rel`
--

CREATE TABLE `product_category_rel` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `product_gallery_rel`
--

CREATE TABLE `product_gallery_rel` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `gallery_id` int(11) NOT NULL,
  `sort_order` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `product_post`
--

CREATE TABLE `product_post` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `subtitle` text,
  `type` varchar(255) DEFAULT NULL,
  `short_desc` varchar(255) DEFAULT NULL,
  `description` text,
  `template` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `status` tinyint(4) DEFAULT '1',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `specifications`
--

CREATE TABLE `specifications` (
  `id` int(11) NOT NULL,
  `item_title` varchar(255) DEFAULT NULL,
  `item_value` varchar(255) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `subscription`
--

CREATE TABLE `subscription` (
  `id` int(11) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `in_page` tinyint(1) DEFAULT NULL,
  `in_pagesection` int(11) DEFAULT NULL,
  `in_pagepost` tinyint(1) DEFAULT NULL,
  `in_product` tinyint(1) DEFAULT NULL,
  `in_gallery` tinyint(1) DEFAULT NULL,
  `in_productpost` tinyint(1) DEFAULT NULL,
  `image` text,
  `sort_order` int(11) DEFAULT '0',
  `status` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `in_page` tinyint(1) DEFAULT NULL,
  `in_pagepost` tinyint(1) DEFAULT NULL,
  `in_product` tinyint(1) DEFAULT NULL,
  `in_gallery` tinyint(1) DEFAULT NULL,
  `in_productpost` tinyint(1) DEFAULT NULL,
  `sort_order` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  `is_archived` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `variations`
--

CREATE TABLE `variations` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `action_type` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `auth_assignment`
--
ALTER TABLE `auth_assignment`
  ADD PRIMARY KEY (`item_name`,`user_id`);

--
-- Indexes for table `auth_item`
--
ALTER TABLE `auth_item`
  ADD PRIMARY KEY (`name`),
  ADD KEY `rule_name` (`rule_name`),
  ADD KEY `type` (`type`);

--
-- Indexes for table `auth_item_child`
--
ALTER TABLE `auth_item_child`
  ADD PRIMARY KEY (`parent`,`child`),
  ADD KEY `child` (`child`);

--
-- Indexes for table `auth_rule`
--
ALTER TABLE `auth_rule`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner_post`
--
ALTER TABLE `banner_post`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog`
--
ALTER TABLE `blog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `category_self_rel`
--
ALTER TABLE `category_self_rel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `extra_field`
--
ALTER TABLE `extra_field`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `extra_field_values`
--
ALTER TABLE `extra_field_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_fields`
--
ALTER TABLE `form_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_list`
--
ALTER TABLE `form_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `form_submitted`
--
ALTER TABLE `form_submitted`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery_post`
--
ALTER TABLE `gallery_post`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `global_settings`
--
ALTER TABLE `global_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mailing_queue`
--
ALTER TABLE `mailing_queue`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `media_fields`
--
ALTER TABLE `media_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_rels`
--
ALTER TABLE `menu_rels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migration`
--
ALTER TABLE `migration`
  ADD PRIMARY KEY (`version`);

--
-- Indexes for table `page`
--
ALTER TABLE `page`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_gallery_rel`
--
ALTER TABLE `page_gallery_rel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_post`
--
ALTER TABLE `page_post`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_self_rels`
--
ALTER TABLE `page_self_rels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_attribute`
--
ALTER TABLE `product_attribute`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_category_rel`
--
ALTER TABLE `product_category_rel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_gallery_rel`
--
ALTER TABLE `product_gallery_rel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_post`
--
ALTER TABLE `product_post`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `specifications`
--
ALTER TABLE `specifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscription`
--
ALTER TABLE `subscription`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `templates`
--
ALTER TABLE `templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `types`
--
ALTER TABLE `types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `variations`
--
ALTER TABLE `variations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `banner_post`
--
ALTER TABLE `banner_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog`
--
ALTER TABLE `blog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category_self_rel`
--
ALTER TABLE `category_self_rel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `extra_field`
--
ALTER TABLE `extra_field`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `extra_field_values`
--
ALTER TABLE `extra_field_values`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `form_fields`
--
ALTER TABLE `form_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `form_list`
--
ALTER TABLE `form_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `form_submitted`
--
ALTER TABLE `form_submitted`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gallery_post`
--
ALTER TABLE `gallery_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `global_settings`
--
ALTER TABLE `global_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mailing_queue`
--
ALTER TABLE `mailing_queue`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media_fields`
--
ALTER TABLE `media_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menu_rels`
--
ALTER TABLE `menu_rels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page`
--
ALTER TABLE `page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page_gallery_rel`
--
ALTER TABLE `page_gallery_rel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page_post`
--
ALTER TABLE `page_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page_self_rels`
--
ALTER TABLE `page_self_rels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_attribute`
--
ALTER TABLE `product_attribute`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_category_rel`
--
ALTER TABLE `product_category_rel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_gallery_rel`
--
ALTER TABLE `product_gallery_rel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_post`
--
ALTER TABLE `product_post`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `specifications`
--
ALTER TABLE `specifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription`
--
ALTER TABLE `subscription`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `templates`
--
ALTER TABLE `templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `types`
--
ALTER TABLE `types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `variations`
--
ALTER TABLE `variations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

