-- DETAILS FOR DEV SERVER - START
UPDATE `tblplans` SET `stripe_data` = '{\r\n \"product_id\": \"prod_IT2yTAv8XZkrlZ\",\r\n \"montly_price_id\": \"price_1Hs6sqCDs5uR0HQQZ6ATitap\",\r\n \"yearly_price_id\": \"price_1Hs6spCDs5uR0HQQ7MyBpIDE\"\r\n}' WHERE `tblplans`.`id` = 10;
UPDATE `tblplans` SET `stripe_data` = '{\r\n \"product_id\": \"prod_IT31QNf8OKT5Ny\",\r\n \"montly_price_id\": \"price_1Hs6vKCDs5uR0HQQBdZbHrMu\",\r\n \"yearly_price_id\": \"price_1Hs6vKCDs5uR0HQQQx3u3kmn\"\r\n}' WHERE `tblplans`.`id` = 11;
UPDATE `tblplans` SET `stripe_data` = '{\r\n \"product_id\": \"prod_IT32szaXvFdAYz\",\r\n \"montly_price_id\": \"price_1Hs6w2CDs5uR0HQQkUTgZ1aQ\",\r\n \"yearly_price_id\": \"price_1Hs6w2CDs5uR0HQQsXU5CFm1\"\r\n}' WHERE `tblplans`.`id` = 12;
-- DETAILS FOR DEV SERVER - END

-- DETAILS FOR LIVE SERVER - START
UPDATE `tblplans` SET `stripe_data` = '{\r\n \"product_id\": \"prod_IT2nGX7Au45GBV\",\r\n \"montly_price_id\": \"price_1Hs6hXCDs5uR0HQQJ2UjYt20\",\r\n \"yearly_price_id\": \"price_1Hs6hXCDs5uR0HQQ7LghcF1d\"\r\n}' WHERE `tblplans`.`id` = 10;
UPDATE `tblplans` SET `stripe_data` = '{\r\n \"product_id\": \"prod_IT2oHtZkKs2Nkf\",\r\n \"montly_price_id\": \"price_1Hs6jMCDs5uR0HQQF4JppnID\",\r\n \"yearly_price_id\": \"price_1Hs6jMCDs5uR0HQQOoudDStO\"\r\n}' WHERE `tblplans`.`id` = 11;
UPDATE `tblplans` SET `stripe_data` = '{\r\n \"product_id\": \"prod_IT2rOCJ2NHzODn\",\r\n \"montly_price_id\": \"price_1Hs6lrCDs5uR0HQQUnQqQxN8\",\r\n \"yearly_price_id\": \"price_1Hs6lrCDs5uR0HQQOJLBAYsW\"\r\n}' WHERE `tblplans`.`id` = 12;
-- DETAILS FOR LIVE SERVER - END

-- COUPON CODE FOR DEV SERVER - START
INSERT INTO `tblcoupons` (`id`, `coupon_valid_for`, `name`, `description`, `code`, `value_type`, `value`, `start_date`, `end_date`, `total_limit_of_coupon_usage`, `is_specific`, `is_active`, `stripe_coupon_id`, `dateadded`) VALUES (NULL, 'plan', '10% Off Forever', NULL, '2510029942493932', 'percent', '10.00', NULL, NULL, NULL, '0', '1', 'rquHqRdM', '2020-08-14 10:14:21');
INSERT INTO `tblcoupons` (`id`, `coupon_valid_for`, `name`, `description`, `code`, `value_type`, `value`, `start_date`, `end_date`, `total_limit_of_coupon_usage`, `is_specific`, `is_active`, `stripe_coupon_id`, `dateadded`) VALUES (NULL, 'plan', '20% Off Forever', NULL, '9EJ1ST21JX', 'percent', '20.00', NULL, NULL, NULL, '0', '1', 'Vx7AVsaG', '2020-08-14 10:14:21');
-- COUPON CODE FOR DEV SERVER - END


-- UPGRADE PLAN DESCRIPTION
UPDATE `tblplans` SET `description` = '<div class=\"plan-feature\"><p>Includes everything in BASIC</p><span>+ Expenses</span><span>+ 3 Team Members</span><span>+ Time Clock</span><span>+ Custom SMTP</span></div>' WHERE `tblplans`.`id` = 10;
UPDATE `tblplans` SET `description` = '<div class="plan-feature"><p>Includes everything in PROFESSIONAL</p><span>+ More Payment Methods</span><span>+ 10 Team Members</span><span>+ More Suppliers</span></div>' WHERE `tblplans`.`id` = 11;
UPDATE `tblplans` SET `description` = '<div class="plan-feature"><p>Includes Everything In CORPORATE</p><span>+ More Payment Methods</span><span>+ 30 Team Members</span></div>' WHERE `tblplans`.`id` = 12;
UPDATE `tblplans` SET `description` = '<div class="plan-feature"><span>+ Estimates</span><span>+ Invoices</span><span>+ Post Inspections</span><span>+ 1 Team Members</span></div>' WHERE `tblplans`.`id` = 9;