CMS-CSE/maj/sql/maj.sql

ALTER TABLE `banque_comptes` 
ADD `icon` TINYTEXT NULL AFTER `solde_date`,
ADD `import` TINYTEXT NULL AFTER `icon`;

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; 

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;