Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE `special_marks`
- CHANGE COLUMN `button_class` `button_class` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Класс кнопки' AFTER `is_user_can_remove`;
- INSERT IGNORE INTO `special_marks` (`special_marks_title`, `button_class`, `icon_class`) VALUES
- ('Ожидает раскладки', 'sm-waiting-for-spreading', ''),
- ('Раскладка', 'sm-spreading', ''),
- ('Долгая раскладка', 'sm-long-spreading', ''),
- ('Раскладка завершена', 'sm-spreading-complete', '')
- ;
- DROP TABLE IF EXISTS `incomes_to_special_marks`;
- CREATE TABLE `incomes_to_special_marks` (
- `incomes_to_special_marks_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- `entities_id` INT(10) UNSIGNED NOT NULL DEFAULT '41' COMMENT 'Сущность, к которой привязываются метки',
- `object_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'К чему именно привязываются метки',
- `special_marks_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Метка',
- PRIMARY KEY (`incomes_to_special_marks_id`),
- UNIQUE INDEX `object_id_special_marks_id` (`object_id`, `entities_id`, `special_marks_id`)
- )
- COMMENT='Привязка поставок к специальным меткам'
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement