ALTER TABLE `users` ADD `contract_agreement_date` DATE NULL AFTER `contract_agreement`;

-- New edit
ALTER TABLE `halls` ADD `table_ids` LONGTEXT NULL AFTER `category_id`;
ALTER TABLE `hall_descriptions` ADD `reservation_condition` LONGTEXT NOT NULL AFTER `description`, ADD `features` LONGTEXT NOT NULL AFTER `reservation_condition`;
ALTER TABLE `reservations` ADD `other_details` TEXT NOT NULL AFTER `total`;

ALTER TABLE `halls` ADD `views_counts` BIGINT NULL AFTER `rate`, ADD INDEX (`views_counts`);
ALTER TABLE `halls` CHANGE `rate` `rate` SMALLINT(5) NULL DEFAULT NULL;

-- today
ALTER TABLE `users` ADD `verify_code` CHAR(4) NULL AFTER `api_token`, ADD `attempt_send_code` SMALLINT NULL AFTER `verify_code`, ADD `last_attempt_date` DATE NULL AFTER `attempt_send_code`, ADD `code_verify_attempt` SMALLINT NULL AFTER `last_attempt_date`;
ALTER TABLE `users` CHANGE `name` `name` VARCHAR(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `email` `email` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, CHANGE `password` `password` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

-- 5/1/2023

ALTER TABLE `reservations` CHANGE `other_details` `other_details` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

