votelist_for_mysql.sql

来自「一个很不错的问卷调查页面 CSS做的很不错」· SQL 代码 · 共 48 行

SQL
48
字号


CREATE TABLE VoteList(
    Id                BIGINT         AUTO_INCREMENT,
    UserIP            VARCHAR(15),
    VoteDate          TIMESTAMP,
    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),
    PRIMARY KEY (Id)
)
;



⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?