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; DROP INDEX ezsr_data_contentobject_id_contentobject_attribute_id; DROP INDEX ezsr_data_user_id_session_key; CREATE INDEX contentobject_id_contentobject_attribute_id ON ezstarrating_data USING btree ( contentobject_id, contentobject_attribute_id ); CREATE INDEX user_id_session_key ON ezstarrating_data USING btree ( user_id, session_key ); ALTER TABLE ezgmaplocation RENAME COLUMN latitude TO latitude_tmp; ALTER TABLE ezgmaplocation ADD COLUMN latitude double precision; ALTER TABLE ezgmaplocation ALTER latitude SET DEFAULT '0' ; ALTER TABLE ezgmaplocation ALTER latitude SET NOT NULL ; UPDATE ezgmaplocation SET latitude=latitude_tmp; ALTER TABLE ezgmaplocation DROP COLUMN latitude_tmp; ALTER TABLE ezgmaplocation RENAME COLUMN longitude TO longitude_tmp; ALTER TABLE ezgmaplocation ADD COLUMN longitude double precision; ALTER TABLE ezgmaplocation ALTER longitude SET DEFAULT '0' ; ALTER TABLE ezgmaplocation ALTER longitude SET NOT NULL ; UPDATE ezgmaplocation SET longitude=longitude_tmp; ALTER TABLE ezgmaplocation DROP COLUMN longitude_tmp; DROP INDEX ezgml_latitude_longitude_key; CREATE INDEX latitude_longitude_key ON ezgmaplocation USING btree ( latitude, longitude ); ALTER TABLE ezm_block RENAME COLUMN id TO id_tmp; ALTER TABLE ezm_block ADD COLUMN id character varying(32); ALTER TABLE ezm_block ALTER id SET DEFAULT ''::bpchar ; ALTER TABLE ezm_block ALTER id SET NOT NULL ; UPDATE ezm_block SET id=id_tmp; ALTER TABLE ezm_block DROP COLUMN id_tmp; ALTER TABLE ezm_block RENAME COLUMN is_removed TO is_removed_tmp; ALTER TABLE ezm_block ADD COLUMN is_removed integer; ALTER TABLE ezm_block ALTER is_removed SET DEFAULT 0 ; UPDATE ezm_block SET is_removed=is_removed_tmp; ALTER TABLE ezm_block DROP COLUMN is_removed_tmp; ALTER TABLE ezm_block RENAME COLUMN last_update TO last_update_tmp; ALTER TABLE ezm_block ADD COLUMN last_update integer; ALTER TABLE ezm_block ALTER last_update SET DEFAULT 0 ; UPDATE ezm_block SET last_update=last_update_tmp; ALTER TABLE ezm_block DROP COLUMN last_update_tmp; ALTER TABLE ezm_block RENAME COLUMN node_id TO node_id_tmp; ALTER TABLE ezm_block ADD COLUMN node_id integer; ALTER TABLE ezm_block ALTER node_id SET DEFAULT 0 ; ALTER TABLE ezm_block ALTER node_id SET NOT NULL ; UPDATE ezm_block SET node_id=node_id_tmp; ALTER TABLE ezm_block DROP COLUMN node_id_tmp; ALTER TABLE ezm_block RENAME COLUMN overflow_id TO overflow_id_tmp; ALTER TABLE ezm_block ADD COLUMN overflow_id character varying(32); ALTER TABLE ezm_block ALTER overflow_id SET DEFAULT NULL ; UPDATE ezm_block SET overflow_id=overflow_id_tmp; ALTER TABLE ezm_block DROP COLUMN overflow_id_tmp; ALTER TABLE ezm_block RENAME COLUMN rotation_interval TO rotation_interval_tmp; ALTER TABLE ezm_block ADD COLUMN rotation_interval integer; ALTER TABLE ezm_block ALTER rotation_interval SET DEFAULT NULL ; UPDATE ezm_block SET rotation_interval=rotation_interval_tmp; ALTER TABLE ezm_block DROP COLUMN rotation_interval_tmp; ALTER TABLE ezm_block RENAME COLUMN rotation_type TO rotation_type_tmp; ALTER TABLE ezm_block ADD COLUMN rotation_type integer; ALTER TABLE ezm_block ALTER rotation_type SET DEFAULT NULL ; UPDATE ezm_block SET rotation_type=rotation_type_tmp; ALTER TABLE ezm_block DROP COLUMN rotation_type_tmp; ALTER TABLE ezm_block RENAME COLUMN zone_id TO zone_id_tmp; ALTER TABLE ezm_block ADD COLUMN zone_id character varying(32); ALTER TABLE ezm_block ALTER zone_id SET DEFAULT ''::bpchar ; ALTER TABLE ezm_block ALTER zone_id SET NOT NULL ; UPDATE ezm_block SET zone_id=zone_id_tmp; ALTER TABLE ezm_block DROP COLUMN zone_id_tmp; DROP INDEX ezm_block_is_removed; DROP INDEX ezm_block_node_id; CREATE INDEX ezm_block__is_removed ON ezm_block USING btree ( is_removed ); CREATE INDEX ezm_block__node_id ON ezm_block USING btree ( node_id ); ALTER TABLE ezm_pool RENAME COLUMN block_id TO block_id_tmp; ALTER TABLE ezm_pool ADD COLUMN block_id character varying(32); ALTER TABLE ezm_pool ALTER block_id SET DEFAULT ''::bpchar ; ALTER TABLE ezm_pool ALTER block_id SET NOT NULL ; UPDATE ezm_pool SET block_id=block_id_tmp; ALTER TABLE ezm_pool DROP COLUMN block_id_tmp; ALTER TABLE ezm_pool RENAME COLUMN moved_to TO moved_to_tmp; ALTER TABLE ezm_pool ADD COLUMN moved_to character varying(32); ALTER TABLE ezm_pool ALTER moved_to SET DEFAULT NULL ; UPDATE ezm_pool SET moved_to=moved_to_tmp; ALTER TABLE ezm_pool DROP COLUMN moved_to_tmp; ALTER TABLE ezm_pool RENAME COLUMN node_id TO node_id_tmp; ALTER TABLE ezm_pool ADD COLUMN node_id integer; ALTER TABLE ezm_pool ALTER node_id SET DEFAULT 0 ; ALTER TABLE ezm_pool ALTER node_id SET NOT NULL ; UPDATE ezm_pool SET node_id=node_id_tmp; ALTER TABLE ezm_pool DROP COLUMN node_id_tmp; ALTER TABLE ezm_pool RENAME COLUMN object_id TO object_id_tmp; ALTER TABLE ezm_pool ADD COLUMN object_id integer; ALTER TABLE ezm_pool ALTER object_id SET DEFAULT 0 ; ALTER TABLE ezm_pool ALTER object_id SET NOT NULL ; UPDATE ezm_pool SET object_id=object_id_tmp; ALTER TABLE ezm_pool DROP COLUMN object_id_tmp; ALTER TABLE ezm_pool RENAME COLUMN priority TO priority_tmp; ALTER TABLE ezm_pool ADD COLUMN priority integer; ALTER TABLE ezm_pool ALTER priority SET DEFAULT 0 ; UPDATE ezm_pool SET priority=priority_tmp; ALTER TABLE ezm_pool DROP COLUMN priority_tmp; ALTER TABLE ezm_pool RENAME COLUMN rotation_until TO rotation_until_tmp; ALTER TABLE ezm_pool ADD COLUMN rotation_until integer; ALTER TABLE ezm_pool ALTER rotation_until SET DEFAULT 0 ; UPDATE ezm_pool SET rotation_until=rotation_until_tmp; ALTER TABLE ezm_pool DROP COLUMN rotation_until_tmp; ALTER TABLE ezm_pool RENAME COLUMN ts_hidden TO ts_hidden_tmp; ALTER TABLE ezm_pool ADD COLUMN ts_hidden integer; ALTER TABLE ezm_pool ALTER ts_hidden SET DEFAULT 0 ; UPDATE ezm_pool SET ts_hidden=ts_hidden_tmp; ALTER TABLE ezm_pool DROP COLUMN ts_hidden_tmp; ALTER TABLE ezm_pool RENAME COLUMN ts_visible TO ts_visible_tmp; ALTER TABLE ezm_pool ADD COLUMN ts_visible integer; ALTER TABLE ezm_pool ALTER ts_visible SET DEFAULT 0 ; UPDATE ezm_pool SET ts_visible=ts_visible_tmp; ALTER TABLE ezm_pool DROP COLUMN ts_visible_tmp; DROP INDEX ezm_pool_block_id_ts_hidden; DROP INDEX ezm_pool_block_id_ts_publication_priority; DROP INDEX ezm_pool_block_id_ts_visible; CREATE INDEX ezm_pool__block_id__ts_hidden ON ezm_pool USING btree ( block_id, ts_hidden ); CREATE INDEX ezm_pool__block_id__ts_publication__priority ON ezm_pool USING btree ( block_id, ts_publication, priority ); CREATE INDEX ezm_pool__block_id__ts_visible ON ezm_pool USING btree ( block_id, ts_visible ); 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 );