X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F13_payments.sql;h=0196b9a571fa4c1711bd99f3aaec1a78b51bfc27;hb=47712f77e9718652c516c85cde99a58d142f67c9;hp=6252fbd4f40aa9d1f3b966f43588ed9dd222e5eb;hpb=cecdf74795e71ed038411915dad5e0dff6ea51fa;p=platal.git

diff --git a/upgrade/1.0.1/13_payments.sql b/upgrade/1.0.1/13_payments.sql
index 6252fbd..0196b9a 100644
--- a/upgrade/1.0.1/13_payments.sql
+++ b/upgrade/1.0.1/13_payments.sql
@@ -55,26 +55,6 @@ CREATE TABLE payment_reconcilations (
   comments text NOT NULL
 ) ENGINE=InnoDB, CHARSET=utf8;
 
-ALTER TABLE payment_transactions ADD method_id INTEGER DEFAULT NULL AFTER id; # NULL if not initiated from the site
-ALTER TABLE payment_transactions CHANGE timestamp ts_confirmed DATETIME DEFAULT NULL; # NULL = not confirmed
-ALTER TABLE payment_transactions ADD ts_initiated DATETIME DEFAULT NULL AFTER ts_confirmed; # NULL = not initiated
-ALTER TABLE payment_transactions CHANGE amount amount_tmp VARCHAR(15);
-ALTER TABLE payment_transactions ADD amount DECIMAL(9,2) NOT NULL AFTER amount_tmp; # only local currency allowed (EUR)
-ALTER TABLE payment_transactions ADD commission DECIMAL(9,2) DEFAULT NULL AFTER amount;
-ALTER TABLE payment_transactions ADD status ENUM('confirmed','pending','canceled') NOT NULL DEFAULT 'pending';
-ALTER TABLE payment_transactions ADD recon_id INTEGER DEFAULT NULL; # NULL = not reconciliated
-UPDATE payment_transactions SET method_id = 0 WHERE length(id)=7;
-UPDATE payment_transactions SET method_id = 1 WHERE length(id)=15 OR length(id)=17;
-UPDATE payment_transactions SET method_id = 2 WHERE length(id)=14;
-UPDATE payment_transactions SET status = 'confirmed';
-UPDATE payment_transactions SET amount=CONVERT(REPLACE(REPLACE(amount_tmp," EUR",""),",","."),DECIMAL(9,2));
-ALTER TABLE payment_transactions ADD KEY method_id (method_id);
-ALTER TABLE payment_transactions ADD KEY ref (ref);
-# ALTER TABLE payment_transactions ADD UNIQUE KEY fullref (fullref);
-#fullref dupliqués :
-#select t1.* from payment_transactions as t1 join payment_transactions as t2 using(fullref) group by(t1.id) having count(*)!=1 order by fullref;
-ALTER TABLE payment_transactions DROP amount_tmp;
-
 DROP TABLE IF EXISTS payment_transfers;
 CREATE TABLE payment_transfers (
   id INTEGER PRIMARY KEY auto_increment,