Sha256: 67ef99e2d5eb0d6fcaf9e01671e605f1a3556a8683773c91bfdf8a1e63c87d98

Contents?: true

Size: 938 Bytes

Versions: 8

Compression:

Stored size: 938 Bytes

Contents

require 'skr/db/migration_helpers'

class CreateSkrSkuTrans < ActiveRecord::Migration
    def change

        create_skr_table "sku_trans" do |t|
            t.references :origin, :polymorphic => true
            t.skr_reference :sku_loc,        null: false, single: true
            t.skr_currency  "cost",          null: false
            t.string   "origin_description", null: false
            t.integer  "prior_qty",          null: false
            t.decimal  "mac",                null: false, precision: 15, scale: 4
            t.decimal  "prior_mac",          null: false, precision: 15, scale: 4
            t.integer  "qty",                null: false, default: 0
            t.string   "uom_code",           null: false, default: 'EA'
            t.integer  "uom_size",           null: false, default: 1
            t.skr_track_modifications        create_only: true # sku_tran can only be created
          end

    end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version Path
stockor-0.5.0 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.4.0 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.3.0 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.2 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.1.9 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.1.8 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.1.7 db/migrate/20140322035024_create_skr_sku_trans.rb
stockor-0.1.5 db/migrate/20140322035024_create_skr_sku_trans.rb