upgrade/account/07_payment.sql

   1 CREATE TABLE  payment_codeC
   2         LIKE  paiement.codeC;
   3  INSERT INTO  payment_codeC
   4       SELECT  *
   5         FROM  paiement.codeC;
   6
   7 CREATE TABLE  payment_codeRCB
   8         LIKE  paiement.codeRCB;
   9  INSERT INTO  payment_codeRCB
  10       SELECT  *
  11         FROM  paiement.codeRCB;
  12
  13 CREATE TABLE  payment_methods
  14         LIKE  paiement.methodes;
  15  INSERT INTO  payment_methods
  16       SELECT  *
  17         FROM  paiement.methodes;
  18
  19 CREATE TABLE  payments
  20         LIKE  paiement.paiements;
  21  INSERT INTO  payments
  22       SELECT  *
  23         FROM  paiement.paiements;
  24
  25 CREATE TABLE  payment_transactions
  26         LIKE  paiement.transactions;
  27  INSERT INTO  payment_transactions
  28       SELECT  *
  29         FROM  paiement.transactions;
  30
  31 # Conform to naming convention
  32   ALTER TABLE  payments
  33 CHANGE COLUMN  montant_def amount_def DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  34 CHANGE COLUMN  montant_min amount_min DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  35 CHANGE COLUMN  montant_max amount_max DECIMAL(10,2) NOT NULL DEFAULT 0.00;
  36
  37   ALTER TABLE  payment_transactions
  38 CHANGE COLUMN  montant amount VARCHAR(15) NOT NULL DEFAULT '0.00',
  39 CHANGE COLUMN  cle pkey VARCHAR(5) NOT NULL;
  40
  41 # vim:set ft=mysql: