Git Repository Public Repository

namibia

URLs

Copy to Clipboard
 
feef9ce7f4863195874b73ad2e0c8374d53ec4e6
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
ALTER TABLE app_config CHANGE vat_percentage vat_percentage NUMERIC(5, 2) NOT NULL, CHANGE app_version app_version NUMERIC(5, 2) NOT NULL;
CREATE UNIQUE INDEX UNIQ_92EA9B0CE7927C74 ON regional_manager (email);
ALTER TABLE auction CHANGE bid_price bid_price NUMERIC(11, 2) NOT NULL, CHANGE reserve_price reserve_price NUMERIC(11, 2) NOT NULL, CHANGE bid_increment bid_increment NUMERIC(11, 2) NOT NULL;
ALTER TABLE auction_autobid CHANGE amount amount NUMERIC(11, 2) NOT NULL;
ALTER TABLE auction_bid CHANGE amount amount NUMERIC(11, 2) NOT NULL;
ALTER TABLE auction_increment CHANGE amount amount NUMERIC(11, 2) NOT NULL;
ALTER TABLE company_device_registration ADD CONSTRAINT FK_4BB0D48CCCFA12B8 FOREIGN KEY (profile_id) REFERENCES profile (id);
ALTER TABLE profile_permissions_override ADD stock_bulk_import_drive TINYINT(1) NOT NULL, ADD stock_bulk_import_pinnacle TINYINT(1) NOT NULL;
ALTER TABLE profile_permissions ADD stock_bulk_import_drive TINYINT(1) NOT NULL, ADD stock_bulk_import_pinnacle TINYINT(1) NOT NULL;
ALTER TABLE vehicle_pricing_history CHANGE trade trade NUMERIC(11, 2) NOT NULL, CHANGE total_recon total_recon NUMERIC(11, 2) NOT NULL, CHANGE priceg_offer priceg_offer NUMERIC(11, 2) NOT NULL, CHANGE auction_winbid auction_winbid NUMERIC(11, 2) NOT NULL, CHANGE list_price list_price NUMERIC(11, 2) NOT NULL;
ALTER TABLE stock CHANGE trade_price trade_price NUMERIC(11, 2) NOT NULL, CHANGE retail_price retail_price NUMERIC(11, 2) NOT NULL, CHANGE retail_amount_required retail_amount_required NUMERIC(11, 2) NOT NULL, CHANGE purchase_price purchase_price NUMERIC(11, 2) NOT NULL, CHANGE sale_price sale_price NUMERIC(11, 2) NOT NULL, CHANGE damage_total damage_total NUMERIC(11, 2) NOT NULL, CHANGE highest_offer highest_offer NUMERIC(11, 2) NOT NULL, CHANGE highest_bid highest_bid NUMERIC(11, 2) NOT NULL, CHANGE old_trade_price old_trade_price NUMERIC(11, 2) NOT NULL, CHANGE old_retail_price old_retail_price NUMERIC(11, 2) NOT NULL, CHANGE list_price list_price NUMERIC(11, 2) NOT NULL, CHANGE old_list_price old_list_price NUMERIC(11, 2) NOT NULL;
ALTER TABLE stock_damages CHANGE amount amount NUMERIC(11, 2) NOT NULL;
ALTER TABLE stock_valuation CHANGE required_price required_price NUMERIC(11, 2) DEFAULT NULL, CHANGE amount_offered amount_offered NUMERIC(11, 2) NOT NULL, CHANGE over_allowance over_allowance NUMERIC(11, 2) NOT NULL, CHANGE stand_in_value stand_in_value NUMERIC(11, 2) NOT NULL, CHANGE projected_retail projected_retail NUMERIC(11, 2) NOT NULL, CHANGE planned_margin planned_margin NUMERIC(11, 2) NOT NULL, CHANGE bank_settlement_amount bank_settlement_amount NUMERIC(11, 2) NOT NULL;
ALTER TABLE price_guide_offer CHANGE amount amount NUMERIC(11, 2) NOT NULL;
ALTER TABLE adherence_stock ADD CONSTRAINT FK_AF612E80B2840ED6 FOREIGN KEY (adherence_id) REFERENCES adherence (id);

Commits for namibia/data/old_b4c stuff/update-schema.sql

Diff revisions: vs.
Revision Author Commited Message
df0489 ... Mark Fri 14 Oct, 2016 10:01:00 +0000

initial commit