<commit_before>drop TABLE CATISSUE_TABLE_RELATION;
CREATE TABLE CATISSUE_TABLE_RELATION
(
      PARENT_TABLE_ID bigint,      
      
      CHILD_TABLE_ID bigint
);

drop table CATISSUE_QUERY_INTERFACE_TABLE_DATA;
CREATE TABLE CATISSUE_QUERY_INTERFACE_TABLE_DATA
(
      TABLE_ID bigint not null auto_increment, 
	  
      TABLE_NAME varchar(50),

      DISPLAY_NAME varchar(50),
	
      ALIAS_NAME varchar(50),
      
      primary key (TABLE_ID)
);


drop table CATISSUE_QUERY_INTERFACE_COLUMN_DATA;
CREATE TABLE CATISSUE_QUERY_INTERFACE_COLUMN_DATA
(
	  IDENTIFIER bigint not null auto_increment,

      TABLE_ID bigint not null,

      COLUMN_NAME varchar(50),

      DISPLAY_NAME varchar(50),
      
      ATTRIBUTE_TYPE varchar(30),
      
	  primary key (IDENTIFIER)
);

insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID, TABLE_NAME,DISPLAY_NAME,ALIAS_NAME) values (1,'CATISSUE_STORAGE_TYPE','Storage Type','StorageType');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'IDENTIFIER' , 'Identifier' , 'bigint' );
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'TYPE' , 'Type' , 'varchar');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'DEFAULT_TEMPERATURE_IN_CENTIGRADE' , 'Default Temperature In Centigrade' , 'double');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'DEFAULT_TEMPERATURE_IN_CENTIGRADE' , 'Default Temperature In Centigrade' , 'double');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'ONE_DIMENSION_LABEL' , 'One Dimension Label' , 'varchar');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'TWO_DIMENSION_LABEL' , 'Two Dimension Label' , 'varchar');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'STORAGE_CONTAINER_CAPACITY_ID' , 'Storage Container Capacity Id' , 'bigint');

insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID,TABLE_NAME,DISPLAY_NAME,ALIAS_NAME) values (2, 'CATISSUE_STORAGE_CONTAINER_CAPACITY','Storage Container Capacity','StorageContainerCapacity');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 2, 'IDENTIFIER' , 'Identifier' , 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 2, 'ONE_DIMENSION_CAPACITY' , 'One Dimension Capacity' , 'integer');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 2, 'TWO_DIMENSION_CAPACITY' , 'Two Dimension Capacity' , 'integer');

insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID,TABLE_NAME,DISPLAY_NAME,ALIAS_NAME) values (3,'CATISSUE_SITE','Site','Site');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 3, 'IDENTIFIER' , 'Identifier' , 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 3, 'NAME' , 'Name' , 'varchar');<commit_msg>*** empty log message ***<commit_after>drop TABLE CATISSUE_TABLE_RELATION;
CREATE TABLE CATISSUE_TABLE_RELATION
(
      PARENT_TABLE_ID bigint,      
      
      CHILD_TABLE_ID bigint
);

drop table CATISSUE_QUERY_INTERFACE_TABLE_DATA;
CREATE TABLE CATISSUE_QUERY_INTERFACE_TABLE_DATA
(
      TABLE_ID bigint not null auto_increment, 
	  
      TABLE_NAME varchar(50),

      DISPLAY_NAME varchar(50),
	
      ALIAS_NAME varchar(50),
      
      primary key (TABLE_ID)
);


drop table CATISSUE_QUERY_INTERFACE_COLUMN_DATA;
CREATE TABLE CATISSUE_QUERY_INTERFACE_COLUMN_DATA
(
	  IDENTIFIER bigint not null auto_increment,

      TABLE_ID bigint not null,

      COLUMN_NAME varchar(50),

      DISPLAY_NAME varchar(50),
      
      ATTRIBUTE_TYPE varchar(30),
      
	  primary key (IDENTIFIER)
);

insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID, TABLE_NAME,DISPLAY_NAME,ALIAS_NAME) values (1,'CATISSUE_STORAGE_TYPE','Storage Type','StorageType');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'IDENTIFIER' , 'Identifier' , 'bigint' );
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'TYPE' , 'Type' , 'varchar');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'DEFAULT_TEMPERATURE_IN_CENTIGRADE' , 'Default Temperature In Centigrade' , 'double');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'ONE_DIMENSION_LABEL' , 'One Dimension Label' , 'varchar');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'TWO_DIMENSION_LABEL' , 'Two Dimension Label' , 'varchar');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 1, 'STORAGE_CONTAINER_CAPACITY_ID' , 'Storage Container Capacity Id' , 'bigint');

insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID,TABLE_NAME,DISPLAY_NAME,ALIAS_NAME) values (2, 'CATISSUE_STORAGE_CONTAINER_CAPACITY','Storage Container Capacity','StorageContainerCapacity');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 2, 'IDENTIFIER' , 'Identifier' , 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 2, 'ONE_DIMENSION_CAPACITY' , 'One Dimension Capacity' , 'integer');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 2, 'TWO_DIMENSION_CAPACITY' , 'Two Dimension Capacity' , 'integer');

insert into CATISSUE_QUERY_INTERFACE_TABLE_DATA  ( TABLE_ID,TABLE_NAME,DISPLAY_NAME,ALIAS_NAME) values (3,'CATISSUE_SITE','Site','Site');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 3, 'IDENTIFIER' , 'Identifier' , 'bigint');
insert into CATISSUE_QUERY_INTERFACE_COLUMN_DATA ( TABLE_ID, COLUMN_NAME , DISPLAY_NAME , ATTRIBUTE_TYPE ) values ( 3, 'NAME' , 'Name' , 'varchar');
{'fraction_non_alphanumeric': 0.08768487775430124, 'fraction_numerical': 0.007998792635073951, 'mean_word_length': 6.3879598662207355, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '175607', 'n_tokens_mistral': 2515, 'n_tokens_neox': 2399, 'n_words': 464}