forked from Gitlink/microservices
24 lines
1.6 KiB
SQL
24 lines
1.6 KiB
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`zone_partners`
|
||
ADD COLUMN `type_id` int(11) NULL DEFAULT NULL COMMENT '合作伙伴分类主键' AFTER `remark`;
|
||
|
||
CREATE TABLE `ruoyi-gitlink`.`zone_partners_type`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '合作伙伴分类主键',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '合作伙伴分类名称',
|
||
`sort` int(4) NULL DEFAULT 1 COMMENT '排序',
|
||
`dept_id` int(11) NOT NULL COMMENT '所属组织Id',
|
||
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
||
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`zone_id` int(11) NOT NULL COMMENT '专区标识',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '特色专区合作伙伴分类'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1; |