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

<cfquery name="loc.query" datasource="wheelstestdb">
CREATE TABLE users
(
	id int NOT NULL #loc.ident# PRIMARY KEY,
	username varchar(50) NOT NULL,
	password varchar(50) NOT NULL,
	firstname varchar(50) NOT NULL,

<cfquery name="loc.query" datasource="wheelstestdb">
CREATE TABLE posts
(
	<cfif loc.db IS "sqlite">
		id integer NOT NULL PRIMARY KEY #loc.ident#,
	<cfelse>
		id int NOT NULL #loc.ident# PRIMARY KEY,
	</cfif>
	authorid int NULL,
	title varchar(250) NOT NULL,
	body text NOT NULL,
