ALTER TABLE `oc_clinical_service` ADD `enable_acupuncture` INT(1) NOT NULL DEFAULT '0' AFTER `enable_etcm`;

ALTER TABLE `oc_clinical_sale` ADD `service_type` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `ngp_prescription_id`;

ALTER TABLE `oc_clinical_sale` ADD `service_form_id` INT(11) NOT NULL DEFAULT '0' AFTER `service_type`;

ALTER TABLE `oc_clinecal_service_item` ADD `service_form_id` INT(11) NOT NULL DEFAULT '0' AFTER `clinecal_service_id`;

ALTER TABLE `oc_service_form` ADD `consultation` DECIMAL(10,2) NOT NULL AFTER `total_price`;

ALTER TABLE `oc_service_form` ADD `hide` INT(1) NOT NULL DEFAULT '0' AFTER `date_modified`;

ALTER TABLE `oc_service_form` ADD `clinical_sale_id` INT(11) NOT NULL DEFAULT '0' AFTER `service_form_id`;

ALTER TABLE `oc_clinical_sale` ADD `subtotal` DECIMAL(15,4) NOT NULL AFTER `total_d_gst`;

ALTER TABLE `oc_service_partner_sale_order` ADD `transcation_fee` DECIMAL(10,4) NOT NULL COMMENT 'va;ue in percentage %' AFTER `total`;

ALTER TABLE oc_user_device ADD huawei_token TEXT NOT NULL AFTER access_token;

ALTER TABLE oc_clinecal_sales_prescription ADD remark TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '2 pills per times / 每次几粒，每次 180ml' AFTER name;

ALTER TABLE oc_clinicalsale_product ADD remark TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER taketype;

ALTER TABLE oc_clinecal_sales_prescription CHANGE remark medication_method TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '2 pills per times / 每次几粒，每次 180ml';

ALTER TABLE oc_clinecal_sales_prescription ADD remark TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER medication_method;

ALTER TABLE oc_service_partner_purchase_order ADD date_prepared VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER date_payment;

ALTER TABLE oc_service_partner_sale_order ADD date_prepared VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER date_payment;

ALTER TABLE oc_service_partner_sale_order ADD etcm_customer_id INT NOT NULL AFTER doc_date;

ALTER TABLE oc_service_partner_sale_order ADD add_order VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER payment_method;

ALTER TABLE `oc_service_partner_purchase_order` ADD `proof_of_delivery` VARCHAR(255) NOT NULL AFTER `tracking_no`;

INSERT INTO `oc_setting` (`setting_id`,`store_id`,`code`,`key`,`value`,`serialized`) VALUES (NULL, '0', 'config_spp', 'config_spp_pickup_session', 'a:3:{i:0;s:5:\"13:00\";i:1;s:5:\"14:00\";i:2;s:5:\"16:00\";}', '1');

INSERT INTO `oc_setting` (`setting_id`, `store_id`, `code`, `key`, `value`, `serialized`) VALUES
(44350, 0, 'config', 'config_sms_appointment', '{\"status\":\"1\",\"template\":\"Your appointment has been {action} {date}  {time} at {storename}. Thank you\"}', 1),
(44349, 0, 'config', 'config_sms', '{\"host\":\"http:\\/\\/broadcast.smsgateway.cc\\/API\\/ReceiveSMS.aspx?Username={username}&Password={password}&MobileNumber={country_code}{mobile_number}&ContentType={content_type}&MsgText={msg_text}\",\"host_unicode\":\"http:\\/\\/broadcast.smsgateway.cc\\/api\\/Unicode.aspx?Username={username}&Password={password}&UMsg={msg_text}\",\"username\":\"tcm@qiangyitang.com\",\"password\":\"p@ssw0rd5400\",\"content_type\":\"1\"}', 1);