 <cfquery name="loc.query" datasource="wheelstestdb">
 CREATE TABLE users
 (
-	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>
 	username varchar(50) NOT NULL,
 	password varchar(50) NOT NULL,
 	firstname varchar(50) NOT NULL,

<cfquery name="loc.query" datasource="wheelstestdb">
CREATE TABLE authors
(
	id int NOT NULL #loc.ident# PRIMARY KEY,
	firstname varchar(100) NOT NULL,
	lastname varchar(100) NOT NULL
) #loc.engine#

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