 <cfquery name="loc.query" datasource="wheelstestdb">
 CREATE TABLE collisiontests
 (
-	id int NOT NULL #loc.ident# PRIMARY KEY,
+	<cfif loc.db IS "sqlite">
+		id integer NOT NULL PRIMARY KEY #loc.ident#,
+	<cfelse>
+		id int NOT NULL #loc.ident# PRIMARY KEY,
+	</cfif>
 	method varchar(100) NOT NULL
 ) #loc.engine#
 </cfquery>

<cfelseif loc.db IS "mysql">
	<cfset loc.ident = "AUTO_INCREMENT">
	<cfset loc.engine = "ENGINE=InnoDB">
<cfelse>
	<cfset loc.ident = "IDENTITY">
	<cfset loc.engine = "">

<cfquery name="loc.query" datasource="wheelstestdb">
CREATE TABLE tags
(
	<cfif loc.db IS "sqlite">
		id integer NOT NULL PRIMARY KEY #loc.ident#,
	<cfelse>
		id int NOT NULL #loc.ident# PRIMARY KEY,
	</cfif>
	name varchar(50) NOT NULL,
	description varchar(50) NULL
) #loc.engine#
