QQ机器人初始表
<pre><code class="language-sql">
-------------------------------- 2.0版本新增未上线-----------------------------
-- 积分商城配置
CREATE TABLE &quot;public&quot;.&quot;points_mall_setting&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;gid&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;open_status&quot; int4,
&quot;cover_img&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;share_title&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;share_img&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;inventory_status&quot; int4,
&quot;total_class_status&quot; int4
)
;
ALTER TABLE &quot;public&quot;.&quot;points_mall_setting&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;points_mall_setting&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 注释
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;gid&quot; IS '频道id';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;open_status&quot; IS '1未开启 2已开启';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;cover_img&quot; IS '商城封面设置';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;share_title&quot; IS '商城分享标题';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;share_img&quot; IS '商城分享图片';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;inventory_status&quot; IS '显示商品库存 1不显示 2显示';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_setting&quot;.&quot;total_class_status&quot; IS '隐藏全部分类 1隐藏 2显示';
-- 积分商城商品分类
CREATE TABLE &quot;public&quot;.&quot;points_mall_type&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;name&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;sort&quot; int4 NOT NULL
)
;
ALTER TABLE &quot;public&quot;.&quot;points_mall_type&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;points_mall_type&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 注释
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_type&quot;.&quot;gid&quot; IS '频道id';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_type&quot;.&quot;name&quot; IS '分类名称';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_type&quot;.&quot;sort&quot; IS '排序';
-- 积分商城奖品
CREATE TABLE &quot;public&quot;.&quot;points_mall_prizes&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;prize_img&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;kind&quot; int4,
&quot;name&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;surplus&quot; int4,
&quot;day_most&quot; int4,
&quot;expend_point&quot; int4,
&quot;upper_limit&quot; int4,
&quot;prize_type_id&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;put_on&quot; int4,
&quot;introduce&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;exchange_group&quot; json,
&quot;write_info&quot; json,
&quot;outher&quot; json,
&quot;sort&quot; int4
)
;
ALTER TABLE &quot;public&quot;.&quot;points_mall_prizes&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;points_mall_prizes&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 注释
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;gid&quot; IS '频道id';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;prize_img&quot; IS '奖品图片';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;kind&quot; IS '种类 1自定义 2 现金红包 3身分组 4兑换码 5补签卡';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;name&quot; IS '商品名称';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;surplus&quot; IS '商品剩余库存';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;day_most&quot; IS '每日最多兑换';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;expend_point&quot; IS '兑换消耗多少积分';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;upper_limit&quot; IS '用户兑换上限';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;prize_type_id&quot; IS '商城种类id ';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;put_on&quot; IS '1:未上架 2:已上架';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;introduce&quot; IS '商品介绍';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;exchange_group&quot; IS '兑换身分组限制';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;write_info&quot; IS '需要填写得信息名称 为空是不填写';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;outher&quot; IS '其他信息';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_prizes&quot;.&quot;sort&quot; IS '排序';
-- 积分商城奖品兑换记录
CREATE TABLE &quot;public&quot;.&quot;points_mall_exchange&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;prizes_id&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;user_id&quot; varchar(64) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;exchange_time&quot; int4,
&quot;verify_status&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;write_info&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;outher&quot; varchar(255) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;
)
;
ALTER TABLE &quot;public&quot;.&quot;points_mall_exchange&quot; OWNER TO &quot;haiwan&quot;;
-- 注释
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;gid&quot; IS '频道id';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;prizes_id&quot; IS '奖品id';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;user_id&quot; IS '兑奖用户id';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;exchange_time&quot; IS '兑奖时间';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;verify_status&quot; IS '1未核销 2已核销';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;write_info&quot; IS '兑奖填写信息';
COMMENT ON COLUMN &quot;public&quot;.&quot;points_mall_exchange&quot;.&quot;outher&quot; IS '兑换码';
-- 每日一言类型
CREATE TABLE &quot;public&quot;.&quot;every_day_saying_type&quot; (
&quot;no_&quot; serial primary key,
&quot;name&quot; varchar(128) COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;public&quot;.&quot;every_day_saying_type&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;biz_acct_dept_basis_data_no&quot; ON &quot;public&quot;.&quot;every_day_saying_type&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 每日一言
CREATE TABLE &quot;public&quot;.&quot;every_day_saying&quot; (
&quot;no_&quot; serial primary key,
&quot;type&quot; int4 NOT NULL,
&quot;saying&quot; varchar(256) COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;author&quot; varchar(128) COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;public&quot;.&quot;every_day_saying&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;every_day_saying_no&quot; ON &quot;public&quot;.&quot;every_day_saying&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 九宫格抽奖配置
CREATE TABLE &quot;sudoku_raffle&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;status&quot; int4 NOT NULL,
&quot;is_show_probability&quot; int4 NOT NULL,
&quot;content&quot; json,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;sudoku_raffle&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;sudoku_raffle_no_index&quot; ON &quot;sudoku_raffle&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;public&quot;.&quot;sudoku_raffle&quot;.&quot;gid&quot; IS '频道ID';
COMMENT ON COLUMN &quot;public&quot;.&quot;sudoku_raffle&quot;.&quot;status&quot; IS '状态 0-关闭 1-开启';
COMMENT ON COLUMN &quot;public&quot;.&quot;sudoku_raffle&quot;.&quot;is_show_probability&quot; IS '是否公示中奖概率 0-不公示 1-公示';
-- 九宫格奖项关系表
CREATE TABLE &quot;sudoku_raffle_award_relation&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;sudoku_raffle_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;award_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;location&quot; int4 NOT NULL NOT NULL,
&quot;content&quot; json,
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;sudoku_raffle_award_relation&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;sudoku_raffle_award_relation_no_index&quot; ON &quot;sudoku_raffle_award_relation&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;public&quot;.&quot;sudoku_raffle&quot;.&quot;gid&quot; IS '频道ID';
COMMENT ON COLUMN &quot;sudoku_raffle_award_relation&quot;.&quot;sudoku_raffle_id&quot; IS '九宫格配置ID';
COMMENT ON COLUMN &quot;sudoku_raffle_award_relation&quot;.&quot;award_id&quot; IS '奖项ID';
COMMENT ON COLUMN &quot;sudoku_raffle_award_relation&quot;.&quot;location&quot; IS '九宫格位置';
-- 奖励配置表
CREATE TABLE &quot;award_conf&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;source&quot; int4 NOT NULL NOT NULL,
&quot;type&quot; int4 NOT NULL NOT NULL,
&quot;status&quot; int4 NOT NULL,
&quot;content&quot; json,
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;award_conf&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;award_conf_no_index&quot; ON &quot;award_conf&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;award_conf&quot;.&quot;source&quot; IS '来源 1-九宫格 2-其他';
COMMENT ON COLUMN &quot;award_conf&quot;.&quot;type&quot; IS '奖项类型';
COMMENT ON COLUMN &quot;award_conf&quot;.&quot;status&quot; IS '状态 0-关闭 1-开启';
-- 用户中奖记录
CREATE TABLE &quot;user_award_rec&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;award_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;user_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;win_time&quot; int4 NOT NULL,
&quot;status&quot; int4 NOT NULL,
&quot;content&quot; json,
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;user_award_rec&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_award_rec_no_index&quot; ON &quot;user_award_rec&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;user_award_rec&quot;.&quot;award_id&quot; IS '奖品ID';
COMMENT ON COLUMN &quot;user_award_rec&quot;.&quot;user_id&quot; IS '中奖人ID';
COMMENT ON COLUMN &quot;user_award_rec&quot;.&quot;win_time&quot; IS '中奖时间';
-- 用户签到打卡记录
CREATE TABLE &quot;user_clock_in_rec&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;clock_in_date&quot; int4 NOT NULL,
&quot;clock_in_type&quot; int4 NOT NULL,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;user_clock_in_rec&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_clock_in_rec_no_index&quot; ON &quot;sudoku_raffle&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;public&quot;.&quot;user_clock_in_rec&quot;.&quot;clock_in_date&quot; IS '打卡日期时间戳';
COMMENT ON COLUMN &quot;public&quot;.&quot;user_clock_in_rec&quot;.&quot;clock_in_type&quot; IS '打卡类型 1-指令打卡 2-补签卡补卡 3-积分补卡';
-- 用户签到打卡记录
CREATE TABLE &quot;user_year_clock_in_rec&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;clock_in_year&quot; int4 NOT NULL,
&quot;clock_in_text&quot; text COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;user_year_clock_in_rec&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_year_clock_in_rec_no_index&quot; ON &quot;sudoku_raffle&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;public&quot;.&quot;user_year_clock_in_rec&quot;.&quot;clock_in_year&quot; IS '打卡年份';
COMMENT ON COLUMN &quot;public&quot;.&quot;user_year_clock_in_rec&quot;.&quot;clock_in_text&quot; IS '打卡数据, 将每天的打卡记录按照一年以二进制存储, 0为当天未打卡 1为当天已打卡';
-- 用户频道道具仓库
CREATE TABLE &quot;user_poe_warehouse&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;content&quot; json,
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;user_poe_warehouse&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_poe_warehouse_no_index&quot; ON &quot;sudoku_raffle_award_relation&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;public&quot;.&quot;user_poe_warehouse&quot;.&quot;content&quot; IS '道具json存储';
-- 用户道具仓库变化记录
CREATE TABLE &quot;user_poe_warehouse_rec&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;type&quot; int4 NOT NULL NOT NULL,
&quot;count&quot; int4 NOT NULL NOT NULL,
&quot;direcon&quot; int4 NOT NULL NOT NULL,
&quot;before&quot; int4 NOT NULL NOT NULL,
&quot;after&quot; int4 NOT NULL NOT NULL,
&quot;updated_at&quot; int4 NOT NULL NOT NULL,
&quot;reason&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
ALTER TABLE &quot;user_poe_warehouse_rec&quot; OWNER TO &quot;yuanqq&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_poe_warehouse_rec_no_index&quot; ON &quot;award_conf&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;user_poe_warehouse_rec&quot;.&quot;type&quot; IS '道具类型 1:补签卡';
COMMENT ON COLUMN &quot;user_poe_warehouse_rec&quot;.&quot;direcon&quot; IS '1-增加 2-减少';
COMMENT ON COLUMN &quot;user_poe_warehouse_rec&quot;.&quot;updated_at&quot; IS '变动时间';
-- 默认配置
INSERT into case_set_default_resource (type, content) VALUES (20, '{&quot;nick_name_check_url&quot;: &quot;https://doc.changqian365.com/robot/IMG230208B59E422D8EF740A1A03783052EC2A3AE.jpg&quot;, &quot;nick_name_check_name&quot;: &quot;昵称校验&quot;, &quot;top_cover_url&quot;: &quot;https://doc.changqian365.com/robot/IMG230208B59E422D8EF740A1A03783052EC2A3AE.jpg&quot;, &quot;top_cover_name&quot;: &quot;顶部封面&quot;}')
INSERT into case_set_default_resource (type, content) VALUES (21, '{&quot;rookie_draw_url&quot;: &quot;https://doc.changqian365.com/robot/IMG2302211707F454D4F84140A602CACFED2A6E99.png&quot;,&quot;rookie_draw_name&quot;: &quot;新人抽奖默认封面&quot;}');
-- 创建表 command_red_packet_data_list
CREATE TABLE &quot;public&quot;.&quot;command_red_packet_data_list&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;crps_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; int4,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;sum_count&quot; int4,
&quot;total&quot; decimal
);
ALTER TABLE &quot;public&quot;.&quot;command_red_packet_data_list&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;command_red_packet_data_list&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 command_red_packet_data
CREATE TABLE &quot;public&quot;.&quot;command_red_packet_data&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;crps_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;sum_count&quot; int4,
&quot;participation_people&quot; int4,
&quot;win_a_prize_people&quot; int4,
&quot;total&quot; decimal,
&quot;issue&quot; decimal,
&quot;surplus&quot; decimal
);
ALTER TABLE &quot;public&quot;.&quot;command_red_packet_data&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;command_red_packet_data&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 command_red_packet_record
CREATE TABLE &quot;public&quot;.&quot;command_red_packet_record&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;crps_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;win_a_prize&quot; int4,
&quot;total&quot; decimal
);
ALTER TABLE &quot;public&quot;.&quot;command_red_packet_record&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;command_red_packet_record&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 command_red_packet_setting
CREATE TABLE &quot;public&quot;.&quot;command_red_packet_setting&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;packet_type&quot; int4,
&quot;status&quot; int4,
&quot;total&quot; decimal,
&quot;min_one_quota&quot; decimal,
&quot;max_one_quota&quot; decimal,
&quot;command&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;probability&quot; int4,
&quot;most_participation&quot; int4,
&quot;most_win_a_prize&quot; int4,
&quot;start_time&quot; int4,
&quot;end_time&quot; int4,
&quot;channel_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;channel_name&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;advanced_settings&quot; json
);
ALTER TABLE &quot;public&quot;.&quot;command_red_packet_setting&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;command_red_packet_setting&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 wallet_account
CREATE TABLE &quot;public&quot;.&quot;wallet_account&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;remaining&quot; decimal,
&quot;version&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;status&quot; int4
);
ALTER TABLE &quot;public&quot;.&quot;wallet_account&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;wallet_account&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 wallet_detail
CREATE TABLE &quot;public&quot;.&quot;wallet_detail&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;wallet_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;note&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;before&quot; decimal,
&quot;direction&quot; int4,
&quot;amount&quot; decimal,
&quot;after&quot; decimal,
&quot;create_time&quot; int4,
&quot;reason&quot; int4
);
ALTER TABLE &quot;public&quot;.&quot;wallet_detail&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;wallet_detail&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 customize_game
CREATE TABLE &quot;public&quot;.&quot;customize_game&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;last_time&quot; int4,
&quot;result&quot; int4
);
ALTER TABLE &quot;public&quot;.&quot;customize_game&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;customize_game&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 guess_number
CREATE TABLE &quot;public&quot;.&quot;guess_number&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;number&quot; int4,
&quot;integral&quot; int4,
&quot;last_time&quot; int4,
&quot;residual_opportunity&quot; int4,
&quot;result&quot; int4
);
ALTER TABLE &quot;public&quot;.&quot;guess_number&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;guess_number&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 report_list
CREATE TABLE &quot;public&quot;.&quot;report_list&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;handler&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;informant&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;status&quot; int4,
&quot;processing_time&quot; int4,
&quot;content&quot; json
);
ALTER TABLE &quot;public&quot;.&quot;report_list&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;report_list&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 reporting_duty_conf
CREATE TABLE &quot;public&quot;.&quot;reporting_duty_conf&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;settings&quot; json
);
ALTER TABLE &quot;public&quot;.&quot;reporting_duty_conf&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;reporting_duty_conf&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 guild_user_birthday
CREATE TABLE &quot;public&quot;.&quot;guild_user_birthday&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;constellation&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;birthday&quot; int4,
&quot;year&quot; int4,
&quot;month&quot; int4,
&quot;day&quot; int4,
&quot;status&quot; int4
);
ALTER TABLE &quot;public&quot;.&quot;guild_user_birthday&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;guild_user_birthday&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 guild_data_board
CREATE TABLE &quot;public&quot;.&quot;guild_data_board&quot; (
CREATE TABLE &quot;public&quot;.&quot;guild_data_board&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;date&quot; int4,
&quot;add_num&quot; int4,
&quot;remove_num&quot; int4,
&quot;net_increase&quot; int4,
&quot;people&quot; json
);
ALTER TABLE &quot;public&quot;.&quot;guild_data_board&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;guild_data_board&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 timing_setting
CREATE TABLE &quot;public&quot;.&quot;timing_setting&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; int4,
&quot;settings&quot; json
);
ALTER TABLE &quot;public&quot;.&quot;timing_setting&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;timing_setting&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 panel_guild_role
CREATE TABLE &quot;public&quot;.&quot;panel_guild_role&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;status&quot; int2,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; int4,
&quot;foundation&quot; json,
&quot;advanced_settings&quot; json,
&quot;instruction&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;channel&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;channel_name&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;command&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;
);
ALTER TABLE &quot;public&quot;.&quot;panel_guild_role&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;panel_guild_role&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- 创建表 panel_guild_role_choose
CREATE TABLE &quot;public&quot;.&quot;panel_guild_role_choose&quot; (
&quot;no_&quot; serial primary key,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0),
&quot;is_available&quot; int4 NOT NULL DEFAULT 1,
&quot;panel_guild_role_choose_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;panel_role_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;role_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;role_name&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;role_duration&quot; int4,
&quot;role_introduce&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;copy_writing&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;key_words&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;
);
ALTER TABLE &quot;public&quot;.&quot;panel_guild_role_choose&quot; OWNER TO &quot;haiwan&quot;;
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;panel_guild_role_choose&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-------------------------------- 1.0版本已上线-----------------------------
-- 创建数据表
-- 创建表 apscheduler_jobs
CREATE TABLE &quot;public&quot;.&quot;apscheduler_jobs&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;next_run_time&quot; float8,
&quot;job_state&quot; bytea,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 user
CREATE TABLE &quot;public&quot;.&quot;user&quot; (
&quot;no_&quot; serial primary key,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;union_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;is_bot&quot; int2,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 user_info
CREATE TABLE &quot;public&quot;.&quot;user_info&quot; (
&quot;no_&quot; serial primary key,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;uphone&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;uname&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;avatar&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;birthday&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;star_sign&quot; int2,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 third_party_auth
CREATE TABLE &quot;public&quot;.&quot;third_party_auth&quot; (
&quot;no_&quot; serial primary key,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;open_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;session_token&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;expired_in&quot; int8,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 guild
CREATE TABLE &quot;public&quot;.&quot;guild&quot; (
&quot;no_&quot; serial primary key,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gname&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;icon&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;owner_bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;member_count&quot; int4,
&quot;max_members&quot; int4,
&quot;desc&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;joined_at&quot; int4,
&quot;bot_status&quot; int4,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 channel
CREATE TABLE &quot;public&quot;.&quot;channel&quot; (
&quot;no_&quot; serial primary key,
&quot;cid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 guild_bot_user
CREATE TABLE &quot;public&quot;.&quot;guild_bot_user&quot; (
&quot;no_&quot; serial primary key,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 case_set_tmpl
CREATE TABLE &quot;public&quot;.&quot;case_set_tmpl&quot; (
&quot;no_&quot; serial primary key,
&quot;tmpl_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;name&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 case_set_field
CREATE TABLE &quot;public&quot;.&quot;case_set_field&quot; (
&quot;no_&quot; serial primary key,
&quot;name&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;tmpl_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;annotation&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 custom_case
CREATE TABLE &quot;public&quot;.&quot;custom_case&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;tmpl_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;status&quot; int4,
&quot;type&quot; int4,
&quot;content&quot; json,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 case_set_default_resource
CREATE TABLE &quot;public&quot;.&quot;case_set_default_resource&quot; (
&quot;no_&quot; serial primary key,
&quot;type&quot; int4,
&quot;content&quot; json,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 point_wallet
CREATE TABLE &quot;public&quot;.&quot;point_wallet&quot; (
&quot;no_&quot; serial primary key,
&quot;uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;balance&quot; int4,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 point_wallet_rec
CREATE TABLE &quot;public&quot;.&quot;point_wallet_rec&quot; (
&quot;no_&quot; serial primary key,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;amount&quot; int4,
&quot;direction&quot; int4,
&quot;balance_before&quot; int4,
&quot;update_at&quot; int4,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 guild_point_set
CREATE TABLE &quot;public&quot;.&quot;guild_point_set&quot; (
&quot;no_&quot; serial primary key,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;alias&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;detail&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 user_warning
CREATE TABLE &quot;public&quot;.&quot;user_warning&quot; (
&quot;no_&quot; serial primary key,
&quot;wid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;cid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;reason&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;warned_at&quot; int4,
&quot;status&quot; int4,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 robot_resp_event_log
CREATE TABLE &quot;public&quot;.&quot;robot_resp_event_log&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; int4,
&quot;time&quot; timestamp(0),
&quot;content&quot; json,
&quot;req_event_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 robot_req_event_log
CREATE TABLE &quot;public&quot;.&quot;robot_req_event_log&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; int4,
&quot;time&quot; timestamp(0),
&quot;content&quot; json,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 timing_tak
CREATE TABLE &quot;public&quot;.&quot;timing_tak&quot; (
&quot;no_&quot; serial primary key,
&quot;id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;gid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;type&quot; int4,
&quot;status&quot; int4,
&quot;addr&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;param&quot; json,
&quot;time&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;repeat&quot; int4,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 创建表 task_result
CREATE TABLE &quot;public&quot;.&quot;task_result&quot; (
&quot;no_&quot; serial primary key,
&quot;task_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;result&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;failure&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot;,
&quot;creation_time&quot; timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
&quot;update_time&quot; timestamp(0)
);
-- 定义触发器
create or replace function update_timestamp() returns trigger as
$$
begin
new.update_time= current_timestamp;
return new;
end
$$
language plpgsql;
-- 创建表之后才能添加权限和触发器
-- 添加权限
ALTER TABLE &quot;public&quot;.&quot;apscheduler_jobs&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;case_set_default_resource&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;case_set_field&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;case_set_tmpl&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;channel&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;custom_case&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;guild&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;guild_bot_user&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;guild_point_set&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;point_wallet&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;point_wallet_rec&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;robot_req_event_log&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;robot_resp_event_log&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;task_result&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;third_party_auth&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;timing_tak&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;user&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;user_info&quot; OWNER TO &quot;robot&quot;;
ALTER TABLE &quot;public&quot;.&quot;user_warning&quot; OWNER TO &quot;robot&quot;;
-- 添加触发器
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;apscheduler_jobs&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;case_set_default_resource&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;case_set_field&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;case_set_tmpl&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;channel&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;custom_case&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;guild&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;guild_bot_user&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;guild_point_set&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;point_wallet&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;point_wallet_rec&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;robot_req_event_log&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;robot_resp_event_log&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;task_result&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;third_party_auth&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;timing_tak&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;user&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;user_info&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;user_warning&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
</code></pre>