26 lines
1.6 KiB
MySQL
26 lines
1.6 KiB
MySQL
|
-- ----------------------------
|
||
|
|
-- Table structure for demo_project
|
||
|
|
-- ----------------------------
|
||
|
|
DROP TABLE IF EXISTS `demo_project`;
|
||
|
|
CREATE TABLE `demo_project` (
|
||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '项目ID',
|
||
|
|
`project_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '项目名称',
|
||
|
|
`project_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '项目编号',
|
||
|
|
`establish_date` datetime NULL DEFAULT NULL COMMENT '立项时间',
|
||
|
|
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
|
||
|
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
|
|
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
|
||
|
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
|
|
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
|
|
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
|
||
|
|
PRIMARY KEY (`id`) USING BTREE
|
||
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '项目管理表';
|
||
|
|
|
||
|
|
-- ----------------------------
|
||
|
|
-- Records of demo_project (示例数据)
|
||
|
|
-- ----------------------------
|
||
|
|
BEGIN;
|
||
|
|
INSERT INTO `demo_project` (`id`, `project_name`, `project_code`, `establish_date`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`)
|
||
|
|
VALUES (1, '示例项目一', 'PROJ-2024-001', '2024-01-01 00:00:00', '1', '2024-01-01 10:00:00', '1', '2024-01-01 10:00:00', b'0', 1);
|
||
|
|
COMMIT;
|