CREATE TABLE IF NOT EXISTS `wbs24_ozonapinew_orders_stack` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `external_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `account_index` int(11) NOT NULL DEFAULT '1',
 `order` text COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `external_id_account_index` (`external_id`, `account_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `wbs24_ozonapinew_orders_state` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `external_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `account_index` int(11) NOT NULL DEFAULT '1',
 `delivery_method_id` varchar(255) COLLATE utf8_unicode_ci NULL,
 `success_ship` varchar(255) COLLATE utf8_unicode_ci NULL,
 `act_create_id` varchar(255) COLLATE utf8_unicode_ci NULL,
 `act_creation_status` varchar(255) COLLATE utf8_unicode_ci NULL,
 `act` varchar(255) COLLATE utf8_unicode_ci NULL,
 `package_label` varchar(255) COLLATE utf8_unicode_ci NULL,
 `disabled_act` varchar(255) COLLATE utf8_unicode_ci NULL,
 `disabled_package_label` varchar(255) COLLATE utf8_unicode_ci NULL,
 `cancelled_order` varchar(255) COLLATE utf8_unicode_ci NULL,
 `delivering_order_status` varchar(255) COLLATE utf8_unicode_ci NULL,
 `last_mile_order_status` varchar(255) COLLATE utf8_unicode_ci NULL,
 `delivered_order_status` varchar(255) COLLATE utf8_unicode_ci NULL,
 `tpl_integration_type` varchar(255) COLLATE utf8_unicode_ci NULL,
 `attempts_package_label` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`id`),
 UNIQUE KEY `external_id_account_index` (`external_id`, `account_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `wbs24_ozonapinew_delivery_services` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `delivery_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `name` text COLLATE utf8_unicode_ci NOT NULL,
 `account_index` int(11) NOT NULL DEFAULT '1',
 PRIMARY KEY (`id`),
 UNIQUE KEY `delivery_id_account_index` (`delivery_id`, `account_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `wbs24_ozonapinew_log` (
 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `account_index` int(11) NOT NULL DEFAULT '1',
 `timestamp` datetime NOT NULL, -- дата создания лога
 `entity_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, -- тип сущности, котрая создала лог (заказы, остатки, цены)
 `log_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, -- тип лога (ошибка, информация, отладка)
 `api_method` varchar(255) COLLATE utf8_unicode_ci NOT NULL, -- api метода, в следствии которого выявилась ошибка
 `message` text COLLATE utf8_unicode_ci NOT NULL, -- сообщение
 `api_request` text COLLATE utf8_unicode_ci NOT NULL, -- Json отправленного запроса
 `api_response` text COLLATE utf8_unicode_ci NOT NULL, -- Json ответа на запрос
 `trace` text COLLATE utf8_unicode_ci NOT NULL, -- Цепочка вызовов
 PRIMARY KEY (`id`),
 UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `wbs24_ozonapinew_allowed_products` (
 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `account_index` int(11) NOT NULL DEFAULT '1',
 `offer_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `product_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `package_ratio` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `iblock_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `entity_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `parent_product_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `parent_iblock_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `account_index_iblock_id_offer_id_entity_type` (`account_index`, `iblock_id`, `product_id`, `entity_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;