cmQWS0Q4

1
2
3INSERT IGNORE INTO entities_groups (`entities_groups_title`, `entities_groups_description`) VALUES ('Статусы', 'Статусы');
4SELECT @entities_groups_id := eg.entities_groups_id FROM entities_groups AS eg WHERE entities_groups_title = 'Статусы';
5
6INSERT IGNORE INTO entities (`entities_groups_id`, `entities_title`, `entities_name`, `entities_description`) VALUES (@entities_groups_id, 'Статусы', 'statuses', 'Таблицы со статусами разных сущностей');
7
8
9SELECT @entities_id := e.entities_id FROM entities AS e WHERE e.entities_name = 'statuses';
10
11INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Универсальные статусы', 'statuses');
12INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Статусы акций', 'categories_status');
13INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Статусы пользователей', 'customers_status');
14INSERT IGNORE INTO entities_types (`entities_id`, `entities_types_title`, `entities_types_name`) VALUES (@entities_id, 'Статусы заказов', 'orders_status');
15
16
17CREATE TABLE IF NOT EXISTS statuses_groups (
18	`statuses_groups_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
19	`entities_types_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Таблица статусов',
20	`statuses_groups_name` VARCHAR(100) NOT NULL DEFAULT '',
21	`statuses_groups_title` VARCHAR(100) NOT NULL DEFAULT '',
22	PRIMARY KEY (`statuses_groups_id`),
23	UNIQUE INDEX `statuses_groups_name` (`statuses_groups_name`)
24)
25COMMENT='Произвольные группы статусов, которые используются в statuses_to_statuses_groups'
26COLLATE='utf8_general_ci'
27;
28
29CREATE TABLE IF NOT EXISTS `statuses_to_statuses_groups` (
30	`statuses_to_statuses_groups_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
31	`statuses_groups_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
32	`statuses_id` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
33	PRIMARY KEY (`statuses_to_statuses_groups_id`),
34	INDEX `statuses_groups_id` (`statuses_groups_id`)
35)
36COLLATE='utf8_general_ci'
37;
38
39SELECT @entities_types_id := et.entities_types_id FROM entities_types AS et WHERE et.entities_types_name = 'statuses';
40
41
42INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'digital_documents_update_gtd', 'Статусы документа ЭДО в которых обновляем ГТД');
43INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'digital_documents_update_price', 'Статусы документа ЭДО в которых обновляем цены, НДС');
44INSERT IGNORE INTO statuses_groups (`entities_types_id`, `statuses_groups_name`, `statuses_groups_title`) VALUES (@entities_types_id, 'digital_documents_recalculate', 'Статусы документа ЭДО в которых пересчитываем недостачи');