Contents

Sequel.migration do
  up do
    create_table(:account_sets) do
      primary_key :id
      Datetime :created_at, :null => false
      Datetime :updated_at, :null => false
      String :name, :null => false
      String :description
      index :name, :unique => true
    end

    create_table(:account_set_accounts) do
      primary_key :id
      Datetime :added_at, :null => false
      Integer :account_set_id, :null => false
      Integer :provider_id, :null => true
      String :account, :limit => 10, :null => false
      index :account_set_id
      index :provider_id
      index :account
      index [:account_set_id, :account], :unique => true
    end

    create_table(:features) do
      primary_key :id
      Datetime :created_at, :null => false
      Datetime :updated_at, :null => false
      String :name, :null => false
      String :description
      index :name, :unique => true
    end

    create_table(:account_set_features) do
      primary_key :id
      Datetime :added_at, :null => false
      Integer :account_set_id, :null => false
      Integer :feature_id, :null => false
      index :feature_id
      index [:account_set_id, :feature_id], :unique => true
    end

    create_table(:feature_account_overrides) do
      Integer :provider_id, :null => true
      String :account, :limit => 10, :null => false
      Integer :feature_id, :null => false
      Integer :value, :null => false
      index :provider_id
      index :feature_id
      index [:account, :feature_id], :unique => true
    end
  end

  down do
    drop_table :account_sets
    drop_table :account_set_accounts
    drop_table :features
    drop_table :account_set_features
    drop_table :feature_account_overrides
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
glowworm-0.3.0	server/db_migrations/20111004214649_change_feature_accounts_to_string.rb