jro_apps/redmine Files · lib/plugins/awesome_nested_set/spec/db/schema.rb

fix always new lft and rgt are lft = 1, rgt = 2 (#6579)...

fix always new lft and rgt are lft = 1, rgt = 2 (#6579) git-svn-id: http://svn.redmine.org/redmine/trunk@13009 e93f8b46-1217-0410-a6f0-8f06a7374b81

Toshi MARUYAMA - - Load All Authors

File last commit:

r12732:d1057bc4ad66


                r12734:3c83d1c64640

Download file

             schema.rb
        
                    74 lines
            
             | 1.9 KiB
            
                | text/x-ruby
            
             |
                RubyLexer
            
             / lib / plugins / awesome_nested_set / spec / db / schema.rb
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Toshi MARUYAMA
    
import awesome_nested_set 2.1.6 (#6579)...

              r12732
            
      ActiveRecord::Schema.define(:version => 0) do

        create_table :categories, :force => true do |t|

          t.column :name, :string

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

          t.column :depth, :integer

          t.column :organization_id, :integer

        end

        create_table :departments, :force => true do |t|

          t.column :name, :string

        end

        create_table :notes, :force => true do |t|

          t.column :body, :text

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

          t.column :depth, :integer

          t.column :notable_id, :integer

          t.column :notable_type, :string

        end

        create_table :renamed_columns, :force => true do |t|

          t.column :name, :string

          t.column :mother_id, :integer

          t.column :red, :integer

          t.column :black, :integer

          t.column :pitch, :integer

        end

        create_table :things, :force => true do |t|

          t.column :body, :text

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

          t.column :depth, :integer

          t.column :children_count, :integer

        end

        create_table :brokens, :force => true do |t|

          t.column :name, :string

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

          t.column :depth, :integer

        end

        create_table :orders, :force => true do |t|

          t.column :name, :string

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

          t.column :depth, :integer

        end

        create_table :positions, :force => true do |t|

          t.column :name, :string

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

          t.column :depth, :integer

          t.column :position, :integer

        end

        create_table :no_depths, :force => true do |t|

          t.column :name, :string

          t.column :parent_id, :integer

          t.column :lft, :integer

          t.column :rgt, :integer

        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

Toshi MARUYAMA import awesome_nested_set 2.1.6 (#6579)...	r12732	ActiveRecord::Schema.define(:version => 0) do

		create_table :categories, :force => true do \|t\|
		t.column :name, :string
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		t.column :depth, :integer
		t.column :organization_id, :integer
		end

		create_table :departments, :force => true do \|t\|
		t.column :name, :string
		end

		create_table :notes, :force => true do \|t\|
		t.column :body, :text
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		t.column :depth, :integer
		t.column :notable_id, :integer
		t.column :notable_type, :string
		end

		create_table :renamed_columns, :force => true do \|t\|
		t.column :name, :string
		t.column :mother_id, :integer
		t.column :red, :integer
		t.column :black, :integer
		t.column :pitch, :integer
		end

		create_table :things, :force => true do \|t\|
		t.column :body, :text
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		t.column :depth, :integer
		t.column :children_count, :integer
		end

		create_table :brokens, :force => true do \|t\|
		t.column :name, :string
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		t.column :depth, :integer
		end

		create_table :orders, :force => true do \|t\|
		t.column :name, :string
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		t.column :depth, :integer
		end

		create_table :positions, :force => true do \|t\|
		t.column :name, :string
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		t.column :depth, :integer
		t.column :position, :integer
		end

		create_table :no_depths, :force => true do \|t\|
		t.column :name, :string
		t.column :parent_id, :integer
		t.column :lft, :integer
		t.column :rgt, :integer
		end
		end