Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-18137

ORACLE : ezp4.4->ezp4.5 upgrade : Database check fails after upgrade

    Details

      Description

      Hi

      After upgrading from 4.4->4.5 and I go to setup -> Upgrade tests and checks the database schema I get:

      To synchronize your database with the distribution setup, run the following SQL commands:
      DROP INDEX contentobject_id_conten00002_i;
      CREATE INDEX contentobject_id_conten00001_i ON ezstarrating_data ( contentobject_id, contentobject_attribute_id );
      DROP INDEX ezm_pool__block_id__ts_00001_i;
      CREATE INDEX ezm_pool_block_id_ts_publ_prio ON ezm_pool ( block_id, ts_publication, priority );
      

      1. ezm_pool.txt
        103 kB
        Vidar Langseid
      2. ezstarrating_data.txt
        77 kB
        Vidar Langseid

        Issue Links

          Activity

          Hide
          Vidar Langseid added a comment -

          Ouput of the following is attached (ezstarrating_data.txt and ezm_pool.txt )

          select * from dba_indexes where table_name='EZSTARRATING_DATA';
          select * from dba_indexes where table_name='EZM_POOL';
          

          Show
          Vidar Langseid added a comment - Ouput of the following is attached (ezstarrating_data.txt and ezm_pool.txt ) select * from dba_indexes where table_name='EZSTARRATING_DATA'; select * from dba_indexes where table_name='EZM_POOL';
          Hide
          Gaetano Giunta added a comment -

          1. what is the path used to get athe the 4.5 db, in detail?

          2. are you sure you did not have those warnings before upgrading?

          Show
          Gaetano Giunta added a comment - 1. what is the path used to get athe the 4.5 db, in detail? 2. are you sure you did not have those warnings before upgrading?
          Hide
          Chen Xiongjie added a comment -

          More issues for a clean oracle setup(webin) and check database consistency:

          To synchronize your database with the distribution setup, run the following SQL commands:
          ALTER TABLE ezstarrating MODIFY (contentobject_attribute_id INTEGER DEFAULT 0);
          ALTER TABLE ezstarrating MODIFY (contentobject_id INTEGER DEFAULT 0);
          ALTER TABLE ezstarrating MODIFY (rating_average FLOAT DEFAULT 0);
          ALTER TABLE ezstarrating MODIFY (rating_count INTEGER DEFAULT 0);
          ALTER TABLE ezstarrating_data MODIFY (contentobject_attribute_id INTEGER DEFAULT 0);
          ALTER TABLE ezstarrating_data MODIFY (contentobject_id INTEGER DEFAULT 0);
          ALTER TABLE ezstarrating_data MODIFY (created_at INTEGER DEFAULT 0);
          ALTER TABLE ezstarrating_data MODIFY (rating FLOAT DEFAULT 0);
          ALTER TABLE ezstarrating_data MODIFY (session_key VARCHAR2(32) NOT NULL);
          ALTER TABLE ezstarrating_data MODIFY (user_id INTEGER DEFAULT 0);
          CREATE SEQUENCE s_x_ezpnet_branch;

          CREATE TABLE ezx_ezpnet_branch (
          created INTEGER DEFAULT 0 NOT NULL,
          creator_id INTEGER DEFAULT 0 NOT NULL,
          description VARCHAR2(255),
          id INTEGER NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          status INTEGER DEFAULT 0 NOT NULL,
          url VARCHAR2(255),
          PRIMARY KEY ( id, status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_branch_id_tr
          BEFORE INSERT ON ezx_ezpnet_branch FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_branch.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_installation;

          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 VARCHAR2(255),
          object_count VARCHAR2(20),
          email_notifications VARCHAR2(255),
          id INTEGER NOT NULL,
          is_enabled INTEGER DEFAULT 1 NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          multi_db_enabled INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          patch_mode INTEGER DEFAULT 0 NOT NULL,
          remote_id VARCHAR2(255),
          status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id, status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_installation_id_tr
          BEFORE INSERT ON ezx_ezpnet_installation FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_installation.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE INDEX ezx_ezpnet_installation00001_i ON ezx_ezpnet_installation ( customer_id );

          CREATE TABLE ezx_ezpnet_large_store (
          class_name VARCHAR2(130) NOT NULL,
          data CLOB NOT NULL,
          field VARCHAR2(130) NOT NULL,
          key_hash VARCHAR2(32) NOT NULL,
          offset INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( class_name, key_hash, field, offset )
          );

          CREATE SEQUENCE s_x_ezpnet_mod_patch_item;

          CREATE TABLE ezx_ezpnet_mod_patch_item (
          finnished INTEGER DEFAULT 0 NOT NULL,
          fmode INTEGER DEFAULT 0 NOT NULL,
          id INTEGER 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 VARCHAR2(255),
          started INTEGER DEFAULT 0 NOT NULL,
          status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_mod_patch_i00003_tr
          BEFORE INSERT ON ezx_ezpnet_mod_patch_item FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_mod_patch_item.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_module_branch;

          CREATE TABLE ezx_ezpnet_module_branch (
          created INTEGER DEFAULT 0 NOT NULL,
          creator_id INTEGER DEFAULT 0 NOT NULL,
          description VARCHAR2(255),
          id INTEGER NOT NULL,
          is_certified INTEGER DEFAULT 1 NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          status INTEGER DEFAULT 0 NOT NULL,
          url VARCHAR2(255),
          version_identifier VARCHAR2(255),
          PRIMARY KEY ( id, status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_module_branch_id_tr
          BEFORE INSERT ON ezx_ezpnet_module_branch FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_module_branch.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_module_inst;

          CREATE TABLE ezx_ezpnet_module_inst (
          created INTEGER DEFAULT 0 NOT NULL,
          creator_id INTEGER DEFAULT 0 NOT NULL,
          description VARCHAR2(255),
          email_notifications VARCHAR2(255),
          enabled INTEGER DEFAULT 1 NOT NULL,
          id INTEGER NOT NULL,
          installation_id INTEGER DEFAULT 0 NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          module_branch_id INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id, status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_module_inst_id_tr
          BEFORE INSERT ON ezx_ezpnet_module_inst FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_module_inst.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_module_patch;

          CREATE TABLE ezx_ezpnet_module_patch (
          created INTEGER DEFAULT 0 NOT NULL,
          creator_id INTEGER DEFAULT 0 NOT NULL,
          description VARCHAR2(255),
          filedata CLOB,
          id INTEGER NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          module_branch_id INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          options CLOB,
          original_filename VARCHAR2(255),
          required_patch_id INTEGER DEFAULT 0 NOT NULL,
          status INTEGER DEFAULT 0 NOT NULL,
          status_info CLOB,
          version_status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id, version_status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_module_patch_id_tr
          BEFORE INSERT ON ezx_ezpnet_module_patch FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_module_patch.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_mon_group;

          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 VARCHAR2(255),
          id INTEGER NOT NULL,
          max_frequency INTEGER DEFAULT 4 NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          show_result INTEGER DEFAULT 1 NOT NULL,
          status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id, status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_group_id_tr
          BEFORE INSERT ON ezx_ezpnet_mon_group FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_mon_group.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE INDEX ezx_ezpnet_mon_group_branch_id ON ezx_ezpnet_mon_group ( branch_id );

          CREATE SEQUENCE s_x_ezpnet_mon_item;

          CREATE TABLE ezx_ezpnet_mon_item (
          created INTEGER DEFAULT 0 NOT NULL,
          creator_id INTEGER DEFAULT 0 NOT NULL,
          description VARCHAR2(255),
          enabled INTEGER DEFAULT 0 NOT NULL,
          function_data CLOB NOT NULL,
          graph_type VARCHAR2(255),
          id INTEGER NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          monitor_group_id INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          original_filename VARCHAR2(255),
          per_database INTEGER DEFAULT 0 NOT NULL,
          severity INTEGER DEFAULT 1 NOT NULL,
          status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id, status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_item_id_tr
          BEFORE INSERT ON ezx_ezpnet_mon_item FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_mon_item.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE INDEX idx_mon_item_group_id ON ezx_ezpnet_mon_item ( monitor_group_id );

          CREATE SEQUENCE s_x_ezpnet_mon_result;

          CREATE TABLE ezx_ezpnet_mon_result (
          finnished INTEGER DEFAULT 0 NOT NULL,
          id INTEGER NOT NULL,
          installation_id INTEGER DEFAULT 0 NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          node_id VARCHAR2(255),
          started INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_result_id_tr
          BEFORE INSERT ON ezx_ezpnet_mon_result FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_mon_result.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE INDEX ezx_ezpnet_mon_result_f00002_i ON ezx_ezpnet_mon_result ( finnished );

          CREATE INDEX ezx_ezpnet_mon_result_inst_id ON ezx_ezpnet_mon_result ( installation_id );

          CREATE SEQUENCE s_x_ezpnet_mon_value;

          CREATE TABLE ezx_ezpnet_mon_value (
          created INTEGER DEFAULT 0 NOT NULL,
          description CLOB,
          id INTEGER 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 VARCHAR2(255),
          success INTEGER DEFAULT 1 NOT NULL,
          value VARCHAR2(255),
          PRIMARY KEY ( id )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_value_id_tr
          BEFORE INSERT ON ezx_ezpnet_mon_value FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_mon_value.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_patch;

          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 CLOB,
          filedata CLOB NOT NULL,
          id INTEGER NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          name VARCHAR2(255),
          options CLOB,
          original_filename VARCHAR2(255),
          required_patch_id INTEGER DEFAULT 0 NOT NULL,
          status INTEGER DEFAULT 0 NOT NULL,
          status_info CLOB,
          version_status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id, version_status )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_patch_id_tr
          BEFORE INSERT ON ezx_ezpnet_patch FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_patch.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_patch_item;

          CREATE TABLE ezx_ezpnet_patch_item (
          finnished INTEGER DEFAULT 0 NOT NULL,
          fmode INTEGER DEFAULT 0 NOT NULL,
          id INTEGER NOT NULL,
          installation_id INTEGER DEFAULT 0 NOT NULL,
          modified INTEGER DEFAULT 0 NOT NULL,
          node_id VARCHAR2(255),
          patch_id INTEGER DEFAULT 0 NOT NULL,
          started INTEGER DEFAULT 0 NOT NULL,
          status INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_patch_item_id_tr
          BEFORE INSERT ON ezx_ezpnet_patch_item FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_patch_item.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE INDEX ezx_ezpnet_patch_item_inst_id ON ezx_ezpnet_patch_item ( installation_id );

          CREATE INDEX ezx_ezpnet_patch_item_status ON ezx_ezpnet_patch_item ( status );

          CREATE SEQUENCE s_x_ezpnet_patch_sql_st;

          CREATE TABLE ezx_ezpnet_patch_sql_st (
          base_patch_id INTEGER DEFAULT 0 NOT NULL,
          created INTEGER DEFAULT 0 NOT NULL,
          db_name VARCHAR2(255),
          id INTEGER 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 VARCHAR2(255),
          PRIMARY KEY ( id )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_patch_sql_st_id_tr
          BEFORE INSERT ON ezx_ezpnet_patch_sql_st FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_patch_sql_st.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE SEQUENCE s_x_ezpnet_soap_log;

          CREATE TABLE ezx_ezpnet_soap_log (
          class_name VARCHAR2(255),
          extended_filter VARCHAR2(255),
          id INTEGER NOT NULL,
          key_name VARCHAR2(255),
          local_value INTEGER DEFAULT 0 NOT NULL,
          remote_host VARCHAR2(255),
          remote_modified INTEGER DEFAULT 0 NOT NULL,
          remote_value INTEGER DEFAULT 0 NOT NULL,
          timestamp INTEGER DEFAULT 0 NOT NULL,
          PRIMARY KEY ( id )
          );

          CREATE OR REPLACE TRIGGER ezx_ezpnet_soap_log_id_tr
          BEFORE INSERT ON ezx_ezpnet_soap_log FOR EACH ROW WHEN (new.id IS NULL)
          BEGIN
          SELECT s_x_ezpnet_soap_log.nextval INTO :new.id FROM dual;
          END;
          /

          CREATE INDEX idx_remote_modified ON ezx_ezpnet_soap_log ( remote_modified );

          CREATE INDEX idx_remote_val ON ezx_ezpnet_soap_log ( remote_value );

          CREATE INDEX idx_remote_val_host ON ezx_ezpnet_soap_log ( remote_host, remote_value );

          CREATE TABLE ezx_ezpnet_storage (
          id VARCHAR2(255) NOT NULL,
          id2 VARCHAR2(255) NOT NULL,
          value CLOB NOT NULL
          );

          CREATE INDEX id ON ezx_ezpnet_storage ( id );

          CREATE INDEX id2 ON ezx_ezpnet_storage ( id2 );

          CREATE TABLE ezx_oauth_client_consumer_user (
          access_token VARCHAR2(64),
          access_token_secret VARCHAR2(64),
          access_token_ttl INTEGER DEFAULT 0 NOT NULL,
          ts INTEGER DEFAULT 0 NOT NULL,
          user_remote_id VARCHAR2(100) NOT NULL,
          verifier CHAR(13),
          PRIMARY KEY ( user_remote_id )
          );

          CREATE UNIQUE INDEX access_token ON ezx_oauth_client_consumer_user ( access_token );

          Show
          Chen Xiongjie added a comment - More issues for a clean oracle setup(webin) and check database consistency: To synchronize your database with the distribution setup, run the following SQL commands: ALTER TABLE ezstarrating MODIFY (contentobject_attribute_id INTEGER DEFAULT 0); ALTER TABLE ezstarrating MODIFY (contentobject_id INTEGER DEFAULT 0); ALTER TABLE ezstarrating MODIFY (rating_average FLOAT DEFAULT 0); ALTER TABLE ezstarrating MODIFY (rating_count INTEGER DEFAULT 0); ALTER TABLE ezstarrating_data MODIFY (contentobject_attribute_id INTEGER DEFAULT 0); ALTER TABLE ezstarrating_data MODIFY (contentobject_id INTEGER DEFAULT 0); ALTER TABLE ezstarrating_data MODIFY (created_at INTEGER DEFAULT 0); ALTER TABLE ezstarrating_data MODIFY (rating FLOAT DEFAULT 0); ALTER TABLE ezstarrating_data MODIFY (session_key VARCHAR2(32) NOT NULL); ALTER TABLE ezstarrating_data MODIFY (user_id INTEGER DEFAULT 0); CREATE SEQUENCE s_x_ezpnet_branch; CREATE TABLE ezx_ezpnet_branch ( created INTEGER DEFAULT 0 NOT NULL, creator_id INTEGER DEFAULT 0 NOT NULL, description VARCHAR2(255), id INTEGER NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), status INTEGER DEFAULT 0 NOT NULL, url VARCHAR2(255), PRIMARY KEY ( id, status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_branch_id_tr BEFORE INSERT ON ezx_ezpnet_branch FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_branch.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_installation; 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 VARCHAR2(255), object_count VARCHAR2(20), email_notifications VARCHAR2(255), id INTEGER NOT NULL, is_enabled INTEGER DEFAULT 1 NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, multi_db_enabled INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), patch_mode INTEGER DEFAULT 0 NOT NULL, remote_id VARCHAR2(255), status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id, status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_installation_id_tr BEFORE INSERT ON ezx_ezpnet_installation FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_installation.nextval INTO :new.id FROM dual; END; / CREATE INDEX ezx_ezpnet_installation00001_i ON ezx_ezpnet_installation ( customer_id ); CREATE TABLE ezx_ezpnet_large_store ( class_name VARCHAR2(130) NOT NULL, data CLOB NOT NULL, field VARCHAR2(130) NOT NULL, key_hash VARCHAR2(32) NOT NULL, offset INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( class_name, key_hash, field, offset ) ); CREATE SEQUENCE s_x_ezpnet_mod_patch_item; CREATE TABLE ezx_ezpnet_mod_patch_item ( finnished INTEGER DEFAULT 0 NOT NULL, fmode INTEGER DEFAULT 0 NOT NULL, id INTEGER 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 VARCHAR2(255), started INTEGER DEFAULT 0 NOT NULL, status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_mod_patch_i00003_tr BEFORE INSERT ON ezx_ezpnet_mod_patch_item FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_mod_patch_item.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_module_branch; CREATE TABLE ezx_ezpnet_module_branch ( created INTEGER DEFAULT 0 NOT NULL, creator_id INTEGER DEFAULT 0 NOT NULL, description VARCHAR2(255), id INTEGER NOT NULL, is_certified INTEGER DEFAULT 1 NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), status INTEGER DEFAULT 0 NOT NULL, url VARCHAR2(255), version_identifier VARCHAR2(255), PRIMARY KEY ( id, status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_module_branch_id_tr BEFORE INSERT ON ezx_ezpnet_module_branch FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_module_branch.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_module_inst; CREATE TABLE ezx_ezpnet_module_inst ( created INTEGER DEFAULT 0 NOT NULL, creator_id INTEGER DEFAULT 0 NOT NULL, description VARCHAR2(255), email_notifications VARCHAR2(255), enabled INTEGER DEFAULT 1 NOT NULL, id INTEGER NOT NULL, installation_id INTEGER DEFAULT 0 NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, module_branch_id INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id, status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_module_inst_id_tr BEFORE INSERT ON ezx_ezpnet_module_inst FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_module_inst.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_module_patch; CREATE TABLE ezx_ezpnet_module_patch ( created INTEGER DEFAULT 0 NOT NULL, creator_id INTEGER DEFAULT 0 NOT NULL, description VARCHAR2(255), filedata CLOB, id INTEGER NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, module_branch_id INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), options CLOB, original_filename VARCHAR2(255), required_patch_id INTEGER DEFAULT 0 NOT NULL, status INTEGER DEFAULT 0 NOT NULL, status_info CLOB, version_status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id, version_status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_module_patch_id_tr BEFORE INSERT ON ezx_ezpnet_module_patch FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_module_patch.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_mon_group; 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 VARCHAR2(255), id INTEGER NOT NULL, max_frequency INTEGER DEFAULT 4 NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), show_result INTEGER DEFAULT 1 NOT NULL, status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id, status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_group_id_tr BEFORE INSERT ON ezx_ezpnet_mon_group FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_mon_group.nextval INTO :new.id FROM dual; END; / CREATE INDEX ezx_ezpnet_mon_group_branch_id ON ezx_ezpnet_mon_group ( branch_id ); CREATE SEQUENCE s_x_ezpnet_mon_item; CREATE TABLE ezx_ezpnet_mon_item ( created INTEGER DEFAULT 0 NOT NULL, creator_id INTEGER DEFAULT 0 NOT NULL, description VARCHAR2(255), enabled INTEGER DEFAULT 0 NOT NULL, function_data CLOB NOT NULL, graph_type VARCHAR2(255), id INTEGER NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, monitor_group_id INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), original_filename VARCHAR2(255), per_database INTEGER DEFAULT 0 NOT NULL, severity INTEGER DEFAULT 1 NOT NULL, status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id, status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_item_id_tr BEFORE INSERT ON ezx_ezpnet_mon_item FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_mon_item.nextval INTO :new.id FROM dual; END; / CREATE INDEX idx_mon_item_group_id ON ezx_ezpnet_mon_item ( monitor_group_id ); CREATE SEQUENCE s_x_ezpnet_mon_result; CREATE TABLE ezx_ezpnet_mon_result ( finnished INTEGER DEFAULT 0 NOT NULL, id INTEGER NOT NULL, installation_id INTEGER DEFAULT 0 NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, node_id VARCHAR2(255), started INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_result_id_tr BEFORE INSERT ON ezx_ezpnet_mon_result FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_mon_result.nextval INTO :new.id FROM dual; END; / CREATE INDEX ezx_ezpnet_mon_result_f00002_i ON ezx_ezpnet_mon_result ( finnished ); CREATE INDEX ezx_ezpnet_mon_result_inst_id ON ezx_ezpnet_mon_result ( installation_id ); CREATE SEQUENCE s_x_ezpnet_mon_value; CREATE TABLE ezx_ezpnet_mon_value ( created INTEGER DEFAULT 0 NOT NULL, description CLOB, id INTEGER 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 VARCHAR2(255), success INTEGER DEFAULT 1 NOT NULL, value VARCHAR2(255), PRIMARY KEY ( id ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_mon_value_id_tr BEFORE INSERT ON ezx_ezpnet_mon_value FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_mon_value.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_patch; 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 CLOB, filedata CLOB NOT NULL, id INTEGER NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, name VARCHAR2(255), options CLOB, original_filename VARCHAR2(255), required_patch_id INTEGER DEFAULT 0 NOT NULL, status INTEGER DEFAULT 0 NOT NULL, status_info CLOB, version_status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id, version_status ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_patch_id_tr BEFORE INSERT ON ezx_ezpnet_patch FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_patch.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_patch_item; CREATE TABLE ezx_ezpnet_patch_item ( finnished INTEGER DEFAULT 0 NOT NULL, fmode INTEGER DEFAULT 0 NOT NULL, id INTEGER NOT NULL, installation_id INTEGER DEFAULT 0 NOT NULL, modified INTEGER DEFAULT 0 NOT NULL, node_id VARCHAR2(255), patch_id INTEGER DEFAULT 0 NOT NULL, started INTEGER DEFAULT 0 NOT NULL, status INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_patch_item_id_tr BEFORE INSERT ON ezx_ezpnet_patch_item FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_patch_item.nextval INTO :new.id FROM dual; END; / CREATE INDEX ezx_ezpnet_patch_item_inst_id ON ezx_ezpnet_patch_item ( installation_id ); CREATE INDEX ezx_ezpnet_patch_item_status ON ezx_ezpnet_patch_item ( status ); CREATE SEQUENCE s_x_ezpnet_patch_sql_st; CREATE TABLE ezx_ezpnet_patch_sql_st ( base_patch_id INTEGER DEFAULT 0 NOT NULL, created INTEGER DEFAULT 0 NOT NULL, db_name VARCHAR2(255), id INTEGER 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 VARCHAR2(255), PRIMARY KEY ( id ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_patch_sql_st_id_tr BEFORE INSERT ON ezx_ezpnet_patch_sql_st FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_patch_sql_st.nextval INTO :new.id FROM dual; END; / CREATE SEQUENCE s_x_ezpnet_soap_log; CREATE TABLE ezx_ezpnet_soap_log ( class_name VARCHAR2(255), extended_filter VARCHAR2(255), id INTEGER NOT NULL, key_name VARCHAR2(255), local_value INTEGER DEFAULT 0 NOT NULL, remote_host VARCHAR2(255), remote_modified INTEGER DEFAULT 0 NOT NULL, remote_value INTEGER DEFAULT 0 NOT NULL, timestamp INTEGER DEFAULT 0 NOT NULL, PRIMARY KEY ( id ) ); CREATE OR REPLACE TRIGGER ezx_ezpnet_soap_log_id_tr BEFORE INSERT ON ezx_ezpnet_soap_log FOR EACH ROW WHEN (new.id IS NULL) BEGIN SELECT s_x_ezpnet_soap_log.nextval INTO :new.id FROM dual; END; / CREATE INDEX idx_remote_modified ON ezx_ezpnet_soap_log ( remote_modified ); CREATE INDEX idx_remote_val ON ezx_ezpnet_soap_log ( remote_value ); CREATE INDEX idx_remote_val_host ON ezx_ezpnet_soap_log ( remote_host, remote_value ); CREATE TABLE ezx_ezpnet_storage ( id VARCHAR2(255) NOT NULL, id2 VARCHAR2(255) NOT NULL, value CLOB NOT NULL ); CREATE INDEX id ON ezx_ezpnet_storage ( id ); CREATE INDEX id2 ON ezx_ezpnet_storage ( id2 ); CREATE TABLE ezx_oauth_client_consumer_user ( access_token VARCHAR2(64), access_token_secret VARCHAR2(64), access_token_ttl INTEGER DEFAULT 0 NOT NULL, ts INTEGER DEFAULT 0 NOT NULL, user_remote_id VARCHAR2(100) NOT NULL, verifier CHAR(13), PRIMARY KEY ( user_remote_id ) ); CREATE UNIQUE INDEX access_token ON ezx_oauth_client_consumer_user ( access_token );
          Hide
          Chen Xiongjie added a comment -

          In reply to comment #053827
          That's something else, ignore it.

          Show
          Chen Xiongjie added a comment - In reply to comment #053827 That's something else, ignore it.
          Hide
          Chen Xiongjie added a comment -

          @vl, is the 4.4 is updated from 4.3 or new installation?

          Show
          Chen Xiongjie added a comment - @vl, is the 4.4 is updated from 4.3 or new installation?
          Hide
          Vidar Langseid added a comment -

          This was a 4.4 ezflow (no demodata) installation ( on mysql ).
          Dumped to dba, installed in oracle then upgraded to 4.4beta2

          Show
          Vidar Langseid added a comment - This was a 4.4 ezflow (no demodata) installation ( on mysql ). Dumped to dba, installed in oracle then upgraded to 4.4beta2
          Show
          Chen Xiongjie added a comment - for ezflow one: https://github.com/ezsystems/ezoracle/commit/27957352395e5f529cda2cb0cce799595a1069a6
          Hide
          Chen Xiongjie added a comment -

          Fixed in ezoracle 2.2.0 (with the previous comment commit):
          https://github.com/ezsystems/ezoracle/commit/3f038984adcabb94c1dfcadf3335ef7e299a77dd

          Show
          Chen Xiongjie added a comment - Fixed in ezoracle 2.2.0 (with the previous comment commit): https://github.com/ezsystems/ezoracle/commit/3f038984adcabb94c1dfcadf3335ef7e299a77dd
          Hide
          Geir Arne Waaler added a comment -

          Reported as fixed. I move it to Closed.

          Geir Arne Waaler
          eZ Documentation

          Show
          Geir Arne Waaler added a comment - Reported as fixed. I move it to Closed. Geir Arne Waaler eZ Documentation

            People

            • Assignee:
              Chen Xiongjie
              Reporter:
              Vidar Langseid
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: