drop table votelist;

CREATE TABLE VoteList(
    Id                BIGINT   GENERATED ALWAYS AS IDENTITY ,
    UserIP            VARCHAR(12),
    VoteDate          VARCHAR(24),
    QPXW              CHAR(1),
    SHHXW             CHAR(1),
    SHXW              CHAR(1),
    GNXW              CHAR(1),
    GWXW              CHAR(1),
    JSXW              CHAR(1),
    LSXW              CHAR(1),
    XWFT              CHAR(1),
    Sports            CHAR(1),
    Finance           CHAR(1),
    Tech              CHAR(1),
    Entertainment1    CHAR(1),
    Entertainment2    CHAR(1),
    Entertainment3    CHAR(1),
    QPDL              CHAR(1),
    WSDP              CHAR(1),
    JIAOTONG          CHAR(1),
    ZHUSUDINGPIAO     CHAR(1),
    LYYJ              CHAR(1),
    BZMT              CHAR(1),
    REDIAN            CHAR(1),
    SHICHANG          CHAR(1),
    ERSHOUFANG        CHAR(1),
    ZUFANG            CHAR(1),
    JIAJUZHUANGXIU    CHAR(1),
    DAOGOU            CHAR(1),
    CHEXINGJIESHAO    CHAR(1),
    JIAOYUXINWEN      CHAR(1),
    CHUGUOLIUXUE      CHAR(1),
    PEIXUN            CHAR(1),
    JIUYEZIXUN        CHAR(1),
    JIAZHENG          CHAR(1),
    DUSHU             CHAR(1),
    TONGCHENGYIWU     CHAR(1),
    BOKESHEQU         CHAR(1),
    CONSTRAINT PK2 PRIMARY KEY (Id)
)
;