· 7 years ago · Nov 16, 2018, 12:52 PM
1DROP TABLE IF EXISTS delivery_points_types;
2CREATE TABLE `delivery_points_types` (
3 `delivery_points_types_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
4 `delivery_points_types_name` VARCHAR(255) NOT NULL DEFAULT '',
5 PRIMARY KEY (`delivery_points_types_id`)
6)
7COLLATE='utf8_general_ci'
8ENGINE=InnoDB
9;
10INSERT INTO `delivery_points_types` VALUES (1, 'ПоÑтамат'),(2, 'Пункт выдачи заказов');
11
12DROP TABLE IF EXISTS delivery_points_payments_types;
13CREATE TABLE `delivery_points_payments_types` (
14 `delivery_points_payments_types_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
15 `delivery_points_payments_types_name` VARCHAR(255) NOT NULL DEFAULT '',
16 PRIMARY KEY (`delivery_points_payments_types_id`)
17)
18COLLATE='utf8_general_ci'
19ENGINE=InnoDB
20;
21INSERT INTO `delivery_points_payments_types` VALUES (1, 'Ðаличными через каÑÑу'),(2, 'Ðаличными или банковÑкими картами через каÑÑу'), (3, 'Через терминал банка');
22
23DROP TABLE IF EXISTS delivery_points;
24CREATE TABLE `delivery_points` (
25 `delivery_points_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
26 `delivery_types_id` INT(10) NOT NULL COMMENT 'СÑылка на ÑпоÑоб доÑтавки',
27 `delivery_points_number` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Ðомер точки доÑтавки в ÑиÑтеме ТК',
28 `delivery_points_types_id` INT(10) NOT NULL COMMENT 'Тип точки доÑтавки',
29 `delivery_points_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Ðаименование точки доÑтавки',
30 `delivery_points_description` TEXT NOT NULL DEFAULT '' COMMENT 'ОпиÑание точки доÑтавки',
31 `delivery_points_address` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'ÐÐ´Ñ€ÐµÑ Ñ‚Ð¾Ñ‡ÐºÐ¸ доÑтавки',
32 `delivery_points_city_code` VARCHAR(255) NOT NULL DEFAULT '0' COMMENT 'Код города в ÑиÑтеме ТК',
33 `delivery_points_latitude` DECIMAL(11,8) NULL DEFAULT NULL COMMENT 'Широта',
34 `delivery_points_longitude` DECIMAL(11,8) NULL DEFAULT NULL COMMENT 'Долгота',
35 `delivery_points_payments_types_id` INT(10) NOT NULL COMMENT 'СÑылка на доÑтупный тип оплаты',
36 `delivery_points_schedule` VARCHAR(500) NOT NULL DEFAULT '' COMMENT 'График работы',
37 `delivery_points_additional_info` TEXT NOT NULL DEFAULT '' COMMENT 'Ð”Ð¾Ð¿Ð¾Ð»Ð½Ð¸Ñ‚ÐµÐ»ÑŒÐ½Ð°Ñ Ð¸Ð½Ñ„Ð¾Ñ€Ð¼Ð°Ñ†Ð¸Ñ, ÑÐ¿ÐµÑ†Ð¸Ñ„Ð¸Ñ‡Ð½Ð°Ñ Ð´Ð»Ñ ÑпоÑоба доÑтавки',
38 `is_active` TINYINT(1) NOT NULL DEFAULT '1' COMMENT 'Флаг активноÑти точки',
39 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
40 `date_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 PRIMARY KEY (`delivery_points_id`),
42 UNIQUE INDEX `delivery_types_id_delivery_points_number_idx` (`delivery_types_id`, `delivery_points_number`),
43 INDEX `delivery_types_id_delivery_points_city_code_idx` (`delivery_types_id`, `delivery_points_city_code`),
44 INDEX `delivery_points_payments_types_id_idx` (delivery_points_payments_types_id),
45 INDEX `delivery_points_types_id_idx` (delivery_points_types_id),
46 INDEX `is_active_idx` (is_active)
47)
48COLLATE='utf8_general_ci'
49ENGINE=InnoDB
50;