To synchronize your database with the distribution setup, run the following SQL commands:
ALTER TABLE ezscheduled_script RENAME COLUMN progress TO progress_tmp;
ALTER TABLE ezscheduled_script ADD COLUMN progress integer;
ALTER TABLE ezscheduled_script ALTER progress SET DEFAULT 0 ;
UPDATE ezscheduled_script SET progress=progress_tmp;
ALTER TABLE ezscheduled_script DROP COLUMN progress_tmp;

CREATE SEQUENCE ezorder_nr_incr_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezorder_nr_incr (
id integer DEFAULT nextval('ezorder_nr_incr_s'::text) NOT NULL
);

ALTER TABLE ONLY ezorder_nr_incr ADD CONSTRAINT ezorder_nr_incr_pkey PRIMARY KEY ( id );

CREATE SEQUENCE ezx_ezpnet_branch_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_branch (
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_branch_s'::text) NOT NULL,
modified integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
status integer DEFAULT 0 NOT NULL,
url character varying(255) DEFAULT ''::character varying
);

ALTER TABLE ONLY ezx_ezpnet_branch ADD CONSTRAINT ezx_ezpnet_branch_pkey PRIMARY KEY ( id, status );

CREATE SEQUENCE ezx_ezpnet_installation_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_installation (
branch_id integer DEFAULT 0 NOT NULL,
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
customer_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
object_count character varying(20) DEFAULT ''::character varying,
email_notifications character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_installation_s'::text) NOT NULL,
is_enabled integer DEFAULT 1 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
multi_db_enabled integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
patch_mode integer DEFAULT 0 NOT NULL,
remote_id character varying(255) DEFAULT ''::character varying,
status integer DEFAULT 0 NOT NULL
);
CREATE INDEX ezx_ezpnet_installation_cust_id ON ezx_ezpnet_installation USING btree ( customer_id );

ALTER TABLE ONLY ezx_ezpnet_installation ADD CONSTRAINT ezx_ezpnet_installation_pkey PRIMARY KEY ( id, status );


CREATE TABLE ezx_ezpnet_large_store (
class_name character varying(130) DEFAULT ''::character varying NOT NULL,
data text NOT NULL,
field character varying(130) DEFAULT ''::character varying NOT NULL,
key_hash character varying(32) DEFAULT ''::character varying NOT NULL,
"offset" integer DEFAULT 0 NOT NULL
);

ALTER TABLE ONLY ezx_ezpnet_large_store ADD CONSTRAINT ezx_ezpnet_large_store_pkey PRIMARY KEY ( class_name, key_hash, field, "offset" );

CREATE SEQUENCE ezx_ezpnet_mod_patch_item_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_mod_patch_item (
finnished integer DEFAULT 0 NOT NULL,
fmode integer DEFAULT 0 NOT NULL,
id integer DEFAULT nextval('ezx_ezpnet_mod_patch_item_s'::text) NOT NULL,
installation_id integer DEFAULT 0 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
module_patch_id integer DEFAULT 0 NOT NULL,
node_id character varying(255) DEFAULT ''::character varying,
started integer DEFAULT 0 NOT NULL,
status integer DEFAULT 0 NOT NULL
);

ALTER TABLE ONLY ezx_ezpnet_mod_patch_item ADD CONSTRAINT ezx_ezpnet_mod_patch_item_pkey PRIMARY KEY ( id );

CREATE SEQUENCE ezx_ezpnet_module_branch_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_module_branch (
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_module_branch_s'::text) NOT NULL,
is_certified integer DEFAULT 1 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
status integer DEFAULT 0 NOT NULL,
url character varying(255) DEFAULT ''::character varying,
version_identifier character varying(255) DEFAULT ''::character varying
);

ALTER TABLE ONLY ezx_ezpnet_module_branch ADD CONSTRAINT ezx_ezpnet_module_branch_pkey PRIMARY KEY ( id, status );

CREATE SEQUENCE ezx_ezpnet_module_inst_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_module_inst (
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
email_notifications character varying(255) DEFAULT ''::character varying,
enabled integer DEFAULT 1 NOT NULL,
id integer DEFAULT nextval('ezx_ezpnet_module_inst_s'::text) NOT NULL,
installation_id integer DEFAULT 0 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
module_branch_id integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
status integer DEFAULT 0 NOT NULL
);

ALTER TABLE ONLY ezx_ezpnet_module_inst ADD CONSTRAINT ezx_ezpnet_module_inst_pkey PRIMARY KEY ( id, status );

CREATE SEQUENCE ezx_ezpnet_module_patch_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_module_patch (
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
filedata text,
id integer DEFAULT nextval('ezx_ezpnet_module_patch_s'::text) NOT NULL,
modified integer DEFAULT 0 NOT NULL,
module_branch_id integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
options text,
original_filename character varying(255) DEFAULT ''::character varying,
required_patch_id integer DEFAULT 0 NOT NULL,
status integer DEFAULT 0 NOT NULL,
status_info text,
version_status integer DEFAULT 0 NOT NULL
);

ALTER TABLE ONLY ezx_ezpnet_module_patch ADD CONSTRAINT ezx_ezpnet_module_patch_pkey PRIMARY KEY ( id, version_status );

CREATE SEQUENCE ezx_ezpnet_mon_group_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_mon_group (
branch_id integer DEFAULT 0 NOT NULL,
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_mon_group_s'::text) NOT NULL,
max_frequency integer DEFAULT 4 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
show_result integer DEFAULT 1 NOT NULL,
status integer DEFAULT 0 NOT NULL
);
CREATE INDEX ezx_ezpnet_mon_group_branch_id ON ezx_ezpnet_mon_group USING btree ( branch_id );

ALTER TABLE ONLY ezx_ezpnet_mon_group ADD CONSTRAINT ezx_ezpnet_mon_group_pkey PRIMARY KEY ( id, status );

CREATE SEQUENCE ezx_ezpnet_mon_item_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_mon_item (
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description character varying(255) DEFAULT ''::character varying,
enabled integer DEFAULT 0 NOT NULL,
function_data text NOT NULL,
graph_type character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_mon_item_s'::text) NOT NULL,
modified integer DEFAULT 0 NOT NULL,
monitor_group_id integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
original_filename character varying(255) DEFAULT ''::character varying,
per_database integer DEFAULT 0 NOT NULL,
severity integer DEFAULT 1 NOT NULL,
status integer DEFAULT 0 NOT NULL
);
CREATE INDEX idx_mon_item_group_id ON ezx_ezpnet_mon_item USING btree ( monitor_group_id );

ALTER TABLE ONLY ezx_ezpnet_mon_item ADD CONSTRAINT ezx_ezpnet_mon_item_pkey PRIMARY KEY ( id, status );

CREATE SEQUENCE ezx_ezpnet_mon_result_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_mon_result (
finnished integer DEFAULT 0 NOT NULL,
id integer DEFAULT nextval('ezx_ezpnet_mon_result_s'::text) NOT NULL,
installation_id integer DEFAULT 0 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
node_id character varying(255) DEFAULT ''::character varying,
started integer DEFAULT 0 NOT NULL
);
CREATE INDEX ezx_ezpnet_mon_result_finnished ON ezx_ezpnet_mon_result USING btree ( finnished );


CREATE INDEX ezx_ezpnet_mon_result_inst_id ON ezx_ezpnet_mon_result USING btree ( installation_id );

ALTER TABLE ONLY ezx_ezpnet_mon_result ADD CONSTRAINT ezx_ezpnet_mon_result_pkey PRIMARY KEY ( id );

CREATE SEQUENCE ezx_ezpnet_mon_value_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_mon_value (
created integer DEFAULT 0 NOT NULL,
description text,
id integer DEFAULT nextval('ezx_ezpnet_mon_value_s'::text) NOT NULL,
installation_id integer DEFAULT 0 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
monitor_item_id integer DEFAULT 0 NOT NULL,
monitor_result_id integer DEFAULT 0 NOT NULL,
node_id character varying(255) DEFAULT ''::character varying,
success integer DEFAULT 1 NOT NULL,
value character varying(255) DEFAULT ''::character varying
);

ALTER TABLE ONLY ezx_ezpnet_mon_value ADD CONSTRAINT ezx_ezpnet_mon_value_pkey PRIMARY KEY ( id );

CREATE SEQUENCE ezx_ezpnet_patch_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_patch (
branch_id integer DEFAULT 0 NOT NULL,
created integer DEFAULT 0 NOT NULL,
creator_id integer DEFAULT 0 NOT NULL,
description text,
filedata text NOT NULL,
id integer DEFAULT nextval('ezx_ezpnet_patch_s'::text) NOT NULL,
modified integer DEFAULT 0 NOT NULL,
name character varying(255) DEFAULT ''::character varying,
options text,
original_filename character varying(255) DEFAULT ''::character varying,
required_patch_id integer DEFAULT 0 NOT NULL,
status integer DEFAULT 0 NOT NULL,
status_info text,
version_status integer DEFAULT 0 NOT NULL
);

ALTER TABLE ONLY ezx_ezpnet_patch ADD CONSTRAINT ezx_ezpnet_patch_pkey PRIMARY KEY ( id, version_status );

CREATE SEQUENCE ezx_ezpnet_patch_item_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_patch_item (
finnished integer DEFAULT 0 NOT NULL,
fmode integer DEFAULT 0 NOT NULL,
id integer DEFAULT nextval('ezx_ezpnet_patch_item_s'::text) NOT NULL,
installation_id integer DEFAULT 0 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
node_id character varying(255) DEFAULT ''::character varying,
patch_id integer DEFAULT 0 NOT NULL,
started integer DEFAULT 0 NOT NULL,
status integer DEFAULT 0 NOT NULL
);
CREATE INDEX ezx_ezpnet_patch_item_inst_id ON ezx_ezpnet_patch_item USING btree ( installation_id );


CREATE INDEX ezx_ezpnet_patch_item_status ON ezx_ezpnet_patch_item USING btree ( status );

ALTER TABLE ONLY ezx_ezpnet_patch_item ADD CONSTRAINT ezx_ezpnet_patch_item_pkey PRIMARY KEY ( id );

CREATE SEQUENCE ezx_ezpnet_patch_sql_st_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_patch_sql_st (
base_patch_id integer DEFAULT 0 NOT NULL,
created integer DEFAULT 0 NOT NULL,
db_name character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_patch_sql_st_s'::text) NOT NULL,
installation_id integer DEFAULT 0 NOT NULL,
is_enabled integer DEFAULT 1 NOT NULL,
latest_patch_id integer DEFAULT 0 NOT NULL,
modified integer DEFAULT 0 NOT NULL,
site_access character varying(255) DEFAULT ''::character varying
);

ALTER TABLE ONLY ezx_ezpnet_patch_sql_st ADD CONSTRAINT ezx_ezpnet_patch_sql_st_pkey PRIMARY KEY ( id );

CREATE SEQUENCE ezx_ezpnet_soap_log_s
START 1
INCREMENT 1
MAXVALUE 9223372036854775807
MINVALUE 1
CACHE 1;
CREATE TABLE ezx_ezpnet_soap_log (
class_name character varying(255) DEFAULT ''::character varying,
extended_filter character varying(255) DEFAULT ''::character varying,
id integer DEFAULT nextval('ezx_ezpnet_soap_log_s'::text) NOT NULL,
key_name character varying(255) DEFAULT ''::character varying,
local_value integer DEFAULT 0 NOT NULL,
remote_host character varying(255) DEFAULT ''::character varying,
remote_modified integer DEFAULT 0 NOT NULL,
remote_value integer DEFAULT 0 NOT NULL,
"timestamp" integer DEFAULT 0 NOT NULL
);
CREATE INDEX idx_remote_modified ON ezx_ezpnet_soap_log USING btree ( remote_modified );


CREATE INDEX idx_remote_val ON ezx_ezpnet_soap_log USING btree ( remote_value );


CREATE INDEX idx_remote_val_host ON ezx_ezpnet_soap_log USING btree ( remote_host, remote_value );

ALTER TABLE ONLY ezx_ezpnet_soap_log ADD CONSTRAINT ezx_ezpnet_soap_log_pkey PRIMARY KEY ( id );


CREATE TABLE ezx_ezpnet_storage (
id character varying(255) DEFAULT ''::character varying NOT NULL,
id2 character varying(255) DEFAULT ''::character varying NOT NULL,
value text NOT NULL
);
CREATE INDEX id ON ezx_ezpnet_storage USING btree ( id );


CREATE INDEX id2 ON ezx_ezpnet_storage USING btree ( id2 );



CREATE TABLE ezx_oauth_client_consumer_user (
access_token character varying(64) DEFAULT ''::character varying,
access_token_secret character varying(64) DEFAULT ''::character varying,
access_token_ttl integer DEFAULT 0 NOT NULL,
ts integer DEFAULT 0 NOT NULL,
user_remote_id character varying(100) DEFAULT ''::character varying NOT NULL,
verifier character varying(13) DEFAULT NULL
);
CREATE UNIQUE INDEX access_token ON ezx_oauth_client_consumer_user USING btree ( access_token );

ALTER TABLE ONLY ezx_oauth_client_consumer_user ADD CONSTRAINT ezx_oauth_client_consumer_user_pkey PRIMARY KEY ( user_remote_id );

DROP TABLE ezgmaplocation;
DROP TABLE ezm_block;
DROP TABLE ezm_pool;
DROP TABLE ezstarrating;
DROP TABLE ezstarrating_data;