class CreateModelTables

Migration

Public Class Methods

up() click to toggle source
# File test/standard_api/test_app/models.rb, line 54
  def self.up

    comment = "test comment"
    exec_query(<<-SQL, "SQL")
      COMMENT ON DATABASE #{quote_column_name(current_database)} IS #{quote(comment)};
    SQL

    create_table "accounts", force: :cascade do |t|
      t.string   'name',                 limit: 255
      t.integer  'property_id'
      t.integer  "subject_id"
      t.string   "subject_type"
      t.datetime "property_cached_at"
      t.datetime "subject_cached_at"
      t.integer  'photos_count', null: false, default: 0
      t.datetime "created_at",                         null: false
    end

    create_table "landlords", force: :cascade do |t|
      t.string  "name"
    end

    create_table "photos", force: :cascade do |t|
      t.integer  "account_id"
      t.integer  "property_id"
      t.string   "format",                 limit: 255
      t.datetime "created_at",                         null: false
    end

    create_table "properties", force: :cascade do |t|
      t.string   "name",                 limit: 255
      t.string   "aliases",              default: [],   array: true
      t.text     "description"
      t.integer  "constructed"
      t.decimal  "size"
      t.datetime "created_at",                         null: false
      t.boolean  "active",             default: false
    end

    create_table "references", force: :cascade do |t|
      t.integer  "subject_id"
      t.string   "subject_type",         limit: 255
      t.string   "key"
      t.string   "value"
    end

    create_table "photos_properties", force: :cascade do |t|
      t.integer  "photo_id"
      t.integer  "property_id"
    end

    create_table "landlords_properties", force: :cascade do |t|
      t.integer  "landlord_id"
      t.integer  "property_id"
    end

    create_table "documents", force: :cascade do |t|
      t.string   'type'
    end

    create_table "attachments", force: :cascade do |t|
      t.string  'record_type'
      t.integer  'record_id'
      t.integer  'document_id'
    end
  end