 	deletedat datetime NULL,
 	views int NOT NULL DEFAULT 0,
 	averagerating float NULL
-)
+) #loc.engine#
 </cfquery>
 
 <cfquery name="loc.query" datasource="wheelstestdb">

<cfdbinfo name="loc.dbinfo" datasource="wheelstestdb" type="version">
<cfset loc.db = LCase(Replace(loc.dbinfo.database_productname, " ", "", "all"))>

<!--- handle differences in database for identity inserts --->
<cfif loc.db IS "microsoftsqlserver">
	<cfset loc.ident = "IDENTITY(1,1)">
<cfelseif loc.db IS "mysql">
	<cfset loc.ident = "AUTO_INCREMENT">
<cfelse>
	<cfset loc.ident = "IDENTITY">
</cfif>

<!--- get a listing of all the tables and view in the database --->

	userid int NOT NULL,
	title varchar(255) NOT NULL,
	description text NOT NULL
) #loc.engine#
</cfquery>

<cfquery name="loc.query" datasource="wheelstestdb">
