 	<cfset loc.identityColumnType = "int NOT NULL AUTO_INCREMENT">
 	<cfset loc.storageEngine = "ENGINE=InnoDB">
 <cfelseif loc.db IS "sqlite">
-	<cfset loc.identityColumnType = "integer NOT NULL AUTOINCREMENT">
+	<cfset loc.identityColumnType = "integer NOT NULL PRIMARY KEY AUTOINCREMENT">
 <cfelseif loc.db IS "h2">
 	<cfset loc.identityColumnType = "int NOT NULL IDENTITY">
 <cfelseif loc.db IS "postgresql">

	updatedat #loc.datetimeColumnType# NOT NULL,
	deletedat #loc.datetimeColumnType# NULL,
	views int NOT NULL DEFAULT 0,
	averagerating float NULL,
	PRIMARY KEY(id)
) #loc.storageEngine#
</cfquery>


	name varchar(100) NOT NULL,
	url varchar(100) NULL,
	email varchar(100) NULL,
	createdat #loc.datetimeColumnType# NOT NULL
	<cfif loc.identityColumnType Does Not Contain "PRIMARY KEY">,PRIMARY KEY(id)</cfif>
) #loc.storageEngine#
</cfquery>

