ALTER TABLE `payments_requests`
    ADD COLUMN `contractors_id` INT(10) UNSIGNED NOT NULL DEFAULT '265' AFTER `type_id`;

ALTER TABLE `customers_cards`
    ADD COLUMN `contractors_id` INT(10) UNSIGNED NOT NULL DEFAULT '265' AFTER `customers_cards_bank`,
    MODIFY COLUMN payment_systems_id INT(10) UNSIGNED NOT NULL DEFAULT '32';


# новое поле из задачи http://redmine.m/issues/48668
UPDATE customers_cards as cc SET cc.payment_systems_id = 32;


DROP TABLE IF EXISTS `payment_systems_to_groups`;
CREATE TABLE IF NOT EXISTS `payment_systems_to_groups` (
                                                           `payment_systems_id` int(11) NOT NULL,
                                                           `payment_system_groups_id` int(10) unsigned NOT NULL,
                                                           `payment_systems_order` int(10) unsigned NOT NULL DEFAULT 1,
                                                           UNIQUE KEY `payment_systems_id_payment_system_group_id` (`payment_system_groups_id`,`payment_systems_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `payment_systems_to_groups` (`payment_systems_id`, `payment_system_groups_id`, `payment_systems_order`) VALUES
(-1, 1, 1),
(32, 1, 2),
(-1, 2, 1),
(32, 2, 2),
(-1, 3, 1),
(32, 3, 2),
(-1, 4, 1),
(32, 4, 2);

ALTER TABLE `payment_systems`
    CHANGE COLUMN `payment_systems_id` `payment_systems_id` INT(10) NOT NULL DEFAULT 0 FIRST,
    CHANGE COLUMN `payment_systems_company` `payment_systems_company` ENUM('chronopay','yandex','moneta','mamsy') NOT NULL DEFAULT 'chronopay' AFTER `payment_systems_active`;


INSERT INTO `payment_systems` (`payment_systems_id`, `payment_systems_title`, `payment_systems_short_name`, `payment_systems_active`, `payment_systems_company`) VALUES
(-1, 'Наличными при доставке', 'cash', 1, 'mamsy'),
(97, 'Null', 'null', 0, 'mamsy'),
(98, 'Баланс', 'balance', 1, 'mamsy'),
(99, 'Накладные', 'invoice', 1, 'mamsy');