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 |