# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 1) do

  create_table "LESSONS", :force => true do |t|
    t.column "title", :string
    t.column "text",  :string
  end

# Could not dump table "SYSALIASES" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.AliasInfo' for column 'aliasinfo'

# Could not dump table "SYSCHECKS" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.ReferencedColumns' for column 'referencedcolumns'

# Could not dump table "SYSCOLPERMS" because of following StandardError
#   Unknown type 'org.apache.derby.iapi.services.io.FormatableBitSet' for column 'columns'

# Could not dump table "SYSCOLUMNS" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.TypeDescriptor' for column 'columndatatype'

# Could not dump table "SYSCONGLOMERATES" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.IndexDescriptor' for column 'descriptor'

  create_table "SYSCONSTRAINTS", :id => false, :force => true do |t|
    t.column "constraintid",   :string,  :limit => 36,  :null => false
    t.column "tableid",        :string,  :limit => 36,  :null => false
    t.column "constraintname", :string,  :limit => 128, :null => false
    t.column "type",           :string,  :limit => 1,   :null => false
    t.column "schemaid",       :string,  :limit => 36,  :null => false
    t.column "state",          :string,  :limit => 1,   :null => false
    t.column "referencecount", :integer,                :null => false
  end

  add_index "sysconstraints", ["constraintid"], :name => "sysconstraints_index1", :unique => true
  add_index "sysconstraints", ["constraintname", "schemaid"], :name => "sysconstraints_index2", :unique => true
  add_index "sysconstraints", ["tableid"], :name => "sysconstraints_index3"

# Could not dump table "SYSDEPENDS" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.DependableFinder' for column 'dependentfinder'

  create_table "SYSDUMMY1", :id => false, :force => true do |t|
    t.column "ibmreqd", :string, :limit => 1
  end

  create_table "SYSFILES", :id => false, :force => true do |t|
    t.column "fileid",       :string,  :limit => 36,  :null => false
    t.column "schemaid",     :string,  :limit => 36,  :null => false
    t.column "filename",     :string,  :limit => 128, :null => false
    t.column "generationid", :integer, :limit => 19,  :null => false
  end

  add_index "sysfiles", ["filename", "schemaid"], :name => "sysfiles_index1", :unique => true
  add_index "sysfiles", ["fileid"], :name => "sysfiles_index2", :unique => true

  create_table "SYSFOREIGNKEYS", :id => false, :force => true do |t|
    t.column "constraintid",    :string, :limit => 36, :null => false
    t.column "conglomerateid",  :string, :limit => 36, :null => false
    t.column "keyconstraintid", :string, :limit => 36, :null => false
    t.column "deleterule",      :string, :limit => 1,  :null => false
    t.column "updaterule",      :string, :limit => 1,  :null => false
  end

  add_index "sysforeignkeys", ["constraintid"], :name => "sysforeignkeys_index1", :unique => true
  add_index "sysforeignkeys", ["keyconstraintid"], :name => "sysforeignkeys_index2"

  create_table "SYSKEYS", :id => false, :force => true do |t|
    t.column "constraintid",   :string, :limit => 36, :null => false
    t.column "conglomerateid", :string, :limit => 36, :null => false
  end

  add_index "syskeys", ["constraintid"], :name => "syskeys_index1", :unique => true

  create_table "SYSROUTINEPERMS", :id => false, :force => true do |t|
    t.column "routinepermsid", :string, :limit => 36,  :null => false
    t.column "grantee",        :string, :limit => 128, :null => false
    t.column "grantor",        :string, :limit => 128, :null => false
    t.column "aliasid",        :string, :limit => 36,  :null => false
    t.column "grantoption",    :string, :limit => 1,   :null => false
  end

  add_index "sysroutineperms", ["grantee", "aliasid", "grantor"], :name => "sysroutineperms_index1", :unique => true
  add_index "sysroutineperms", ["routinepermsid"], :name => "sysroutineperms_index2", :unique => true
  add_index "sysroutineperms", ["aliasid"], :name => "sysroutineperms_index3"

  create_table "SYSSCHEMAS", :id => false, :force => true do |t|
    t.column "schemaid",        :string, :limit => 36,  :null => false
    t.column "schemaname",      :string, :limit => 128, :null => false
    t.column "authorizationid", :string, :limit => 128, :null => false
  end

  add_index "sysschemas", ["schemaname"], :name => "sysschemas_index1", :unique => true
  add_index "sysschemas", ["schemaid"], :name => "sysschemas_index2", :unique => true

  create_table "SYSSTATEMENTS", :id => false, :force => true do |t|
    t.column "stmtid",              :string,    :limit => 36,    :null => false
    t.column "stmtname",            :string,    :limit => 128,   :null => false
    t.column "schemaid",            :string,    :limit => 36,    :null => false
    t.column "type",                :string,    :limit => 1,     :null => false
    t.column "valid",               :boolean,                    :null => false
    t.column "text",                :string,    :limit => 32700, :null => false
    t.column "lastcompiled",        :timestamp, :limit => 26
    t.column "compilationschemaid", :string,    :limit => 36,    :null => false
    t.column "usingtext",           :string,    :limit => 32700
  end

  add_index "sysstatements", ["stmtid"], :name => "sysstatements_index1", :unique => true
  add_index "sysstatements", ["stmtname", "schemaid"], :name => "sysstatements_index2", :unique => true

# Could not dump table "SYSSTATISTICS" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.Statistics(12)' for column 'statistics'

  create_table "SYSTABLEPERMS", :id => false, :force => true do |t|
    t.column "tablepermsid",   :string, :limit => 36,  :null => false
    t.column "grantee",        :string, :limit => 128, :null => false
    t.column "grantor",        :string, :limit => 128, :null => false
    t.column "tableid",        :string, :limit => 36,  :null => false
    t.column "selectpriv",     :string, :limit => 1,   :null => false
    t.column "deletepriv",     :string, :limit => 1,   :null => false
    t.column "insertpriv",     :string, :limit => 1,   :null => false
    t.column "updatepriv",     :string, :limit => 1,   :null => false
    t.column "referencespriv", :string, :limit => 1,   :null => false
    t.column "triggerpriv",    :string, :limit => 1,   :null => false
  end

  add_index "systableperms", ["grantee", "tableid", "grantor"], :name => "systableperms_index1", :unique => true
  add_index "systableperms", ["tablepermsid"], :name => "systableperms_index2", :unique => true
  add_index "systableperms", ["tableid"], :name => "systableperms_index3"

  create_table "SYSTABLES", :id => false, :force => true do |t|
    t.column "tableid",         :string, :limit => 36,  :null => false
    t.column "tablename",       :string, :limit => 128, :null => false
    t.column "tabletype",       :string, :limit => 1,   :null => false
    t.column "schemaid",        :string, :limit => 36,  :null => false
    t.column "lockgranularity", :string, :limit => 1,   :null => false
  end

  add_index "systables", ["tablename", "schemaid"], :name => "systables_index1", :unique => true
  add_index "systables", ["tableid"], :name => "systables_index2", :unique => true

# Could not dump table "SYSTRIGGERS" because of following StandardError
#   Unknown type 'org.apache.derby.catalog.ReferencedColumns' for column 'referencedcolumns'

  create_table "SYSVIEWS", :id => false, :force => true do |t|
    t.column "tableid",             :string, :limit => 36,    :null => false
    t.column "viewdefinition",      :string, :limit => 32700, :null => false
    t.column "checkoption",         :string, :limit => 1,     :null => false
    t.column "compilationschemaid", :string, :limit => 36,    :null => false
  end

  add_index "sysviews", ["tableid"], :name => "sysviews_index1", :unique => true

end