CREATE TABLE IF NOT EXISTS `stock_formations` (
    `stock_formations_id` INT(11) NOT NULL AUTO_INCREMENT,
    `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `formation_number` INT(11) NOT NULL DEFAULT '1',
    `pallets_cnt` INT(11) NOT NULL DEFAULT '1',
    PRIMARY KEY (`stock_formations_id`),
    INDEX `date_added` (`date_added`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

CREATE TABLE IF NOT EXISTS `stock_formations_orders` (
    `stock_formations_id` INT(11) NOT NULL,
    `orders_id` INT(11) NOT NULL,
    PRIMARY KEY (`stock_formations_id`, `orders_id`)
)
ENGINE=InnoDB
;

ALTER TABLE `log_stock_buttons`
    ADD COLUMN `stock_formations_id` INT NULL AFTER `comment`,
    ADD INDEX `stock_formations_id` (`stock_formations_id`);

ALTER TABLE `products_change_log`
    ADD COLUMN `products_trade_price` DECIMAL(15,2) NULL DEFAULT NULL AFTER `products_old_price`;

CREATE TABLE IF NOT EXISTS `settings_little_alpha` (
    `key` VARCHAR(50) NOT NULL,
    `value` VARCHAR(255) NOT NULL,
    PRIMARY KEY (`key`, `value`)
)
ENGINE=InnoDB
;

INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('orders_limit', '10000');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('table_size_limit', '100');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('db_name', 'gb_lopera_lite');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'xml');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'fias');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'status_history');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'news_access_roles');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'news_access_customers');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'news');
INSERT INTO `settings_little_alpha` (`key`, `value`) VALUES ('skip_table', 'news_search');

DROP TABLE IF EXISTS `categories_mistakes_manage_groups`;
CREATE TABLE `categories_mistakes_manage_groups` (
  `categories_mistakes_manage_groups_id` INT AUTO_INCREMENT PRIMARY KEY,
  `categories_mistakes_manage_groups_name` VARCHAR(100),
  `acl_roles_groups_id` INT

) ENGINE InnoDB CHARACTER SET utf8;

DROP TABLE IF EXISTS `categories_responsible`;
CREATE TABLE `categories_responsible` (
  `categories_responsible_id` INT AUTO_INCREMENT PRIMARY KEY,
  `categories_id` INT,
  `customers_id` INT,

  UNIQUE INDEX `categories_customers` (`categories_id`, `customers_id`)
) ENGINE InnoDB;

INSERT INTO `categories_mistakes_manage_groups` VALUES
  (1, 'Продажи', 6),
  (2, 'Контент', 7),
  (3, 'Фотостудия', 10),
  (4, 'Аналитики', 12),
  (5, 'Копирайтеры ', 8)
;

UPDATE `categories_mistakes_types`
  SET `categories_mistakes_types_manage_group` = 1
  WHERE `categories_mistakes_types_manage_group` = 6;

UPDATE `categories_mistakes_types`
SET `categories_mistakes_types_manage_group` = 2
WHERE `categories_mistakes_types_manage_group` = 7;

UPDATE `categories_mistakes_types`
SET `categories_mistakes_types_manage_group` = 3
WHERE `categories_mistakes_types_manage_group` = 10;

UPDATE `categories_mistakes_types`
SET `categories_mistakes_types_manage_group` = 4
WHERE `categories_mistakes_types_manage_group` = 12;

DROP TABLE IF EXISTS `categories_to_age`;

CREATE TABLE `categories_to_age` (
    `categories_to_age_id` INT(11) NOT NULL AUTO_INCREMENT,
    `categories_id` INT(11) NOT NULL,
    `brands_age_id` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`categories_to_age_id`)
)
ENGINE=InnoDB;


ALTER TABLE `categories_extra`
    ADD COLUMN `categories_comment` TEXT NULL DEFAULT NULL AFTER `photography_links`;

ALTER TABLE `categories_sections_binds`
    ALTER `products_classes_id` DROP DEFAULT,
    ALTER `products_types_id` DROP DEFAULT,
    ALTER `products_tags_id` DROP DEFAULT;
ALTER TABLE `categories_sections_binds`
    CHANGE COLUMN `products_classes_id` `products_classes_id` INT(11) NULL AFTER `sections_id`,
    CHANGE COLUMN `products_types_id` `products_types_id` INT(11) NULL AFTER `products_classes_id`,
    CHANGE COLUMN `products_tags_id` `products_tags_id` INT(11) NULL AFTER `products_types_id`;


ALTER TABLE `categories_sections_binds`
    ADD COLUMN `categories_sections_binds_id` INT(11) NOT NULL AUTO_INCREMENT FIRST,
    ADD PRIMARY KEY (`categories_sections_binds_id`);

INSERT INTO `box_defects` (`box_defects_groups_id`, `name`) VALUES (2, 'Отсутствует Счет-фактура');

CREATE TABLE `suppliers_reports_barcodes` (
  `suppliers_reports_barcodes_id` INT AUTO_INCREMENT PRIMARY KEY,
  `suppliers_report_1c_id` INT,
  `files_id` INT

) ENGINE InnoDB;