Autogenerating database schema

ColdFusion automatically creates tables when ORM is initialized for the application. For auto-generating tables, do the following:

In the THIS scope of Application.cfc, in ormsettings struct, set the dbCreate property to one of the following values:

  • update: Creates the table (if it does not exist) or updates the table (if it exists).

  • dropcreate: Drops the table if it exists and then creates it.

For example, 
<cfset this.ormsettings.dbCreate="update">

Certain specific attributes (DDL-only attributes) defined for the tags cfcomponent and cfproperty can be use to define various attributes for the auto-generated tables and columns. DDL-only attributes are used only for DDL generation. For details of these attributes, see the table in the section DDL-only attributes in Column.

Examples

Application.cfc
<cfset this.name = "AG"/>
<cfset this.ormenabled=true/>
<cfset this.datasource = "ORM_DDL">
<cfset this.ormsettings.dbCreate="dropcreate">
<cfset this.ormsettings.sqlscript="mysqlscript.sql">

Artists.cfc

<cfcomponent persistent="true" table="Artists">
      <cfproperty name="artistid" fieldtype="id" ormtype="integer" length=10>
      <cfproperty name="firstname" ormtype="string" length="20" notnull="true">
      <cfproperty name="lastname" ormtype="string" length="20" notnull="true">
      <cfproperty name="address"  ormtype="string" length="50">
      <cfproperty name="city" ormtype="string" length="20">
      <cfproperty name="state" ormtype="string" length="2">
      <cfproperty name="postalcode" ormtype="string" length="10">
      <cfproperty name="email" ormtype="string" length="50" unique="true">
      <cfproperty name="phone" ormtype="string" length="20">
      <cfproperty name="fax" ormtype="string" length="12">
      <cfproperty name="thepassword" ormtype="string" length="20">
</cfcomponent>
art.cfc
<cfcomponent persistent="true" table="Art">
      <cfproperty name="artid" generator="identity" fieldtype="id">
      <cfproperty name="artname" ormtype="string" length="50">
      <cfproperty name="price" ormtype="double">
      <cfproperty name="largeimage" ormtype="string" length="30">
      <cfproperty name="mediaid" ormtype="integer" length="10">
      <cfproperty name="issold" ormtype="boolean" dbdefault=1>
      <cfproperty name="artist" fkcolumn="artistid" fieldtype="many-to-one" cfc="CArtists">
</cfcomponent>