ActiveRecord::Schema.define do

  create_table :bankserv_statements, :force => true do |t|
    t.boolean :processed, :default => false
    t.string :client_code
    t.text :data
    t.timestamps
  end
  
  create_table :bankserv_notify_me_statements, :force => true do |t|
    t.boolean :processed, :default => false
    t.string :client_code
    t.text :data
    t.timestamps
  end
  
  create_table :bankserv_transactions, :force => true do |t|
    t.boolean :processed, :default => false
    t.string :client_code
    t.text :data
    t.references :bankserv_statement
    t.timestamps
  end

  create_table :bankserv_notify_me_transactions, :force => true do |t|
    t.boolean :processed, :default => false
    t.string :client_code
    t.text :data
    t.references :bankserv_notify_me_statement
    t.timestamps
  end
  
  create_table :bankserv_services, :force => true do |t|
    t.boolean :active, :default => false
    t.string :type
    t.string :client_code
    t.text :config
    t.timestamps
  end
  
  create_table :bankserv_requests, :force => true do |t|
    t.integer :service_id
    t.string :type
    t.text :data
    t.boolean :processed, :default => false
    t.string :status
    t.text :response
    t.boolean :test, :default => false
    t.timestamps
  end
  
  create_table :bankserv_bank_accounts, :force => true do |t|
    t.string :branch_code
    t.string :account_number
    t.string :account_type
    t.string :initials
    t.string :account_name
    t.string :id_number
    t.timestamps
  end
  
  create_table :bankserv_account_holder_verifications, :force => true do |t|
    t.boolean :internal, :default => false
    t.references :bankserv_bank_account
    t.references :bankserv_request
    t.string :status, :default => "new"
    t.text :response
    t.string :user_ref
    t.timestamps
  end
  
  create_table :bankserv_debits, :force => true do |t|
    t.string :record_type
    t.integer :amount
    t.string :action_date
    t.references :bankserv_bank_account
    t.references :bankserv_request
    t.integer :batch_id
    t.string :status, :default => "new"
    t.text :response
    t.string :user_ref
    t.timestamps
  end
  
  create_table :bankserv_credits, :force => true do |t|
    t.string :record_type
    t.integer :amount
    t.string :action_date
    t.references :bankserv_bank_account
    t.references :bankserv_request
    t.integer :batch_id
    t.string :status, :default => "new"
    t.text :response
    t.string :user_ref
    t.timestamps
  end
  
  create_table :bankserv_documents, :force => true do |t|
    t.string :client_code
    t.string :type
    t.references :set
    t.boolean :processed, :default => false
    t.string :transmission_status
    t.string :rec_status
    t.string :transmission_number
    t.string :reply_status
    t.text :error
    t.string :user_ref
    t.timestamps
  end
  
  create_table :bankserv_sets, :force => true do |t|
    t.references :document
    t.references :set
    t.string :type
    t.string :generation_number
    t.string :reply_status
    t.timestamps
  end
  
  create_table :bankserv_records, :force => true do |t|
    t.references :set
    t.string :record_type
    t.string :reference
    t.text :data
    t.text :error
    t.string :sourceable_type
    t.integer :sourceable_id
    t.timestamps
  end
  
  create_table :bankserv_engine_configurations, :force => true do |t|
    t.integer :interval_in_minutes
    t.string :input_directory
    t.string :output_directory
    t.string :archive_directory
  end
  
  create_table :bankserv_engine_processes, :force => true do |t|
    t.boolean :running
    t.boolean :success
    t.text :response
    t.timestamps
    
    t.datetime :completed_at
  end
  
end