jro_apps/redmine Commit - r8876:a98b65c2d435

1

class ChangeAttachmentsContainerDefaults < ActiveRecord::Migration

1

class ChangeAttachmentsContainerDefaults < ActiveRecord::Migration

2

def self.up

2

def self.up

3

# Need to drop the index otherwise the following error occurs in Rails 3.1.3:

4

#

5

# Index name 'temp_index_altered_attachments_on_container_id_and_container_type' on

6

# table 'altered_attachments' is too long; the limit is 64 characters

7

remove_index :attachments, [:container_id, :container_type]

8

3

change_column :attachments, :container_id, :integer, :default => nil, :null => true

9

change_column :attachments, :container_id, :integer, :default => nil, :null => true

4

change_column :attachments, :container_type, :string, :limit => 30, :default => nil, :null => true

10

change_column :attachments, :container_type, :string, :limit => 30, :default => nil, :null => true

5

Attachment.update_all "container_id = NULL", "container_id = 0"

11

Attachment.update_all "container_id = NULL", "container_id = 0"

6

Attachment.update_all "container_type = NULL", "container_type = ''"

12

Attachment.update_all "container_type = NULL", "container_type = ''"

13

14

add_index :attachments, [:container_id, :container_type]

7

end

15

end

8

16

9

def self.down

17

def self.down

18

remove_index :attachments, [:container_id, :container_type]

19

10

change_column :attachments, :container_id, :integer, :default => 0, :null => false

20

change_column :attachments, :container_id, :integer, :default => 0, :null => false

11

change_column :attachments, :container_type, :string, :limit => 30, :default => "", :null => false

21

change_column :attachments, :container_type, :string, :limit => 30, :default => "", :null => false

22

23

add_index :attachments, [:container_id, :container_type]

12

end

24

end

13

end

25

end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             class ChangeAttachmentsContainerDefaults < ActiveRecord::Migration
               def self.up
+                # Need to drop the index otherwise the following error occurs in Rails 3.1.3:
+                #
+                # Index name 'temp_index_altered_attachments_on_container_id_and_container_type' on
+                # table 'altered_attachments' is too long; the limit is 64 characters
+                remove_index :attachments, [:container_id, :container_type]
                 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 = ''"
+                add_index :attachments, [:container_id, :container_type]
               end
               def self.down
+                remove_index :attachments, [:container_id, :container_type]
                 change_column :attachments, :container_id, :integer, :default => 0, :null => false
                 change_column :attachments, :container_type, :string, :limit => 30, :default => "", :null => false
+                add_index :attachments, [:container_id, :container_type]
               end
             end