diff options
author | Harald Eilertsen <haraldei@anduin.net> | 2013-01-25 21:53:05 +0100 |
---|---|---|
committer | Harald Eilertsen <haraldei@anduin.net> | 2013-01-25 21:53:05 +0100 |
commit | f087c23c8600fe197d3a59f4a0cd839754459b37 (patch) | |
tree | 5577105a38545b143efec0bdb8c134bea04005c8 /db/migrate/20130124232352_create_refinerycms_authentication_schema.refinery_authentication.rb | |
download | hmnoweb-f087c23c8600fe197d3a59f4a0cd839754459b37.tar.gz hmnoweb-f087c23c8600fe197d3a59f4a0cd839754459b37.tar.bz2 hmnoweb-f087c23c8600fe197d3a59f4a0cd839754459b37.zip |
Initial commit.
Diffstat (limited to 'db/migrate/20130124232352_create_refinerycms_authentication_schema.refinery_authentication.rb')
-rw-r--r-- | db/migrate/20130124232352_create_refinerycms_authentication_schema.refinery_authentication.rb | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/db/migrate/20130124232352_create_refinerycms_authentication_schema.refinery_authentication.rb b/db/migrate/20130124232352_create_refinerycms_authentication_schema.refinery_authentication.rb new file mode 100644 index 0000000..b306ecc --- /dev/null +++ b/db/migrate/20130124232352_create_refinerycms_authentication_schema.refinery_authentication.rb @@ -0,0 +1,44 @@ +# This migration comes from refinery_authentication (originally 20100913234705) +class CreateRefinerycmsAuthenticationSchema < ActiveRecord::Migration + def change + # Postgres apparently requires the roles_users table to exist before creating the roles table. + create_table :refinery_roles_users, :id => false do |t| + t.integer :user_id + t.integer :role_id + end + + add_index :refinery_roles_users, [:role_id, :user_id] + add_index :refinery_roles_users, [:user_id, :role_id] + + create_table :refinery_roles do |t| + t.string :title + end + + create_table :refinery_user_plugins do |t| + t.integer :user_id + t.string :name + t.integer :position + end + + add_index :refinery_user_plugins, :name + add_index :refinery_user_plugins, [:user_id, :name], :unique => true + + create_table :refinery_users do |t| + t.string :username, :null => false + t.string :email, :null => false + t.string :encrypted_password, :null => false + t.datetime :current_sign_in_at + t.datetime :last_sign_in_at + t.string :current_sign_in_ip + t.string :last_sign_in_ip + t.integer :sign_in_count + t.datetime :remember_created_at + t.string :reset_password_token + t.datetime :reset_password_sent_at + + t.timestamps + end + + add_index :refinery_users, :id + end +end |