booksdefinition.oli

数据仓库工具

<definitionInclude>
	<importDefinition name="BOOKS" tableName="BOOKS" logMode="normal" objectIDIncrement="20" >
		<valueColumns>
			<valueColumn sourceColumnName="BOOKNAME" targetTableName="BOOKS" targetColumnName="BOOKNAME" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="LANGUAGE" targetTableName="BOOKS" targetColumnName="LANGUAGE" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="KEYVALUE" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="0" valueMode="Key"/>
			<valueColumn sourceColumnName="XMLNAME" targetTableName="BOOKS" targetColumnName="XMLNAME" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER01DESC" targetTableName="BOOKS" targetColumnName="CHAPTER01DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER02DESC" targetTableName="BOOKS" targetColumnName="CHAPTER02DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER03DESC" targetTableName="BOOKS" targetColumnName="CHAPTER03DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER04DESC" targetTableName="BOOKS" targetColumnName="CHAPTER04DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER05DESC" targetTableName="BOOKS" targetColumnName="CHAPTER05DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER06DESC" targetTableName="BOOKS" targetColumnName="CHAPTER06DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER07DESC" targetTableName="BOOKS" targetColumnName="CHAPTER07DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER08DESC" targetTableName="BOOKS" targetColumnName="CHAPTER08DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER09DESC" targetTableName="BOOKS" targetColumnName="CHAPTER09DESC" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="CHAPTER10DESC" targetTableName="BOOKS" targetColumnName="CHAPTER10DESC" targetTableID="0" valueMode="Overwrite"/>
		</valueColumns>
		<tables>
			<table tableName="BOOKS" tableID="0" insert="true" tableMode="Query" oidLogic="true"/>
		</tables>
	</importDefinition>
	<importDefinition name="BOOKLINKS" tableName="BOOKLINKS" logMode="normal" objectIDIncrement="20" >
		<valueColumns>			
			<valueColumn sourceColumnName="TYPEKEY" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="9" valueMode="Key"/>
			<valueColumn sourceColumnName="BOOKLINENUMBER" targetTableName="BOOKLINKS" targetColumnName="BOOKLINENUMBER" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="KEYVALUE" targetTableName="BOOKLINKS" targetColumnName="KEYVALUE" targetTableID="0" valueMode="Key"/>
			<valueColumn sourceColumnName="XMLNAME" targetTableName="BOOKLINKS" targetColumnName="XMLNAME" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING01" targetTableName="BOOKLINKS" targetColumnName="URLSTRING01" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING02" targetTableName="BOOKLINKS" targetColumnName="URLSTRING02" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING03" targetTableName="BOOKLINKS" targetColumnName="URLSTRING03" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING04" targetTableName="BOOKLINKS" targetColumnName="URLSTRING04" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING05" targetTableName="BOOKLINKS" targetColumnName="URLSTRING05" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING06" targetTableName="BOOKLINKS" targetColumnName="URLSTRING06" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING07" targetTableName="BOOKLINKS" targetColumnName="URLSTRING07" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING08" targetTableName="BOOKLINKS" targetColumnName="URLSTRING08" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING09" targetTableName="BOOKLINKS" targetColumnName="URLSTRING09" targetTableID="0" valueMode="Overwrite"/>
			<valueColumn sourceColumnName="URLSTRING10" targetTableName="BOOKLINKS" targetColumnName="URLSTRING10" targetTableID="0" valueMode="Overwrite"/>
		</valueColumns>
		<relationColumns>
			<relationColumn relationSourceTableName="BOOKS" relationSourceTableID="9" relationTargetTableName="BOOKLINKS" relationTargetColumnName="BOOKOID" relationTargetTableID="0" relationMode="Overwrite"/>
		</relationColumns>
		<tables>
			<table tableName="BOOKS" tableID="9" insert="false" tableMode="Query" oidLogic="true"/>
			<table tableName="BOOKLINKS" tableID="0" insert="true" tableMode="Query" oidLogic="true"/>
		</tables>
	</importDefinition>
	<importDefinition name="RelationBooks" tableName="BOOKLINKS" logMode="normal" objectIDIncrement="20" >
		<valueColumns>
			<valueColumn sourceColumnName="KEYVALUE" targetTableName="BOOKLINKS" targetColumnName="KEYVALUE" targetTableID="0" valueMode="Key"/>
			<valueColumn sourceColumnName="TYPEKEY" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="1" valueMode="Key"/>
			<valueColumn sourceColumnName="BOOKKEY" targetTableName="BOOKLINKS" targetColumnName="KEYVALUE" targetTableID="2" valueMode="Key"/>
			<valueColumn sourceColumnName="BOOKTYPEKEY" targetTableName="BOOKS" targetColumnName="KEYVALUE" targetTableID="3" valueMode="Key"/>
		</valueColumns>
		<relationColumns>
			<relationColumn relationSourceTableName="BOOKLINKS" relationSourceTableID="2" relationTargetTableName="BOOKLINKS" relationTargetColumnName="BOOKLINKSOID" relationTargetTableID="0" relationMode="Overwrite"/>
		</relationColumns>
		<tables>
			<table tableName="BOOKS" tableID="1" insert="false" tableMode="Cache" oidLogic="true"/>
			<table tableName="BOOKLINKS" tableID="0" insert="false" tableMode="Cache" oidLogic="true"/>
			<table tableName="BOOKS" tableID="3" insert="false" tableMode="Cache" oidLogic="true"/>
			<table tableName="BOOKLINKS" tableID="2" insert="false" tableMode="Cache" oidLogic="true"/>
		</tables>
	</importDefinition>
</definitionInclude>