summaryrefslogtreecommitdiffstats
path: root/db/migrate
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20120223110929_change_attachments_container_defaults.rb13
1 files changed, 13 insertions, 0 deletions
diff --git a/db/migrate/20120223110929_change_attachments_container_defaults.rb b/db/migrate/20120223110929_change_attachments_container_defaults.rb
new file mode 100644
index 000000000..39af099f8
--- /dev/null
+++ b/db/migrate/20120223110929_change_attachments_container_defaults.rb
@@ -0,0 +1,13 @@
+class ChangeAttachmentsContainerDefaults < ActiveRecord::Migration
+ def self.up
+ change_column :attachments, :container_id, :integer, :default => nil, :null => true
+ change_column :attachments, :container_type, :string, :limit => 30, :default => nil, :null => true
+ Attachment.update_all "container_id = NULL", "container_id = 0"
+ Attachment.update_all "container_type = NULL", "container_type = ''"
+ end
+
+ def self.down
+ change_column :attachments, :container_id, :integer, :default => 0, :null => false
+ change_column :attachments, :container_type, :string, :limit => 30, :default => "", :null => false
+ end
+end