1 CREATE TABLE payment_codeC
3 INSERT INTO payment_codeC
7 CREATE TABLE payment_codeRCB
9 INSERT INTO payment_codeRCB
11 FROM paiement.codeRCB
;
13 CREATE TABLE payment_methods
14 LIKE paiement.methodes
;
15 INSERT INTO payment_methods
17 FROM paiement.methodes
;
20 LIKE paiement.paiements
;
23 FROM paiement.paiements
;
25 CREATE TABLE payment_transactions
26 LIKE paiement.transactions
;
27 INSERT INTO payment_transactions
29 FROM paiement.transactions
;
31 # Conform
to naming convention
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;
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;