upgrade/1.1.8/01_clean_bankaccounts.sql

   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;
   9
  10 -- vim=set syntax=mysql