QQ机器人v2.0版本

-- 清空机器人字段
UPDATE "public"."user" SET  "bot_uid" = NULL;

------------------------签到系列-------------------------------
-- 用户签到打卡记录
CREATE TABLE "user_clock_in_rec" (
    "no_" serial primary key,
    "id" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "gid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "uid" varchar COLLATE "pg_catalog"."default",
    "bot_uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "clock_in_date" int4 NOT NULL,
    "clock_in_type" int4 NOT NULL,
    "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "update_time" timestamp(0),
    -- ID唯一
    CONSTRAINT "user_clock_in_rec_id_unique_check" UNIQUE ("id")
);
ALTER TABLE "user_clock_in_rec" OWNER TO "haiwan";
-- 触发器
CREATE TRIGGER "user_clock_in_rec_update_at" BEFORE UPDATE ON "user_clock_in_rec" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- no_索引
CREATE UNIQUE INDEX "user_clock_in_rec_no_index" ON "user_clock_in_rec" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN "public"."user_clock_in_rec"."clock_in_date" IS '打卡日期时间戳';
COMMENT ON COLUMN "public"."user_clock_in_rec"."clock_in_type" IS '打卡类型 1-指令打卡 2-补签卡补卡 3-积分补卡';
-- 用户签到打卡记录
CREATE TABLE "user_year_clock_in_rec" (
    "no_" serial primary key,
    "id" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "gid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "uid" varchar COLLATE "pg_catalog"."default",
    "bot_uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "clock_in_year" int4 NOT NULL,
    "clock_in_text" text COLLATE "pg_catalog"."default" NOT NULL,
    "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "update_time" timestamp(0),
    -- ID唯一
    CONSTRAINT "user_year_clock_in_rec_id_unique_check" UNIQUE ("id"),
    -- 一个用户同一个频道一年记录唯一
    CONSTRAINT "user_year_clock_in_rec_user_guild_year_clock_in_unique_check" UNIQUE ("gid", "bot_uid", "clock_in_year")
);
-- 触发器
CREATE TRIGGER "user_year_clock_in_rec_update_at" BEFORE UPDATE ON "user_year_clock_in_rec" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "user_year_clock_in_rec" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "user_year_clock_in_rec_no_index" ON "user_year_clock_in_rec" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN "public"."user_year_clock_in_rec"."clock_in_year" IS '打卡年份';
COMMENT ON COLUMN "public"."user_year_clock_in_rec"."clock_in_text" IS '打卡数据, 将每天的打卡记录按照一年以二进制存储, 0为当天未打卡 1为当天已打卡';
-- 用户积分钱包
CREATE TABLE "point_account" (
    "no_" serial primary key,
    "id" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "gid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "uid" varchar COLLATE "pg_catalog"."default",
    "bot_uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "balance" int4,
    "is_available" int4 NOT NULL DEFAULT 1,
    "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "update_time" timestamp(0),
    -- ID唯一
    CONSTRAINT "point_account_id_unique_check" UNIQUE ("id"),
    -- 一个用户一个频道一个积分钱包
    CONSTRAINT "point_account_user_guild_point_account_unique" UNIQUE ("gid", "bot_uid")
);
-- 触发器
CREATE TRIGGER "point_account_update_at" BEFORE UPDATE ON "point_account" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "point_account" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "point_account_no_index" ON "point_account" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 用户积分变化记录
CREATE TABLE "point_account_rec" (
    "no_" serial primary key,
    "point_acct_id" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "balance_before" int4 NOT NULL,
    "amount" int4 NOT NULL,
    "balance_after" int4 NOT NULL,
    "update_at" int4 NOT NULL NOT NULL,
    "reason" int4 NOT NULL,
    "note" varchar,
    "is_available" int4 NOT NULL DEFAULT 1,
    "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "update_time" timestamp(0)
);
-- 触发器
CREATE TRIGGER "point_account_rec_update_at" BEFORE UPDATE ON "point_account_rec" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "point_account_rec" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "point_account_rec_no_index" ON "point_account_rec" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN "point_account_rec"."point_acct_id" IS '用户积分账号ID';
COMMENT ON COLUMN "point_account_rec"."balance_before" IS '变动前积分余额';
COMMENT ON COLUMN "point_account_rec"."amount" IS '变动金额';
COMMENT ON COLUMN "point_account_rec"."balance_after" IS '变动后积分余额';
COMMENT ON COLUMN "point_account_rec"."update_at" IS '变动时间';
COMMENT ON COLUMN "point_account_rec"."reason" IS '变动类型';
COMMENT ON COLUMN "point_account_rec"."note" IS '变动说明';
-- 用户频道道具仓库
CREATE TABLE "user_poe_warehouse" (
    "no_" serial primary key,
    "id" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "gid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "bot_uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "content" json,
    "is_available" int4 NOT NULL DEFAULT 1,
    "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "update_time" timestamp(0),
    -- ID唯一
    CONSTRAINT "user_poe_warehouse_id_unique_check" UNIQUE ("id"),
    -- 一个用户一个频道一个道具仓库
    CONSTRAINT "user_poe_warehouse_user_guild_poe_warehouse_unique" UNIQUE ("gid", "bot_uid")
);
-- 触发器
CREATE TRIGGER "user_poe_warehouse_update_at" BEFORE UPDATE ON "user_poe_warehouse" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "user_poe_warehouse" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "user_poe_warehouse_no_index" ON "user_poe_warehouse" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN "public"."user_poe_warehouse"."content" IS '道具json存储';
-- 用户道具仓库变化记录
CREATE TABLE "user_poe_warehouse_rec" (
    "no_" serial primary key,
    "id" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "bot_uid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "gid" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "type" int4 NOT NULL NOT NULL,
    "count" int4 NOT NULL NOT NULL,
    "direction" int4 NOT NULL NOT NULL,
    "before" int4 NOT NULL NOT NULL,
    "after" int4 NOT NULL NOT NULL,
    "update_at" int4 NOT NULL NOT NULL,
    "reason" varchar COLLATE "pg_catalog"."default" NOT NULL,
    "is_available" int4 NOT NULL DEFAULT 1,
    "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "update_time" timestamp(0),
    -- ID唯一
    CONSTRAINT "user_poe_warehouse_rec_id_unique_check" UNIQUE ("id")
);
-- 触发器
CREATE TRIGGER "user_poe_warehouse_rec_update_at" BEFORE UPDATE ON "user_poe_warehouse_rec" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "user_poe_warehouse_rec" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "user_poe_warehouse_rec_no_index" ON "user_poe_warehouse_rec" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN "user_poe_warehouse_rec"."type" IS '道具类型 1：补签卡';
COMMENT ON COLUMN "user_poe_warehouse_rec"."direction" IS '1-增加 2-减少';
COMMENT ON COLUMN "user_poe_warehouse_rec"."update_at" IS '变动时间';
-- 每日一言类型
CREATE TABLE "every_day_saying_type" (
  "no_" serial primary key,
  "name" varchar(128) COLLATE "pg_catalog"."default" NOT NULL,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0)
);
-- 更新时间触发器
CREATE TRIGGER "update_at" BEFORE UPDATE ON "every_day_saying_type" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "public"."every_day_saying_type" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "biz_acct_dept_basis_data_no" ON "every_day_saying_type" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
-- 每日一言
CREATE TABLE "every_day_saying" (
  "no_" serial primary key,
  "type" int4 NOT NULL,
  "saying" varchar(256) COLLATE "pg_catalog"."default" NOT NULL,
  "author" varchar(128) COLLATE "pg_catalog"."default",
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0)
);
-- 更新时间触发器
CREATE TRIGGER "update_at" BEFORE UPDATE ON "every_day_saying" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
ALTER TABLE "public"."every_day_saying" OWNER TO "haiwan";
-- no_索引
CREATE UNIQUE INDEX "every_day_saying_no" ON "every_day_saying" USING btree ("no_" "pg_catalog"."int4_ops" ASC NULLS LAST);
----------------------------------------------------------------------------
-- 默认配置
INSERT into case_set_default_resource (type, content) VALUES (20, '{"nick_name_check_url": "https://doc.changqian365.com/robot/IMG230208B59E422D8EF740A1A03783052EC2A3AE.jpg", "nick_name_check_name": "昵称校验", "top_cover_url": "https://doc.changqian365.com/robot/IMG230208B59E422D8EF740A1A03783052EC2A3AE.jpg", "top_cover_name": "顶部封面"}');
INSERT into case_set_default_resource (type, content) VALUES (21, '{"rookie_draw_url": "https://doc.changqian365.com/robot/IMG2302211707F454D4F84140A602CACFED2A6E99.png","rookie_draw_name": "新人抽奖默认封面"}');
-- 创建表 command_red_packet_data_list
CREATE TABLE "public"."command_red_packet_data_list" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "crps_id" varchar COLLATE "pg_catalog"."default",
   "type" int4,
   "uid" varchar COLLATE "pg_catalog"."default",
   "sum_count" int4,
   "total" decimal
);
ALTER TABLE "public"."command_red_packet_data_list"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "command_red_packet_data_list" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 command_red_packet_data
CREATE TABLE "public"."command_red_packet_data" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "crps_id" varchar COLLATE "pg_catalog"."default",
   "sum_count" int4,
   "participation_people" int4,
   "win_a_prize_people" int4,
   "total" decimal,
   "issue" decimal,
   "surplus" decimal
);
ALTER TABLE "public"."command_red_packet_data"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "command_red_packet_data" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 command_red_packet_record
CREATE TABLE "public"."command_red_packet_record" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "crps_id" varchar COLLATE "pg_catalog"."default",
   "uid" varchar COLLATE "pg_catalog"."default",
   "win_a_prize" int4,
   "total" decimal
);
ALTER TABLE "public"."command_red_packet_record"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "command_red_packet_record" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 command_red_packet_setting
CREATE TABLE "public"."command_red_packet_setting" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
   "gid" varchar COLLATE "pg_catalog"."default",
   "uid" varchar COLLATE "pg_catalog"."default",
   "packet_type" int4,
   "status" int4,
   "total" decimal,
   "min_one_quota" decimal,
   "max_one_quota" decimal,
   "command" varchar COLLATE "pg_catalog"."default",
   "probability" int4,
   "most_participation" int4,
   "most_win_a_prize" int4,
   "start_time" int4,
   "end_time" int4,
   "channel_id" varchar COLLATE "pg_catalog"."default",
   "channel_name" varchar COLLATE "pg_catalog"."default",
   "advanced_settings" json
);
ALTER TABLE "public"."command_red_packet_setting"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "command_red_packet_setting" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 wallet_account
CREATE TABLE "public"."wallet_account" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
   "uid" varchar COLLATE "pg_catalog"."default",
   "remaining" decimal,
   "version" varchar COLLATE "pg_catalog"."default",
   "status" int4
);
ALTER TABLE "public"."wallet_account"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "wallet_account" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 wallet_detail
CREATE TABLE "public"."wallet_detail" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "wallet_id" varchar COLLATE "pg_catalog"."default",
   "note" varchar COLLATE "pg_catalog"."default",
   "before" decimal,
   "direction" int4,
   "amount" decimal,
   "after" decimal,
   "create_time" int4,
   "reason" int4
);
ALTER TABLE "public"."wallet_detail"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "wallet_detail" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 customize_game
CREATE TABLE "public"."customize_game" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
   "gid" varchar COLLATE "pg_catalog"."default",
   "bot_uid" varchar COLLATE "pg_catalog"."default",
   "last_time" int4,
   "result" int4
);
ALTER TABLE "public"."customize_game"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "customize_game" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 guess_number
CREATE TABLE "public"."guess_number" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
   "gid" varchar COLLATE "pg_catalog"."default",
   "bot_uid" varchar COLLATE "pg_catalog"."default",
   "number" int4,
   "integral" int4,
   "last_time" int4,
   "residual_opportunity" int4,
   "result" int4
);
ALTER TABLE "public"."guess_number"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "guess_number" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 report_list
CREATE TABLE "public"."report_list" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
  "gid" varchar COLLATE "pg_catalog"."default",
  "handler" varchar COLLATE "pg_catalog"."default",
  "informant" varchar COLLATE "pg_catalog"."default",
  "status" int4,
  "processing_time" int4,
  "content" json
);
ALTER TABLE "public"."report_list"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "report_list" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 reporting_duty_conf
CREATE TABLE "public"."reporting_duty_conf" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "gid" varchar COLLATE "pg_catalog"."default",
  "settings" json
);
ALTER TABLE "public"."reporting_duty_conf"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "reporting_duty_conf" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 guild_user_birthday
CREATE TABLE "public"."guild_user_birthday" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
  "gid" varchar COLLATE "pg_catalog"."default",
  "bot_uid" varchar COLLATE "pg_catalog"."default",
  "constellation" varchar COLLATE "pg_catalog"."default",
  "birthday" int4,
  "year" int4,
  "month" int4,
  "day" int4,
  "status" int4
);
ALTER TABLE "public"."guild_user_birthday"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "guild_user_birthday" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 guild_data_board
CREATE TABLE "public"."guild_data_board" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
  "gid" varchar COLLATE "pg_catalog"."default",
  "date" int4,
  "add_num" int4,
  "remove_num" int4,
  "net_increase" int4,
  "people" json
);
ALTER TABLE "public"."guild_data_board"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "guild_data_board" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 timing_setting
CREATE TABLE "public"."timing_setting" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
  "gid" varchar COLLATE "pg_catalog"."default",
  "type" int4,
  "settings" json
);
ALTER TABLE "public"."timing_setting"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "timing_setting" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 panel_guild_role
CREATE TABLE "public"."panel_guild_role" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "id" varchar COLLATE "pg_catalog"."default",
  "status" int2,
  "gid" varchar COLLATE "pg_catalog"."default",
  "type" int4,
  "foundation" json,
  "advanced_settings" json,
  "instruction" varchar COLLATE "pg_catalog"."default",
  "channel" varchar COLLATE "pg_catalog"."default",
  "channel_name" varchar COLLATE "pg_catalog"."default",
  "command" varchar COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."panel_guild_role"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "panel_guild_role" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();
-- 创建表 panel_guild_role_choose
CREATE TABLE "public"."panel_guild_role_choose" (
  "no_" serial primary key,
  "creation_time" timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "update_time" timestamp(0),
  "is_available" int4 NOT NULL DEFAULT 1,
  "panel_guild_role_choose_id" varchar COLLATE "pg_catalog"."default",
  "panel_role_id" varchar COLLATE "pg_catalog"."default",
  "role_id" varchar COLLATE "pg_catalog"."default",
  "role_name" varchar COLLATE "pg_catalog"."default",
  "role_duration" int4,
  "role_introduce" varchar COLLATE "pg_catalog"."default",
  "copy_writing" varchar COLLATE "pg_catalog"."default",
  "key_words" varchar COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."panel_guild_role_choose"  OWNER TO "haiwan";
CREATE TRIGGER "update_at" BEFORE UPDATE ON "panel_guild_role_choose" FOR EACH ROW EXECUTE PROCEDURE "update_timestamp"();