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 (
    `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 '',
    PRIMARY KEY (`statuses_groups_id`),
    UNIQUE INDEX `statuses_groups_name` (`statuses_groups_name`)
)
COMMENT='Произвольные группы статусов, которые используются в statuses_to_statuses_groups'
COLLATE='utf8_general_ci'
;

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`),
    INDEX `statuses_groups_id` (`statuses_groups_id`)
)
COLLATE='utf8_general_ci'
;

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, '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', 'Статусы документа ЭДО в которых пересчитываем недостачи');