﻿<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE database [
  <!ENTITY % cfgDefinition SYSTEM "cfgDefinition.dtd">
  %cfgDefinition;
]>
<database>
  <schema>
  	<table name="TM_GlobalSetting" ignore_exist_error="true" exist_no_drop="true">
  	  <field name="Name" type="text" size="260" primary-key="primary-key" />
  	  <field name="IntValue" type="integer"/>
      <field name="StrValue" type="text" size="260" />
      <field name="DateValue" type="datetime" />
  	</table>
  
    <table name="TM_PortalProtectServers" ignore_exist_error="true" exist_no_drop="true">
      <field name="ServerName" type="text" size="64" primary-key="primary-key"/>
	  <field name="PortalProtectVersion" type="text" size="32" default="0" />	  
    </table>   
    
    <table name="TM_RecycleBin" ignore_exist_error="true" exist_no_drop="true">
      <field name="SiteId" type="guid" />
      <field name="WebId" type="guid" />
      <field name="BinId" type="tinyint" />
      <field name="DeleteUserId" type="integer" />
      <field name="DeleteTransactionId" type="varbinary" size="16" />
      <field name="DeleteDate" type="datetime" />
      <field name="ItemType" type="tinyint" />
      <field name="ListId" type="guid" />
      <field name="DocId" type="guid" />
      <field name="DocVersionId" type="integer" />
      <field name="ListItemId" type="integer" />
	  <field name="Title" type="text" size="260" />
	  <field name="DirName" type="text" size="256" />
	  <field name="LeafName" type="text" size="128" />
      <field name="AuthorId" type="integer" />
      <field name="Size" type="bigint" />
	  <field name="ListDirName" type="text" size="256" />
      <field name="ScopeId" type="guid" />
	  <field name="ProgId" type="text" size="255" />      
	  <field name="URL" type="text" size="512" />
 	  <field name="QuarantinedReason" type="text" size="64" />
	  <field name="PolicyName" type="text" size="256" />
	  <field name="Author" type="text" size="64" />
	  <field name="LastModifiedUser" type="text" size="64" />
	  <field name="SharePointVersion" type="integer"  />
	  <field name="ChildDeleteTransactionId" type="varbinary" size="16" />
	  <field name="OriginalItemType" type="tinyint"  />
	  <field name="EffectiveDeleteTransactionId" type="varbinary" size="16" />	  
    </table>  
  </schema>
</database>
