You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
1.3 KiB
28 lines
1.3 KiB
DROP TABLE IF EXISTS "public"."t_hy_user";
|
|
-- 手动创建序列
|
|
drop SEQUENCE if EXISTS t_hy_user_serial;
|
|
CREATE SEQUENCE t_hy_user_serial START 1;
|
|
|
|
CREATE TABLE "public"."t_hy_user" (
|
|
id INTEGER NOT NULL DEFAULT nextval('t_hy_user_serial') PRIMARY KEY,
|
|
"user_id" char(36) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"open_id" char(28) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"login_count" int4 NOT NULL DEFAULT 0,
|
|
"img_count" int4 NOT NULL DEFAULT 0,
|
|
"gold_count" int4 NOT NULL DEFAULT 0,
|
|
"nick_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"last_login_time" date NOT NULL
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."t_hy_user"."id" IS '主键';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."user_id" IS '用户ID';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."open_id" IS '微信返回的open_id';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."login_count" IS '登录次数';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."img_count" IS '生成的图片数量';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."gold_count" IS '金豆数量';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."nick_name" IS '微信昵称';
|
|
COMMENT ON COLUMN "public"."t_hy_user"."last_login_time" IS '最后一次登录时间';
|
|
|
|
-- 清空表并且还原序列
|
|
TRUNCATE TABLE t_hy_task;
|
|
ALTER SEQUENCE t_hy_task_task_id_seq RESTART WITH 1; |