<cfcomponent extends="Records" displayname="Specials" output="no">

<cffunction name="getDbXml" access="public" returntype="string" output="no" hint="I return the XML for the tables needed for Groups to work.">
	
	<cfset var tableXML = "">
	
	<cfsavecontent variable="tableXML">
	<tables>
		<table name="dmSpecials">
			<field ColumnName="RecordID" CF_DataType="CF_SQL_INTEGER" PrimaryKey="true" Increment="true" />
			<field ColumnName="RecordVal" CF_DataType="CF_SQL_VARCHAR" Length="80" />
			<field ColumnName="ordernum" CF_DataType="CF_SQL_INTEGER" Special="Sorter" />
			<field ColumnName="created" CF_DataType="CF_SQL_DATE" Special="CreationDate" />
			<field ColumnName="updated" CF_DataType="CF_SQL_DATE" Special="LastUpdatedDate" />
			<field ColumnName="isDeleted" CF_DataType="CF_SQL_BIT" Special="DeletionMark" />
		</table>
		<data table="dmSpecials">
			<row RecordVal="Dress Code" />
			<row RecordVal="Sick Leave" />
			<row RecordVal="Incident Management" />
		</data>
	</tables>
	</cfsavecontent>
	
	<cfreturn tableXML>
</cffunction>

</cfcomponent>