1.建表语句

CREATE TABLE `e_order` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
    `customer_id` bigint NULL COMMENT '客户id',
    `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '客户名称',
    `total_money` double NULL COMMENT '合计金额',
    `submit_time` datetime NULL COMMENT '提交时间',
	`syn_time` datetime NULL COMMENT '同步时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB
    DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    COMMENT='订单表'
    AUTO_INCREMENT=656
    ROW_FORMAT=DYNAMIC
    AVG_ROW_LENGTH=273;

2. 新增字段语句

ALTER TABLE `e_order`  ADD COLUMN `address` varchar(255) NULL COMMENT '地址' AFTER `pay_time` ;

ALTER TABLE `e_order`  ADD COLUMN `invoice_type` int NULL default 0 COMMENT '发票类型' AFTER `address` ;

3.修改字段名

ALTER TABLE `e_customer`  CHANGE COLUMN `buy_idcard_date` `book_val_date` datetime NULL 
COMMENT '委托书有效期' AFTER `buy_idcard`;