 <!--- 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">

<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;
</cfquery>



	<cfset loc.identityColumnType = "SERIAL NOT NULL">
	<cfset loc.dateTimeColumnType = "timestamp">
	<cfset loc.binaryColumnType = "bytea">
<cfelseif loc.db IS "oracle">
	<cfset loc.identityColumnType = "int NOT NULL">
	<cfset loc.dateTimeColumnType = "timestamp">
	<cfset loc.textColumnType = "long">
	<cfset loc.dateTimeDefault = "to_timestamp(#loc.dateTimeDefault#,'yyyy-dd-mm hh24:mi:ss.FF')">
</cfif>

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