Redmine

token ring wrote:

Please publish latest database schema

You can find it in db/schema.rb file under your Redmine's installation directory. Here is an excerpt.

[...]

  create_table "attachments", force: :cascade do |t|
    t.integer "container_id" 
    t.string "container_type", limit: 30
    t.string "filename", default: "", null: false
    t.string "disk_filename", default: "", null: false
    t.integer "filesize", limit: 8, default: 0, null: false
    t.string "content_type", default: "" 
    t.string "digest", limit: 64, default: "", null: false
    t.integer "downloads", default: 0, null: false
    t.integer "author_id", default: 0, null: false
    t.datetime "created_on" 
    t.string "description" 
    t.string "disk_directory" 
    t.index ["author_id"], name: "index_attachments_on_author_id" 
    t.index ["container_id", "container_type"], name: "index_attachments_on_container_id_and_container_type" 
    t.index ["created_on"], name: "index_attachments_on_created_on" 
    t.index ["disk_filename"], name: "index_attachments_on_disk_filename" 
  end

[...]