CREATE TABLE WebSimpleList_fields
(
    module_id BIGINT UNSIGNED NOT NULL DEFAULT '0',
    field VARCHAR(50) NOT NULL DEFAULT '',
    isLinked TINYINT DEFAULT 0,
    sortOrder TINYINT DEFAULT 0,
    PRIMARY KEY ( module_id,field ),
    KEY ( module_id ),
    FOREIGN KEY ( module_id ) REFERENCES Module ( id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Fields to be displayed by WebSimpleList in table";
