Sha256: 590b98db8d422d90971f321a9f230c4516b6cff23dbdb2e3c6724275c28cf2e2

Contents?: true

Size: 1.26 KB

Versions: 138

Compression:

Stored size: 1.26 KB

Contents

class CreateItems < ActiveRecord::Migration
  def self.up
    create_table :items do |t|
      #t.integer :manifestation_id
      t.string :call_number
      t.string :item_identifier
      t.integer :circulation_status_id, :default => 5, :null => false
      t.integer :checkout_type_id, :default => 1, :null => false
      t.timestamps
      t.datetime :deleted_at
      t.integer :shelf_id, :default => 1, :null => false
      t.integer :basket_id
      t.boolean :include_supplements, :default => false, :null => false
      t.integer :checkouts_count, :default => 0, :null => false
      t.integer :owns_count, :default => 0, :null => false
      t.integer :resource_has_subjects_count, :default => 0, :null => false
      t.text :note
      t.string :url
      t.integer :price
      t.integer :lock_version, :default => 0, :null => false
      t.integer :required_role_id, :default => 1, :null => false
      t.string :state
      t.integer :required_score, :default => 0, :null => false
    end
    #add_index :items, :manifestation_id
    add_index :items, :circulation_status_id
    add_index :items, :checkout_type_id
    add_index :items, :shelf_id
    add_index :items, :item_identifier
    add_index :items, :required_role_id
  end

  def self.down
    drop_table :items
  end
end

Version data entries

138 entries across 138 versions & 7 rubygems

Version Path
enju_inventory-0.1.11.pre7 spec/dummy/db/migrate/006_create_items.rb
enju_purchase_request-0.1.0.pre6 spec/dummy/db/migrate/006_create_items.rb
enju_inter_library_loan-0.1.0.pre6 spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.11.pre6 spec/dummy/db/migrate/006_create_items.rb
enju_inter_library_loan-0.1.0.pre5 spec/dummy/db/migrate/006_create_items.rb
enju_purchase_request-0.1.0.pre5 spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.11.pre5 spec/dummy/db/migrate/006_create_items.rb
enju_inter_library_loan-0.1.0.pre4 spec/dummy/db/migrate/006_create_items.rb
enju_purchase_request-0.1.0.pre4 spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.11.pre4 spec/dummy/db/migrate/006_create_items.rb
enju_inter_library_loan-0.1.0.pre3 spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.11.pre2 spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.11.pre spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.10 spec/dummy/db/migrate/006_create_items.rb
enju_purchase_request-0.1.0.pre3 spec/dummy/db/migrate/006_create_items.rb
enju_inter_library_loan-0.1.0.pre2 spec/dummy/db/migrate/006_create_items.rb
enju_inventory-0.1.9 spec/dummy/db/migrate/006_create_items.rb
enju_inter_library_loan-0.1.0.pre spec/dummy/db/migrate/006_create_items.rb
enju_purchase_request-0.1.0.pre2 spec/dummy/db/migrate/006_create_items.rb
enju_purchase_request-0.1.0.pre spec/dummy/db/migrate/006_create_items.rb