1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / api.bishalbazzar.com / _sql /
Filename : progress.txt
back
SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `gwcil_live`.`attribute` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`attribute` ADD INDEX `attribute_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`attribute_items` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`attribute_items` ADD INDEX `attribute_items_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`banner` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`banner` ADD INDEX `banner_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`brands` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`brands` MODIFY COLUMN `brand_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `top`;

ALTER TABLE `gwcil_live`.`brands` ADD INDEX `brands_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`cart` DROP INDEX `cart_uuid_unique`;

ALTER TABLE `gwcil_live`.`cart` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`cart` ADD INDEX `cart_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`cart_item` DROP INDEX `cart_item_uuid_unique`;

ALTER TABLE `gwcil_live`.`cart_item` ADD COLUMN `store_id` bigint UNSIGNED NOT NULL AFTER `product_id`;

ALTER TABLE `gwcil_live`.`cart_item` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`cart_item` MODIFY COLUMN `cart_id` bigint UNSIGNED NOT NULL AFTER `uuid`;

ALTER TABLE `gwcil_live`.`cart_item` MODIFY COLUMN `product_id` bigint UNSIGNED NOT NULL AFTER `cart_id`;

ALTER TABLE `gwcil_live`.`cart_item` ADD INDEX `cart_item_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`cart_item` ADD INDEX `cart_item_store_id_index`(`store_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`cart_item_variation` DROP INDEX `cart_item_variation_uuid_unique`;

ALTER TABLE `gwcil_live`.`cart_item_variation` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`cart_item_variation` MODIFY COLUMN `cart_id` bigint UNSIGNED NOT NULL AFTER `uuid`;

ALTER TABLE `gwcil_live`.`cart_item_variation` MODIFY COLUMN `cart_item_id` bigint UNSIGNED NOT NULL AFTER `cart_id`;

ALTER TABLE `gwcil_live`.`cart_item_variation` ADD INDEX `cart_item_variation_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`contact` ADD COLUMN `viewed` tinyint NOT NULL DEFAULT 0 AFTER `user_id`;

ALTER TABLE `gwcil_live`.`contact` ADD COLUMN `replayed` tinyint NOT NULL DEFAULT 0 AFTER `viewed`;

ALTER TABLE `gwcil_live`.`contact` ADD INDEX `contact_viewed_index`(`viewed` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`coupons` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`coupons` MODIFY COLUMN `coupon_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `coupon_type`;

ALTER TABLE `gwcil_live`.`coupons` ADD INDEX `coupons_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`customer_shipping_address` DROP INDEX `customer_shipping_address_uuid_unique`;

ALTER TABLE `gwcil_live`.`customer_shipping_address` ADD COLUMN `type` enum('customer','vendor','staff') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'customer' AFTER `address`;

ALTER TABLE `gwcil_live`.`customer_shipping_address` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`customer_shipping_address` ADD INDEX `customer_shipping_address_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`customer_shipping_address` ADD INDEX `customer_shipping_address_type_index`(`type` ASC) USING BTREE;

CREATE TABLE `gwcil_live`.`customer_tax`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `exemption` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `status` enum('submitted') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted',
  `tax_form` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `customer_tax_user_id_index`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

ALTER TABLE `gwcil_live`.`order` DROP INDEX `order_uuid_unique`;

ALTER TABLE `gwcil_live`.`order` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`order` MODIFY COLUMN `shipping_method` json NULL AFTER `delivery_date_time`;

ALTER TABLE `gwcil_live`.`order` MODIFY COLUMN `user_id` bigint UNSIGNED NOT NULL AFTER `tracking_check_link`;

ALTER TABLE `gwcil_live`.`order` MODIFY COLUMN `delivery_person_id` bigint UNSIGNED NULL DEFAULT NULL AFTER `user_id`;

ALTER TABLE `gwcil_live`.`order` ADD INDEX `order_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_item` DROP INDEX `order_item_uuid_unique`;

ALTER TABLE `gwcil_live`.`order_item` ADD COLUMN `store_id` int UNSIGNED NOT NULL AFTER `product_id`;

ALTER TABLE `gwcil_live`.`order_item` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`order_item` MODIFY COLUMN `product_id` bigint UNSIGNED NOT NULL AFTER `uuid`;

ALTER TABLE `gwcil_live`.`order_item` MODIFY COLUMN `order_id` bigint UNSIGNED NOT NULL AFTER `total_amount`;

ALTER TABLE `gwcil_live`.`order_item` MODIFY COLUMN `user_id` bigint UNSIGNED NOT NULL AFTER `order_id`;

ALTER TABLE `gwcil_live`.`order_item` ADD INDEX `order_item_order_id_foreign`(`order_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_item` ADD INDEX `order_item_user_id_foreign`(`user_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_item` ADD INDEX `order_item_product_id_foreign`(`product_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_item` ADD INDEX `order_item_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_item_variation` DROP INDEX `order_item_variation_uuid_unique`;

ALTER TABLE `gwcil_live`.`order_item_variation` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`order_item_variation` MODIFY COLUMN `order_id` bigint UNSIGNED NOT NULL AFTER `uuid`;

ALTER TABLE `gwcil_live`.`order_item_variation` MODIFY COLUMN `order_item_id` bigint UNSIGNED NOT NULL AFTER `order_id`;

ALTER TABLE `gwcil_live`.`order_item_variation` MODIFY COLUMN `user_id` bigint UNSIGNED NOT NULL AFTER `order_item_id`;

ALTER TABLE `gwcil_live`.`order_item_variation` ADD INDEX `order_item_variation_user_id_foreign`(`user_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_item_variation` ADD INDEX `order_item_variation_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_return` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`order_return` ADD INDEX `order_return_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_return_item_variation` DROP INDEX `order_return_item_variation_uuid_unique`;

ALTER TABLE `gwcil_live`.`order_return_item_variation` ADD INDEX `order_return_item_variation_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_return_items` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`order_return_items` ADD INDEX `order_return_items_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`order_tracking` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`order_tracking` ADD INDEX `order_tracking_uuid_index`(`uuid` ASC) USING BTREE;

CREATE TABLE `gwcil_live`.`pickup_points`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `staff_id` int UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `pick_up_status` enum('enable','disabled','banned') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cash_on_pickup_status` enum('enable','disabled','banned') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `pickup_points_phone_unique`(`phone` ASC) USING BTREE,
  UNIQUE INDEX `pickup_points_email_unique`(`email` ASC) USING BTREE,
  INDEX `pickup_points_uuid_index`(`uuid` ASC) USING BTREE,
  INDEX `pickup_points_staff_id_index`(`staff_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

ALTER TABLE `gwcil_live`.`products` DROP INDEX `products_uuid_unique`;

ALTER TABLE `gwcil_live`.`products` ADD COLUMN `approved` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `meta_description`;

ALTER TABLE `gwcil_live`.`products` ADD COLUMN `store_id` bigint UNSIGNED NOT NULL AFTER `status`;

ALTER TABLE `gwcil_live`.`products` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`products` MODIFY COLUMN `status` enum('submitted','publish','draft','hold','rejected','banned') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted' AFTER `approved`;

ALTER TABLE `gwcil_live`.`products` ADD INDEX `products_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`products` ADD INDEX `products_store_id_index`(`store_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`recent_view_log` DROP INDEX `recent_view_log_uuid_unique`;

ALTER TABLE `gwcil_live`.`recent_view_log` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`recent_view_log` ADD INDEX `recent_view_log_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`renewal_products` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`renewal_products` ADD INDEX `renewal_products_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `user_id` int UNSIGNED NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `product_id` int UNSIGNED NOT NULL AFTER `user_id`;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `rating` smallint NOT NULL DEFAULT 0 AFTER `product_id`;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `rating`;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `status` enum('active','inactive','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `comment`;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `viewed` tinyint NULL DEFAULT 0 AFTER `status`;

ALTER TABLE `gwcil_live`.`review` ADD COLUMN `deleted_at` timestamp NULL DEFAULT NULL AFTER `updated_at`;

ALTER TABLE `gwcil_live`.`review` ADD INDEX `review_user_id_index`(`user_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`review` ADD INDEX `review_product_id_index`(`product_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`review` ADD INDEX `review_rating_index`(`rating` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`settings` ADD COLUMN `status` enum('public','private') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'private' AFTER `value`;

ALTER TABLE `gwcil_live`.`settings` ADD INDEX `settings_status_index`(`status` ASC) USING BTREE;

CREATE TABLE `gwcil_live`.`staff`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `staff_uuid_index`(`uuid` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

CREATE TABLE `gwcil_live`.`store`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `active` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `sliders` json NULL,
  `website` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `facebook` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `instagram` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `twitter` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `youtube` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `meta_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `pick_up_point_id` int UNSIGNED NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `store_slug_unique`(`slug` ASC) USING BTREE,
  UNIQUE INDEX `store_phone_unique`(`phone` ASC) USING BTREE,
  UNIQUE INDEX `store_email_unique`(`email` ASC) USING BTREE,
  INDEX `store_user_id_foreign`(`user_id` ASC) USING BTREE,
  INDEX `store_uuid_index`(`uuid` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

ALTER TABLE `gwcil_live`.`taxonomies` ADD COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `active`;

ALTER TABLE `gwcil_live`.`taxonomies` MODIFY COLUMN `type` enum('main','child','sub_child') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'main' AFTER `parent_id`;

ALTER TABLE `gwcil_live`.`taxonomies` MODIFY COLUMN `group_id` smallint NULL DEFAULT NULL AFTER `type`;

ALTER TABLE `gwcil_live`.`taxonomies` DROP COLUMN `using_for`;

ALTER TABLE `gwcil_live`.`taxonomies` ADD INDEX `taxonomies_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`taxonomies` ADD INDEX `taxonomies_group_id_index`(`group_id` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`user_registration` DROP INDEX `user_registration_uuid_unique`;

ALTER TABLE `gwcil_live`.`user_registration` DROP INDEX `user_registration_email_unique`;

ALTER TABLE `gwcil_live`.`user_registration` DROP INDEX `user_registration_phone_unique`;

ALTER TABLE `gwcil_live`.`user_registration` MODIFY COLUMN `id` bigint UNSIGNED NOT NULL FIRST;

ALTER TABLE `gwcil_live`.`user_registration` MODIFY COLUMN `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `id`;

ALTER TABLE `gwcil_live`.`user_registration` DROP PRIMARY KEY;

ALTER TABLE `gwcil_live`.`user_registration` ADD INDEX `user_registration_uuid_index`(`uuid` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`user_registration` ADD INDEX `user_registration_email_index`(`email` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`user_registration` ADD INDEX `user_registration_phone_index`(`phone` ASC) USING BTREE;

ALTER TABLE `gwcil_live`.`cart_item` ADD CONSTRAINT `cart_item_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `gwcil_live`.`cart` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`cart_item_variation` ADD CONSTRAINT `cart_item_variation_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `gwcil_live`.`cart` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`cart_item_variation` ADD CONSTRAINT `cart_item_variation_cart_item_id_foreign` FOREIGN KEY (`cart_item_id`) REFERENCES `gwcil_live`.`cart_item` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order` ADD CONSTRAINT `order_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `gwcil_live`.`users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order_item` ADD CONSTRAINT `order_item_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `gwcil_live`.`order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order_item` ADD CONSTRAINT `order_item_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `gwcil_live`.`products` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order_item` ADD CONSTRAINT `order_item_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `gwcil_live`.`users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order_item_variation` ADD CONSTRAINT `order_item_variation_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `gwcil_live`.`order` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order_item_variation` ADD CONSTRAINT `order_item_variation_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `gwcil_live`.`order_item` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`order_item_variation` ADD CONSTRAINT `order_item_variation_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `gwcil_live`.`users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE `gwcil_live`.`store` ADD CONSTRAINT `store_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `gwcil_live`.`users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;

DROP TABLE IF EXISTS `gwcil_live`.`customer_tax_form`;

DROP TABLE IF EXISTS `gwcil_live`.`sellers`;

DROP TABLE IF EXISTS `gwcil_live`.`telescope_entries`;

DROP TABLE IF EXISTS `gwcil_live`.`telescope_entries_tags`;

DROP TABLE IF EXISTS `gwcil_live`.`telescope_monitoring`;

SET FOREIGN_KEY_CHECKS=1;