 	birthdayyear int NULL,
 	birthtime datetime NULL DEFAULT '2000-01-01 18:26:08.690',
 	isactive bit NULL
-)
+) #loc.engine#
 </cfquery>
 
 

	authorid int NULL,
	dateofbirth datetime NOT NULL,
	bio text NULL
)
</cfquery>

<cfquery name="loc.query" datasource="wheelstestdb">

<cfdbinfo name="loc.dbinfo" datasource="wheelstestdb" type="version">
<cfset loc.db = LCase(Replace(loc.dbinfo.database_productname, " ", "", "all"))>

<!--- handle differences in database for identity inserts and engines --->
<cfif loc.db IS "microsoftsqlserver">
	<cfset loc.ident = "IDENTITY(1,1)">
	<cfset loc.engine = "">
<cfelseif loc.db IS "mysql">
	<cfset loc.ident = "AUTO_INCREMENT">
	<cfset loc.engine = "ENGINE=InnoDB">
<cfelse>
	<cfset loc.ident = "IDENTITY">
	<cfset loc.engine = "">
</cfif>

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