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