webform.mysql

来自「对于。Net最新的MVC开发方式提供自动对类的注入Webform」· MYSQL 代码 · 共 32 行

CREATE TABLE webform 
  ( nid int(10) unsigned not null,
    confirmation text, 
    email varchar(255),
    primary key(nid));

CREATE TABLE webform_component 
  ( nid int(10) unsigned not null, 
    cid int(10) unsigned not null, 
    name varchar(128), 
    type varchar(16), 
    value varchar(128),
    extra text, 
    mandatory int(2) unsigned, 
    weight int(2),
    PRIMARY KEY(nid, cid));

CREATE TABLE webform_role_node 
  ( nid int(10) unsigned not null,
    rid int(10) unsigned not null,
    PRIMARY KEY(nid, rid));

CREATE TABLE webform_submitted_data
  ( nid int(10) unsigned not null, 
    sid int(10) unsigned not null, 
    name varchar(255) not null,
    data longtext,
    PRIMARY KEY(nid, sid, name));

-- Setting default variables
INSERT INTO variable VALUES ('webform_version', 'a:2:{s:4:"text";s:5:"4.6.2";s:5:"build";i:462;}');