cafe-grader-web Files · db/migrate/007_create

cafe-grader-web

Location: cafe-grader-web/db/migrate/007_create_rights.rb

Commit Description:

utf8mb4

Commit Description:

utf8mb4

References:

r862:0df5f90eea20 default

File last commit:

r822:f42556ce3209 upgrade_rails7

Show/Diff file:

Action:

            
                    db/migrate/007_create_rights.rb
                
             | 21 lines
             | 615 B
             | text/x-ruby 
             | RubyLexer
             | 
      
            History
        
           Show Full History
         |
          Annotation
         | Raw
         |
              
              Download
              
      class CreateRights < ActiveRecord::Migration[4.2]

        def self.up

          create_table :rights, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|

            t.column 'name', :string

            t.column 'controller', :string

            t.column 'action', :string

          end

          create_table :rights_roles, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|

            t.column 'right_id', :integer

            t.column 'role_id', :integer

          end

          add_index :rights_roles, :role_id

        end

        def self.down

          drop_table :rights_roles

          drop_table :rights

        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
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 permissions settings

Sign in to your account

Last Author

				class CreateRights < ActiveRecord::Migration[4.2]
				def self.up
				create_table :rights, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do \|t\|
				t.column 'name', :string
				t.column 'controller', :string
				t.column 'action', :string
				end

				create_table :rights_roles, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do \|t\|
				t.column 'right_id', :integer
				t.column 'role_id', :integer
				end

				add_index :rights_roles, :role_id
				end

				def self.down
				drop_table :rights_roles
				drop_table :rights
				end
				end