Contents

require 'skr/db/migration_helpers'

class CreateSkrGlPostings < ActiveRecord::Migration
    def change
        create_skr_table "gl_postings" do |t|
            t.skr_reference :gl_transaction,   single: true
            t.string       "account_number",   null: false
            t.skr_currency "amount",           null: false
            t.boolean      "is_debit",         null: false
            t.integer      "year",             null: false, limit: 2
            t.integer      "period",           null: false, limit: 2
            t.skr_track_modifications          create_only: true # since it can't be updated
        end
        skr_add_index :gl_postings, [:period,:year,:account_number]
    end
end

Version data entries

8 entries across 8 versions & 1 rubygems

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