...
R1804408 "Removed OEMPartyId (manufacturerPartyId) from Product entity as it was remnant of an old approach."
Jira | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
SQL query to remove manufacturerPartyId from the database to avoid error in the logs for field count mismatch.
ALTER TABLE PRODUCT DROP MANUFACTURER_PARTY_ID;
R1805961 "Manage life span of marketing related entites
Jira | ||||||
---|---|---|---|---|---|---|
|
This added the fromDate, and thruDate fields to the MarketingCampaignPrice, MarketingCampaignPromo, MarketingCampaignRole entities, fromDate is a PK field.
After an OFBiz start, run the SQL
BEGIN;
UPDATE marketing_campaign_price SET from_date='2000-01-01 00:00:00';
ALTER TABLE marketing_campaign_price
DROP CONSTRAINT pk_marketing_campaign_price,
ADD CONSTRAINT pk_marketing_campaign_price PRIMARY KEY (marketing_campaign_id, product_price_rule_id, from_date);
COMMIT;
BEGIN;
UPDATE marketing_campaign_promo SET from_date='2000-01-01 00:00:00';
ALTER TABLE marketing_campaign_promo
DROP CONSTRAINT pk_marketing_campaign_promo,
ADD CONSTRAINT pk_marketing_campaign_promo PRIMARY KEY (marketing_campaign_id, product_promo_id, from_date);
COMMIT;
BEGIN;
UPDATE marketing_campaign_role SET from_date='2000-01-01 00:00:00';
ALTER TABLE marketing_campaign_role
DROP CONSTRAINT pk_marketing_campaign_role,
ADD CONSTRAINT pk_marketing_campaign_role PRIMARY KEY (marketing_campaign_id, party_id, role_type_id, from_date);
COMMIT;