diff options
author | Vijay Dev <vijaydev.cse@gmail.com> | 2011-07-15 11:32:11 -0700 |
---|---|---|
committer | Vijay Dev <vijaydev.cse@gmail.com> | 2011-07-15 11:32:11 -0700 |
commit | 88e307a0a6cadd9aafed38cce939a20abecd2a53 (patch) | |
tree | 957b38b8dd1f60466d7b1531e93938330f6ad192 /railties | |
parent | b6d5612f551e982441097a67df001b5da99dee58 (diff) | |
parent | 651cabc69a6cd661bc33824b995c2242fb65befe (diff) | |
download | rails-88e307a0a6cadd9aafed38cce939a20abecd2a53.tar.gz rails-88e307a0a6cadd9aafed38cce939a20abecd2a53.tar.bz2 rails-88e307a0a6cadd9aafed38cce939a20abecd2a53.zip |
Merge pull request #52 from dyba/651cabc69a6cd661bc33824b995c2242fb65befe
Modified migrations file
Diffstat (limited to 'railties')
-rw-r--r-- | railties/guides/source/migrations.textile | 39 |
1 files changed, 27 insertions, 12 deletions
diff --git a/railties/guides/source/migrations.textile b/railties/guides/source/migrations.textile index 7e71a5048d..c88e3cc338 100644 --- a/railties/guides/source/migrations.textile +++ b/railties/guides/source/migrations.textile @@ -117,6 +117,33 @@ Occasionally you will make a mistake when writing a migration. If you have alrea In general editing existing migrations is not a good idea: you will be creating extra work for yourself and your co-workers and cause major headaches if the existing version of the migration has already been run on production machines. Instead you should write a new migration that performs the changes you require. Editing a freshly generated migration that has not yet been committed to source control (or more generally which has not been propagated beyond your development machine) is relatively harmless. +h4. Supported Types + +Active Record supports the following types: + +* +:primary_key+ +* +:string+ +* +:text+ +* +:integer+ +* +:float+ +* +:decimal+ +* +:datetime+ +* +:timestamp+ +* +:time+ +* +:date+ +* +:binary+ +* +:boolean+ + +These will be mapped onto an appropriate underlying database type, for example with MySQL +:string+ is mapped to +VARCHAR(255)+. You can create columns of types not supported by Active Record when using the non-sexy syntax, for example + +<ruby> +create_table :products do |t| + t.column :name, 'polygon', :null => false +end +</ruby> + +This may however hinder portability to other databases. + h3. Creating a Migration h4. Creating a Model @@ -261,18 +288,6 @@ end will append +ENGINE=BLACKHOLE+ to the SQL statement used to create the table (when using MySQL the default is +ENGINE=InnoDB+). -The types supported by Active Record are +:primary_key+, +:string+, +:text+, +:integer+, +:float+, +:decimal+, +:datetime+, +:timestamp+, +:time+, +:date+, +:binary+, +:boolean+. - -These will be mapped onto an appropriate underlying database type, for example with MySQL +:string+ is mapped to +VARCHAR(255)+. You can create columns of types not supported by Active Record when using the non-sexy syntax, for example - -<ruby> -create_table :products do |t| - t.column :name, 'polygon', :null => false -end -</ruby> - -This may however hinder portability to other databases. - h4. Changing Tables A close cousin of +create_table+ is +change_table+, used for changing existing tables. It is used in a similar fashion to +create_table+ but the object yielded to the block knows more tricks. For example |