INSERT IGNORE INTO entities_groups (`entities_groups_title`, `entities_groups_description`) VALUES ('Статусы', 'Статусы');
SELECT @entities_groups_id := eg.entities_groups_id FROM entities_groups AS eg WHERE entities_groups_title = 'Статусы';

INSERT IGNORE INTO entities (`entities_groups_id`, `entities_title`, `entities_name`, `entities_description`) VALUES (@entities_groups_id, 'Статусы', 'statuses', 'Таблицы со статусами разных сущностей');


SELECT @entities_id := e.entities_id FROM entities AS e WHERE e.entities_name = 'statuses';

INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Универсальные статусы', 'statuses');
INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Статусы акций', 'categories_status');
INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Статусы пользователей', 'customers_status');
INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Статусы заказов', 'orders_status');


CREATE TABLE IF NOT EXISTS `statuses_groups_sets` (
    `statuses_groups_sets_id` INT(11) NOT NULL AUTO_INCREMENT,
    `statuses_groups_sets_name` VARCHAR(100) NOT NULL,
    `statuses_groups_sets_title` VARCHAR(250) NOT NULL,
    PRIMARY KEY (`statuses_groups_sets_id`),
    UNIQUE INDEX `statuses_groups_sets_name` (`statuses_groups_sets_name`)
)
COMMENT='Произвольные наборы групп статусов для объединения групп'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

CREATE TABLE IF NOT EXISTS `statuses_groups` (
    `statuses_groups_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `entities_types_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Таблица статусов',
    `statuses_groups_name` VARCHAR(100) NOT NULL DEFAULT '',
    `statuses_groups_title` VARCHAR(100) NOT NULL DEFAULT '',
    `statuses_groups_sets_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Набор групп статусов',
    PRIMARY KEY (`statuses_groups_id`),
    UNIQUE INDEX `statuses_groups_name` (`statuses_groups_name`)
)
COMMENT='Произвольные группы статусов, которые используются в statuses_to_statuses_groups'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;


CREATE TABLE IF NOT EXISTS  `statuses_to_statuses_groups` (
    `statuses_to_statuses_groups_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `statuses_groups_id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `statuses_id` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (`statuses_to_statuses_groups_id`),
    UNIQUE INDEX `statuses_groups_id_statuses_id` (`statuses_groups_id`, `statuses_id`),
    INDEX `statuses_groups_id` (`statuses_groups_id`)
)
COMMENT='Содержимое произвольной группы статусов'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;


SELECT @entities_types_id := et.entities_types_id FROM entities_types AS et WHERE et.entities_types_name = 'statuses';

INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'suppliers_statuses_all', 'Все статусы поставщика');
INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'suppliers_contracts_statuses_all', 'Все статусы договоров поставщика');

INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'digital_documents_update_gtd', 'Статусы документа ЭДО в которых обновляем ГТД');
INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'digital_documents_update_price', 'Статусы документа ЭДО в которых обновляем цены, НДС');
INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'digital_documents_recalculate', 'Статусы документа ЭДО в которых пересчитываем недостачи');

INSERT IGNORE INTO statuses_to_statuses_groups (`statuses_groups_id`, `statuses_id`)
SELECT DISTINCT
    sg.statuses_groups_id
    , s.suppliers_status
FROM suppliers AS s
    JOIN statuses_groups AS sg ON sg.statuses_groups_name = 'suppliers_statuses_all';


INSERT IGNORE INTO statuses_to_statuses_groups (`statuses_groups_id`, `statuses_id`)
SELECT DISTINCT
    sg.statuses_groups_id
    , s.suppliers_contracts_status
FROM suppliers_contracts AS s
    JOIN statuses_groups AS sg ON sg.statuses_groups_name = 'suppliers_contracts_statuses_all';