Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS delivery_points_types;
- CREATE TABLE `delivery_points_types` (
- `delivery_points_types_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `delivery_points_types_name` VARCHAR(255) NOT NULL DEFAULT '',
- PRIMARY KEY (`delivery_points_types_id`)
- )
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB
- ;
- INSERT INTO `delivery_points_types` VALUES (1, 'Постамат'),(2, 'Пункт выдачи заказов');
- DROP TABLE IF EXISTS delivery_points_payments_types;
- CREATE TABLE `delivery_points_payments_types` (
- `delivery_points_payments_types_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `delivery_points_payments_types_name` VARCHAR(255) NOT NULL DEFAULT '',
- PRIMARY KEY (`delivery_points_payments_types_id`)
- )
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB
- ;
- INSERT INTO `delivery_points_payments_types` VALUES (1, 'Наличными через кассу'),(2, 'Наличными или банковскими картами через кассу'), (3, 'Через терминал банка');
- DROP TABLE IF EXISTS delivery_points;
- CREATE TABLE `delivery_points` (
- `delivery_points_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `delivery_types_id` INT(10) NOT NULL COMMENT 'Ссылка на способ доставки',
- `delivery_points_number` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Номер точки доставки в системе ТК',
- `delivery_points_types_id` INT(10) NOT NULL COMMENT 'Тип точки доставки',
- `delivery_points_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Наименование точки доставки',
- `delivery_points_description` TEXT NOT NULL DEFAULT '' COMMENT 'Описание точки доставки',
- `delivery_points_address` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Адрес точки доставки',
- `delivery_points_city_code` VARCHAR(255) NOT NULL DEFAULT '0' COMMENT 'Код города в системе ТК',
- `delivery_points_latitude` DECIMAL(11,8) NULL DEFAULT NULL COMMENT 'Широта',
- `delivery_points_longitude` DECIMAL(11,8) NULL DEFAULT NULL COMMENT 'Долгота',
- `delivery_points_payments_types_id` INT(10) NOT NULL COMMENT 'Ссылка на доступный тип оплаты',
- `delivery_points_schedule` VARCHAR(500) NOT NULL DEFAULT '' COMMENT 'График работы',
- `delivery_points_additional_info` TEXT NOT NULL DEFAULT '' COMMENT 'Дополнительная информация, специфичная для способа доставки',
- `is_active` TINYINT(1) NOT NULL DEFAULT '1' COMMENT 'Флаг активности точки',
- `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `date_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`delivery_points_id`),
- UNIQUE INDEX `delivery_types_id_delivery_points_number_idx` (`delivery_types_id`, `delivery_points_number`),
- INDEX `delivery_types_id_delivery_points_city_code_idx` (`delivery_types_id`, `delivery_points_city_code`),
- INDEX `delivery_points_payments_types_id_idx` (delivery_points_payments_types_id),
- INDEX `delivery_points_types_id_idx` (delivery_points_types_id),
- INDEX `is_active_idx` (is_active)
- )
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement