MySQL 5.5
<cfcomponent extends="plugins.dbmigrate.Migration" hint="creates groups table">
<cffunction name="up">
<cfscript>
t = createTable(name='groups');
t.string(columnNames='displayName', null=false, limit='100');
t.string(columnNames='nameSpace', null=false, limit='100');
t.string(columnNames='description', limit='255');
t.references('user');
t.timestamps();
t.create();
</cfscript>
</cffunction>
<cffunction name="down">
<cfscript>
dropTable('groups');
</cfscript>
</cffunction>
</cfcomponent>
results in the following sql
CREATE TABLE groups (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
displayName VARCHAR(100) NOT NULL,
nameSpace VARCHAR(100) NOT NULL,
description VARCHAR(255),
userid INT NOT NULL,
createdat DATETIME,
updatedat DATETIME,
deletedat DATETIME,
);
MySQL 5.5
results in the following sql
CREATE TABLE
groups(idINT NOT NULL AUTO_INCREMENT PRIMARY KEY,displayNameVARCHAR(100) NOT NULL,nameSpaceVARCHAR(100) NOT NULL,descriptionVARCHAR(255),useridINT NOT NULL,createdatDATETIME,updatedatDATETIME,deletedatDATETIME,);