newCashBook/expores_node/db/update.sql

ALTER TABLE cashbook.authors MODIFY COLUMN id int NOT NULL AUTO_INCREMENT;

ALTER TABLE cashbook.authors DROP KEY authors_unique_1;
ALTER TABLE cashbook.authors DROP COLUMN mobile;
ALTER TABLE cashbook.authors CHANGE email account varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
ALTER TABLE cashbook.authors DROP COLUMN login_type;


ALTER TABLE cashbook.record ADD source_id varchar(100) NULL;


ALTER TABLE cashbook.record MODIFY COLUMN remark LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL;

ALTER TABLE cashbook.more_record ADD more_id varchar(300) NOT NULL;
ALTER TABLE cashbook.more_record ADD CONSTRAINT more_record_unique UNIQUE KEY (more_id);
ALTER TABLE cashbook.more_record ADD remark LONGTEXT NULL;

ALTER TABLE cashbook.more_record ADD total_fee decimal(15,2) NOT NULL;

ALTER TABLE cashbook.more_record MODIFY COLUMN name varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;


ALTER TABLE cashbook.more_record ADD start_time TIMESTAMP NOT NULL;

ALTER TABLE cashbook.more_record ADD start_time TIMESTAMP NOT NULL;
ALTER TABLE cashbook.more_record ADD end_time TIMESTAMP NOT NULL;

ALTER TABLE cashbook.more_record ADD type_id INT NULL;


ALTER TABLE cashbook.more_record ADD log_day INT NOT NULL;