#$Id: DatabaseSchema.conf,v 1.16.2.2 2006/05/11 11:16:01 srini Exp $
BeginModules SQLOneSearch

BeginCreateSchema
create table SearchIndexInfo (
  CRID bigint(19) NOT NULL default '0',
  INDEXDSID bigint(19) NOT NULL default '0',
  INDEXDSNAME varchar(30) NOT NULL default 'default',
  CONSTRAINT SearchIndexInfo_PK PRIMARY KEY  (INDEXDSID),
  CONSTRAINT SearchIndexInfo_UK0 UNIQUE (CRID),
  CONSTRAINT SearchIndexInfo_UK1 UNIQUE (INDEXDSNAME),
  CONSTRAINT SII_CR_FK0 FOREIGN KEY (CRID) REFERENCES ConfigurationRecord (CRID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE AppIndexingInfo (
  CRID bigint(19) NOT NULL default '0',
  APPLICATIONID bigint(19) NOT NULL default '0',
  APPLICATIONNAME varchar(30) NOT NULL default '',
  APPDSNAME varchar(30) NOT NULL default 'default',
  MAXWORDSIZE int(5) NOT NULL default '200',
  INDEXINGDELIMITERS varchar(40) NOT NULL default ' ,:@-.(){}',
  ENABLEPARTIALSEARCH tinyint(1) NOT NULL default '0',
  ENABLEDYNAMICINDEXING tinyint(1) NOT NULL default '0',
  ENABLEINCREMENTALINDEXING tinyint(1) NOT NULL default '0',
  POPULATE_FK_REL tinyint(1) NOT NULL default '0',
  STATUS smallint(1) NOT NULL default '0',
  CONSTRAINT AppIndexingInfo_PK PRIMARY KEY  (APPLICATIONID),
  CONSTRAINT AppIndexingInfo_UK0 UNIQUE (CRID),
  CONSTRAINT AppIndexingInfo_UK1 UNIQUE (APPDSNAME),
  CONSTRAINT AppIndexingInfo_UK2 UNIQUE (APPLICATIONNAME),
  CONSTRAINT AII_CR_FK0 FOREIGN KEY (CRID) REFERENCES ConfigurationRecord (CRID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE AppScheduleInfo (
  APPLICATIONID bigint(19) NOT NULL default '0',
  SCHEDULERID  bigint(20) NOT NULL default '0',
  SCHEDULETYPE varchar(10) NOT NULL default 'Daily',
  SCHEDULEDETAILS varchar(200) NOT NULL,
  CONSTRAINT AppScheduleInfo_PK PRIMARY KEY  (APPLICATIONID),
  CONSTRAINT ASI_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE,
  KEY AppScheduleInfo_IDX1 (SCHEDULERID),
  CONSTRAINT ASI_AII_FK1 FOREIGN KEY (SCHEDULERID) REFERENCES Schedule (SCHEDULE_ID) ON DELETE CASCADE)
TYPE=InnoDB 
EndCreateSchema

BeginCreateSchema
CREATE TABLE KeyFinderConfig (
  APPLICATIONID bigint(19) NOT NULL default '0',
  MAXNUMPKCOLS int(2) NOT NULL default '5',
  MAXCOLLENGTH int(5) NOT NULL default '200',
  MINROWSFORFINDINGPK int(5) NOT NULL default '10',
  COMPARECOLNAMES tinyint(1) NOT NULL default '0',
  PERCENTMATCH int(3) NOT NULL default '100',
  CONSTRAINT KeyFinderConfig_PK PRIMARY KEY  (APPLICATIONID),
  CONSTRAINT KFC_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE RelFinderConfig (
  APPLICATIONID bigint(19) NOT NULL default '0',
  USETBLCREATIONTIME tinyint(1) NOT NULL default '1',
  CONSTRAINT RelFinderConfig_PK PRIMARY KEY  (APPLICATIONID),
  CONSTRAINT RFC_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE DataTypeToIgnore (
  APPLICATIONID bigint(19) NOT NULL default '0',
  DATATYPE varchar(30) NOT NULL default '',
  CONSTRAINT DataTypeToIgnore_PK PRIMARY KEY  (APPLICATIONID,DATATYPE),
  KEY DataTypeToIgnore_IDX0 (APPLICATIONID),
  CONSTRAINT DTTI_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE
) TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE TableToIndex (
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  CONSTRAINT TableToIndex_PK PRIMARY KEY  (APPLICATIONID,TABLENAME),
  KEY TableToIndex_IDX0 (APPLICATIONID),
  CONSTRAINT TTI_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE ColumnToIgnore (
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  COLUMNNAME varchar(30) NOT NULL default '',
  CONSTRAINT ColumnToIgnore_PK PRIMARY KEY  (APPLICATIONID,TABLENAME,COLUMNNAME),
  KEY ColumnToIgnore_IDX0 (APPLICATIONID,TABLENAME),
  CONSTRAINT CTI_TTI_FK0 FOREIGN KEY (APPLICATIONID, TABLENAME) REFERENCES TableToIndex (APPLICATIONID, TABLENAME) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE AppCategories (
  CATEGORYID bigint(19) NOT NULL default '0',
  APPLICATIONID bigint(19) NOT NULL default '0',
  CATEGORY varchar(30) NOT NULL default '',
  CONSTRAINT AppCategories_PK PRIMARY KEY  (CATEGORYID),
  UNIQUE KEY AppCategories_UK0 (APPLICATIONID,CATEGORY),
  KEY AppCategories_IDX0 (APPLICATIONID),
  CONSTRAINT AC_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE TableInCategory (
  CATEGORYID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  CONSTRAINT TableInCategory_PK PRIMARY KEY  (CATEGORYID,TABLENAME),
  KEY TableInCategory_IDX0 (CATEGORYID),
  CONSTRAINT TIC_AC_FK0 FOREIGN KEY (CATEGORYID) REFERENCES AppCategories (CATEGORYID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE GroupByCategory (
  CATEGORYID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  GROUPBYCOLUMN varchar(30) NOT NULL default '',
  CONSTRAINT GroupByCategory_PK PRIMARY KEY  (CATEGORYID,TABLENAME),
  CONSTRAINT GBC_TIC_FK0 FOREIGN KEY (CATEGORYID, TABLENAME) REFERENCES TableInCategory (CATEGORYID, TABLENAME) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE CrawlerTaskInput (
  INSTANCEID bigint(19) NOT NULL default '0',
  APPLICATIONNAME varchar(40) NOT NULL default '',
  CONSTRAINT CrawlerTaskInput_PK PRIMARY KEY  (INSTANCEID),
  KEY CrawlerTaskInput_IDX0 (INSTANCEID),
  CONSTRAINT CTT_TI_FK0 FOREIGN KEY (INSTANCEID) REFERENCES Task_Input (INSTANCE_ID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE SearchSortTable (
  SSORTID bigint(19) NOT NULL default '0',
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  CONSTRAINT SearchSortTable_PK PRIMARY KEY  (SSORTID),
  CONSTRAINT SearchSortTable_UK0 UNIQUE (APPLICATIONID,TABLENAME),
  KEY SearchSortTable_IDX0 (APPLICATIONID),
  CONSTRAINT SST_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE SearchSortColumn (
  SSORTID bigint(19) NOT NULL default '0',
  COLUMNNAME varchar(40) NOT NULL default '',
  ISASCENDING tinyint(1) NOT NULL default '1',
  SORTORDER int(2) NOT NULL default '1',
  CONSTRAINT SearchSortColumn_PK PRIMARY KEY  (SSORTID,COLUMNNAME),
  KEY SearchSortColumn_IDX0 (SSORTID),
  CONSTRAINT SSC_SST_FK0 FOREIGN KEY (SSORTID) REFERENCES SearchSortTable (SSORTID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE VocabularyInfo (
  VOCABULARYID bigint(19) NOT NULL default '0',
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(30) NOT NULL default '',
  COLUMNNAME varchar(30) NOT NULL default '',
  ORIGINALVALUE varchar(30) NOT NULL default '',
  DBVALUE varchar(30) NOT NULL default '',
  CONSTRAINT VocabularyInfo_PK PRIMARY KEY  (VOCABULARYID),
  KEY VocabularyInfo_IDX0 (APPLICATIONID),
  CONSTRAINT VI_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE
) TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE VocabularyValueMap (
  VOCABULARYID bigint(19) NOT NULL default '0',
  DBVALUE varchar(30) NOT NULL default '',
  ORIGINALVALUE varchar(30) NOT NULL default '',
  CONSTRAINT VocabularyValueMap_PK PRIMARY KEY  (VOCABULARYID,DBVALUE),
  KEY VocabularyInfo_IDX0 (VOCABULARYID),
  CONSTRAINT VVM_VI_FK0 FOREIGN KEY (VOCABULARYID) REFERENCES VocabularyInfo (VOCABULARYID) ON DELETE CASCADE
) TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE ColumnIndex (
  COLUMNID bigint(19) NOT NULL default '0',
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  COLUMNNAME varchar(30) NOT NULL default '',
  COLUMNTYPE int(2) NOT NULL default '0',
  TOTALWORDS int(10) NOT NULL default '0',
  CONSTRAINT ColumnIndex_PK PRIMARY KEY  (COLUMNID),
  KEY ColumnIndex_IDX0 (APPLICATIONID),
  CONSTRAINT CI_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE TableWeight (
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(40) NOT NULL default '',
  ISDOMINANT int(10) NOT NULL default '1',
  TABLEMARKS float NOT NULL default '0',
  TABLERANK int(10) NOT NULL default '0',
  NUMBEROFROWS bigint(19) NOT NULL default '0',
  NUMBEROFCOLS int(10) NOT NULL default '0',
  CONSTRAINT TableWeight_PK PRIMARY KEY  (APPLICATIONID,TABLENAME),
  KEY TableWeight_IDX0 (APPLICATIONID),
  CONSTRAINT TW_AII FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE RelationshipInfo (
  RELID bigint(19) NOT NULL default '0',
  FKNAME varchar(240) NOT NULL default '',
  APPLICATIONID bigint(19) NOT NULL default '0',
  ORIGINTABLENAME varchar(40) NOT NULL default '',
  ORIGINCOLUMNNAME varchar(30) NOT NULL default '',
  DESTTABLENAME varchar(40) NOT NULL default '',
  DESTCOLUMNNAME varchar(30) NOT NULL default '',
  RELLEVEL int(10) NOT NULL default '1',
  KEYTYPE int(2) NOT NULL default '2',
  CONSTRAINT RelationshipInfo_PK PRIMARY KEY  (RELID),
  KEY RelationshipInfo_IDX0 (APPLICATIONID),
  KEY RelationshipInfo_IDX1 (ORIGINTABLENAME),
  KEY RelationshipInfo_IDX2 (DESTTABLENAME),
  CONSTRAINT RI_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE DatabaseWordCount (
  APPLICATIONID bigint(19) NOT NULL default '0',
  WORDCOUNT int(10) NOT NULL default '0',
  CONSTRAINT DatabaseWordCount_PK PRIMARY KEY  (APPLICATIONID),
  KEY DatabaseWordCount_IDX0 (APPLICATIONID),
  CONSTRAINT DWC_AII_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema


BeginCreateSchema
CREATE TABLE DatabaseResource (
  RESOURCEID bigint(19) NOT NULL default '0',
  CREATEDTIME bigint(19) NOT NULL default '0',
  HOSTNAME varchar(200) NOT NULL,
  PORT varchar(10) NOT NULL,
  DBNAME varchar(40) NOT NULL,
  DSNAME varchar(240) NOT NULL,
  CONSTRAINT DatabaseResource_PK PRIMARY KEY  (RESOURCEID),
  UNIQUE KEY DatabaseResource_UK0 (HOSTNAME,PORT,DBNAME))
TYPE=InnoDB
EndCreateSchema

BeginCreateSchema
CREATE TABLE WordOccurrences (
  WORDHASHID int(10) NOT NULL default '0',
  COLUMNID bigint(19) NOT NULL default '0',
  WORDCOUNT int(10) NOT NULL default '0',
  CONSTRAINT WordOccurrences_PK PRIMARY KEY  (WORDHASHID,COLUMNID),
  KEY WordOccurrences_IDX0 (COLUMNID),
  CONSTRAINT WO_CI_FK0 FOREIGN KEY (COLUMNID) REFERENCES ColumnIndex (COLUMNID) ON DELETE CASCADE
) TYPE=MyISAM
EndCreateSchema

BeginCreateSchema
CREATE TABLE WordMap (
  APPLICATIONID bigint(19) NOT NULL default '0',
  WORD varchar(210) NOT NULL default '',
  KEY WordMap_IDX1 (APPLICATIONID,WORD),
  KEY WordMap_IDX0 (APPLICATIONID),
  CONSTRAINT WO_CI_FK0 FOREIGN KEY (APPLICATIONID) REFERENCES ColumnIndex (APPLICATIONID) ON DELETE CASCADE)
TYPE=MyISAM
EndCreateSchema

BeginCreateSchema
CREATE TABLE TableViewMap (
  TVMAPID bigint(19) NOT NULL default '0',
  APPLICATIONID bigint(19) NOT NULL default '0',
  TABLENAME varchar(50) NOT NULL default '',
  VIEWNAME varchar(30) default NULL,
  CONFIGLIST varchar(30) default NULL,
  DESCRIPTION varchar(150) default 'default',
  TABLEDETAILS tinyint(1) NOT NULL default '1',
  QUERY tinyint(1) NOT NULL default '1',
  TABLERELATIONS tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (TVMAPID),
  KEY TVM_FK1_IDX (APPLICATIONID),
  CONSTRAINT TableViewMap_FK FOREIGN KEY (APPLICATIONID) REFERENCES AppIndexingInfo (APPLICATIONID) ON DELETE CASCADE)
TYPE=InnoDB
EndCreateSchema

EndModules SQLOneSearch