root/form/mysql.sql

CREATE TABLE prefix_forms (
        ident int(11) NOT NULL auto_increment,
        name varchar(128) NOT NULL,
        title text,
        description text,
    response_text text,
    created int(11) NOT NULL,
    owner int(11) NOT NULL,
    access varchar(20) NOT NULL,
    notification int(1) NOT NULL,
    PRIMARY KEY  (ident),
    KEY owner (owner),
    KEY access (access),
    UNIQUE KEY name (name)
);

CREATE TABLE prefix_form_fields (
    ident int(11) NOT NULL auto_increment,
    internal_name varchar(128) NOT NULL,
    original_internal_name varchar(128) NOT NULL,
    field_type varchar(128) NOT NULL,
    title text,
    description text,
    default_value text,
    category varchar(128),
    required int(1),
    profile int(1),
    invisible int(1),
    col int(1),
    is_keyword_tag int(1),
    default_access varchar(20),
    choice_type varchar(20),
    orientation varchar(20),
    PRIMARY KEY  (ident),
    UNIQUE KEY internal_name (internal_name)
);

CREATE TABLE prefix_form_fields_choice (
    ident int(11) NOT NULL auto_increment,
    field_id int(11) NOT NULL,
    group_id int(11) NOT NULL,
    value varchar(128) NOT NULL,
    label text,
    PRIMARY KEY  (ident)
);

CREATE TABLE prefix_form_fields_map (
    ident int(11) NOT NULL auto_increment,
    form_id int(11) NOT NULL,
    field_id int(11) NOT NULL,
    display_order int(11) NOT NULL,
    PRIMARY KEY  (ident),
    KEY form_id (form_id)
);

CREATE TABLE prefix_form_data (
    ident int(11) NOT NULL auto_increment,
    name varchar(128) NOT NULL,
    value text NOT NULL,
    form_id int(11) NOT NULL,
    field_id int(11) NOT NULL,
    map_id int(11) NOT NULL,
    profile_id int(11) NOT NULL,
    created int(11) NOT NULL,
    owner int(11) NOT NULL,  
    PRIMARY KEY  (ident),
    KEY name (name),
    KEY form_id (form_id),
    KEY field_id (field_id),
    KEY map_id (map_id),
    KEY owner (owner)
);