[platal.git] / upgrade / 1.1.8 / 01_clean_bankaccounts.sql

UPDATE payments SET rib_id = NULL;
UPDATE payment_transfers SET account_id = NULL;
DELETE FROM payment_bankaccounts;
ALTER TABLE payment_bankaccounts CHANGE account iban varchar(33) NOT NULL DEFAULT 'FRkk BBBB BGGG GGCC CCCC CCCC CKK';
ALTER TABLE payment_bankaccounts ADD COLUMN bic varchar(11) NOT NULL DEFAULT 'XXXXXXXXXXX' AFTER iban;
INSERT INTO payment_bankaccounts (id, asso_id, iban, bic, owner, status) VALUES (1, 53, DEFAULT, DEFAULT, 'RIB inconnu', 'new');
UPDATE payments SET rib_id = 1;
ALTER TABLE payments CHANGE rib_id rib_id int(11) NOT NULL DEFAULT 1;

-- vim=set syntax=mysql
Commit	Line	Data
38813e10	1	UPDATE payments SET rib_id = NULL;
243dc7a0	2	UPDATE payment_transfers SET account_id = NULL;
38813e10 AL	3	DELETE FROM payment_bankaccounts;
	4	ALTER TABLE payment_bankaccounts CHANGE account iban varchar(33) NOT NULL DEFAULT 'FRkk BBBB BGGG GGCC CCCC CCCC CKK';
	5	ALTER TABLE payment_bankaccounts ADD COLUMN bic varchar(11) NOT NULL DEFAULT 'XXXXXXXXXXX' AFTER iban;
	6	INSERT INTO payment_bankaccounts (id, asso_id, iban, bic, owner, status) VALUES (1, 53, DEFAULT, DEFAULT, 'RIB inconnu', 'new');
	7	UPDATE payments SET rib_id = 1;
	8	ALTER TABLE payments CHANGE rib_id rib_id int(11) NOT NULL DEFAULT 1;
	9
	10	-- vim=set syntax=mysql