newCashBook/node_expores/db/update.sql

ALTER TABLE cashbook.book ADD is_del INT DEFAULT 0 NOT NULL;


ALTER TABLE cashbook.book CHANGE auther_id author_id varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账本创建者';

ALTER TABLE cashbook.book ADD is_del varchar(100) DEFAULT '0' NOT NULL;
ALTER TABLE cashbook.book CHANGE auther_id author_id varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账本创建者';


ALTER TABLE cashbook.record_files CHANGE user_id author_id varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;
ALTER TABLE cashbook.types CHANGE user_id author_id varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL;