Gui element

From MapbenderWiki

MySQL

CREATE TABLE gui_element (
 fkey_gui_id varchar(50) NOT NULL default ,
 e_id varchar(50) NOT NULL default ,
 e_pos tinyint(4) unsigned zerofill default NULL,
 e_public tinyint(1) unsigned zerofill default NULL,
 e_comment text,
 e_element varchar(255) NOT NULL default ,
 e_src varchar(255) default NULL,
 e_attributes longtext,
 e_left int(4) default NULL,
 e_top int(4) default NULL,
 e_width int(4) unsigned default NULL,
 e_height int(4) unsigned default NULL,
 e_z_index tinyint(3) unsigned default NULL,
 e_more_styles longtext,
 e_content longtext,
 e_closetag varchar(255) default NULL,
 e_js_file varchar(50) default NULL,
 e_mb_mod varchar(50) default NULL,
 e_target varchar(50) default NULL,
 e_requires varchar(50) default NULL,
 PRIMARY KEY  (fkey_gui_id,e_id),
 KEY idx_gui_id_e_id (fkey_gui_id,e_id)
) TYPE=InnoDB;

ALTER TABLE `gui_element` CHANGE `e_closeTag` `e_closetag` VARCHAR(255);

PostgreSQL

CREATE TABLE gui_element

(
 fkey_gui_id varchar(50) NOT NULL DEFAULT ::character varying,
 e_id varchar(50) NOT NULL DEFAULT ::character varying,
 e_pos int4,
 e_public int4,
 e_comment text,
 e_element varchar(255) NOT NULL DEFAULT ::character varying,
 e_src varchar(255),
 e_attributes text,
 e_left int4,
 e_top int4,
 e_width int4,
 e_height int4,
 e_z_index int4,
 e_more_styles text,
 e_content text,
 e_closetag varchar(255),
 e_js_file varchar(50),
 e_mb_mod varchar(50),
 e_target varchar(50),
 e_requires varchar(50),
 CONSTRAINT pk_fkey_gui_id PRIMARY KEY (fkey_gui_id, e_id),
 CONSTRAINT gui_element_ibfk1 FOREIGN KEY (fkey_gui_id) REFERENCES gui (gui_id) ON UPDATE CASCADE ON DELETE CASCADE
) 
WITH OIDS;

ALTER TABLE gui_element Rename Column "e_closeTag" TO e_closetag;