ALTER TABLE `oc_user_device` ADD `access_token` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `gcm_token`, ADD `fcm_token` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `access_token`, ADD `huawei_token` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `fcm_token`;

ALTER TABLE `oc_appointment` ADD `customer_ic` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `telephone`;

ALTER TABLE `oc_appointment` ADD `hide` INT(11) NOT NULL AFTER `lastmodified_date`;

---------------------------------------------------