From ee5baccab552762e9d57fb3fab04cd099dae018d Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@aliyun.com>
Date: 星期二, 03 九月 2024 23:59:11 +0800
Subject: [PATCH] BasicMapperImpl
---
sql/init.sql | 26 ++++++++++++++------------
1 files changed, 14 insertions(+), 12 deletions(-)
diff --git a/sql/init.sql b/sql/init.sql
index 73c01d5..9150eac 100644
--- a/sql/init.sql
+++ b/sql/init.sql
@@ -1,12 +1,13 @@
+-- 函数 - 设置表的最后更新时间
CREATE OR REPLACE FUNCTION "public"."update_timestamp_column"()
RETURNS "pg_catalog"."trigger" AS $BODY$
BEGIN
-NEW.timestamp_column := current_timestamp;
+NEW.update_time := current_timestamp;
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
- COST 100
+ COST 100;
-- test_info - 测试信息表
DROP TABLE IF EXISTS "public"."test_info";
@@ -26,8 +27,17 @@
"is_delete" int2 NOT NULL DEFAULT 0
)
;
+-- 设置主键
+ALTER TABLE "public"."test_info" ADD CONSTRAINT "PK_test_info_pkey" PRIMARY KEY ("id");
+-- 索引
+CREATE INDEX "IDX_test_info_create_time" ON "public"."test_info"("create_time");
+-- 触发器：自动赋值最后更新时间
+CREATE TRIGGER "TG_test_info" BEFORE INSERT OR UPDATE OF "update_time" ON "public"."test_info"
+FOR EACH ROW
+EXECUTE PROCEDURE "public"."update_timestamp_column"();
+-- 添加描述
COMMENT ON TABLE "public"."test_info" IS '测试信息表';
-COMMENT ON COLUMN "public"."test_info"."id" IS '主键id';
+COMMENT ON COLUMN "public"."test_info"."id" IS '主键';
COMMENT ON COLUMN "public"."test_info"."name" IS '名称';
COMMENT ON COLUMN "public"."test_info"."user_id" IS '用户id';
COMMENT ON COLUMN "public"."test_info"."phone" IS '电话';
@@ -35,16 +45,8 @@
COMMENT ON COLUMN "public"."test_info"."sex" IS '性别 男=1,女=2,其他=3';
COMMENT ON COLUMN "public"."test_info"."birthday" IS '生日';
COMMENT ON COLUMN "public"."test_info"."sort" IS '排序值';
-COMMENT ON COLUMN "public"."test_info"."status" IS '状态 正常=200,停用=300,删除=400';
+COMMENT ON COLUMN "public"."test_info"."status" IS '状态 EState';
COMMENT ON COLUMN "public"."test_info"."comment" IS '备注';
COMMENT ON COLUMN "public"."test_info"."create_time" IS '数据创建时间';
COMMENT ON COLUMN "public"."test_info"."update_time" IS '最后更新时间';
COMMENT ON COLUMN "public"."test_info"."is_delete" IS '是否删除(逻辑删除)';
--- 设置主键
-ALTER TABLE "public"."test_info" ADD CONSTRAINT "PK_test_info" PRIMARY KEY ("id");
--- 索引
-CREATE INDEX "IDX_test_info_create_time" ON "public"."test_info"("create_time");
--- 触发器：自动赋值最后更新时间
-CREATE TRIGGER "TG_test_info" BEFORE UPDATE OF "update_time" ON "public"."test_info"
-FOR EACH ROW
-EXECUTE PROCEDURE "public"."update_timestamp_column"();
--
Gitblit v1.9.3