Database Changes 2.2.3

From MapbenderWiki

MySQL:

ALTER TABLE gui_element_vars CHANGE var_name var_name VARCHAR(50); CREATE TABLE mb_user_wmc ( wmc_id varchar(20) NOT NULL default '', fkey_user_id int(11) NOT NULL default '0', wmc longtext NOT NULL, wmc_title varchar(50) default NULL, wmc_timestamp int(10) default NULL, KEY fkey_user_id (fkey_user_id) ) TYPE=InnoDB; ALTER TABLE `mb_user_wmc` ADD CONSTRAINT `mb_user_wmc_ibfk_1` FOREIGN KEY (`fkey_user_id`) REFERENCES `mb_user` (`mb_user_id`) ON DELETE CASCADE ON UPDATE CASCADE;

PostgreSQL:

-- -- size of varchar changed from 255 to 50 -- ALTER TABLE gui_element_vars ALTER var_name TYPE varchar(50); -- -- new table: mb_user_wmc -- CREATE TABLE mb_user_wmc ( wmc_id character varying(20) DEFAULT '' NOT NULL , fkey_user_id integer DEFAULT 0 NOT NULL , wmc text NOT NULL, wmc_title character varying(50) DEFAULT NULL , wmc_timestamp integer DEFAULT NULL ); ALTER TABLE ONLY mb_user_wmc ADD CONSTRAINT mb_user_wmc_ibfk_1 FOREIGN KEY (fkey_user_id) REFERENCES mb_user (mb_user_id) ON UPDATE CASCADE ON DELETE CASCADE;