 (
 	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>
+	lastname varchar(100) NOT NULL,
+	PRIMARY KEY(id #loc.identityKeyWord#)
 ) #loc.storageEngine#
 </cfquery>
 

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


(
	shopid char(9) NOT NULL,
	citycode int NULL,
	name varchar(80) NOT NULL,
	PRIMARY KEY(shopid)
) #loc.storageEngine#
</cfquery>

