 CREATE TABLE comments
 (
 	id #loc.identityColumnType#
-	,postid int NOT NULL
+	,postid #loc.intColumnType# NOT NULL
 	,body #loc.textColumnType# NOT NULL
 	,name varchar(100) NOT NULL
 	,url varchar(100) NULL

<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">

</cfquery>

<cfquery name="loc.query" datasource="#application.wheels.dataSourceName#">
CREATE TABLE galleries
(
	id #loc.identityColumnType#
	,userid #loc.intColumnType# NOT NULL
	,title varchar(255) NOT NULL
	,description #loc.textColumnType# NOT NULL
	,PRIMARY KEY(id)
) #loc.storageEngine#
</cfquery>

<cfquery name="loc.query" datasource="#application.wheels.dataSourceName#">
CREATE TABLE photos
(
	id #loc.identityColumnType#
	,galleryid #loc.intColumnType# NOT NULL
	,filename varchar(255) NOT NULL
	,description varchar(255) NOT NULL
	,filedata #loc.binaryColumnType# NULL
	,PRIMARY KEY(id)
) #loc.storageEngine#
</cfquery>

