QQ机器人v2.0版本
<pre><code class="language-sql">
-- 清空机器人字段
UPDATE &quot;public&quot;.&quot;user&quot; SET &quot;bot_uid&quot; = NULL;
------------------------签到系列-------------------------------
-- 用户签到打卡记录
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;,
&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),
-- ID唯一
CONSTRAINT &quot;user_clock_in_rec_id_unique_check&quot; UNIQUE (&quot;id&quot;)
);
ALTER TABLE &quot;user_clock_in_rec&quot; OWNER TO &quot;haiwan&quot;;
-- 触发器
CREATE TRIGGER &quot;user_clock_in_rec_update_at&quot; BEFORE UPDATE ON &quot;user_clock_in_rec&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
-- no_索引
CREATE UNIQUE INDEX &quot;user_clock_in_rec_no_index&quot; ON &quot;user_clock_in_rec&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;,
&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),
-- ID唯一
CONSTRAINT &quot;user_year_clock_in_rec_id_unique_check&quot; UNIQUE (&quot;id&quot;),
-- 一个用户同一个频道一年记录唯一
CONSTRAINT &quot;user_year_clock_in_rec_user_guild_year_clock_in_unique_check&quot; UNIQUE (&quot;gid&quot;, &quot;bot_uid&quot;, &quot;clock_in_year&quot;)
);
-- 触发器
CREATE TRIGGER &quot;user_year_clock_in_rec_update_at&quot; BEFORE UPDATE ON &quot;user_year_clock_in_rec&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;user_year_clock_in_rec&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_year_clock_in_rec_no_index&quot; ON &quot;user_year_clock_in_rec&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;point_account&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;,
&quot;bot_uid&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;balance&quot; int4,
&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),
-- ID唯一
CONSTRAINT &quot;point_account_id_unique_check&quot; UNIQUE (&quot;id&quot;),
-- 一个用户一个频道一个积分钱包
CONSTRAINT &quot;point_account_user_guild_point_account_unique&quot; UNIQUE (&quot;gid&quot;, &quot;bot_uid&quot;)
);
-- 触发器
CREATE TRIGGER &quot;point_account_update_at&quot; BEFORE UPDATE ON &quot;point_account&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;point_account&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;point_account_no_index&quot; ON &quot;point_account&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 用户积分变化记录
CREATE TABLE &quot;point_account_rec&quot; (
&quot;no_&quot; serial primary key,
&quot;point_acct_id&quot; varchar COLLATE &quot;pg_catalog&quot;.&quot;default&quot; NOT NULL,
&quot;balance_before&quot; int4 NOT NULL,
&quot;amount&quot; int4 NOT NULL,
&quot;balance_after&quot; int4 NOT NULL,
&quot;update_at&quot; int4 NOT NULL NOT NULL,
&quot;reason&quot; int4 NOT NULL,
&quot;note&quot; varchar,
&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)
);
-- 触发器
CREATE TRIGGER &quot;point_account_rec_update_at&quot; BEFORE UPDATE ON &quot;point_account_rec&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;point_account_rec&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;point_account_rec_no_index&quot; ON &quot;point_account_rec&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
-- 字段注释
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;point_acct_id&quot; IS '用户积分账号ID';
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;balance_before&quot; IS '变动前积分余额';
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;amount&quot; IS '变动金额';
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;balance_after&quot; IS '变动后积分余额';
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;update_at&quot; IS '变动时间';
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;reason&quot; IS '变动类型';
COMMENT ON COLUMN &quot;point_account_rec&quot;.&quot;note&quot; IS '变动说明';
-- 用户频道道具仓库
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;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;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),
-- ID唯一
CONSTRAINT &quot;user_poe_warehouse_id_unique_check&quot; UNIQUE (&quot;id&quot;),
-- 一个用户一个频道一个道具仓库
CONSTRAINT &quot;user_poe_warehouse_user_guild_poe_warehouse_unique&quot; UNIQUE (&quot;gid&quot;, &quot;bot_uid&quot;)
);
-- 触发器
CREATE TRIGGER &quot;user_poe_warehouse_update_at&quot; BEFORE UPDATE ON &quot;user_poe_warehouse&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;user_poe_warehouse&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_poe_warehouse_no_index&quot; ON &quot;user_poe_warehouse&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;direction&quot; int4 NOT NULL NOT NULL,
&quot;before&quot; int4 NOT NULL NOT NULL,
&quot;after&quot; int4 NOT NULL NOT NULL,
&quot;update_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),
-- ID唯一
CONSTRAINT &quot;user_poe_warehouse_rec_id_unique_check&quot; UNIQUE (&quot;id&quot;)
);
-- 触发器
CREATE TRIGGER &quot;user_poe_warehouse_rec_update_at&quot; BEFORE UPDATE ON &quot;user_poe_warehouse_rec&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;user_poe_warehouse_rec&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;user_poe_warehouse_rec_no_index&quot; ON &quot;user_poe_warehouse_rec&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;direction&quot; IS '1-增加 2-减少';
COMMENT ON COLUMN &quot;user_poe_warehouse_rec&quot;.&quot;update_at&quot; IS '变动时间';
-- 每日一言类型
CREATE TABLE &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)
);
-- 更新时间触发器
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;every_day_saying_type&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;public&quot;.&quot;every_day_saying_type&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;biz_acct_dept_basis_data_no&quot; ON &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;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)
);
-- 更新时间触发器
CREATE TRIGGER &quot;update_at&quot; BEFORE UPDATE ON &quot;every_day_saying&quot; FOR EACH ROW EXECUTE PROCEDURE &quot;update_timestamp&quot;();
ALTER TABLE &quot;public&quot;.&quot;every_day_saying&quot; OWNER TO &quot;haiwan&quot;;
-- no_索引
CREATE UNIQUE INDEX &quot;every_day_saying_no&quot; ON &quot;every_day_saying&quot; USING btree (&quot;no_&quot; &quot;pg_catalog&quot;.&quot;int4_ops&quot; ASC NULLS LAST);
----------------------------------------------------------------------------
-- 默认配置
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; (
&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;();</code></pre>