cfwheels-dbmigrate-plugin
cfwheels-dbmigrate-plugin copied to clipboard
tdm00
ColdFusion on Wheels DBMigrate plugin fork
This should fix the issue #76 Error when creating references. The code was already in adapters.Abstract.cfc. Just need to call it from ForeignKeyDefinition
Example: ```javascript t = createTable(name='testTable'); t.date(columnNames="startat,endat"); t.timestamps(); t.create(); ``` This will create `datetime` type columns for `startat` and `endat`. In the file `adapters\MicrosoftSQLServer.cfc` I noticed `variables.sqlTypes['date'] = {name='DATETIME'}`, same as...
I am just starting out with cfwheels and tying to follow along with Chris Peters' CFWheels DBMigrate Create Operations video on Vimeo. (https://vimeo.com/channels/cfwheels/40902756) I got the default app installed no...
Added new limit options for integers, dates, & money (maps to decimal on non-mssql db) handy new methods mediumInteger(), smallInteger(), tinyInteger() adds support for MSSQL: DATE, SMALLDATETIME, MONEY, SMALLMONEY, BIGINT,...
This feature would be very handy during the development of migration scripts. Perhaps a link on the plugin's index page. I'm not convinced the the step parameter is required? From...
MySQL 5.5 ``` 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(); dropTable('groups'); ``` results in the following sql CREATE TABLE `groups` ( `id` INT...
The 'quoteTableName' function (Abstract.cfc) needs to be moved to the 'PostgreSQL' adapter as Postgres requires double quotes.
When adding records it would be great if I the createdat and updatedat would be automatically used also if available. ``` t = createTable('tags'); t.string('name'); t.timestamps(); t.create(); addRecord(table='tags',id=1,name='ColdFusion'); addRecord(table='tags',id=2,name='Wheels') ```...
Not sure how hard it would be but when creating new migration scripts for create table it would be cool if one could add the table name so that the...
