ALTER TABLE `front_end_theme_content` ADD `top_offers` TEXT NOT NULL AFTER `id`;

ALTER TABLE `current_theme` ADD `top_offer` INT(11) NOT NULL DEFAULT '1' AFTER `contact`;

UPDATE `front_end_theme_content` SET `top_offers` = '[{ \"id\": 1, \"name\": \"Top Offer\", \"image\": \"images/prototypes/banner1.jpg\", \"alt\": \"Top Offer\" }]' WHERE `front_end_theme_content`.`id` = 1;

ALTER TABLE `front_end_theme_content` ADD `login` TEXT NOT NULL AFTER `top_offers`;
ALTER TABLE `current_theme` ADD `login` INT(11) NOT NULL DEFAULT '1' AFTER `top_offer`;


CREATE TABLE IF NOT EXISTS `top_offers` (
  `top_offers_id` int(11) NOT NULL AUTO_INCREMENT,
  `top_offers_text` text NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`top_offers_id`)
);


INSERT INTO `top_offers` (`top_offers_id`, `top_offers_text`, `created_at`, `updated_at`, `language_id`) VALUES
(1, '<p>Get<strong> UPTO 40% OFF </strong>on your 1st order <strong> <a href=\\\"#\\\"> More details </a> </strong></p>', '2020-02-04 07:23:23', '2020-02-03 20:26:53', 1),
(2, '<p>Get<strong> UPTO 40% OFF </strong>on your 1st order <strong> <a href=\\\"#\\\"> More details </a> </strong></p>', '0000-00-00 00:00:00', '2020-02-03 20:26:53', 2);


ALTER TABLE `front_end_theme_content` ADD `transitions` TEXT NOT NULL AFTER `login`;
UPDATE `front_end_theme_content` SET `transitions` = '[{ \"id\": 1, \"name\": \"Transition Zoomin\" }, { \"id\": 2, \"name\": \"Transition Flashing\" } , { \"id\": 3, \"name\": \"Transition Shine\" , { \"id\": 4, \"name\": \"Transition Circle\" } , { \"id\": 5, \"name\": \"Transition Opacity\" }]' WHERE `front_end_theme_content`.`id` = 1;

ALTER TABLE `current_theme` ADD `transitions` INT(11) NOT NULL AFTER `login`;
UPDATE `current_theme` SET `transitions` = '1' WHERE `current_theme`.`id` = 1;




ALTER TABLE `front_end_theme_content` ADD `banners_two` TEXT NOT NULL AFTER `transitions`;

UPDATE `front_end_theme_content` SET `banners_two` = '[ { "id": 1, "name": "Banner One", "image": "images/prototypes/banner1.jpg", "alt": "Banner One" }, { "id": 2, "name": "Banner Two", "image": "images/prototypes/banner2.jpg", "alt": "Banner Two" }, { "id": 3, "name": "Banner Three", "image": "images/prototypes/banner3.jpg", "alt": "Banner Three" }, { "id": 4, "name": "Banner Four", "image": "images/prototypes/banner4.jpg", "alt": "Banner Four" }, { "id": 5, "name": "Banner Five", "image": "images/prototypes/banner5.jpg", "alt": "Banner Five" }, { "id": 6, "name": "Banner Six", "image": "images/prototypes/banner6.jpg", "alt": "Banner Six" }, { "id": 7, "name": "Banner Seven", "image": "images/prototypes/banner7.jpg", "alt": "Banner Seven" }, { "id": 8, "name": "Banner Eight", "image": "images/prototypes/banner8.jpg", "alt": "Banner Eight" }, { "id": 9, "name": "Banner Nine", "image": "images/prototypes/banner9.jpg", "alt": "Banner Nine" }, { "id": 10, "name": "Banner Ten", "image": "images/prototypes/banner10.jpg", "alt": "Banner Ten" }, { "id": 11, "name": "Banner Eleven", "image": "images/prototypes/banner11.jpg", "alt": "Banner Eleven" }, { "id": 12, "name": "Banner Twelve", "image": "images/prototypes/banner12.jpg", "alt": "Banner Twelve" }, { "id": 13, "name": "Banner Thirteen", "image": "images/prototypes/banner13.jpg", "alt": "Banner Thirteen" }, { "id": 14, "name": "Banner Fourteen", "image": "images/prototypes/banner14.jpg", "alt": "Banner Fourteen" }, { "id": 15, "name": "Banner Fifteen", "image": "images/prototypes/banner15.jpg", "alt": "Banner Fifteen" }, { "id": 16, "name": "Banner Sixteen", "image": "images/prototypes/banner16.jpg", "alt": "Banner Sixteen" }, { "id": 17, "name": "Banner Seventeen", "image": "images/prototypes/banner17.jpg", "alt": "Banner Seventeen" }, { "id": 18, "name": "Banner Eighteen", "image": "images/prototypes/banner18.jpg", "alt": "Banner Eighteen" }, { "id": 19, "name": "Banner Nineteen", "image": "images/prototypes/banner19.jpg", "alt": "Banner Nineteen" } ]';



ALTER TABLE `current_theme` ADD `banner_two` INT(11) NOT NULL AFTER `transitions`;
UPDATE `current_theme` SET `banner_two` = '1' WHERE `current_theme`.`id` = 1;

INSERT INTO `constant_banners` (`banners_id`, `banners_title`, `banners_url`, `banners_image`, `date_added`, `status`, `languages_id`, `type`) VALUES (NULL, 'ad_banner3', '', '107', '2020-02-26 02:10:11', '1', '1', '41'), (NULL, 'ad_banner3', '', '107', '2020-02-26 04:08:08', '1', '2', '41');


UPDATE `front_end_theme_content` SET `product_section_order` = '[{\r\n                    \"id\": 10,\r\n                    \"name\": \"Second Ad Section\",\r\n                    \"order\": 1,\r\n                    \"file_name\": \"sec_ad_banner\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/sec_ad_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/sec_ad_section-cross.jpg\",\r\n                    \"alt\": \"Second Ad Section\"\r\n                }, {\r\n                    \"id\": 5,\r\n                    \"name\": \"Categories\",\r\n                    \"order\": 2,\r\n                    \"file_name\": \"categories\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/categories.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/categories-cross.jpg\",\r\n                    \"alt\": \"Categories\"\r\n                }, {\r\n                    \"id\": 1,\r\n                    \"name\": \"Banner Section\",\r\n                    \"order\": 3,\r\n                    \"file_name\": \"banner_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/banner_section.jpg\",\r\n                    \"alt\": \"Banner Section\"\r\n                }, {\r\n                    \"id\": 9,\r\n                    \"name\": \"Top Selling\",\r\n                    \"order\": 4,\r\n                    \"file_name\": \"top\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/top.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/top-cross.jpg\",\r\n                    \"alt\": \"Top Selling\"\r\n                }, {\r\n                    \"id\": 8,\r\n                    \"name\": \"Newest Product Section\",\r\n                    \"order\": 5,\r\n                    \"file_name\": \"newest_product\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/newest_product.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/newest_product-cross.jpg\",\r\n                    \"alt\": \"Newest Product Section\"\r\n                }, {\r\n                    \"id\": 11,\r\n                    \"name\": \"Tab Products View\",\r\n                    \"order\": 6,\r\n                    \"file_name\": \"tab\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/tab.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/tab-cross.jpg\",\r\n                    \"alt\": \"Tab Products View\"\r\n                }, {\r\n                    \"id\": 3,\r\n                    \"name\": \"Special Products Section\",\r\n                    \"order\": 7,\r\n                    \"file_name\": \"special\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/special_product.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/special_product-cross.jpg\",\r\n                    \"alt\": \"Special Products Section\"\r\n                }, {\r\n                    \"id\": 2,\r\n                    \"name\": \"Flash Sale Section\",\r\n                    \"order\": 8,\r\n                    \"file_name\": \"flash_sale_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/flash_sale_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/flash_sale_section-cross.jpg\",\r\n                    \"alt\": \"Flash Sale Section\"\r\n                }, {\r\n                    \"id\": 4,\r\n                    \"name\": \"Ad Section\",\r\n                    \"order\": 9,\r\n                    \"file_name\": \"ad_banner_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/ad_banner_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/ad_banner_section-cross.jpg\",\r\n                    \"alt\": \"Ad Section\"\r\n                }, {\r\n                    \"id\": 6,\r\n                    \"name\": \"Blog Section\",\r\n                    \"order\": 10,\r\n                    \"file_name\": \"blog_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/blog_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/blog_section-cross.jpg\",\r\n                    \"alt\": \"Blog Section\"\r\n                }, {\r\n                    \"id\": 12,\r\n                    \"name\": \"Banner 2 Section\",\r\n                    \"order\": 11,\r\n                    \"file_name\": \"banner_two_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/sec_ad_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/sec_ad_section-cross.jpg\",\r\n                    \"alt\": \"Banner 2 Section\"\r\n                }, {\r\n                    \"id\": 7,\r\n                    \"name\": \"Info Boxes\",\r\n                    \"order\": 12,\r\n                    \"file_name\": \"info_boxes\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/info_boxes.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/info_boxes-cross.jpg\",\r\n                    \"alt\": \"Info Boxes\"\r\n                }]\r\n                ' WHERE `front_end_theme_content`.`id` = 1;

UPDATE `front_end_theme_content` SET `login` = '[{\r\n                    \"id\": 10,\r\n                    \"name\": \"Second Ad Section\",\r\n                    \"order\": 1,\r\n                    \"file_name\": \"sec_ad_banner\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/sec_ad_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/sec_ad_section-cross.jpg\",\r\n                    \"alt\": \"Second Ad Section\"\r\n                }, {\r\n                    \"id\": 5,\r\n                    \"name\": \"Categories\",\r\n                    \"order\": 2,\r\n                    \"file_name\": \"categories\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/categories.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/categories-cross.jpg\",\r\n                    \"alt\": \"Categories\"\r\n                }, {\r\n                    \"id\": 1,\r\n                    \"name\": \"Banner Section\",\r\n                    \"order\": 3,\r\n                    \"file_name\": \"banner_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/banner_section.jpg\",\r\n                    \"alt\": \"Banner Section\"\r\n                }, {\r\n                    \"id\": 9,\r\n                    \"name\": \"Top Selling\",\r\n                    \"order\": 4,\r\n                    \"file_name\": \"top\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/top.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/top-cross.jpg\",\r\n                    \"alt\": \"Top Selling\"\r\n                }, {\r\n                    \"id\": 8,\r\n                    \"name\": \"Newest Product Section\",\r\n                    \"order\": 5,\r\n                    \"file_name\": \"newest_product\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/newest_product.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/newest_product-cross.jpg\",\r\n                    \"alt\": \"Newest Product Section\"\r\n                }, {\r\n                    \"id\": 11,\r\n                    \"name\": \"Tab Products View\",\r\n                    \"order\": 6,\r\n                    \"file_name\": \"tab\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/tab.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/tab-cross.jpg\",\r\n                    \"alt\": \"Tab Products View\"\r\n                }, {\r\n                    \"id\": 3,\r\n                    \"name\": \"Special Products Section\",\r\n                    \"order\": 7,\r\n                    \"file_name\": \"special\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/special_product.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/special_product-cross.jpg\",\r\n                    \"alt\": \"Special Products Section\"\r\n                }, {\r\n                    \"id\": 2,\r\n                    \"name\": \"Flash Sale Section\",\r\n                    \"order\": 8,\r\n                    \"file_name\": \"flash_sale_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/flash_sale_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/flash_sale_section-cross.jpg\",\r\n                    \"alt\": \"Flash Sale Section\"\r\n                }, {\r\n                    \"id\": 4,\r\n                    \"name\": \"Ad Section\",\r\n                    \"order\": 9,\r\n                    \"file_name\": \"ad_banner_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/ad_banner_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/ad_banner_section-cross.jpg\",\r\n                    \"alt\": \"Ad Section\"\r\n                }, {\r\n                    \"id\": 6,\r\n                    \"name\": \"Blog Section\",\r\n                    \"order\": 10,\r\n                    \"file_name\": \"blog_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/blog_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/blog_section-cross.jpg\",\r\n                    \"alt\": \"Blog Section\"\r\n                }, {\r\n                    \"id\": 12,\r\n                    \"name\": \"Banner 2 Section\",\r\n                    \"order\": 11,\r\n                    \"file_name\": \"banner_two_section\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/sec_ad_section.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/sec_ad_section-cross.jpg\",\r\n                    \"alt\": \"Banner 2 Section\"\r\n                }, {\r\n                    \"id\": 7,\r\n                    \"name\": \"Info Boxes\",\r\n                    \"order\": 12,\r\n                    \"file_name\": \"info_boxes\",\r\n                    \"status\": 1,\r\n                    \"image\": \"images\\/prototypes\\/info_boxes.jpg\",\r\n                    \"disabled_image\": \"images\\/prototypes\\/info_boxes-cross.jpg\",\r\n                    \"alt\": \"Info Boxes\"\r\n                }]\r\n                ' WHERE `front_end_theme_content`.`id` = 1;

UPDATE `front_end_theme_content` SET `login` = '[      {         \"id\":1,       \"name\":\"Login Page One\"    },    {         \"id\":2,       \"name\":\"Login Page Two\"    } ]' WHERE `front_end_theme_content`.`id` = 1;

UPDATE `front_end_theme_content` SET `transitions` = '[      {         \"id\":1,       \"name\":\"Transition Zoomin\"    },    {         \"id\":2,       \"name\":\"Transition Flashing\"    },    {         \"id\":3,       \"name\":\"Transition Shine\"    },    {         \"id\":4,       \"name\":\"Transition Circle\"    },    {         \"id\":5,       \"name\":\"Transition Opacity\"    } ]' WHERE `front_end_theme_content`.`id` = 1;

UPDATE `front_end_theme_content` SET `news` = '[      {         \"id\":1,       \"name\":\"News One\"    },    {         \"id\":2,       \"name\":\"News Two\"    }     ]' WHERE `front_end_theme_content`.`id` = 1;


INSERT INTO `settings` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES 
(NULL, 'newsletter', '1', '2020-03-20 04:12:09', '2020-03-20 04:12:09'), 
(NULL, 'allow_cookies', '1', NULL, '2020-03-20 04:12:09'),
(NULL, 'card_style', '1', NULL, '2020-03-20 04:12:09'), 
(NULL, 'banner_style', '1', NULL, '2020-03-20 04:12:09'),
(NULL, 'mail_chimp_api', NULL, NULL, NULL), 
(NULL, 'mail_chimp_list_id', NULL, NULL, NULL), 
(NULL, 'newsletter_image', NULL, NULL, NULL);

CREATE TABLE `home_banners` (
  `home_banners_id` int(100) NOT NULL,
  `banner_name` varchar(100) NOT NULL,
  `language_id` int(100) NOT NULL DEFAULT 1,
  `text` text NOT NULL,
  `image` int(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
);