1 ALTER TABLE payment_transactions
ADD method_id
INTEGER DEFAULT NULL AFTER id; #
NULL if not initiated
from the site
2 ALTER TABLE payment_transactions CHANGE
timestamp ts_confirmed DATETIME
DEFAULT NULL; #
NULL = not confirmed
3 ALTER TABLE payment_transactions
ADD ts_initiated DATETIME
DEFAULT NULL AFTER ts_confirmed
; #
NULL = not initiated
4 ALTER TABLE payment_transactions CHANGE amount amount_tmp
VARCHAR(15);
5 ALTER TABLE payment_transactions
ADD amount
DECIMAL(9,2) NOT NULL AFTER amount_tmp
; #
only local currency
allowed (EUR
)
6 ALTER TABLE payment_transactions
ADD commission
DECIMAL(9,2) DEFAULT NULL AFTER amount
;
7 ALTER TABLE payment_transactions
ADD status
ENUM('confirmed','pending','canceled') NOT NULL DEFAULT 'pending';
8 ALTER TABLE payment_transactions
ADD recon_id
INTEGER DEFAULT NULL; #
NULL = not reconciliated
9 UPDATE payment_transactions
SET method_id
= 0 WHERE length(id)=7;
10 UPDATE payment_transactions
SET method_id
= 1 WHERE length(id)=15 OR length(id)=17;
11 UPDATE payment_transactions
SET method_id
= 2 WHERE length(id)=14;
12 UPDATE payment_transactions
SET status
= 'confirmed';
13 UPDATE payment_transactions
SET amount
=CONVERT(REPLACE(REPLACE(amount_tmp
," EUR",""),",","."),DECIMAL(9,2));
14 ALTER TABLE payment_transactions
ADD KEY method_id (method_id
);
15 ALTER TABLE payment_transactions
ADD KEY ref (ref);
16 #
ALTER TABLE payment_transactions
ADD UNIQUE KEY fullref (fullref
);
18 #
select t1.
* from payment_transactions
as t1
join payment_transactions
as t2
using(fullref
) group by(t1.
id) having count(*)!=1 order by fullref
;
19 ALTER TABLE payment_transactions
DROP amount_tmp
;
21 ALTER TABLE payment_transactions
ADD COLUMN display BOOL
NOT NULL DEFAULT FALSE;
22 ALTER TABLE payments
MODIFY COLUMN flags
SET('unique', 'old', 'donation') NOT NULL DEFAULT '';
24 -- vim:set syntax=mysql: