diff options
author | Jarka Kadlecova <jarka@gitlab.com> | 2017-03-15 14:18:44 +0100 |
---|---|---|
committer | Jarka Kadlecova <jarka@gitlab.com> | 2017-03-28 13:58:35 +0200 |
commit | 1c3c7fb25d972fc19d5b4bb371cb21094d81e478 (patch) | |
tree | 1989aa0a7964ccdac4f6a6751f50967fe5fe801d /db | |
parent | ad831ace7ed8d2ed999b15f8350aaa51f0490124 (diff) | |
download | gitlab-ce-1c3c7fb25d972fc19d5b4bb371cb21094d81e478.tar.gz |
Add system_note_metadata model
Diffstat (limited to 'db')
-rw-r--r-- | db/migrate/20170314082049_create_system_note_metadata.rb | 19 | ||||
-rw-r--r-- | db/schema.rb | 9 |
2 files changed, 28 insertions, 0 deletions
diff --git a/db/migrate/20170314082049_create_system_note_metadata.rb b/db/migrate/20170314082049_create_system_note_metadata.rb new file mode 100644 index 00000000000..c58da88631f --- /dev/null +++ b/db/migrate/20170314082049_create_system_note_metadata.rb @@ -0,0 +1,19 @@ +class CreateSystemNoteMetadata < ActiveRecord::Migration + include Gitlab::Database::MigrationHelpers + + DOWNTIME = false + + disable_ddl_transaction! + + def change + create_table :system_note_metadata do |t| + t.references :note, null: false + t.integer :commit_count + t.string :icon + + t.timestamps null: false + end + + add_concurrent_foreign_key :system_note_metadata, :notes, column: :note_id, on_delete: :cascade + end +end diff --git a/db/schema.rb b/db/schema.rb index f476637ceb2..456dbd41230 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -1075,6 +1075,14 @@ ActiveRecord::Schema.define(version: 20170317203554) do add_index "subscriptions", ["subscribable_id", "subscribable_type", "user_id", "project_id"], name: "index_subscriptions_on_subscribable_and_user_id_and_project_id", unique: true, using: :btree + create_table "system_note_metadata", force: :cascade do |t| + t.integer "note_id", null: false + t.integer "commit_count" + t.string "icon" + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + create_table "taggings", force: :cascade do |t| t.integer "tag_id" t.integer "taggable_id" @@ -1308,6 +1316,7 @@ ActiveRecord::Schema.define(version: 20170317203554) do add_foreign_key "protected_branch_merge_access_levels", "protected_branches" add_foreign_key "protected_branch_push_access_levels", "protected_branches" add_foreign_key "subscriptions", "projects", on_delete: :cascade + add_foreign_key "system_note_metadata", "notes", name: "fk_d83a918cb1", on_delete: :cascade add_foreign_key "timelogs", "issues", name: "fk_timelogs_issues_issue_id", on_delete: :cascade add_foreign_key "timelogs", "merge_requests", name: "fk_timelogs_merge_requests_merge_request_id", on_delete: :cascade add_foreign_key "trending_projects", "projects", on_delete: :cascade |