1 UPDATE payments
SET rib_id
= NULL;
2 UPDATE payment_transfers
SET account_id
= NULL;
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;
10 -- vim=set syntax=mysql