class CreateAssignedOrderItems < ActiveRecord::Migration[5.1]
  def change
    create_table :assigned_order_items, :id => false do |t|
      t.string :assigned_order_item_id, :limit => 16, :primary_key => true #custom primary key - to ensure consistence for cloud syncing
      t.string     :item_code, :null => false, :index => true
      t.string :instance_code, :null => false, :index => true
      t.references :order_queue_station, foreign_key: true, :index => true
      t.string :order_id, foreign_key: true, :limit => 16
      t.boolean :print_status
      t.boolean :delivery_status, :index => true

      t.timestamps
    end
    add_index :assigned_order_items, :created_at
    add_index :assigned_order_items, [:item_code, :instance_code, :order_queue_station_id, :delivery_status, :created_at], name: 'index_assigned_order_items'
  end
end
