Layer

From MapbenderWiki

CREATE TABLE layer (

 layer_id int(11) NOT NULL auto_increment,

 fkey_wms_id int(11) NOT NULL default '0',

 layer_pos int(11) NOT NULL default '0',

 layer_parent varchar(50) NOT NULL default ,

 layer_name varchar(50) NOT NULL default ,

 layer_title varchar(50) NOT NULL default ,

 layer_queryable smallint(6) NOT NULL default '0',

 layer_minscale int(11) default '0',

 layer_maxscale int(11) default '0',

 layer_dataurl varchar(255),

 PRIMARY KEY  (layer_id),

 KEY wms_index (fkey_wms_id)

) TYPE=InnoDB;