ymtFDWR6

1ALTER TABLE `payments_requests`
2    ADD COLUMN `contractors_id` INT(10) UNSIGNED NOT NULL DEFAULT '265' AFTER `type_id`;
3
4ALTER TABLE `customers_cards`
5    ADD COLUMN `contractors_id` INT(10) UNSIGNED NOT NULL DEFAULT '265' AFTER `customers_cards_bank`,
6    MODIFY COLUMN payment_systems_id INT(10) UNSIGNED NOT NULL DEFAULT '32';
7
8
9# новое поле из задачи http://redmine.m/issues/48668
10UPDATE customers_cards as cc SET cc.payment_systems_id = 32;
11
12
13DROP TABLE IF EXISTS `payment_systems_to_groups`;
14CREATE TABLE IF NOT EXISTS `payment_systems_to_groups` (
15                                                           `payment_systems_id` int(11) NOT NULL,
16                                                           `payment_system_groups_id` int(10) unsigned NOT NULL,
17                                                           `payment_systems_order` int(10) unsigned NOT NULL DEFAULT 1,
18                                                           UNIQUE KEY `payment_systems_id_payment_system_group_id` (`payment_system_groups_id`,`payment_systems_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21
22INSERT INTO `payment_systems_to_groups` (`payment_systems_id`, `payment_system_groups_id`, `payment_systems_order`) VALUES
23(-1, 1, 1),
24(32, 1, 2),
25(-1, 2, 1),
26(32, 2, 2),
27(-1, 3, 1),
28(32, 3, 2),
29(-1, 4, 1),
30(32, 4, 2);
31
32ALTER TABLE `payment_systems`
33    CHANGE COLUMN `payment_systems_id` `payment_systems_id` INT(10) NOT NULL DEFAULT 0 FIRST,
34    CHANGE COLUMN `payment_systems_company` `payment_systems_company` ENUM('chronopay','yandex','moneta','mamsy') NOT NULL DEFAULT 'chronopay' AFTER `payment_systems_active`;
35
36
37INSERT INTO `payment_systems` (`payment_systems_id`, `payment_systems_title`, `payment_systems_short_name`, `payment_systems_active`, `payment_systems_company`) VALUES
38(-1, 'Наличными при доставке', 'cash', 1, 'mamsy'),
39(97, 'Null', 'null', 0, 'mamsy'),
40(98, 'Баланс', 'balance', 1, 'mamsy'),
41(99, 'Накладные', 'invoice', 1, 'mamsy');