# encoding: UTF-8

# Copyright 2011-2013 innoQ Deutschland GmbH
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

class CreateSchema < ActiveRecord::Migration
  def self.up
    create_table 'classifications', force: true do |t|
      t.integer  'owner_id'
      t.integer  'target_id'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'classifications', ['owner_id', 'target_id'], name: 'ix_classifications_fk'

    create_table 'classifiers', force: true do |t|
      t.string   'title'
      t.string   'description'
      t.string   'notation'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'classifiers', ['notation'], name: 'ix_classifiers_on_notation'

    create_table 'concept_relations', force: true do |t|
      t.string   'type'
      t.integer  'owner_id'
      t.integer  'target_id'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'concept_relations', ['owner_id', 'target_id'], name: 'ix_concept_relations_fk'

    create_table 'concepts', force: true do |t|
      t.string   'type'
      t.string   'origin', limit: 4000
      t.integer  'rev',                               default: 1
      t.date     'published_at'
      t.integer  'published_version_id'
      t.integer  'locked_by'
      t.date     'expired_at'
      t.date     'follow_up'
      t.boolean  'to_review'
      t.date     'rdf_updated_at'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'concepts', ['origin'], name: 'ix_concepts_on_origin', length: 255
    add_index 'concepts', ['published_version_id'], name: 'ix_concepts_publ_version_id'

    create_table 'label_relations', force: true do |t|
      t.string   'type'
      t.integer  'domain_id'
      t.integer  'range_id'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'label_relations', ['domain_id', 'range_id', 'type'], name: 'ix_label_relations_fk_type'
    add_index 'label_relations', ['type'], name: 'ix_label_relations_on_type'

    create_table 'labelings', force: true do |t|
      t.string   'type'
      t.integer  'owner_id'
      t.integer  'target_id'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'labelings', ['owner_id', 'target_id', 'type'], name: 'ix_labelings_fk_type'
    add_index 'labelings', ['type'], name: 'ix_labelings_on_type'

    create_table 'labels', force: true do |t|
      t.string   'type'
      t.string   'origin', limit: 4000
      t.string   'language'
      t.string   'value',                limit: 1024
      t.integer  'rev',                  default: 1
      t.integer  'published_version_id'
      t.date     'published_at'
      t.integer  'locked_by'
      t.date     'expired_at'
      t.date     'follow_up'
      t.boolean  'to_review'
      t.date     'rdf_updated_at'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'labels', ['language'], name: 'ix_labels_on_language'
    add_index 'labels', ['origin'], name: 'ix_labels_on_origin', length: 255
    add_index 'labels', ['published_version_id'], name: 'ix_labels_published_version_id'

    create_table 'matches', force: true do |t|
      t.integer  'concept_id'
      t.string   'type'
      t.string   'value'
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'matches', ['concept_id', 'type'], name: 'ix_matches_fk_type'
    add_index 'matches', ['type'], name: 'ix_matches_on_type'

    create_table 'note_annotations', force: true do |t|
      t.integer  'note_id'
      t.string   'identifier', limit: 50
      t.string   'value',      limit: 1024
      t.datetime 'created_at'
      t.datetime 'updated_at'
    end

    add_index 'note_annotations', ['note_id'], name: 'ix_note_annotations_fk'

    create_table 'notes', force: true do |t|
      t.string   'language',   limit: 2
      t.string   'value',      limit: 1024
      t.string   'type',       limit: 50
      t.datetime 'created_at'
      t.datetime 'updated_at'
      t.integer  'owner_id'
      t.string   'owner_type',                 null: false
    end

    add_index 'notes', ['owner_id', 'owner_type', 'type'], name: 'ix_notes_fk_type'
    add_index 'notes', ['language'], name: 'ix_notes_on_language'
    add_index 'notes', ['type'], name: 'ix_notes_on_type'

    create_table 'users', force: true do |t|
      t.string   'forename'
      t.string   'surname'
      t.string   'email'
      t.string   'crypted_password'
      t.boolean  'active'
      t.datetime 'created_at'
      t.datetime 'updated_at'
      t.string   'password_salt'
      t.string   'persistence_token'
      t.string   'perishable_token'
      t.string   'role'
      t.string   'telephone_number'
    end
  end

  def self.down
    drop_table 'classifications'
    drop_table 'classifiers'
    drop_table 'concept_relations'
    drop_table 'concepts'
    drop_table 'label_relations'
    drop_table 'labelings'
    drop_table 'labels'
    drop_table 'matches'
    drop_table 'note_annotations'
    drop_table 'notes'
    drop_table 'users'
  end
end