2
0

maj.sql 399 B

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