QQ机器人v2.2版本
<pre><code>-- 奖励配置表
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;robot&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-红包 3-自定义 4-奖励组 5-频道活动抽奖 99-其他';
COMMENT ON COLUMN &quot;award_conf&quot;.&quot;type&quot; IS '奖项类型, 1-自定义奖励 2-现金红包 3-积分 4-身份组 5-补签卡 6-兑换码 99-其他';
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;bot_uid&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;robot&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 '中奖时间';</code></pre>