CMS-CSE/maj/sql/maj.sql

ALTER TABLE `banque_comptes` ADD `icon` TINYTEXT NULL AFTER `solde_date`; 
UPDATE `banque_comptes` SET `icon` = 'courant' WHERE `banque_comptes`.`id` = 1; 
UPDATE `banque_comptes` SET `icon` = 'courant' WHERE `banque_comptes`.`id` = 2; 
UPDATE `banque_comptes` SET `icon` = 'epargne' WHERE `banque_comptes`.`id` = 3; 
UPDATE `banque_comptes` SET `icon` = 'epargne' WHERE `banque_comptes`.`id` = 4; 

ALTER TABLE `banque_comptes` ADD `import` TINYTEXT NULL AFTER `icon`; 
UPDATE `banque_comptes` SET `import` = 'csv' WHERE `banque_comptes`.`id` = 1; 
UPDATE `banque_comptes` SET `import` = 'csv' WHERE `banque_comptes`.`id` = 2; 
UPDATE `banque_comptes` SET `import` = 'csv' WHERE `banque_comptes`.`id` = 3; 
UPDATE `banque_comptes` SET `import` = 'manuel' WHERE `banque_comptes`.`id` = 4;