UPDATE `multicart_metatags` SET `vTitle`='Multicart3.0', `vKeywords`='Multicart3.0', `vDescription`='Multicart3.0' WHERE `vPageName`='index.php';
INSERT INTO `multicart_us_states` (`state_id`, `state_name`, `state_abbr`, `country_code`) VALUES
	(1, 'Alabama', 'AL', 'US'),
	(2, 'Alaska', 'AK', 'US'),
	(3, 'Arizona', 'AZ', 'US'),
	(4, 'Arkansas', 'AR', 'US'),
	(5, 'California', 'CA', 'US'),
	(6, 'Colorado', 'CO', 'US'),
	(7, 'Connecticut', 'CT', 'US'),
	(8, 'Delaware', 'DE', 'US'),
	(9, 'District of Columbia', 'DC', 'US'),
	(10, 'Florida', 'FL', 'US'),
	(11, 'Georgia', 'GA', 'US'),
	(12, 'Hawaii', 'HI', 'US'),
	(13, 'Idaho', 'ID', 'US'),
	(14, 'Illinois', 'IL', 'US'),
	(15, 'Indiana', 'IN', 'US'),
	(16, 'Iowa', 'IA', 'US'),
	(17, 'Kansas', 'KS', 'US'),
	(18, 'Kentucky', 'KY', 'US'),
	(19, 'Louisiana', 'LA', 'US'),
	(20, 'Maine', 'ME', 'US'),
	(21, 'Maryland', 'MD', 'US'),
	(22, 'Massachusetts', 'MA', 'US'),
	(23, 'Michigan', 'MI', 'US'),
	(24, 'Minnesota', 'MN', 'US'),
	(25, 'Mississippi', 'MS', 'US'),
	(26, 'Missouri', 'MO', 'US'),
	(27, 'Montana', 'MT', 'US'),
	(28, 'Nebraska', 'NE', 'US'),
	(29, 'Nevada', 'NV', 'US'),
	(30, 'New Hampshire', 'NH', 'US'),
	(31, 'New Jersey', 'NJ', 'US'),
	(32, 'New Mexico', 'NM', 'US'),
	(33, 'New York', 'NY', 'US'),
	(34, 'North Carolina', 'NC', 'US'),
	(35, 'North Dakota', 'ND', 'US'),
	(36, 'Ohio', 'OH', 'US'),
	(37, 'Oklahoma', 'OK', 'US'),
	(38, 'Oregon', 'OR', 'US'),
	(39, 'Pennsylvania', 'PA', 'US'),
	(40, 'Rhode Island', 'RI', 'US'),
	(41, 'South Carolina', 'SC', 'US'),
	(42, 'South Dakota', 'SD', 'US'),
	(43, 'Tennessee', 'TN', 'US'),
	(44, 'Texas', 'TX', 'US'),
	(45, 'Utah', 'UT', 'US'),
	(46, 'Vermont', 'VT', 'US'),
	(47, 'Virginia', 'VA', 'US'),
	(48, 'Washington', 'WA', 'US'),
	(49, 'West Virginia', 'WV', 'US'),
	(50, 'Wisconsin', 'WI', 'US'),
	(51, 'Wyoming', 'WY', 'US'),
	(52, 'Other Locations', 'OL', '');


INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `parent_id`, `divname`) VALUES ('User IP Address', 'LEFT_MENU_USER_IP_ADDRESS', 'user_ip_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 'User Ip Address');

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`) VALUES ('Blocked IP Address', 'LEFT_MENU_BLOCKED_IP', 'blockedip.php?rightMenu=rghtMenu4');

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `parent_id`, `divname`) VALUES ('Seller IP Address', 'LEFT_MENU_SELLER_IP_ADDRESS', 'seller_ip_report.php?

rghtMenu=rghtMenu4&displayDiv=Reports', 19, 'Seller Ip Address');

INSERT INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ('seller_invoice_mail', 'Monthly Invoice To Seller ', 'Dear [seller_name],Your invoice for [from_date]-[to_date] in the [site_name] site.[invoice_content] ', '[seller_name][site_name][invoice_content]', 'A');

INSERT INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES ('seller_account_deactivation_mail', 'Seller Account Deactivation Mail', 'Dear [seller_name],[custom_content] ', '[seller_name][site_name][custom_content]', 'A'); 

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `parent_id`, `divname`) VALUES ('Referral Report ', 'LEFT_MENU_REFERRAL_REPORT', 'referral_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 'Referral Report');

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `parent_id`, `divname`) VALUES ('Category-wise Sales Report ', 'LEFT_MENU_CATEGORY_SALES_REPORT', 'category_sale_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 'Category-wise Sales Report');

INSERT INTO `multicart_admin_menu` (`page_name`, `title`, `link`, `parent_id`, `divname`) VALUES ('Seller Report ', 'LEFT_MENU_SELLER_REPORT', 'seller_report.php?rghtMenu=rghtMenu4&displayDiv=Reports', 19, 'Seller Report'); 


INSERT INTO `multicart_email_templates` (`nemail_id`, `vtemplate_name`, `vtemplate_title`, 
`vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('', 'seller_previlge_update', 'Seller account activation mail for existing buyer account', 
'[account_details] \r\n\r\nWith regards, \r\n[site_name] Team', '[site_name], [account_details]', 'A');

UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=78 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=77 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=76 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=75 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=74 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=73 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=72 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=71 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=70 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=69 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=68 LIMIT 1;
UPDATE `multicart_helpcategory` SET `active`='1' WHERE  `hcid`=67 LIMIT 1;

UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=219 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=220 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=221 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=222 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=223 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=224 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=225 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=226 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=227 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=228 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=229 LIMIT 1;
UPDATE `multicart_help` SET `active`='1' WHERE  `hid`=230 LIMIT 1;

UPDATE `multicart_help` SET `active`='0' WHERE  `hid`=227 LIMIT 1;
UPDATE `multicart_help` SET `hcid`=69 WHERE  `hid`=184 LIMIT 1;

UPDATE `multicart_email_templates` SET `vemail_body`='[order_details]' WHERE  `nemail_id`=50 LIMIT 1;

UPDATE `multicart_categories` SET `alias`='giftcertificate' WHERE  `category_id`=1 LIMIT 1;

UPDATE `multicart_categories` SET `alias`='giftcertificate' WHERE  `category_id`=1 LIMIT 1;


ALTER TABLE `multicart_products`
  ADD COLUMN `seller_vacation_mode` ENUM('Y','N') NULL DEFAULT 'N' COMMENT ' N=Vacation mode  not ebaled , Y= Vacation mode enabled' AFTER `publish_timezone`;


UPDATE `multicart_help` SET `active`='0' WHERE  `hid`=227 LIMIT 1;
UPDATE `multicart_help` SET `hcid`=69 WHERE  `hid`=184 LIMIT 1;

INSERT INTO `multicart_email_templates` (`vtemplate_name`, `vtemplate_title`, `vemail_body`, `vreplaceable_variables`, `vtemplate_flag`) VALUES
('order_statuschange_buyer_to_seller', 'Order Status Change Mail From Buyer To Seller', '[order_details]', '[site_name], [order_details],[buyer_first_name],[buyer_last_name]', 'A');