jro_apps/redmine Files · db/migrate/010_create_comments.rb

Fixed: 10342 Creation of Schema in Oracle...

Fixed: 10342 Creation of Schema in Oracle Comment is a reserved keyword for Oracle. The five 'Comment' columns are renamed to 'Commments'. Migration scripts were modified to let oracle users create the database. For the others, migration 41 will rename the columns (only if columns have the 'old' name). Fixed also a few oracle specific issues. Note: currently (in Rails 1.2.3), there's bug in Rails oracle adapter. See: http://dev.rubyonrails.org/ticket/7344 Attached patch is required for redMine to work properly. git-svn-id: http://redmine.rubyforge.org/svn/trunk@479 e93f8b46-1217-0410-a6f0-8f06a7374b81

Jean-Philippe Lang - - Load All Authors

File last commit:

r476:52547466f0f1


                r476:52547466f0f1

Download file

             010_create_comments.rb
        
                    16 lines
            
             | 524 B
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / db / migrate / 010_create_comments.rb
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      class CreateComments < ActiveRecord::Migration

        def self.up

          create_table :comments do |t|

            t.column :commented_type, :string, :limit => 30, :default => "", :null => false

            t.column :commented_id, :integer, :default => 0, :null => false

            t.column :author_id, :integer, :default => 0, :null => false

            t.column :comments, :text

            t.column :created_on, :datetime, :null => false

            t.column :updated_on, :datetime, :null => false

          end

        end

        def self.down

          drop_table :comments

        end

      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 CreateComments < ActiveRecord::Migration
				def self.up
				create_table :comments do \|t\|
				t.column :commented_type, :string, :limit => 30, :default => "", :null => false
				t.column :commented_id, :integer, :default => 0, :null => false
				t.column :author_id, :integer, :default => 0, :null => false
				t.column :comments, :text
				t.column :created_on, :datetime, :null => false
				t.column :updated_on, :datetime, :null => false
				end
				end

				def self.down
				drop_table :comments
				end
				end