chezbetty/migrations/migration_1.4.1-1.5.0.sql from um-cseg/chez-betty

chezbetty/migrations/migration_1.4.1-1.5.0.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

ALTER TABLE items ADD COLUMN sales_tax BOOLEAN NOT NULL default FALSE;
ALTER TABLE items ADD COLUMN bottle_dep BOOLEAN NOT NULL default FALSE;
ALTER TABLE boxes ADD COLUMN sales_tax BOOLEAN NOT NULL default FALSE;
ALTER TABLE boxes ADD COLUMN bottle_dep BOOLEAN NOT NULL default FALSE;
ALTER TABLE items_history ADD COLUMN sales_tax BOOLEAN NOT NULL default FALSE;
ALTER TABLE items_history ADD COLUMN bottle_dep BOOLEAN NOT NULL default FALSE;

ALTER TYPE transaction_type ADD VALUE 'cashdeposit';
UPDATE transactions set type='cashdeposit' where type='deposit';

ALTER TABLE announcements ADD COLUMN deleted BOOLEAN NOT NULL default FALSE;
ALTER TABLE requests ADD COLUMN deleted BOOLEAN NOT NULL default FALSE;

ALTER TYPE account_type ADD VALUE 'pool';