 <cfquery name="loc.query" datasource="#application.wheels.dataSourceName#">
 CREATE VIEW userphotos AS
 SELECT u.id AS userid, u.username AS username, u.firstname AS firstname, u.lastname AS lastname, pg.title AS title, pg.photogalleryid AS photogalleryid
-FROM users u INNER JOIN photogalleries pg ON u.id = pg.userid;
+FROM users u INNER JOIN photogalleries pg ON u.id = pg.userid
 </cfquery>
 
 

	<cfset loc.identityColumnType = "SERIAL NOT NULL">
	<cfset loc.dateTimeColumnType = "timestamp">
	<cfset loc.binaryColumnType = "bytea">
</cfif>

<!--- get a listing of all the tables and view in the database --->

<!--- handle differences in database for identity inserts, column types etc--->
<cfset loc.storageEngine = "">
<cfset loc.dateTimeColumnType = "datetime">
<cfset loc.dateTimeDefault = "'2000-01-01 18:26:08.690'">
<cfset loc.binaryColumnType = "blob">
<cfset loc.textColumnType = "text">
<cfset loc.identityColumnType = "">

<cfif loc.db IS "microsoftsqlserver">
	<cfset loc.identityColumnType = "int NOT NULL IDENTITY(1,1)">
	<cfset loc.binaryColumnType = "image">
