Contents

class AddUsersTables < ActiveRecord::Migration[4.2]
  
  def up
    create_table :users do |t|
      t.string :username
      t.string :password_hash, limit: 100
      
      t.string :first_name, limit: 100
      t.string :last_name, limit: 100
      
      t.text :dynamic_fields
      
      t.boolean :active, null: false, default: true
      t.boolean :is_superuser, null: false, default: true
      
      t.datetime :created_on
      t.datetime :updated_on
    end
    add_index "users", ["username"], name: "UN_users_username", unique: true
    
    create_table :user_groups do |t|
      t.string :name
      
      t.datetime :created_on
      t.datetime :updated_on
    end
    add_index "user_groups", ["name"], name: "UN_user_groups_name", unique: true
    
    create_table :user_group_memberships, id: false do |t|
      t.integer :user_id, null: false
      t.integer :user_group_id, null: false
      t.datetime :created_on
    end
    execute 'alter table user_group_memberships add constraint PK_user_group_memberships primary key (user_id, user_group_id)'
  end
  
  def down
    drop_table :user_group_memberships
    drop_table :user_groups
    drop_table :users
  end
  
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
imagine_cms-5.2.6	db/migrate/20121115083811_add_users_tables.rb
imagine_cms-5.2.5	db/migrate/20121115083811_add_users_tables.rb
imagine_cms-5.2.4	db/migrate/20121115083811_add_users_tables.rb
imagine_cms-5.2.3	db/migrate/20121115083811_add_users_tables.rb
imagine_cms-5.2.2	db/migrate/20121115083811_add_users_tables.rb
imagine_cms-5.2.1	db/migrate/20121115083811_add_users_tables.rb
imagine_cms-5.2.0	db/migrate/20121115083811_add_users_tables.rb