// @@@ START COPYRIGHT @@@
//
// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.
//
// @@@ END COPYRIGHT @@@

/*
 ********************************************************************************
 * 
 * File:         CmpSeabaseDDLrepos.h
 * Description:  This file describes repository tables used by Trafodion.
 *                
 * *****************************************************************************
 */

#ifndef _CMP_SEABASE_REPOS_H_
#define _CMP_SEABASE_REPOS_H_

#define TRAF_METRIC_QUERY_VIEW "METRIC_QUERY_VIEW"

///////////////////////////////////////////////////////////////////////////////
// *** Current Definition ***
//
// Current repository tables definition for Metadata Version 2.1
//  (Major version = 2, Minor version = 1)
///////////////////////////////////////////////////////////////////////////////

//----------------------------------------------------------------
//-- METRIC_QUERY_TABLE
//----------------------------------------------------------------
static const QString createMetricQueryTable[] =
{
{" create table %s.\"%s\"."REPOS_METRIC_QUERY_TABLE" "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable serialized, "},
 {" component_id                           integer unsigned default null serialized, "},
 {" process_id                             integer default null serialized, "},
 {" thread_id                              integer unsigned default null serialized, "},
 {" node_id                                integer unsigned default null serialized, "},   
 {" pnid_id                                integer unsigned default null serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null serialized, "}, 
 {" sequence_number                        integer unsigned default null serialized, "},             
 {" process_name                           char(32) character set iso88591 casespecific default null serialized, "},
 {" exec_start_utc_ts                      timestamp(6) no default not null not droppable not serialized, "}, 
 {" query_id                               char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
 {" query_signature_id                     char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific default null serialized, "},
 {" user_name                              char(256 bytes) character set utf8 casespecific default null serialized, "},
 {" role_name                              char(256 bytes) character set utf8 casespecific default null serialized, "},
 {" start_priority                         integer unsigned default null serialized, "},
 {" master_process_id                      char(64) character set iso88591 casespecific       default null serialized, "},
 {" session_id                             char(108) character set iso88591 casespecific      default null serialized, "},
 {" client_name                            varchar(1024) character set iso88591 casespecific  default null serialized, "},
 {" application_name                       char(130) character set iso88591 casespecific      default null serialized, "},
 {" statement_id                           char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific      default null serialized, "},
 {" statement_type                         char(36) character set iso88591 casespecific       default null serialized, "},
 {" statement_subtype                      char(36) character set iso88591 casespecific       default null serialized, "},
 {" submit_utc_ts				   timestamp(6) default null not serialized, "},
 {" compile_start_utc_ts			   timestamp(6) default null not serialized, "},
 {" compile_end_utc_ts			   timestamp(6) default null not serialized, "},
 {" compile_elapsed_time			   largeint default null serialized, "},
 {" cmp_affinity_num				   largeint default null serialized, "},
 {" cmp_dop					   largeint default null serialized, "},
 {" cmp_txn_needed				   largeint default null serialized, "},
 {" cmp_mandatory_x_prod			   largeint default null serialized, "},
 {" cmp_missing_stats				   largeint default null serialized, "},
 {" cmp_num_joins				   largeint default null serialized, "},
 {" cmp_full_scan_on_table			   largeint default null serialized, "},
 {" cmp_rows_accessed_full_scan		   double precision default null not serialized, "},
 {" est_accessed_rows       		   double precision default null not serialized, "}, 
 {" est_used_rows				   double precision default null not serialized, "}, 
 {" cmp_compiler_id				   char(28) character set iso88591 casespecific default null serialized, "},
 {" cmp_cpu_path_length			   largeint default null serialized, "},
 {" cmp_cpu_binder				   largeint default null serialized, "},
 {" cmp_cpu_normalizer			   largeint default null serialized, "},
 {" cmp_cpu_analyzer				   largeint default null serialized, "},
 {" cmp_cpu_optimizer				   largeint default null serialized, "},
 {" cmp_cpu_generator				   largeint default null serialized, "},
 {" cmp_metadata_cache_hits			   largeint default null serialized, "},
 {" cmp_metadata_cache_lookups		   largeint default null serialized, "},
 {" cmp_query_cache_status	largeint                    default null serialized, "},
 {" cmp_histogram_cache_hits	largeint                default null serialized, "},
 {" cmp_histogram_cache_lookups	largeint                default null serialized, "},
 {" cmp_stmt_heap_size	largeint                        default null serialized, "},
 {" cmp_context_heap_size	largeint                    default null serialized, "},
 {" cmp_optimization_tasks	largeint                    default null serialized, "},
 {" cmp_optimization_contexts	largeint                default null serialized, "},
 {" cmp_is_recompile	smallint                        default null serialized, "},
 {" est_num_seq_ios	double precision                  	default null not serialized, "},
 {" est_num_rand_ios	double precision                default null not serialized, "},
 {" est_cost	double precision                  		default null not serialized, "},
 {" est_cardinality	double precision                  	default null not serialized, "},
 {" est_io_time	double precision                  		default null not serialized, "},
 {" est_msg_time	double precision                  	default null not serialized, "},
 {" est_idle_time	double precision                  	default null not serialized, "},
 {" est_cpu_time	double precision                  	default null not serialized, "},
 {" est_total_time	double precision                  	default null not serialized, "},
 {" est_total_mem	double precision                  	default null not serialized, "},
 {" est_resource_usage	largeint                        default null serialized, "},
 {" aggregate_option	char(3)   character set iso88591 casespecific    	default null serialized, "},
 {" cmp_number_of_bmos	integer                         default null serialized, "},
 {" cmp_overflow_mode	char(10) character set iso88591 casespecific      	default null serialized, "},
 {" cmp_overflow_size	largeint                        default null serialized, "},
 {" aggregate_total     largeint                        default null serialized, "},
 {" stats_error_code                       integer                           default null serialized, "},
 {" query_elapsed_time                     largeint                          default null serialized, "},
 {" sql_process_busy_time                  largeint                          default null serialized, "},
 {" disk_process_busy_time                 largeint                          default null serialized, "},
 {" disk_ios                               largeint                          default null serialized, "},
 {" num_sql_processes                      largeint                          default null serialized, "},
 {" sql_space_allocated                    largeint                          default null serialized, "},
 {" sql_space_used                         largeint                          default null serialized, "},
 {" sql_heap_allocated                     largeint                          default null serialized, "},
 {" sql_heap_used                          largeint                          default null serialized, "},
 {" total_mem_alloc                        largeint                          default null serialized, "},
 {" max_mem_used                           largeint                          default null serialized, "},
 {" transaction_id                         char(25) character set iso88591 casespecific       default null serialized, "},
 {" num_request_msgs                       largeint                          default null serialized, "},
 {" num_request_msg_bytes                  largeint                          default null serialized, "},
 {" num_reply_msgs                         largeint                          default null serialized, "},
 {" num_reply_msg_bytes                    largeint                          default null serialized, "},
 {" first_result_return_utc_ts             timestamp(6)                      default null not serialized, "},
 {" rows_returned_to_master                largeint                          default null serialized, "},
 {" parent_query_id                        char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific      default null serialized, "},
 {" parent_system_name                     char(128) character set iso88591 casespecific      default null serialized, "},
 {" exec_end_utc_ts                        timestamp(6)                      default null not serialized, "},
 {" master_execution_time                  largeint                          default null serialized, "},
 {" master_elapsed_time                    largeint                          default null serialized, "},
{" query_status                            char(21) character set utf8 casespecific default null serialized, "},
 {" query_sub_status                       char(30) character set utf8 casespecific default null serialized, "},
 {" error_code                             integer                           default null serialized, "},
 {" sql_error_code                         integer                           default null serialized, "},
 {" error_text                             varchar(2000) character set utf8 casespecific default null serialized, "},
 {" query_text                             varchar(50000) character set utf8 casespecific default null serialized, "},
 {" explain_plan                           varchar("REPOS_MAX_EXPLAIN_PLAN_LEN_STR") character set iso88591 casespecific default null serialized, "},
 {" last_error_before_aqr                  integer                           default null serialized, "},
 {" delay_time_before_aqr_sec              largeint                          default null serialized, "},
 {" total_num_aqr_retries                  largeint                          default null serialized, "},
 {" msg_bytes_to_disk                      largeint                          default null serialized, "},
 {" msgs_to_disk                           largeint                          default null serialized, "},
 {" rows_accessed                          largeint                          default null serialized, "},
 {" rows_retrieved                         largeint                          default null serialized, "},
 {" num_rows_iud                           largeint                          default null serialized, "},
 {" processes_created                      largeint                          default null serialized, "},
 {" process_create_busy_time               largeint                          default null serialized, "},
 {" ovf_file_count                         largeint                          default null serialized, "},
 {" ovf_space_allocated                    largeint                          default null serialized, "},
 {" ovf_space_used                         largeint                          default null serialized, "},
 {" ovf_block_size                         largeint                          default null serialized, "},
 {" ovf_write_read_count                   largeint                          default null serialized, "},
 {" ovf_write_count                        largeint                          default null serialized, "},
 {" ovf_buffer_blocks_written              largeint                          default null serialized, "},
 {" ovf_buffer_bytes_written               largeint                          default null serialized, "},
 {" ovf_read_count                         largeint                          default null serialized, "},
 {" ovf_buffer_blocks_read                 largeint                          default null serialized, "},
 {" ovf_buffer_bytes_read                  largeint                          default null serialized, "},
 {" num_nodes                              largeint                          default null serialized, "},
 {" udr_process_busy_time                  largeint                          default null serialized, "},
 {" pertable_stats                         integer                           default null serialized, "},
 {" last_updated_time                      timestamp(6)                      default null not serialized"},
 {" "},
 {" ) "},
 {" primary key ( exec_start_utc_ts, query_id ) salt using 8 partitions on ( query_id ) "},
 {" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
 {" attribute hbase format "},
 {" ; "}
 };

//----------------------------------------------------------------
// -- METRIC_SESSION_TABLE
// ----------------------------------------------------------------
static const QString createMetricSessionTable[] =
{
 {" create table %s.\"%s\"."REPOS_METRIC_SESSION_TABLE"  "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable serialized, "},
 {" component_id                           integer unsigned default null serialized, "},
 {" process_id                             integer default null serialized, "},
 {" thread_id                              integer unsigned default null serialized, "},
 {" node_id                                integer unsigned default null serialized, "},   
 {" pnid_id                                integer unsigned default null serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null serialized, "}, 
 {" sequence_number                        integer unsigned default null serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null serialized, "},
 {" session_id                             char(108)     character set iso88591 casespecific no default not null not droppable serialized, "},
 {" session_status                         char(5)       character set iso88591 casespecific  default null serialized, "},
 {" session_start_utc_ts               timestamp(6) no default not null not droppable not serialized, "},
 {" session_end_utc_ts                     timestamp(6)                      default null not serialized, "},
 {" user_id                                largeint                          default null serialized, "},
 {" user_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" role_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" client_name                            varchar(256) character set utf8 casespecific  default null serialized, "},
 {" client_user_name                       char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" application_name                       char(130)     character set iso88591 casespecific  default null serialized, "},
 {" profile_name                           varchar(130) character set utf8 casespecific  default null serialized, "},
 {" sla_name                               varchar(130) character set utf8 casespecific  default null serialized, "},
 {" total_execution_time                   largeint                          default null serialized, "},
 {" total_elapsed_time                     largeint                          default null serialized, "},
 {" total_insert_stmts_executed            largeint                          default null serialized, "},
 {" total_delete_stmts_executed            largeint                          default null serialized, "},
 {" total_update_stmts_executed            largeint                          default null serialized, "},
 {" total_select_stmts_executed            largeint                          default null serialized, "},
 {" total_catalog_stmts                    largeint                          default null serialized, "},     
 {" total_prepares                         largeint                          default null serialized, "},
 {" total_executes                         largeint                          default null serialized, "},
 {" total_fetches                          largeint                          default null serialized, "},
 {" total_closes                           largeint                          default null serialized, "},
 {" total_execdirects                      largeint                          default null serialized, "},
 {" total_errors                           largeint                          default null serialized, "},
 {" total_warnings                         largeint                          default null serialized, "},
 {" total_login_elapsed_time_mcsec         largeint                          default null serialized, "},
 {" ldap_login_elapsed_time_mcsec          largeint                          default null serialized, "},
 {" sql_user_elapsed_time_mcsec            largeint                          default null serialized, "},
 {" search_connection_elapsed_time_mcsec   largeint                          default null serialized, "},
 {" search_elapsed_time_mcsec              largeint                          default null serialized, "},
 {" authentication_connection_elapsed_time_mcsec     largeint                default null serialized, "},
 {" authentication_elapsed_time_mcsec      largeint                          default null serialized "},
 {" ) "},
 {" primary key (session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
 {" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
 {" attribute hbase format "},
 {" ; "},
 };

 //----------------------------------------------------------------
 //- METRIC_QUERY_AGGREGATION_TABLE
 //----------------------------------------------------------------
static const QString createMetricQueryAggrTable[] =
{
 {" create table %s.\"%s\"."REPOS_METRIC_QUERY_AGGR_TABLE"  "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable serialized, "},
 {" component_id                           integer unsigned default null serialized, "},
 {" process_id                             integer default null serialized, "},
 {" thread_id                              integer unsigned default null serialized, "},
 {" node_id                                integer unsigned default null serialized, "},   
 {" pnid_id                                integer unsigned default null serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null serialized, "}, 
 {" sequence_number                        integer unsigned default null serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null serialized, "},
 {" session_id                             char(108)     character set iso88591 casespecific no default not null not droppable serialized, "},
 {" session_start_utc_ts                   timestamp(6) no default not null not droppable not serialized, "},
 {" aggregation_last_update_utc_ts         timestamp(6)                      default null not serialized, "},
 {" aggregation_last_elapsed_time          largeint                          default null serialized, "},
 {" user_id                                largeint                          default null serialized, "},
 {" user_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" role_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" client_name                            varchar(256) character set utf8 casespecific  default null serialized, "},
 {" client_user_name                       char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" application_name                       char(130)     character set iso88591 casespecific  default null serialized, "},
 {" total_est_rows_accessed		   largeint default null serialized, "},
 {" total_est_rows_used			   largeint default null serialized, "},
 {" total_rows_retrieved		   largeint default null serialized, "},
 {" total_num_rows_iud			   largeint default null serialized, "},
 {" total_selects			   largeint default null serialized, "},
 {" total_inserts			   largeint default null serialized, "},
 {" total_updates			   largeint default null serialized, "},
 {" total_deletes			   largeint default null serialized, "},
 {" total_ddl_stmts			   largeint default null serialized, "},
 {" total_util_stmts			   largeint default null serialized, "},
 {" total_catalog_stmts			   largeint default null serialized, "},
 {" total_other_stmts			   largeint default null serialized, "},
 {" total_insert_errors			   largeint default null serialized, "},
 {" total_delete_errors			   largeint default null serialized, "},
 {" total_update_errors			   largeint default null serialized, "},
 {" total_select_errors			   largeint default null serialized, "},
 {" total_ddl_errors			   largeint default null serialized, "},
 {" total_util_errors			   largeint default null serialized, "},
 {" total_catalog_errors		   largeint default null serialized, "},
 {" total_other_errors			   largeint default null serialized, "},
 {" delta_estimated_rows_accessed	   largeint default null serialized, "},
 {" delta_estimated_rows_used		   largeint default null serialized, "},
 {" delta_rows_accessed			   largeint default null serialized, "},
 {" delta_rows_retrieved	           largeint default null serialized, "},
 {" delta_num_rows_iud			   largeint default null serialized, "},
 {" delta_selects			   largeint default null serialized, "},
 {" delta_inserts			   largeint default null serialized, "},
 {" delta_updates			   largeint default null serialized, "},
 {" delta_deletes			   largeint default null serialized, "},
 {" delta_ddl_stmts			   largeint default null serialized, "},
 {" delta_util_stmts			   largeint default null serialized, "},
 {" delta_catalog_stmts			   largeint default null serialized, "},
 {" delta_other_stmts			   largeint default null serialized, "},
 {" delta_insert_errors			   largeint default null serialized, "},
 {" delta_delete_errors			   largeint default null serialized, "},
 {" delta_update_errors			   largeint default null serialized, "},
 {" delta_select_errors			   largeint default null serialized, "},
 {" delta_ddl_errors			   largeint default null serialized, "},
 {" delta_util_errors			   largeint default null serialized, "},
 {" delta_catalog_errors		   largeint default null serialized, "},
 {" delta_other_errors			   largeint default null serialized, "},
 {" average_response_time                  largeint default null serialized, "},
 {" throughput_per_second                  largeint default null serialized "},
 {" ) "},
 {" primary key ( session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
 {" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
 {" attribute hbase format "},
 {" ; "}
};

//----------------------------------------------------------------
//-- METRIC_TEXT_TABLE
//----------------------------------------------------------------
static const QString createMetricTextTable[] =
  {
    {" create table %s.\"%s\"."REPOS_METRIC_TEXT_TABLE" "},
    {" ( "},
    {"  query_id     char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
    {"   text_type int not null serialized, "},
    {"   sub_id int not null serialized, "},
    {"   seq_num int not null serialized, "},
    {"   flags largeint not null serialized, "},
    {"   text varchar(50000 bytes) character set iso88591 not null serialized "},
    {" ) "},
    {" primary key (query_id, text_type, sub_id, seq_num) "},
    {" attribute hbase format "},
    {" ; "}
  };


/////////////////////////////////////////////////////////////////////
//
// Information about changed old metadata tables from which upgrade
// is being done to the current version.
// These definitions have changed in the current version of code.
// 
// Old definitions have the form (for ex for METRIC_QUERY_TABLE table):
//            createOldTrafv??MetricQueryTable[]
// v?? is the old version.
//
// When definitions change, make new entries between
// START_OLD_MD_v?? and END_OLD_MD_v??.
// Do not remove older entries. We want to keep them around for
// historical purpose.
//
// Change entries in allReposUpgradeInfo[] struct in this file
// to reflect the 'old' repository tables.
//
//////////////////////////////////////////////////////////////////////

#define TRAF_METRIC_QUERY_TABLE_OLD_REPOS REPOS_METRIC_QUERY_TABLE"_OLD_REPOS"
#define TRAF_METRIC_SESSION_TABLE_OLD_REPOS REPOS_METRIC_SESSION_TABLE"_OLD_REPOS"
#define TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS REPOS_METRIC_QUERY_AGGR_TABLE"_OLD_REPOS"

//----------------------------------------------------------------
//-- METRIC_QUERY_TABLE
//----------------------------------------------------------------
static const QString createOldTrafv11MetricQueryTable[] =
{
{" create table %s.\"%s\"."TRAF_METRIC_QUERY_TABLE_OLD_REPOS" "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable serialized, "},
 {" component_id                           integer unsigned default null serialized, "},
 {" process_id                             integer default null serialized, "},
 {" thread_id                              integer unsigned default null serialized, "},
 {" node_id                                integer unsigned default null serialized, "},   
 {" pnid_id                                integer unsigned default null serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null serialized, "}, 
 {" sequence_number                        integer unsigned default null serialized, "},             
 {" process_name                           char(32) character set iso88591 casespecific default null serialized, "},
 {" exec_start_utc_ts                      timestamp(6) no default not null not droppable not serialized, "}, 
 {" query_id                               char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
 {" user_name                              char(256 bytes) character set utf8 casespecific default null serialized, "},
 {" role_name                              char(256 bytes) character set utf8 casespecific default null serialized, "},
 {" start_priority                         integer unsigned default null serialized, "},
 {" master_process_id                      char(64) character set iso88591 casespecific       default null serialized, "},
 {" session_id                             char(108) character set iso88591 casespecific      default null serialized, "},
 {" client_name                            varchar(1024) character set iso88591 casespecific  default null serialized, "},
 {" application_name                       char(130) character set iso88591 casespecific      default null serialized, "},
 {" statement_id                           char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific      default null serialized, "},
 {" statement_type                         char(36) character set iso88591 casespecific       default null serialized, "},
 {" statement_subtype                      char(36) character set iso88591 casespecific       default null serialized, "},
 {" submit_utc_ts				   timestamp(6) default null not serialized, "},
 {" compile_start_utc_ts			   timestamp(6) default null not serialized, "},
 {" compile_end_utc_ts			   timestamp(6) default null not serialized, "},
 {" compile_elapsed_time			   largeint default null serialized, "},
 {" cmp_affinity_num				   largeint default null serialized, "},
 {" cmp_dop					   largeint default null serialized, "},
 {" cmp_txn_needed				   largeint default null serialized, "},
 {" cmp_mandatory_x_prod			   largeint default null serialized, "},
 {" cmp_missing_stats				   largeint default null serialized, "},
 {" cmp_num_joins				   largeint default null serialized, "},
 {" cmp_full_scan_on_table			   largeint default null serialized, "},
 {" cmp_rows_accessed_full_scan		   double precision default null not serialized, "},
 {" est_accessed_rows       		   double precision default null not serialized, "}, 
 {" est_used_rows				   double precision default null not serialized, "}, 
 {" cmp_compiler_id				   char(28) character set iso88591 casespecific default null serialized, "},
 {" cmp_cpu_path_length			   largeint default null serialized, "},
 {" cmp_cpu_binder				   largeint default null serialized, "},
 {" cmp_cpu_normalizer			   largeint default null serialized, "},
 {" cmp_cpu_analyzer				   largeint default null serialized, "},
 {" cmp_cpu_optimizer				   largeint default null serialized, "},
 {" cmp_cpu_generator				   largeint default null serialized, "},
 {" cmp_metadata_cache_hits			   largeint default null serialized, "},
 {" cmp_metadata_cache_lookups		   largeint default null serialized, "},
 {" cmp_query_cache_status	largeint                    default null serialized, "},
 {" cmp_histogram_cache_hits	largeint                default null serialized, "},
 {" cmp_histogram_cache_lookups	largeint                default null serialized, "},
 {" cmp_stmt_heap_size	largeint                        default null serialized, "},
 {" cmp_context_heap_size	largeint                    default null serialized, "},
 {" cmp_optimization_tasks	largeint                    default null serialized, "},
 {" cmp_optimization_contexts	largeint                default null serialized, "},
 {" cmp_is_recompile	smallint                        default null serialized, "},
 {" est_num_seq_ios	double precision                  	default null not serialized, "},
 {" est_num_rand_ios	double precision                default null not serialized, "},
 {" est_cost	double precision                  		default null not serialized, "},
 {" est_cardinality	double precision                  	default null not serialized, "},
 {" est_io_time	double precision                  		default null not serialized, "},
 {" est_msg_time	double precision                  	default null not serialized, "},
 {" est_idle_time	double precision                  	default null not serialized, "},
 {" est_cpu_time	double precision                  	default null not serialized, "},
 {" est_total_time	double precision                  	default null not serialized, "},
 {" est_total_mem	double precision                  	default null not serialized, "},
 {" est_resource_usage	largeint                        default null serialized, "},
 {" aggregate_option	char(3)   character set iso88591 casespecific    	default null serialized, "},
 {" cmp_number_of_bmos	integer                         default null serialized, "},
 {" cmp_overflow_mode	char(10) character set iso88591 casespecific      	default null serialized, "},
 {" cmp_overflow_size	largeint                        default null serialized, "},
 {" aggregate_total     largeint                        default null serialized, "},
 {" stats_error_code                       integer                           default null serialized, "},
 {" query_elapsed_time                     largeint                          default null serialized, "},
 {" sql_process_busy_time                  largeint                          default null serialized, "},
 {" disk_process_busy_time                 largeint                          default null serialized, "},
 {" disk_ios                               largeint                          default null serialized, "},
 {" num_sql_processes                      largeint                          default null serialized, "},
 {" sql_space_allocated                    largeint                          default null serialized, "},
 {" sql_space_used                         largeint                          default null serialized, "},
 {" sql_heap_allocated                     largeint                          default null serialized, "},
 {" sql_heap_used                          largeint                          default null serialized, "},
 {" total_mem_alloc                        largeint                          default null serialized, "},
 {" max_mem_used                           largeint                          default null serialized, "},
 {" transaction_id                         char(25) character set iso88591 casespecific       default null serialized, "},
 {" num_request_msgs                       largeint                          default null serialized, "},
 {" num_request_msg_bytes                  largeint                          default null serialized, "},
 {" num_reply_msgs                         largeint                          default null serialized, "},
 {" num_reply_msg_bytes                    largeint                          default null serialized, "},
 {" first_result_return_utc_ts             timestamp(6)                      default null not serialized, "},
 {" rows_returned_to_master                largeint                          default null serialized, "},
 {" parent_query_id                        char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific      default null serialized, "},
 {" parent_system_name                     char(128) character set iso88591 casespecific      default null serialized, "},
 {" exec_end_utc_ts                        timestamp(6)                      default null not serialized, "},
 {" master_execution_time                  largeint                          default null serialized, "},
 {" master_elapsed_time                    largeint                          default null serialized, "},
{" query_status                            char(21) character set utf8 casespecific default null serialized, "},
 {" query_sub_status                       char(30) character set utf8 casespecific default null serialized, "},
 {" error_code                             integer                           default null serialized, "},
 {" sql_error_code                         integer                           default null serialized, "},
 {" error_text                             varchar(2000) character set utf8 casespecific default null serialized, "},
 {" query_text                             varchar(50000) character set utf8 casespecific default null serialized, "},
 {" explain_plan                           varchar(200000) character set iso88591 casespecific default null serialized, "},
 {" last_error_before_aqr                  integer                           default null serialized, "},
 {" delay_time_before_aqr_sec              largeint                          default null serialized, "},
 {" total_num_aqr_retries                  largeint                          default null serialized, "},
 {" msg_bytes_to_disk                      largeint                          default null serialized, "},
 {" msgs_to_disk                           largeint                          default null serialized, "},
 {" rows_accessed                          largeint                          default null serialized, "},
 {" rows_retrieved                         largeint                          default null serialized, "},
 {" num_rows_iud                           largeint                          default null serialized, "},
 {" processes_created                      largeint                          default null serialized, "},
 {" process_create_busy_time               largeint                          default null serialized, "},
 {" ovf_file_count                         largeint                          default null serialized, "},
 {" ovf_space_allocated                    largeint                          default null serialized, "},
 {" ovf_space_used                         largeint                          default null serialized, "},
 {" ovf_block_size                         largeint                          default null serialized, "},
 {" ovf_write_read_count                   largeint                          default null serialized, "},
 {" ovf_write_count                        largeint                          default null serialized, "},
 {" ovf_buffer_blocks_written              largeint                          default null serialized, "},
 {" ovf_buffer_bytes_written               largeint                          default null serialized, "},
 {" ovf_read_count                         largeint                          default null serialized, "},
 {" ovf_buffer_blocks_read                 largeint                          default null serialized, "},
 {" ovf_buffer_bytes_read                  largeint                          default null serialized, "},
 {" num_nodes                              largeint                          default null serialized, "},
 {" udr_process_busy_time                  largeint                          default null serialized, "},
 {" pertable_stats                         integer                           default null serialized "},
 {" "},
 {" ) "},
 {" primary key ( exec_start_utc_ts, query_id ) salt using 8 partitions on ( query_id ) "},
 {" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
 {" ; "}
 };

//----------------------------------------------------------------
// -- METRIC_SESSION_TABLE
// ----------------------------------------------------------------
static const QString createOldTrafv11MetricSessionTable[] =
{
 {" create table %s.\"%s\"."TRAF_METRIC_SESSION_TABLE_OLD_REPOS"  "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable serialized, "},
 {" component_id                           integer unsigned default null serialized, "},
 {" process_id                             integer default null serialized, "},
 {" thread_id                              integer unsigned default null serialized, "},
 {" node_id                                integer unsigned default null serialized, "},   
 {" pnid_id                                integer unsigned default null serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null serialized, "}, 
 {" sequence_number                        integer unsigned default null serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null serialized, "},
 {" session_id                             char(108)     character set iso88591 casespecific no default not null not droppable serialized, "},
 {" session_status                         char(5)       character set iso88591 casespecific  default null serialized, "},
 {" session_start_utc_ts               timestamp(6) no default not null not droppable not serialized, "},
 {" session_end_utc_ts                     timestamp(6)                      default null not serialized, "},
 {" user_id                                largeint                          default null serialized, "},
 {" user_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" role_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" client_name                            varchar(256) character set utf8 casespecific  default null serialized, "},
 {" client_user_name                       char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" application_name                       char(130)     character set iso88591 casespecific  default null serialized, "},
 {" total_execution_time                   largeint                          default null serialized, "},
 {" total_elapsed_time                     largeint                          default null serialized, "},
 {" total_insert_stmts_executed            largeint                          default null serialized, "},
 {" total_delete_stmts_executed            largeint                          default null serialized, "},
 {" total_update_stmts_executed            largeint                          default null serialized, "},
 {" total_select_stmts_executed            largeint                          default null serialized, "},
 {" total_catalog_stmts                    largeint                          default null serialized, "},     
 {" total_prepares                         largeint                          default null serialized, "},
 {" total_executes                         largeint                          default null serialized, "},
 {" total_fetches                          largeint                          default null serialized, "},
 {" total_closes                           largeint                          default null serialized, "},
 {" total_execdirects                      largeint                          default null serialized, "},
 {" total_errors                           largeint                          default null serialized, "},
 {" total_warnings                         largeint                          default null serialized, "},
 {" total_login_elapsed_time_mcsec         largeint                          default null serialized, "},
 {" ldap_login_elapsed_time_mcsec          largeint                          default null serialized, "},
 {" sql_user_elapsed_time_mcsec            largeint                          default null serialized, "},
 {" search_connection_elapsed_time_mcsec   largeint                          default null serialized, "},
 {" search_elapsed_time_mcsec              largeint                          default null serialized, "},
 {" authentication_connection_elapsed_time_mcsec     largeint                default null serialized, "},
 {" authentication_elapsed_time_mcsec      largeint                          default null serialized "},
 {" ) "},
{" primary key (session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
 {" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
 {" ; "},
 };

 //----------------------------------------------------------------
 //- METRIC_QUERY_AGGREGATION_TABLE
 //----------------------------------------------------------------
static const QString createOldTrafv11MetricQueryAggrTable[] =
{
 {" create table %s.\"%s\"."TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS"  "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable serialized, "},
 {" component_id                           integer unsigned default null serialized, "},
 {" process_id                             integer default null serialized, "},
 {" thread_id                              integer unsigned default null serialized, "},
 {" node_id                                integer unsigned default null serialized, "},   
 {" pnid_id                                integer unsigned default null serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null serialized, "}, 
 {" sequence_number                        integer unsigned default null serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null serialized, "},
 {" session_id                             char(108)     character set iso88591 casespecific no default not null not droppable serialized, "},
 {" session_start_utc_ts               timestamp(6) no default not null not droppable not serialized, "},
 {" aggregation_last_update_utc_ts         timestamp(6)                      default null not serialized, "},
 {" aggregation_last_elapsed_time          largeint                          default null serialized, "},
 {" user_id                                largeint                          default null serialized, "},
 {" user_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" role_name                              char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" client_name                            varchar(256) character set utf8 casespecific  default null serialized, "},
 {" client_user_name                       char(256 bytes)     character set utf8 casespecific  default null serialized, "},
 {" application_name                       char(130)     character set iso88591 casespecific  default null serialized, "},
 {" total_est_rows_accessed			   largeint default null serialized, "},
 {" total_est_rows_used			   largeint default null serialized, "},
 {" total_rows_retrieved			   largeint default null serialized, "},
 {" total_num_rows_iud			   largeint default null serialized, "},
 {" total_selects			   	   largeint default null serialized, "},
 {" total_inserts			   largeint default null serialized, "},
 {" total_updates			   largeint default null serialized, "},
 {" total_deletes			   largeint default null serialized, "},

 {" total_ddl_stmts			   largeint default null serialized, "},
 {" total_util_stmts			   largeint default null serialized, "},
 {" total_catalog_stmts			   largeint default null serialized, "},
 {" total_other_stmts			   largeint default null serialized, "},

 {" total_insert_errors			          largeint default null serialized, "},
 {" total_delete_errors			          largeint default null serialized, "},
 {" total_update_errors			   largeint default null serialized, "},
 {" total_select_errors			   largeint default null serialized, "},

 {" total_ddl_errors			          largeint default null serialized, "},
 {" total_util_errors			          largeint default null serialized, "},
 {" total_catalog_errors			   largeint default null serialized, "},
 {" total_other_errors			   largeint default null serialized, "},

 {" delta_estimated_rows_accessed			   largeint default null serialized, "},
 {" delta_estimated_rows_used			   largeint default null serialized, "},
 {" delta_rows_accessed			   largeint default null serialized, "},
 {" delta_rows_retrieved			   largeint default null serialized, "},
 {" delta_num_rows_iud			   largeint default null serialized, "},

 {" delta_selects			   largeint default null serialized, "},
 {" delta_inserts			   largeint default null serialized, "},
 {" delta_updates			   largeint default null serialized, "},
 {" delta_deletes			   largeint default null serialized, "},

 {" delta_ddl_stmts			          largeint default null serialized, "},
 {" delta_util_stmts			          largeint default null serialized, "},
 {" delta_catalog_stmts			   largeint default null serialized, "},
 {" delta_other_stmts			   largeint default null serialized, "},

 {" delta_insert_errors			          largeint default null serialized, "},
 {" delta_delete_errors			          largeint default null serialized, "},
 {" delta_update_errors			   largeint default null serialized, "},
 {" delta_select_errors			   largeint default null serialized, "},

 {" delta_ddl_errors			          largeint default null serialized, "},
 {" delta_util_errors			          largeint default null serialized, "},
 {" delta_catalog_errors			   largeint default null serialized, "},
 {" delta_other_errors			   largeint default null serialized "},

 {" ) "},
 {" primary key ( session_start_utc_ts, session_id ) salt using 8 partitions on ( session_id ) "},
 {" hbase_options ( DATA_BLOCK_ENCODING = 'FAST_DIFF', COMPRESSION = 'GZ' ) "},
 {" ; "}
};

//----------------------------------------------------------------
//-- METRIC_TEXT_TABLE
//----------------------------------------------------------------
static const QString createOldTrafv11MetricTextTable[] =
  {
    {" create table %s.\"%s\"."REPOS_METRIC_TEXT_TABLE" "},  // table didn't change when moving from 1.1 to 2.1
    {" ( "},
    {"  query_id                               char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable serialized, "},
    {"   text_type int not null serialized, "},
    {"   sub_id int not null serialized, "},
    {"   seq_num int not null serialized, "},
    {"   flags largeint not null serialized, "},
    {"   text varchar(50000 bytes) character set iso88591 not null serialized "},
    {" ) "},
    {" primary key (query_id, text_type, sub_id, seq_num) "},
    {" ; "}
  };

// The following are the repository definitions for Metadata version 2.3 (before we 
// reset the numbering for Trafodion; 2.3 preceeds Trafodion 1.1). These are
// kept solely for historical purposes.

static const QString createOldv23ReposMetricQueryTable[] =
{
 {" create table %s.\"%s\"."TRAF_METRIC_QUERY_TABLE_OLD_REPOS" "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable not serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable not serialized, "},
 {" component_id                           integer unsigned default null not serialized, "},
 {" process_id                             integer default null not serialized, "},
 {" thread_id                              integer unsigned default null not serialized, "},
 {" node_id                                integer unsigned default null not serialized, "},   
 {" pnid_id                                integer unsigned default null not serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable not serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null not serialized, "}, 
 {" sequence_number                        integer unsigned default null not serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null not serialized, "},
 {" exec_start_utc_ts                      timestamp(6) no default not null not droppable not serialized, "}, 
 {" query_id                               char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific no default not null not droppable not serialized, "},
 {" user_name                              char(256 bytes) character set utf8 casespecific default null not serialized, "},
 {" role_name                              char(256 bytes) character set utf8 casespecific default null not serialized, "},
 {" start_priority                         integer unsigned default null not serialized, "},
 {" master_process_id                      char(64) character set iso88591 casespecific       default null not serialized, "},
 {" session_id                             char(108) character set iso88591 casespecific      default null not serialized, "},
 {" client_name                            varchar(1024) character set iso88591 casespecific  default null not serialized, "},
 {" application_name                       char(130) character set iso88591 casespecific      default null not serialized, "},
 {" statement_id                           char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific      default null not serialized, "},
 {" statement_type                         char(36) character set iso88591 casespecific       default null not serialized, "},
 {" statement_subtype                      char(36) character set iso88591 casespecific       default null not serialized, "},
 {" submit_utc_ts				   timestamp(6) default null not serialized, "},
 {" compile_start_utc_ts			   timestamp(6) default null not serialized, "},
 {" compile_end_utc_ts			   timestamp(6) default null not serialized, "},
 {" compile_elapsed_time			   largeint default null not serialized, "},
 {" cmp_affinity_num				   largeint default null not serialized, "},
 {" cmp_dop					   largeint default null not serialized, "},
 {" cmp_txn_needed				   largeint default null not serialized, "},
 {" cmp_mandatory_x_prod			   largeint default null not serialized, "},
 {" cmp_missing_stats				   largeint default null not serialized, "},
 {" cmp_num_joins				   largeint default null not serialized, "},
 {" cmp_full_scan_on_table			   largeint default null not serialized, "},
 {" cmp_rows_accessed_full_scan		   double precision default null not serialized, "},
 {" est_accessed_rows       		   double precision default null not serialized, "}, 
 {" est_used_rows				   double precision default null not serialized, "}, 
 {" cmp_compiler_id				   char(28) character set iso88591 casespecific default null not serialized, "},
 {" cmp_cpu_path_length			   largeint default null not serialized, "},
 {" cmp_cpu_binder				   largeint default null not serialized, "},
 {" cmp_cpu_normalizer			   largeint default null not serialized, "},
 {" cmp_cpu_analyzer				   largeint default null not serialized, "},
 {" cmp_cpu_optimizer				   largeint default null not serialized, "},
 {" cmp_cpu_generator				   largeint default null not serialized, "},
 {" cmp_metadata_cache_hits			   largeint default null not serialized, "},
 {" cmp_metadata_cache_lookups		   largeint default null not serialized, "},
 {" cmp_query_cache_status	largeint                    default null not serialized, "},
 {" cmp_histogram_cache_hits	largeint                default null not serialized, "},
 {" cmp_histogram_cache_lookups	largeint                default null not serialized, "},
 {" cmp_stmt_heap_size	largeint                        default null not serialized, "},
 {" cmp_context_heap_size	largeint                    default null not serialized, "},
 {" cmp_optimization_tasks	largeint                    default null not serialized, "},
 {" cmp_optimization_contexts	largeint                default null not serialized, "},
 {" cmp_is_recompile	smallint                        default null not serialized, "},
 {" est_num_seq_ios	double precision                  	default null not serialized, "},
 {" est_num_rand_ios	double precision                default null not serialized, "},
 {" est_cost	double precision                  		default null not serialized, "},
 {" est_cardinality	double precision                  	default null not serialized, "},
 {" est_io_time	double precision                  		default null not serialized, "},
 {" est_msg_time	double precision                  	default null not serialized, "},
 {" est_idle_time	double precision                  	default null not serialized, "},
 {" est_cpu_time	double precision                  	default null not serialized, "},
 {" est_total_time	double precision                  	default null not serialized, "},
 {" est_total_mem	double precision                  	default null not serialized, "},
 {" est_resource_usage	largeint                        default null not serialized, "},
 {" aggregate_option	char(3)   character set iso88591 casespecific    	default null not serialized, "},
 {" cmp_number_of_bmos	integer                         default null not serialized, "},
 {" cmp_overflow_mode	char(10) character set iso88591 casespecific      	default null not serialized, "},
 {" cmp_overflow_size	largeint                        default null not serialized, "},
 {" aggregate_total     largeint                        default null not serialized, "},
 {" stats_error_code                       integer                           default null not serialized, "},
 {" query_elapsed_time                     largeint                          default null not serialized, "},
 {" sql_process_busy_time                  largeint                          default null not serialized, "},
 {" disk_process_busy_time                 largeint                          default null not serialized, "},
 {" disk_ios                               largeint                          default null not serialized, "},
 {" num_sql_processes                      largeint                          default null not serialized, "},
 {" sql_space_allocated                    largeint                          default null not serialized, "},
 {" sql_space_used                         largeint                          default null not serialized, "},
 {" sql_heap_allocated                     largeint                          default null not serialized, "},
 {" sql_heap_used                          largeint                          default null not serialized, "},
 {" total_mem_alloc                        largeint                          default null not serialized, "},
 {" max_mem_used                           largeint                          default null not serialized, "},
 {" transaction_id                         char(25) character set iso88591 casespecific       default null not serialized, "},
 {" num_request_msgs                       largeint                          default null not serialized, "},
 {" num_request_msg_bytes                  largeint                          default null not serialized, "},
 {" num_reply_msgs                         largeint                          default null not serialized, "},
 {" num_reply_msg_bytes                    largeint                          default null not serialized, "},
 {" first_result_return_utc_ts             timestamp(6)                      default null not serialized, "},
 {" rows_returned_to_master                largeint                          default null not serialized, "},
 {" parent_query_id                        char("MAX_QUERY_ID_LEN_STR") character set iso88591 casespecific      default null not serialized, "},
 {" parent_system_name                     char(128) character set iso88591 casespecific      default null not serialized, "},
 {" exec_end_utc_ts                        timestamp(6)                      default null not serialized, "},
 {" master_execution_time                  largeint                          default null not serialized, "},
 {" master_elapsed_time                    largeint                          default null not serialized, "},
 {" error_code                             integer                           default null not serialized, "},
 {" sql_error_code                         integer                           default null not serialized, "},
 {" error_text                             varchar(2000) character set utf8 casespecific default null not serialized, "},
 {" query_text                             varchar(50000) character set utf8 casespecific default null not serialized, "},
 {" explain_plan                           varchar(50000) character set utf8 casespecific default null not serialized, "},
 {" last_error_before_aqr                  integer                           default null not serialized, "},
 {" delay_time_before_aqr_sec              largeint                          default null not serialized, "},
 {" total_num_aqr_retries                  largeint                          default null not serialized, "},
 {" msg_bytes_to_disk                      largeint                          default null not serialized, "},
 {" msgs_to_disk                           largeint                          default null not serialized, "},
 {" rows_accessed                          largeint                          default null not serialized, "},
 {" rows_retrieved                         largeint                          default null not serialized, "},
 {" num_rows_iud                           largeint                          default null not serialized, "},
 {" processes_created                      largeint                          default null not serialized, "},
 {" process_create_busy_time               largeint                          default null not serialized, "},
 {" ovf_file_count                         largeint                          default null not serialized, "},
 {" ovf_space_allocated                    largeint                          default null not serialized, "},
 {" ovf_space_used                         largeint                          default null not serialized, "},
 {" ovf_block_size                         largeint                          default null not serialized, "},
 {" ovf_write_read_count                   largeint                          default null not serialized, "},
 {" ovf_write_count                        largeint                          default null not serialized, "},
 {" ovf_buffer_blocks_written              largeint                          default null not serialized, "},
 {" ovf_buffer_bytes_written               largeint                          default null not serialized, "},
 {" ovf_read_count                         largeint                          default null not serialized, "},
 {" ovf_buffer_blocks_read                 largeint                          default null not serialized, "},
 {" ovf_buffer_bytes_read                  largeint                          default null not serialized, "},
 {" num_nodes                              largeint                          default null not serialized, "},
 {" udr_process_busy_time                  largeint                          default null not serialized, "},
 {" pertable_stats                         integer                           default null not serialized "},
 {" "},
 {" ) "},
 {" primary key ( exec_start_utc_ts, query_id ) "},
 {" ; "}
 };

static const QString createOldv23ReposMetricSessionTable[] =
{
 {" create table %s.\"%s\"."TRAF_METRIC_SESSION_TABLE_OLD_REPOS"  "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable not serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable not serialized, "},
 {" component_id                           integer unsigned default null not serialized, "},
 {" process_id                             integer default null not serialized, "},
 {" thread_id                              integer unsigned default null not serialized, "},
 {" node_id                                integer unsigned default null not serialized, "},   
 {" pnid_id                                integer unsigned default null not serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable not serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null not serialized, "}, 
 {" sequence_number                        integer unsigned default null not serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null not serialized, "},
 {" session_id                             char(108)     character set iso88591 casespecific no default not null not droppable not serialized, "},
 {" session_status                         char(5)       character set iso88591 casespecific  default null not serialized, "},
 {" session_start_utc_ts                   timestamp(6)                      default null not serialized, "},
 {" session_end_utc_ts                     timestamp(6)                      default null not serialized, "},
 {" user_id                                largeint                          default null not serialized, "},
 {" user_name                              char(256 bytes)     character set utf8 casespecific  default null not serialized, "},
 {" role_name                              char(256 bytes)     character set utf8 casespecific  default null not serialized, "},
 {" client_name                            varchar(256) character set utf8 casespecific  default null not serialized, "},
 {" client_user_name                       char(256 bytes)     character set utf8 casespecific  default null not serialized, "},
 {" application_name                       char(130)     character set iso88591 casespecific  default null not serialized, "},
 {" total_execution_time                   largeint                          default null not serialized, "},
 {" total_elapsed_time                     largeint                          default null not serialized, "},
 {" total_insert_stmts_executed            largeint                          default null not serialized, "},
 {" total_delete_stmts_executed            largeint                          default null not serialized, "},
 {" total_update_stmts_executed            largeint                          default null not serialized, "},
 {" total_select_stmts_executed            largeint                          default null not serialized, "},
 {" total_catalog_stmts                    largeint                          default null not serialized, "},     
 {" total_prepares                         largeint                          default null not serialized, "},
 {" total_executes                         largeint                          default null not serialized, "},
 {" total_fetches                          largeint                          default null not serialized, "},
 {" total_closes                           largeint                          default null not serialized, "},
 {" total_execdirects                      largeint                          default null not serialized, "},
 {" total_errors                           largeint                          default null not serialized, "},
 {" total_warnings                         largeint                          default null not serialized, "},
 {" total_login_elapsed_time_mcsec         largeint                          default null not serialized, "},
 {" ldap_login_elapsed_time_mcsec          largeint                          default null not serialized, "},
 {" sql_user_elapsed_time_mcsec            largeint                          default null not serialized, "},
 {" search_connection_elapsed_time_mcsec   largeint                          default null not serialized, "},
 {" search_elapsed_time_mcsec              largeint                          default null not serialized, "},
 {" authentication_connection_elapsed_time_mcsec     largeint                default null not serialized, "},
 {" authentication_elapsed_time_mcsec      largeint                          default null not serialized "},
 {" ) "},
 {" primary key ( session_id ) salt using 8 partitions "},
 {" ; "},
 };

 //----------------------------------------------------------------
 //- Old METRIC_QUERY_AGGREGATION_TABLE
 //----------------------------------------------------------------
static const QString createOldv23ReposMetricQueryAggrTable[] =
{
 {" create table %s.\"%s\"."TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS"  "},
 {" ( "},
 {" instance_id                            integer unsigned no default not null not droppable not serialized, "},
 {" tenant_id                              integer unsigned no default not null not droppable not serialized, "},
 {" component_id                           integer unsigned default null not serialized, "},
 {" process_id                             integer default null not serialized, "},
 {" thread_id                              integer unsigned default null not serialized, "},
 {" node_id                                integer unsigned default null not serialized, "},   
 {" pnid_id                                integer unsigned default null not serialized, "}, 
 {" host_id                                integer unsigned no default not null not droppable not serialized, "},
 {" ip_address_id                          char(32) character set iso88591 casespecific default null not serialized, "}, 
 {" sequence_number                        integer unsigned default null not serialized, "},                 
 {" process_name                           char(32) character set iso88591 casespecific default null not serialized, "},
 {" session_id                             char(108)     character set iso88591 casespecific no default not null not droppable not serialized, "},
 {" aggregation_start_utc_ts               timestamp(6) no default not null not droppable not serialized, "},
 {" aggregation_end_utc_ts                 timestamp(6)                      default null not serialized, "},
 {" user_id                                largeint                          default null not serialized, "},
 {" user_name                              char(256 bytes)     character set utf8 casespecific  default null not serialized, "},
 {" role_name                              char(256 bytes)     character set utf8 casespecific  default null not serialized, "},
 {" client_name                            varchar(256) character set utf8 casespecific  default null not serialized, "},
 {" client_user_name                       char(256 bytes)     character set utf8 casespecific  default null not serialized, "},
 {" application_name                       char(130)     character set iso88591 casespecific  default null not serialized, "},
 {" total_est_rows_accessed			   largeint default null not serialized, "},
 {" total_est_rows_used			   largeint default null not serialized, "},
 {" total_rows_retrieved			   largeint default null not serialized, "},
 {" total_num_rows_iud			   largeint default null not serialized, "},
 {" total_selects			   	   largeint default null not serialized, "},
 {" total_inserts			   largeint default null not serialized, "},
 {" total_updates			   largeint default null not serialized, "},
 {" total_deletes			   largeint default null not serialized, "},
 {" delta_estimated_rows_accessed			   largeint default null not serialized, "},
 {" delta_estimated_rows_used			   largeint default null not serialized, "},
 {" delta_rows_accessed			   largeint default null not serialized, "},
 {" delta_rows_retrieved			   largeint default null not serialized, "},
 {" delta_num_rows_uid			   largeint default null not serialized, "},
 {" delta_total_selects			   largeint default null not serialized, "},
 {" delta_total_inserts			   largeint default null not serialized, "},
 {" delta_total_updates			   largeint default null not serialized, "},
 {" delta_total_deletes			   largeint default null not serialized "},
 {" ) "},
 {" primary key ( aggregation_start_utc_ts, session_id ) salt using 8 partitions "},
 {" ; "}
};

static const MDUpgradeInfo allReposUpgradeInfo[] = {

  // TRAF_METRIC_QUERY_TABLE
  { REPOS_METRIC_QUERY_TABLE,  TRAF_METRIC_QUERY_TABLE_OLD_REPOS,
    createMetricQueryTable,  sizeof(createMetricQueryTable),
    createOldTrafv11MetricQueryTable,  sizeof(createOldTrafv11MetricQueryTable),
    NULL, 0,
    TRUE, 

    // new table columns
    "instance_id,"
    "tenant_id,"
    "component_id,"
    "process_id,"
    "thread_id,"
    "node_id,"
    "pnid_id,"
    "host_id,"
    "ip_address_id,"
    "sequence_number,"
    "process_name,"
    "exec_start_utc_ts,"
    "query_id,"
    "query_signature_id,"
    "user_name,"
    "role_name,"
    "start_priority,"
    "master_process_id,"
    "session_id,"
    "client_name,"
    "application_name,"
    "statement_id,"
    "statement_type,"
    "statement_subtype,"
    "submit_utc_ts,"
    "compile_start_utc_ts,"
    "compile_end_utc_ts,"
    "compile_elapsed_time,"
    "cmp_affinity_num,"
    "cmp_dop,"
    "cmp_txn_needed,"
    "cmp_mandatory_x_prod,"
    "cmp_missing_stats,"
    "cmp_num_joins,"
    "cmp_full_scan_on_table,"
    "cmp_rows_accessed_full_scan,"
    "est_accessed_rows,"
    "est_used_rows,"
    "cmp_compiler_id,"
    "cmp_cpu_path_length,"
    "cmp_cpu_binder,"
    "cmp_cpu_normalizer,"
    "cmp_cpu_analyzer,"
    "cmp_cpu_optimizer,"
    "cmp_cpu_generator,"
    "cmp_metadata_cache_hits,"
    "cmp_metadata_cache_lookups,"
    "cmp_query_cache_status,"
    "cmp_histogram_cache_hits,"
    "cmp_histogram_cache_lookups,"
    "cmp_stmt_heap_size,"
    "cmp_context_heap_size,"
    "cmp_optimization_tasks,"
    "cmp_optimization_contexts,"
    "cmp_is_recompile,"
    "est_num_seq_ios,"
    "est_num_rand_ios,"
    "est_cost,"
    "est_cardinality,"
    "est_io_time,"
    "est_msg_time,"
    "est_idle_time,"
    "est_cpu_time,"
    "est_total_time,"
    "est_total_mem,"
    "est_resource_usage,"
    "aggregate_option,"
    "cmp_number_of_bmos,"
    "cmp_overflow_mode,"
    "cmp_overflow_size,"
    "aggregate_total,"
    "stats_error_code,"
    "query_elapsed_time,"
    "sql_process_busy_time,"
    "disk_process_busy_time,"
    "disk_ios,"
    "num_sql_processes,"
    "sql_space_allocated,"
    "sql_space_used,"
    "sql_heap_allocated,"
    "sql_heap_used,"
    "total_mem_alloc,"
    "max_mem_used,"
    "transaction_id,"
    "num_request_msgs,"
    "num_request_msg_bytes,"
    "num_reply_msgs,"
    "num_reply_msg_bytes,"
    "first_result_return_utc_ts,"
    "rows_returned_to_master,"
    "parent_query_id,"
    "parent_system_name,"
    "exec_end_utc_ts,"
    "master_execution_time,"
    "master_elapsed_time,"
    "query_status,"
    "query_sub_status,"
    "error_code,"
    "sql_error_code,"
    "error_text,"
    "query_text,"
    "explain_plan,"
    "last_error_before_aqr,"
    "delay_time_before_aqr_sec,"
    "total_num_aqr_retries,"
    "msg_bytes_to_disk,"
    "msgs_to_disk,"
    "rows_accessed,"
    "rows_retrieved,"
    "num_rows_iud,"
    "processes_created,"
    "process_create_busy_time,"
    "ovf_file_count,"
    "ovf_space_allocated,"
    "ovf_space_used,"
    "ovf_block_size,"
    "ovf_write_read_count,"
    "ovf_write_count,"
    "ovf_buffer_blocks_written,"
    "ovf_buffer_bytes_written,"
    "ovf_read_count,"
    "ovf_buffer_blocks_read,"
    "ovf_buffer_bytes_read,"
    "num_nodes,"
    "udr_process_busy_time,"
    "pertable_stats,"
    "last_updated_time",

    // values from old table to be inserted into new
    "instance_id,"
    "tenant_id,"
    "component_id,"
    "process_id,"
    "thread_id,"
    "node_id,"
    "pnid_id,"
    "host_id,"
    "ip_address_id,"
    "sequence_number,"
    "process_name,"
    "exec_start_utc_ts,"
    "query_id,"
    "NULL,"
    "user_name,"
    "role_name,"
    "start_priority,"
    "master_process_id,"
    "session_id,"
    "client_name,"
    "application_name,"
    "statement_id,"
    "statement_type,"
    "statement_subtype,"
    "submit_utc_ts,"
    "compile_start_utc_ts,"
    "compile_end_utc_ts,"
    "compile_elapsed_time,"
    "cmp_affinity_num,"
    "cmp_dop,"
    "cmp_txn_needed,"
    "cmp_mandatory_x_prod,"
    "cmp_missing_stats,"
    "cmp_num_joins,"
    "cmp_full_scan_on_table,"
    "cmp_rows_accessed_full_scan,"
    "est_accessed_rows,"
    "est_used_rows,"
    "cmp_compiler_id,"
    "cmp_cpu_path_length,"
    "cmp_cpu_binder,"
    "cmp_cpu_normalizer,"
    "cmp_cpu_analyzer,"
    "cmp_cpu_optimizer,"
    "cmp_cpu_generator,"
    "cmp_metadata_cache_hits,"
    "cmp_metadata_cache_lookups,"
    "cmp_query_cache_status,"
    "cmp_histogram_cache_hits,"
    "cmp_histogram_cache_lookups,"
    "cmp_stmt_heap_size,"
    "cmp_context_heap_size,"
    "cmp_optimization_tasks,"
    "cmp_optimization_contexts,"
    "cmp_is_recompile,"
    "est_num_seq_ios,"
    "est_num_rand_ios,"
    "est_cost,"
    "est_cardinality,"
    "est_io_time,"
    "est_msg_time,"
    "est_idle_time,"
    "est_cpu_time,"
    "est_total_time,"
    "est_total_mem,"
    "est_resource_usage,"
    "aggregate_option,"
    "cmp_number_of_bmos,"
    "cmp_overflow_mode,"
    "cmp_overflow_size,"
    "aggregate_total,"
    "stats_error_code,"
    "query_elapsed_time,"
    "sql_process_busy_time,"
    "disk_process_busy_time,"
    "disk_ios,"
    "num_sql_processes,"
    "sql_space_allocated,"
    "sql_space_used,"
    "sql_heap_allocated,"
    "sql_heap_used,"
    "total_mem_alloc,"
    "max_mem_used,"
    "transaction_id,"
    "num_request_msgs,"
    "num_request_msg_bytes,"
    "num_reply_msgs,"
    "num_reply_msg_bytes,"
    "first_result_return_utc_ts,"
    "rows_returned_to_master,"
    "parent_query_id,"
    "parent_system_name,"
    "exec_end_utc_ts,"
    "master_execution_time,"
    "master_elapsed_time,"
    "query_status,"
    "query_sub_status,"
    "error_code,"
    "sql_error_code,"
    "error_text,"
    "query_text,"
    "explain_plan,"
    "last_error_before_aqr,"
    "delay_time_before_aqr_sec,"
    "total_num_aqr_retries,"
    "msg_bytes_to_disk,"
    "msgs_to_disk,"
    "rows_accessed,"
    "rows_retrieved,"
    "num_rows_iud,"
    "processes_created,"
    "process_create_busy_time,"
    "ovf_file_count,"
    "ovf_space_allocated,"
    "ovf_space_used,"
    "ovf_block_size,"
    "ovf_write_read_count,"
    "ovf_write_count,"
    "ovf_buffer_blocks_written,"
    "ovf_buffer_bytes_written,"
    "ovf_read_count,"
    "ovf_buffer_blocks_read,"
    "ovf_buffer_bytes_read,"
    "num_nodes,"
    "udr_process_busy_time,"
    "pertable_stats,"
    "NULL",

    NULL, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE},
 
  // REPOS_METRIC_SESSION_TABLE
  { REPOS_METRIC_SESSION_TABLE,  TRAF_METRIC_SESSION_TABLE_OLD_REPOS,
    createMetricSessionTable,  sizeof(createMetricSessionTable),
    createOldTrafv11MetricSessionTable,  sizeof(createOldTrafv11MetricSessionTable),
    NULL, 0,
    TRUE, 

    // new table columns
    "instance_id,"
    "tenant_id,"
    "component_id,"
    "process_id,"
    "thread_id,"
    "node_id,"   
    "pnid_id,"
    "host_id,"
    "ip_address_id," 
    "sequence_number,"                 
    "process_name,"
    "session_id,"
    "session_status,"
    "session_start_utc_ts,"
    "session_end_utc_ts,"
    "user_id,"
    "user_name,"
    "role_name,"
    "client_name,"
    "client_user_name,"
    "application_name,"
    "profile_name,"
    "sla_name,"
    "total_execution_time,"
    "total_elapsed_time,"
    "total_insert_stmts_executed,"
    "total_delete_stmts_executed,"
    "total_update_stmts_executed,"
    "total_select_stmts_executed,"
    "total_catalog_stmts,"
    "total_executes,"
    "total_fetches,"
    "total_closes,"
    "total_execdirects,"
    "total_errors,"
    "total_warnings,"
    "total_login_elapsed_time_mcsec,"
    "ldap_login_elapsed_time_mcsec,"
    "sql_user_elapsed_time_mcsec,"
    "search_connection_elapsed_time_mcsec,"
    "search_elapsed_time_mcsec,"
    "authentication_connection_elapsed_time_mcsec,"
    "authentication_elapsed_time_mcsec",   

    // values from old table to be inserted into new
    "instance_id,"
    "tenant_id,"
    "component_id,"
    "process_id,"
    "thread_id,"
    "node_id,"   
    "pnid_id,"
    "host_id,"
    "ip_address_id," 
    "sequence_number,"                 
    "process_name,"
    "session_id,"
    "session_status,"
    "session_start_utc_ts,"
    "session_end_utc_ts,"
    "user_id,"
    "user_name,"
    "role_name,"
    "client_name,"
    "client_user_name,"
    "application_name,"
    "NULL,"
    "NULL,"
    "total_execution_time,"
    "total_elapsed_time,"
    "total_insert_stmts_executed,"
    "total_delete_stmts_executed,"
    "total_update_stmts_executed,"
    "total_select_stmts_executed,"
    "total_catalog_stmts,"
    "total_executes,"
    "total_fetches,"
    "total_closes,"
    "total_execdirects,"
    "total_errors,"
    "total_warnings,"
    "total_login_elapsed_time_mcsec,"
    "ldap_login_elapsed_time_mcsec,"
    "sql_user_elapsed_time_mcsec,"
    "search_connection_elapsed_time_mcsec,"
    "search_elapsed_time_mcsec,"
    "authentication_connection_elapsed_time_mcsec,"
    "authentication_elapsed_time_mcsec",  

    NULL, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE},

  // REPOS_METRIC_QUERY_AGGR_TABLE
  { REPOS_METRIC_QUERY_AGGR_TABLE,  TRAF_METRIC_QUERY_AGGR_TABLE_OLD_REPOS,
    createMetricQueryAggrTable,  sizeof(createMetricQueryAggrTable),
    createOldTrafv11MetricQueryAggrTable,  sizeof(createOldTrafv11MetricQueryAggrTable),
    NULL, 0,
    TRUE, 

    // new table columns
    "instance_id, tenant_id, component_id, process_id, thread_id, node_id, pnid_id, host_id,"
    "ip_address_id, sequence_number, process_name, session_id, "
    "session_start_utc_ts, aggregation_last_update_utc_ts, aggregation_last_elapsed_time," 
    "user_id, user_name, role_name, client_name, client_user_name,"
    "application_name, total_est_rows_accessed, total_est_rows_used, total_rows_retrieved,"
    "total_num_rows_iud, total_selects, total_inserts, total_updates, total_deletes,"

    "total_ddl_stmts, total_util_stmts, total_catalog_stmts, total_other_stmts, "
    "total_insert_errors, total_delete_errors, total_update_errors, total_select_errors, "
    "total_ddl_errors, total_util_errors, total_catalog_errors, total_other_errors, "

    "delta_estimated_rows_accessed, delta_estimated_rows_used, delta_rows_accessed,"
    "delta_rows_retrieved, delta_num_rows_iud, "
    "delta_selects, delta_inserts, delta_updates, delta_deletes,"

    "delta_ddl_stmts, delta_util_stmts, delta_catalog_stmts, delta_other_stmts, "
    "delta_insert_errors, delta_delete_errors, delta_update_errors, delta_select_errors, "
    "delta_ddl_errors, delta_util_errors, delta_catalog_errors, delta_other_errors, "
    
    "average_response_time, throughput_per_second ",

    // values from old table to be inserted into new
    "instance_id, tenant_id, component_id, process_id, thread_id, node_id, pnid_id, host_id,"
    "ip_address_id, sequence_number, process_name, session_id, "
    "session_start_utc_ts, aggregation_last_update_utc_ts, aggregation_last_elapsed_time," 
    "user_id, user_name, role_name, client_name, client_user_name,"
    "application_name, total_est_rows_accessed, total_est_rows_used, total_rows_retrieved,"
    "total_num_rows_iud, total_selects, total_inserts, total_updates, total_deletes,"

    "total_ddl_stmts, total_util_stmts, total_catalog_stmts, total_other_stmts, "
    "total_insert_errors, total_delete_errors, total_update_errors, total_select_errors, "
    "total_ddl_errors, total_util_errors, total_catalog_errors, total_other_errors, "

    "delta_estimated_rows_accessed, delta_estimated_rows_used, delta_rows_accessed,"
    "delta_rows_retrieved, delta_num_rows_iud, "
    "delta_selects, delta_inserts, delta_updates, delta_deletes,"

    "delta_ddl_stmts, delta_util_stmts, delta_catalog_stmts, delta_other_stmts, "
    "delta_insert_errors, delta_delete_errors, delta_update_errors, delta_select_errors, "
    "delta_ddl_errors, delta_util_errors, delta_catalog_errors, delta_other_errors, "

    "NULL, NULL",

    NULL, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE},

  // REPOS_METRIC_TEXT_TABLE  
  { REPOS_METRIC_TEXT_TABLE,  NULL,
    createMetricTextTable,  sizeof(createMetricTextTable),
    NULL, 0,
    NULL, 0,
    FALSE, NULL, NULL, NULL, FALSE, FALSE, FALSE, FALSE, FALSE, FALSE}
  
};

#endif