Advertisement
Guest User

Untitled

a guest
Feb 20th, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.30 KB | None | 0 0
  1. ALTER TABLE `special_marks`
  2.   CHANGE COLUMN `button_class` `button_class` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Класс кнопки' AFTER `is_user_can_remove`;
  3.  
  4. INSERT IGNORE INTO `special_marks` (`special_marks_title`, `button_class`, `icon_class`) VALUES
  5.   ('Ожидает раскладки', 'sm-waiting-for-spreading', ''),
  6.   ('Раскладка', 'sm-spreading', ''),
  7.   ('Долгая раскладка', 'sm-long-spreading', ''),
  8.   ('Раскладка завершена', 'sm-spreading-complete', '')
  9. ;
  10.  
  11. DROP TABLE IF EXISTS `incomes_to_special_marks`;
  12. CREATE TABLE `incomes_to_special_marks` (
  13.   `incomes_to_special_marks_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  14.   `entities_id` INT(10) UNSIGNED NOT NULL DEFAULT '41' COMMENT 'Сущность, к которой привязываются метки',
  15.   `object_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'К чему именно привязываются метки',
  16.   `special_marks_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Метка',
  17.   PRIMARY KEY (`incomes_to_special_marks_id`),
  18.   UNIQUE INDEX `object_id_special_marks_id` (`object_id`, `entities_id`, `special_marks_id`)
  19. )
  20.   COMMENT='Привязка поставок к специальным меткам'
  21.   COLLATE='utf8_general_ci'
  22.   ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement