Gecko [ denebpollux.com ]

Name	Size	Permission
v15.sql	896 B	-rw-rw-rw-
v16.sql	1.89 KB	-rw-rw-rw-
v17.sql	2.67 KB	-rw-rw-rw-
v18.sql	2.05 KB	-rw-rw-rw-
v19.sql	473 B	-rw-rw-rw-
v20.sql	5.66 KB	-rw-rw-rw-
v21.sql	113 B	-rw-rw-rw-
v22.sql	113 B	-rw-rw-rw-
v23.sql	113 B	-rw-rw-rw-
v24.sql	403 B	-rw-rw-rw-
v25.sql	5.44 KB	-rw-rw-rw-
v26.sql	113 B	-rw-rw-rw-
v27.sql	16.67 KB	-rw-rw-rw-
v28.sql	704 B	-rw-rw-rw-
v29.sql	4.96 KB	-rw-rw-rw-
v30.sql	113 B	-rw-rw-rw-
v31.sql	433 B	-rw-rw-rw-
v32.sql	784 B	-rw-rw-rw-
v33.sql	1.09 KB	-rw-rw-rw-
v34.sql	269 B	-rw-rw-rw-
v35.sql	113 B	-rw-rw-rw-
v36.sql	126.6 KB	-rw-rw-rw-
v37.sql	720 B	-rw-rw-rw-
v38.sql	729 B	-rw-rw-rw-
v39.sql	1.99 KB	-rw-rw-rw-
v40.sql	2.19 KB	-rw-rw-rw-
v41.sql	2.77 KB	-rw-rw-rw-
v42.sql	540 B	-rw-rw-rw-
v43.sql	1.04 KB	-rw-rw-rw-
v44.sql	113 B	-rw-rw-rw-
v45.sql	821 B	-rw-rw-rw-
v46.sql	113 B	-rw-rw-rw-
v47.sql	113 B	-rw-rw-rw-
v48.sql	2.11 KB	-rw-rw-rw-
v49.sql	1.7 KB	-rw-rw-rw-
v50.sql	1.1 KB	-rw-rw-rw-
v51.sql	206 B	-rw-rw-rw-
v52.sql	1.61 KB	-rw-rw-rw-
v53.sql	873 B	-rw-rw-rw-
v54.sql	207 B	-rw-rw-rw-
v541.sql	113 B	-rw-rw-rw-
v542.sql	227 B	-rw-rw-rw-
v543.sql	113 B	-rw-rw-rw-
v544.sql	214 B	-rw-rw-rw-
v545.sql	385 B	-rw-rw-rw-
v55.sql	4.42 MB	-rw-rw-rw-
v551.sql	305 B	-rw-rw-rw-
v552.sql	2.25 KB	-rw-rw-rw-
v553.sql	202 B	-rw-rw-rw-
v554.sql	1.83 KB	-rw-rw-rw-
v555.sql	373 B	-rw-rw-rw-
v556.sql	293 B	-rw-rw-rw-
v557.sql	201 B	-rw-rw-rw-
v60.sql	2.09 KB	-rw-rw-rw-
v61.sql	111 B	-rw-rw-rw-
v611.sql	199 B	-rw-rw-rw-
v612.sql	723 B	-rw-rw-rw-
v613.sql	113 B	-rw-rw-rw-
v614.sql	113 B	-rw-rw-rw-
v615.sql	113 B	-rw-rw-rw-
v620.sql	3.08 KB	-rw-rw-rw-
v630.sql	24.09 KB	-rw-rw-rw-
v631.sql	604 B	-rw-rw-rw-
v632.sql	445 B	-rw-rw-rw-
v633.sql	113 B	-rw-rw-rw-
v640.sql	715 B	-rw-rw-rw-
v650.sql	229 B	-rw-rw-rw-
v700.sql	856 B	-rw-rw-rw-
v710.sql	113 B	-rw-rw-rw-
v720.sql	113 B	-rw-rw-rw-
v730.sql	180 B	-rw-rw-rw-
v740.sql	212 B	-rw-rw-rw-
v750.sql	113 B	-rw-rw-rw-
v760.sql	113 B	-rw-rw-rw-
v770.sql	113 B	-rw-rw-rw-
v780.sql	113 B	-rw-rw-rw-
v790.sql	113 B	-rw-rw-rw-
v791.sql	289 B	-rw-rw-rw-
v792.sql	300 B	-rw-rw-rw-
v793.sql	113 B	-rw-rw-rw-
v800.sql	1.48 KB	-rw-rw-rw-
v810.sql	111 B	-rw-rw-rw-
v820.sql	6.04 KB	-rw-rw-rw-
v830.sql	359 B	-rw-rw-rw-
v840.sql	783 B	-rw-rw-rw-
v850.sql	1.16 KB	-rw-rw-rw-
v860.sql	2.73 KB	-rw-rw-rw-
v870.sql	2.35 KB	-rw-rw-rw-
v880.sql	797 B	-rw-rw-rw-
v890.sql	3.01 KB	-rw-rw-rw-
v900.sql	7.4 KB	-rw-rw-rw-

Code Editor : v820.sql

ALTER TABLE `coupons` CHANGE `start_date` `start_date` INT(15) NULL, CHANGE `end_date` `end_date` INT(15) NULL;
ALTER TABLE `coupons` ADD `status` TINYINT(1) NOT NULL DEFAULT '1' AFTER `end_date`;

CREATE TABLE `user_coupons` (
  `user_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `coupon_code` varchar(255) NOT NULL,
  `min_buy` double(20,2) NOT NULL,
  `validation_days` int(11) NOT NULL,
  `discount` double(20,2) NOT NULL,
  `discount_type` varchar(20) NOT NULL,
  `expiry_date` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `business_settings` (`id`, `type`, `value`, `lang`, `created_at`, `updated_at`) 
  VALUES (NULL, 'admin_login_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'customer_login_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'customer_register_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'seller_login_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'seller_register_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'delivery_boy_login_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'forgot_password_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'password_reset_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'phone_number_verify_page_image', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'authentication_layout_select', 'boxed', NULL, current_timestamp(), current_timestamp()),
        (NULL, 'flash_deal_card_bg_image', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'flash_deal_card_bg_title', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'flash_deal_card_bg_subtitle', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'flash_deal_card_text', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'todays_deal_card_bg_image', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'todays_deal_card_bg_title', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'todays_deal_card_bg_subtitle', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'todays_deal_card_text', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'new_product_card_bg_image', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'new_product_card_bg_title', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'new_product_card_bg_subtitle', NULL, 'en', current_timestamp(), current_timestamp()),
        (NULL, 'new_product_card_text', NULL, NULL, current_timestamp(), current_timestamp()),
        (NULL, 'featured_categories_text', 'dark', NULL, current_timestamp(), current_timestamp());

INSERT INTO `permissions` (`id`, `name`, `section`, `guard_name`, `created_at`, `updated_at`)
  VALUES (NULL, 'view_size_charts', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'add_size_charts', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'edit_size_charts', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'delete_size_charts', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'view_measurement_points', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'add_measurement_points', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'edit_measurement_points', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'delete_measurement_points', 'size_guide', 'web', current_timestamp(), current_timestamp()),
        (NULL, 'authentication_layout_settings', 'website_setup', 'web', current_timestamp(), current_timestamp());

CREATE TABLE `measurement_points` (
  `id` int(20) NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `measurement_points`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `measurement_points`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

CREATE TABLE `size_charts` (
  `id` int(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `category_id` int(11) NOT NULL,
  `fit_type` varchar(191) DEFAULT NULL,
  `stretch_type` varchar(191) DEFAULT NULL,
  `photos` varchar(191) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `measurement_points` varchar(255) NOT NULL,
  `size_options` varchar(255) NOT NULL,
  `measurement_option` varchar(191) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `size_charts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_id` (`category_id`);
  
ALTER TABLE `size_charts`
  MODIFY `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

CREATE TABLE `size_chart_details` (
  `id` int(20) UNSIGNED NOT NULL,
  `size_chart_id` int(20) NOT NULL,
  `measurement_point_id` int(20) NOT NULL,
  `attribute_value_id` int(20) NOT NULL,
  `inch_value` varchar(191) DEFAULT NULL,
  `cen_value` varchar(191) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `size_chart_details`
  ADD PRIMARY KEY (`id`);
  
ALTER TABLE `size_chart_details`
  MODIFY `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

UPDATE `business_settings` SET `value` = '8.2' WHERE `business_settings`.`type` = 'current_version';

COMMIT;

${this.title}

Code Editor : v820.sql