 CREATE TABLE posts
 (
 	id #loc.identityColumnType#
-	,authorid int NULL
+	,authorid #loc.intColumnType# NULL
 	,title varchar(250) NOT NULL
 	,body #loc.textColumnType# NOT NULL
 	,createdat #loc.datetimeColumnType# NOT NULL
 	,updatedat #loc.datetimeColumnType# NOT NULL
 	,deletedat #loc.datetimeColumnType# NULL
-	,views int DEFAULT 0 NOT NULL
+	,views #loc.intColumnType# DEFAULT 0 NOT NULL
 	,averagerating float NULL
 	,PRIMARY KEY(id)
 ) #loc.storageEngine#

<cfset loc.dateTimeDefault = "'2000-01-01 18:26:08.690'">
<cfset loc.binaryColumnType = "blob">
<cfset loc.textColumnType = "text">
<cfset loc.identityColumnType = "">

<cfif loc.db IS "microsoftsqlserver">

	<cfset loc.dateTimeColumnType = "timestamp">
	<cfset loc.binaryColumnType = "bytea">
<cfelseif loc.db IS "oracle">
	<cfset loc.identityColumnType = "number(38,0) NOT NULL">
	<cfset loc.dateTimeColumnType = "timestamp">
	<cfset loc.textColumnType = "varchar2(4000)">
	<cfset loc.intColumnType = "number(38,0)">
	<cfset loc.dateTimeDefault = "to_timestamp(#loc.dateTimeDefault#,'yyyy-dd-mm hh24:mi:ss.FF')">
</cfif>

