原生SQL语句

创建表

CREATE TABLE `feedbacks`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '问题和意见',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片地址',
  `receiver_id` int(11) NOT NULL COMMENT '接收者id',
  `creator_id` int(11) NOT NULL COMMENT '创建者',
  `status` int(11) NULL DEFAULT 1 COMMENT '状态 1已提交 2已读',
  `create_time` timestamp(0) NULL DEFAULT NULL,
  `update_time` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  `delete_time` timestamp(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

添加字段

ALTER TABLE `reimbursement` ADD COLUMN `reimbursement` json NOT NULL COMMENT '报销人类型和报销人' AFTER `amount`

ALTER TABLE `reimbursement` MODIFY COLUMN `type` varchar(30) NOT NULL DEFAULT '644' COMMENT '报销类型'

删除字段

ALTER TABLE `boss3_basic`.`contract_lord` 
DROP COLUMN `property_phone`;