26 lines
1.5 KiB
SQL
Executable File
26 lines
1.5 KiB
SQL
Executable File
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for pear_project_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `pear_project_info`;
|
|
CREATE TABLE `pear_project_info` (
|
|
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
|
|
`value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '值',
|
|
`description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
|
|
`create_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`update_time` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
|
|
`organization_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织id',
|
|
`project_code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '项目id',
|
|
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
|
|
`code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'code',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE INDEX `code`(`code`) USING BTREE,
|
|
INDEX `project_code`(`project_code`) USING BTREE,
|
|
INDEX `organization_code`(`organization_code`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目自定义信息表' ROW_FORMAT = Compact;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|