inportal_upgrade_v1.2.0.sql
No OneTemporary
Actions

Subscribers

None

File Metadata

	ALTER TABLE OrderItems ADD Cost DOUBLE( 10, 4 ) NOT NULL DEFAULT '0' AFTER Price;
	ALTER TABLE Orders ADD CostTotal DOUBLE( 10, 4 ) NOT NULL DEFAULT '0' AFTER SubTotal ;
	ALTER TABLE Products ADD AssignedCoupon int(11) NOT NULL default '0';

	ALTER TABLE Manufacturers ADD Address1 VARCHAR( 255 ) NULL,
	ADD Address2 VARCHAR( 255 ) NULL ,
	ADD City VARCHAR( 255 ) NULL ,
	ADD State VARCHAR( 50 ) NULL ,
	ADD Zip VARCHAR( 50 ) NULL ,
	ADD Country VARCHAR( 255 ) NULL ,
	ADD Phone VARCHAR( 50 ) NULL ,
	ADD Fax VARCHAR( 50 ) NULL ,
	ADD Email VARCHAR( 255 ) NULL ;

	INSERT INTO CustomField (CustomFieldId, Type, FieldName, FieldLabel, Heading, Prompt, ElementType, ValueList, DisplayOrder, OnGeneralTab, IsSystem) VALUES (NULL, 6, 'shipping_addr_block', 'cust_shipping_addr_block', 'cust_shipping_addr_block', 'cust_shipping_addr_block', 'checkbox', '1=+Block', 0, 1, 1);

	UPDATE ItemReview SET Module = 'In-Commerce' WHERE ItemId IN (SELECT ResourceId FROM Products);

	UPDATE Modules SET Version = '1.2.0' WHERE Name = 'In-Commerce';