#A4# #mb_group# ## ## #mb_group_id# #integer# ## ## #mb_group_name# #varchar(50)# #'' NOT NULL# ## #mb_group_owner# #integer# ## ## #mb_group_description# #varchar(255)# #'' NOT NULL# ## #mb_user# ## ## #mb_user_id# #integer# ## ## #mb_user_name# #varchar(50)# #'' NOT NULL# ## #mb_user_password# #varchar(50)# #'' NOT NULL# ## #mb_user_owner# #integer# #0 NOT NULL# ## #mb_user_description# #varchar(255)# ## ## #mb_user_login_count# #integer# #0 NOT NULL# ## #mb_user_email# #varchar(50)# ## ## #mb_user_phone# #varchar(50)# ## ## #mb_user_department# #varchar(255)# ## ## #mb_user_resolution# #integer# #72 NOT NULL# ## #mb_user_organisation_name# #varchar(255)# ## ## #mb_user_position_name# #varchar(255)# ## ## #mb_user_phone1# #varchar(255)# ## ## #mb_user_facsimile# #varchar(255)# ## ## #mb_user_delivery_point# #varchar(255)# ## ## #mb_user_city# #varchar(255)# ## ## #mb_user_postal_code# #integer# ## ## #mb_user_country# #varchar(255)# ## ## #mb_user_online_resource# #varchar(255)# ## ## #mb_user_mb_group# ## ## #fkey_mb_user_id# #integer# #0# ## #fkey_mb_group_id# #integer# #0# ## ## #mb_user_id# ## #fkey_mb_user_id# #on delete cascade on update cascade# ## #mb_group_id# ## #fkey_mb_group_id# #on delete cascade on update cascade# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_user','mb_user_id'), (SELECT max(mb_user_id) FROM mb_user), true);# #innodb:pre# #ALTER TABLE mb_user CHANGE COLUMN mb_user_id mb_user_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE mb_user_id_seq; ALTER TABLE mb_user ALTER COLUMN mb_user_id SET DEFAULT nextval('mb_user_id_seq'::regclass);# #innodb:pre# #ALTER TABLE mb_group CHANGE COLUMN mb_group_id mb_group_id integer NOT NULL AUTO_INCREMENT;# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_group','mb_group_id'), (SELECT max(mb_group_id) FROM mb_group), true);# #postgres:pre# #CREATE SEQUENCE mb_group_id_seq; ALTER TABLE mb_group ALTER COLUMN mb_group_id SET DEFAULT nextval('mb_group_id_seq'::regclass);# #gui# ## ## #gui_id# #varchar(50)# ## ## #gui_name# #varchar(50)# #'' not null# ## #gui_description# #varchar(255)# #'' not null# ## #gui_public# #integer# #1 not null# ## #gui_element# ## ## #fkey_gui_id# #varchar(50)# #''# ## #e_id# #varchar(50)# #''# ## #e_pos# #integer# ## ## #e_public# #integer# ## ## #e_comment# #text# ## ## #e_title# #varchar(255)# ## ## #e_element# #varchar(255)# #'' NOT NULL# ## #e_attributes# #text# ## ## #e_left# #integer# ## ## #e_tio# #integer# ## ## #e_width# #integer# ## ## #e_height# #integer# ## ## #e_z_index# #integer# ## ## #e_more_styles# #text# ## ## #e_content# #text# ## ## #e_closetag# #varchar(255)# ## ## #e_js_file# #varchar(255)# ## ## #e_mb_mod# #varchar(255)# ## ## #e_target# #varchar(50)# ## ## #e_requires# #varchar(50)# ## ## #e_url# #varchar(255)# ## ## #gui_element_idx# #btree# #unique index# ## #fkey_gui_id# ## ## ## #e_id# ## ## ## #gui_element_vars# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_e_id# #varchar(50)# #''# ## #var_name# #varchar(50)# #''# ## #var_value# #text# ## ## #context# #text# ## ## #var_type# #varchar(50)# ## ## #gui_element_vars_idx# #btree# #index# ## #fkey_gui_id# ## ## ## #fkey_e_id# ## ## ## ## #fkey_gui_id,e_id# ## #fkey_gui_id,fkey_e_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# #gui_mb_user# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_mb_user_id# #integer# #0# ## #mb_user_type# #varchar(50)# ## ## ## #mb_user_id# ## #fkey_mb_user_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# #wms# ## ## #wms_id# #integer# ## ## #wms_version# #varchar(50)# #'' NOT NULL# ## #wms_title# #varchar(255)# #'' NOT NULL# ## #wms_abstract# #text# ## ## #wms_getcapabilities# #varchar(255)# #'' NOT NULL# ## #wms_getmap# #varchar(255)# #'' NOT NULL# ## #wms_getfeatureinfo# #varchar(255)# #'' NOT NULL# ## #wms_getlegendurl# #varchar(255)# ## ## #wms_filter# #varchar(255)# ## ## #wms_getcapabilities_doc# #text# ## ## #wms_owsproxy# #varchar(50)# ## ## #wms_upload_url# #varchar(255)# ## ## #fees# #text# ## ## #accessconstraints# #text# ## ## #contactperson# #varchar(255)# ## ## #contactposition# #varchar(255)# ## ## #contactorganization# #varchar(255)# ## ## #address# #varchar(255)# ## ## #city# #varchar(255)# ## ## #stateorprovince# #varchar(255)# ## ## #postcode# #varchar(255)# ## ## #country# #varchar(255)# ## ## #contactvoicetelephone# #varchar(255)# ## ## #contactfacsimiletelephone# #varchar(255)# ## ## #contactelectronicmailaddress# #varchar(255)# ## ## #wms_mb_getcapabilities_doc# #text# ## ## #wms_owner# #integer# ## ## #wms_timestamp# #integer# ## ## #wms_supportsld# #boolean# ## ## #wms_userlayer# #boolean# ## ## #wms_userstyle# #boolean# ## ## #wms_remotewfs# #boolean# ## ## #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wms','wms_id'), (SELECT max(wms_id) FROM wms), true);# #innodb:pre# #ALTER TABLE wms CHANGE COLUMN wms_id wms_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE wms_id_seq; ALTER TABLE wms ALTER COLUMN wms_id SET DEFAULT nextval('wms_id_seq'::regclass);# #layer# ## ## #layer_id# #integer# ## ## #fkey_wms_id# #integer# #0 NOT NULL# ## #layer_pos# #integer# #0 NOT NULL# ## #layer_parent# #varchar(50)# #'' NOT NULL# ## #layer_name# #varchar(255)# #'' NOT NULL# ## #layer_title# #varchar(255)# #'' NOT NULL# ## #layer_queryable# #integer# #0 NOT NULL# ## #layer_minscale# #integer# #0# ## #layer_maxscale# #integer# #0# ## #layer_dataurl# #varchar(255)# ## ## #layer_metadataurl# #varchar(255)# ## ## #layer_abstract# #text# ## ## #gui_layer# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_layer_id# #integer# #0# ## #gui_layer_wms_id# #integer# #0# ## #gui_layer_status# #integer# #1# ## #gui_layer_selectable# #integer# #1# ## #gui_layer_visible# #integer# #1# ## #gui_layer_queryable# #integer# #0# ## #gui_layer_minscale# #integer# #0# ## #gui_layer_maxscale# #integer# #0# ## #gui_layer_priotity# #integer# ## ## #gui_layer_style# #varchar(50)# ## ## #gui_layer_wfs_featuretype# #varchar(50)# ## ## #wfs# ## ## #wfs_id# #integer# ## ## #wfs_version# #varchar(50)# #'' NOT NULL# ## #wfs_name# #varchar(255)# ## ## #wfs_title# #varchar(255)# #'' NOT NULL# ## #wfs_abstract# #text# ## ## #wfs_getcapabilities# #varchar(255)# #'' NOT NULL# ## #wfs_getfeature# #varchar(255)# ## ## #wfs_transaction# #varchar(255)# ## ## #wfs_owsproxy# #varchar(50)# ## ## #wfs_getcapabilities_doc# #text# ## ## #wfs_upload_url# #varchar(255)# ## ## #fees# #varchar(255)# ## ## #accessconstraints# #text# ## ## #individualname# #varchar(255)# ## ## #positionname# #varchar(255)# ## ## #providername# #varchar(255)# ## ## #city# #varchar(255)# ## ## #deliverypoint# #varchar(255)# ## ## #postalcode# #varchar(255)# ## ## #voice# #varchar(255)# ## ## #facsimile# #varchar(255)# ## ## #electronicmailaddress# #varchar(255)# ## ## #wfs_mb_getcapabilities_doc# #text# ## ## #wfs_owner# #integer# ## ## #wfs_timestamp# #integer# ## ## #country# #varchar(255)# ## ## ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# ## #wms_id# ## #fkey_wms_id# #on delete cascade on update cascade# #gui_wfs# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_wfs_id# #integer# #0# ## ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# ## #wfs_id# ## #fkey_wfs_id# #on delete cascade on update cascade# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs','wfs_id'), (SELECT max(wfs_id) FROM wfs), true);# #innodb:pre# #ALTER TABLE wfs CHANGE COLUMN wfs_id wfs_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE wfs_id_seq; ALTER TABLE wfs ALTER COLUMN wfs_id SET DEFAULT nextval('wfs_id_seq'::regclass);# #gui_mb_group# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_mb_group_id# #integer# #0# ## #mb_group_type# #varchar(50)# #'' NOT NULL# ## ## #mb_group_id# ## #fkey_mb_group_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# #gui_wms# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_wms_id# #integer# #0# ## #gui_wms_position# #integer# #0 NOT NULL# ## #gui_wms_mapformat# #varchar(50)# #'' NOT NULL# ## #gui_wms_featureinfoformat# #varchar(50)# #'' NOT NULL# ## #gui_wms_exceptionformat# #varchar(50)# #'' NOT NULL# ## #gui_wms_epsg# #varchar(50)# #'' NOT NULL# ## #gui_wms_visible# #integer# #1 NOT NULL# ## #gui_wms_sldurl# #varchar(255)# #'' NOT NULL# ## #gui_wms_opacity# #integer# #100# ## #gui_wms_idx# #btree# #unique index# ## #fkey_gui_id# ## ## ## #fkey_wms_id# ## ## ## ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# ## #wms_id# ## #fkey_wms_id# #on delete cascade on update cascade# #wfs_conf# ## ## #wfs_conf_id# #integer# ## ## #wfs_conf_abstract# #text# ## ## #fkey_wfs_id# #integer# #0 NOT NULL# ## #fkey_featuretype_id# #integer# #0 NOT NULL# ## #g_label# #varchar(50)# ## ## #g_label_id# #varchar(50)# ## ## #g_button# #varchar(50)# ## ## #g_button_id# #varchar(50)# ## ## #g_style# #text# ## ## #g_buffer# #double# #0# ## #g_res_style# #text# ## ## #g_use_wzgraphics# #integer# #0# ## #wfs_conf_description# #text# ## ## #wfs_featuretype# ## ## #fkey_wfs_id# #integer# #0 NOT NULL# ## #featuretype_id# #integer# ## ## #featuretype_name# #varchar(255)# #'' NOT NULL# ## #featuretype_title# #varchar(255)# ## ## #featuretype_srs# #varchar(50)# ## ## #featuretype_searchable# #integer# #1# ## #featuretype_abstract# #text# ## ## ## #wfs_id# ## #fkey_wfs_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# ## #wfs_id# ## #fkey_wfs_id# #on delete cascade on update cascade# #wfs_element# ## ## #fkey_featuretype_id# #integer# #0# ## #element_id# #integer# ## ## #element_name# #varchar(255)# ## ## #element_type# #varchar(255)# ## ## #wfs_element_idx# #btree# #unique index# ## #fkey_featuretype_id# ## ## ## #element_id# ## ## ## ## #featuretype_id# ## #fkey_featuretype_id# #on delete cascade on update cascade# #wms_format# ## ## #fkey_wms_id# #integer# #0# ## #data_type# #varchar(50)# #''# ## #data_format# #varchar(100)# #''# ## ## #wms_id# ## #fkey_wms_id# #on delete cascade on update cascade# #wms_srs# ## ## #fkey_wms_id# #integer# #0# ## #wms_srs# #varchar(50)# #''# ## ## #wms_id# ## #fkey_wms_id# #on delete cascade on update cascade# #wms_md_topic_category# ## ## #fkey_wms_id# #integer# #0# ## #fkey_md_topic_category_id# #integer# ## ## ## #wms_id# ## #fkey_wms_id# #on delete cascade on update cascade# #md_topic_category# ## ## #md_topic_category_id# #integer# ## ## #md_topic_category_code_en# #varchar(255)# ## ## #md_topic_category_code_de# #varchar(255)# ## ## ## #md_topic_category_id# ## #fkey_md_topic_category_id# #on delete cascade on update cascade# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs_element','wfs_element_id'), (SELECT max(wfs_element_id) FROM wfs_element), true);# #innodb:pre# #ALTER TABLE wfs_element CHANGE COLUMN element_id element_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE wfs_element_id_seq; ALTER TABLE wfs_element ALTER COLUMN element_id SET DEFAULT nextval('wfs_element_id_seq'::regclass);# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs_featuretype','wfs_featuretype_id'), (SELECT max(wfs_featuretype_id) FROM wfs_featuretype), true);# #innodb:pre# #ALTER TABLE wfs_featuretype CHANGE COLUMN featuretype_id featuretype_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE wfs_featuretype_id_seq; ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_id SET DEFAULT nextval('wfs_featuretype_id_seq'::regclass);# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('layer','layer_id'), (SELECT max(layer_id) FROM layer), true);# #innodb:pre# #ALTER TABLE layer CHANGE COLUMN layer_id layer_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE layer_id_seq; ALTER TABLE layer ALTER COLUMN layer_id SET DEFAULT nextval('layer_id_seq'::regclass);# #gui_wfs_conf# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_wfs_conf_id# #integer# #0# ## ## #wfs_conf_id# ## #fkey_wfs_conf_id# #on delete cascade on update cascade# ## #featuretype_id# ## #fkey_featuretype_id# #on delete cascade on update cascade# #gui_kml# ## ## #kml_id# #integer# ## ## #fkey_mb_user_id# #integer# #NOT NULL# ## #fkey_gui_id# #varchar(50)# ## ## #kml_doc# #text# #NOT NULL# ## #kml_name# #varchar(64)# ## ## #kml_description# #text# ## ## #kml_timestamp# #integer# #NOT NULL# ## #gui_treegde# ## ## #fkey_gui_id# #varchar(50)# #''# ## #fkey_layer_id# #integer# ## ## #id# #integer# ## ## #lft# #integer# #0# ## #rgt# #integer# #0# ## #my_layer_title# #varchar(50)# ## ## #layer# #text# ## ## #wms_id# #text# ## ## #gui_treegde_idx# #btree# #unique index# ## #fkey_gui_id# ## ## ## #id# ## ## ## #lft# ## ## ## #rgt# ## ## ## #keyword# ## ## #keyword_id# #integer# ## ## #keyword# #varchar(255)# #'' NOT NULL# ## #keyword_idx# #btree# #unique index# ## #keyword# ## ## ## #layer_style# ## ## #fkey_layer_id# #integer# #0 NOT NULL# ## #name# #varchar(50)# #'' NOT NULL# ## #title# #varchar(100)# #'' NOT NULL# ## #legendurl# #varchar(255)# ## ## #legendurlformat# #varchar(50)# ## ## ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# #layer_epsg# ## ## #fkey_layer_id# #integer# #0 NOT NULL# ## #epsg# #varchar(50)# #'' NOT NULL# ## #minx# #double# #0# ## #miny# #double# #0# ## #maxx# #double# #0# ## #maxy# #double# #0# ## ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# #layer_load_count# ## ## #fkey_layer_id# #integer# #0 NOT NULL# ## #load_count# #integer# #0 NOT NULL# ## ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# #layer_keyword# ## ## #fkey_layer_id# #integer# ## ## #fkey_keyword_id# #integer# ## ## ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# ## #keyword_id# ## #fkey_keyword_id# #on delete cascade on update cascade# #mb_log# ## ## #id# #integer# ## ## #time_client# #varchar(13)# #'0'# ## #time_server# #varchar(13)# ## ## #time_readable# #varchar(50)# ## ## #mb_session# #varchar(50)# ## ## #gui# #varchar(50)# ## ## #module# #varchar(50)# ## ## #ip# #varchar(20)# ## ## #username# #varchar(50)# ## ## #userid# #varchar(50)# ## ## #request# #text# ## ## #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('mb_log','id'), (SELECT max(id) FROM mb_log), true);# #innodb:pre# #ALTER TABLE mb_log CHANGE COLUMN id id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE mb_log_id_seq; ALTER TABLE mb_log ALTER COLUMN mb_log_id SET DEFAULT nextval('mb_log_id_seq'::regclass);# #mb_monitor# ## ## #upload_id# #varchar(255)# #''# ## #fkey_wms_id# #integer# #0# ## #status# #integer# #0 NOT NULL# ## #status_comment# #varchar(255)# #'' NOT NULL# ## #timestamp_begin# #integer# #NOT NULL# ## #timestamp_end# #integer# #NOT NULL# ## #upload_url# #varchar(255)# #'' NOT NULL# ## #updated# #char(1)# ## ## #image# #integer# ## ## #map_url# #varchar(2048)# ## ## ## #wms_id# ## #fkey_wms_id# #on delete cascade on update cascade# #mb_user_wmc# ## ## #wmc_id# #varchar(20)# ## ## #fkey_user_id# #integer# #0 NOT NULL# ## #wmc# #text# ## ## #wmc_title# #varchar(50)# ## ## #wmc_timestamp# #integer# ## ## ## #mb_user_id# ## #fkey_user_id# #on delete cascade on update cascade# ## #mb_user_id# ## #fkey_mb_user_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# #translations# ## ## #trs_id# #integer# ## ## #locale# #varchar(8)# #'0'# ## #msgid# #varchar(512)# ## ## #msgstr# #varchar(512)# ## ## #msg_id_idx# #btree# #index# ## #msgid# ## ## ## #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('translations','trs_id'), (SELECT max(trs_id) FROM translations), true);# #innodb:pre# #ALTER TABLE translations CHANGE COLUMN trs_id trs_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE translations_id_seq; ALTER TABLE translations ALTER COLUMN trs_id SET DEFAULT nextval('translations_id_seq'::regclass);# #wfs_conf_element# ## ## #wfs_conf_element_id# #integer# ## ## #fkey_wfs_conf_id# #integer# #0 NOT NULL# ## #f_id# #integer# #0 NOT NULL# ## #f_geom# #integer# #0# ## #f_gid# #integer# #0 NOT NULL# ## #f_search# #integer# ## ## #f_pos# #integer# ## ## #f_style_id# #varchar(255)# ## ## #f_toupper# #integer# ## ## #f_label# #varchar(255)# ## ## #f_label_id# #varchar(50)# ## ## #f_show# #integer# ## ## #f_respos# #integer# ## ## #f_form_element_html# #text# ## ## #f_edit# #integer# ## ## #f_mandatory# #integer# ## ## #f_auth_varname# #varchar(255)# ## ## #f_show_detail# #integer# ## ## #f_operator# #varchar(50)# ## ## ## #wfs_conf_id# ## #fkey_wfs_conf_id# #on delete cascade on update cascade# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs_conf_element','wfs_conf_element_id'), (SELECT max(wfs_conf_element_id) FROM wfs_conf_element), true);# #innodb:pre# #ALTER TABLE wfs_conf_element CHANGE COLUMN wfs_conf_element_id wfs_conf_element_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE wfs_conf_element_id_seq; ALTER TABLE wfs_conf_element ALTER COLUMN wfs_conf_element_id SET DEFAULT nextval('wfs_conf_element_id_seq'::regclass);# #wfs_featuretype_keyword# ## ## #fkey_featuretype_id# #integer# #NOT NULL# ## #fkey_keyword_id# #integer# #NOT NULL# ## #wfs_featuretype_namespace# ## ## #fkey_wfs_id# #integer# ## ## #fkey_featuretype_id# #integer# ## ## #namespace# #varchar(255)# #''# ## #namespace_location# #varchar(255)# #'' NOT NULL# ## ## #featuretype_id# ## #fkey_featuretype_id# #on delete cascade on update cascade# ## #wfs_id# ## #fkey_wfs_id# #on delete cascade on update cascade# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('wfs_conf','wfs_conf_id'), (SELECT max(wfs_conf_id) FROM wfs_conf), true);# #innodb:pre# #ALTER TABLE wfs_conf CHANGE COLUMN wfs_conf_id wfs_conf_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE wfs_conf_id_seq; ALTER TABLE wfs_conf ALTER COLUMN wfs_conf_id SET DEFAULT nextval('wfs_conf_id_seq'::regclass);# ## #featuretype_id# ## #fkey_featuretype_id# #on delete cascade on update cascade# ## #keyword_id# ## #fkey_keyword_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# #sld_user_layer# ## ## #sld_user_layer_id# #integer# ## ## #fkey_mb_user_id# #integer# #NOT NULL# ## #fkey_layer_id# #integer# #NOT NULL# ## #fkey_gui_id# #varchar(50)# ## ## #sld_xml# #text# ## ## #use_sld# #integer# ## ## #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('sld_user_layer','sld_user_layer_id'), (SELECT max(sld_user_layer_id) FROM sld_user_layer), true);# #innodb:pre# #ALTER TABLE sld_user_layer CHANGE COLUMN sld_user_layer_id sld_user_layer_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE sld_user_layer_id_seq; ALTER TABLE sld_user_layer ALTER COLUMN sld_user_layer_id SET DEFAULT nextval('sld_user_layer_id_seq'::regclass);# ## #mb_user_id# ## #fkey_mb_user_id# #on delete cascade on update cascade# ## #gui_id# ## #fkey_gui_id# #on delete cascade on update cascade# ## #layer_id# ## #fkey_layer_id# #on delete cascade on update cascade# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('gui_kml','kml_id'), (SELECT max(kml_id) FROM gui_kml), true);# #innodb:pre# #ALTER TABLE gui_kml CHANGE COLUMN kml_id kml_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE kml_id_seq; ALTER TABLE gui_kml ALTER COLUMN kml_id SET DEFAULT nextval('kml_id_seq'::regclass);# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('gui_treegde','id'), (SELECT max(id) FROM layer), true);# #innodb:pre# #ALTER TABLE gui_treegde CHANGE COLUMN id id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE gui_treegde_id_seq; ALTER TABLE gui_treegde ALTER COLUMN id SET DEFAULT nextval('gui_treegde_id_seq'::regclass);# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('keyword','keyword_id'), (SELECT max(keyword_id) FROM keyword), true);# #innodb:pre# #ALTER TABLE keyword CHANGE COLUMN keyword_id keyword_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE keyword_id_seq; ALTER TABLE keyword ALTER COLUMN keyword_id SET DEFAULT nextval('keyword_id_seq'::regclass);# #postgres:post# #SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('md_topic_category','md_topic_category_id'), (SELECT max(md_topic_category_id) FROM md_topic_category), true);# #innodb:pre# #ALTER TABLE md_topic_category CHANGE COLUMN md_topic_category_id md_topic_category_id integer NOT NULL AUTO_INCREMENT;# #postgres:pre# #CREATE SEQUENCE md_topic_category_id_seq; ALTER TABLE md_topic_category ALTER COLUMN md_topic_category_id SET DEFAULT nextval('md_topic_category_id_seq'::regclass);# ## #element_id# ## #f_id# #on delete cascade on update cascade#