ok

Sql code posted
created at 15 Mar 22:52

Edit | Back 
1
2
3
4
5
6
7
8
9
10
 
ALTER TABLE bidding_rules ADD campaign_id BIGINT;
ALTER TABLE bidding_rules ADD ad_positions INTEGER NOT NULL DEFAULT 0;
ALTER TABLE bidding_rules ALTER ad_positions DROP DEFAULT;
ALTER TABLE bidding_rules_log ADD campaign_id BIGINT;
ALTER TABLE bidding_rules_log ADD ad_positions INTEGER NOT NULL DEFAULT 0;
ALTER TABLE bidding_rules_log ALTER ad_positions DROP DEFAULT;
ALTER TABLE bidding_rules DROP PRIMARY KEY;
ALTER TABLE bidding_rules ADD CONSTRAINT bidding_rules_api_key UNIQUE (api, domain, width, height, ad_positions, campaign_id)
554 Bytes in 2 ms with coderay