 (
 	shopid char(9) NOT NULL,
 	citycode int NULL,
-	name varchar(80) NOT NULL,
-	PRIMARY KEY(shopid)
+	name varchar(80) NOT NULL
+	<cfif loc.identityColumnType Does Not Contain "PRIMARY KEY">,PRIMARY KEY(shopid)</cfif>
 ) #loc.storageEngine#
 </cfquery>
 

	photogalleryid #loc.identityColumnType#,
	userid int NOT NULL,
	title varchar(255) NOT NULL,
	description text NOT NULL,
	PRIMARY KEY(photogalleryid)
) #loc.storageEngine#
</cfquery>


(
	id #loc.identityColumnType#,
	firstname varchar(100) NOT NULL,
	lastname varchar(100) NOT NULL
	<cfif loc.identityColumnType Does Not Contain "PRIMARY KEY">,PRIMARY KEY(id)</cfif>
) #loc.storageEngine#
</cfquery>

