MetaBrainz Donation Records

schema_change.sql

BEGIN;

-- Changes to donation table from the old website to new one.
-- See http://git.io/vfhUF (old) and http://git.io/vfhTZ (new).

ALTER TABLE donation ALTER COLUMN moderator DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN contact DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN anon DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN address_street DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN address_city DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN address_state DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN address_postcode DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN address_country DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN payment_date DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN paypal_trans_id DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN memo DROP DEFAULT;
ALTER TABLE donation ALTER COLUMN fee DROP NOT NULL;

ALTER TABLE donation ADD COLUMN payment_method payment_method_types;
-- Assuming `paypal_trans_id` was set only for PayPal donations in the old version.
UPDATE donation
SET payment_method = 'paypal'
WHERE paypal_trans_id IS NOT NULL AND paypal_trans_id <> '';

ALTER TABLE donation ALTER COLUMN paypal_trans_id TYPE CHARACTER VARYING;
ALTER TABLE donation RENAME COLUMN paypal_trans_id TO transaction_id;

ALTER TABLE donation RENAME COLUMN moderator TO editor_name;
ALTER TABLE donation RENAME COLUMN contact TO can_contact;
ALTER TABLE donation RENAME COLUMN anon TO anonymous;

END;

Might want to set payment_method to paypal where paypal_trans_id (now transaction_id) was defined.

Okay, I added that payment_method bit. Script needs to be checked though. I didn't try to run it on the old table.