#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#