Contents

class ActsPermissiveMigration < ActiveRecord::Migration
  def self.up

    # This table holds a mask of permissions and links to a specific circle
    create_table :permissive_permissions do |t|
      t.integer :circle_id
      t.integer :mask, :null => false, :default => 0

      t.timestamps
    end

    # This table polymorphically joins arbitrary acts_permissive objects to
    # the permissions table
    create_table :permissive_groupings do |t|
      t.integer :permission_id
      t.integer :permissible_id
      t.string  :permissible_type

      t.timestamps
    end

    # This defines the actual names of the circles ("yada", "super-awesome-people", "banana")
    create_table :permissive_circles do |t|
      t.string  :name
      t.string  :guid

      t.timestamps
    end

    # This table polymorphically joins arbitrary is_used_permissively objects
    # to the circles table
    create_table :permissive_circlings do |t|
      t.string    :circleable_type
      t.integer   :circleable_id
      t.integer   :circle_id

      t.timestamps
    end

    add_index :permissive_permissions, :circle_id, :name => "circles_index"
    add_index :permissive_permissions, :mask, :name => "masks_masks"

    add_index :permissive_groupings, [:permissible_id, :permissible_type], :name => "grouper_index"
    add_index :permissive_groupings, :permission_id, :name => "permission_grouping_index"

    add_index :permissive_circles, :guid, :name => "circle_guids_index"
    add_index :permissive_circles, :name, :name => "circle_name_index"

    add_index :permissive_circlings, [:circleable_id, :circleable_type], :name => "thing_circling_index"
    add_index :permissive_circlings, :circle_id, :name => "circle_circling_index"
  end

  def self.down
    drop_table :permissive_circles
    drop_table :permissive_permissions
    drop_table :permissive_circlings
    drop_table :permissive_groupings
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
acts_permissive-0.3.4	lib/generators/templates/permissive_migration.rb
acts_permissive-0.3.3	lib/generators/templates/permissive_migration.rb
acts_permissive-0.3.2	lib/generators/templates/permissive_migration.rb
acts_permissive-0.3.1	lib/generators/templates/permissive_migration.rb
acts_permissive-0.3.0	lib/generators/templates/permissive_migration.rb
acts_permissive-0.2.5	lib/generators/templates/permissive_migration.rb