# su postgres

# psql gnuherds

= ALTER TABLE R1_Donations2JobOffersJoins RENAME TO D1_Donations2JobOffers;

= ALTER TABLE D1_Donations2JobOffers ADD COLUMN D1_DonationMagic varchar(512);

= ALTER TABLE D1_Donations2JobOffers ALTER COLUMN D1_DonationMagic SET DEFAULT NULL;

= ALTER TABLE D1_Donations2JobOffers ADD COLUMN D1_DonationMagicExpire timestamp;

= UPDATE D1_Donations2JobOffers set D1_DonationMagicExpire='now';

= ALTER TABLE D1_Donations2JobOffers ALTER COLUMN D1_DonationMagicExpire SET NOT NULL;

= ALTER TABLE D1_Donations2JobOffers ALTER COLUMN D1_DonationMagicExpire SET DEFAULT 'now';