diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.rb | 89 |
1 files changed, 51 insertions, 38 deletions
diff --git a/db/schema.rb b/db/schema.rb index 2048c50f892..bdb32a25efe 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20171213160445) do +ActiveRecord::Schema.define(version: 20171216024411) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -32,8 +32,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.text "description", null: false t.string "header_logo" t.string "logo" - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.text "description_html" t.integer "cached_markdown_version" t.text "new_project_guidelines" @@ -236,8 +236,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do create_table "ci_build_trace_sections", force: :cascade do |t| t.integer "project_id", null: false - t.datetime_with_timezone "date_start", null: false - t.datetime_with_timezone "date_end", null: false + t.datetime "date_start", null: false + t.datetime "date_end", null: false t.integer "byte_start", limit: 8, null: false t.integer "byte_end", limit: 8, null: false t.integer "build_id", null: false @@ -314,8 +314,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.string "encrypted_value_iv" t.integer "group_id", null: false t.boolean "protected", default: false, null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end add_index "ci_group_variables", ["group_id", "key"], name: "index_ci_group_variables_on_group_id_and_key", unique: true, using: :btree @@ -325,9 +325,9 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.integer "job_id", null: false t.integer "file_type", null: false t.integer "size", limit: 8 - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false - t.datetime_with_timezone "expire_at" + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + t.datetime "expire_at" t.string "file" end @@ -341,8 +341,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.string "encrypted_value_salt" t.string "encrypted_value_iv" t.integer "pipeline_schedule_id", null: false - t.datetime_with_timezone "created_at" - t.datetime_with_timezone "updated_at" + t.datetime "created_at" + t.datetime "updated_at" end add_index "ci_pipeline_schedule_variables", ["pipeline_schedule_id", "key"], name: "index_ci_pipeline_schedule_variables_on_schedule_id_and_key", unique: true, using: :btree @@ -364,6 +364,14 @@ ActiveRecord::Schema.define(version: 20171213160445) do add_index "ci_pipeline_schedules", ["next_run_at", "active"], name: "index_ci_pipeline_schedules_on_next_run_at_and_active", using: :btree add_index "ci_pipeline_schedules", ["project_id"], name: "index_ci_pipeline_schedules_on_project_id", using: :btree + create_table "ci_pipeline_subscriptions", force: :cascade do |t| + t.integer "ci_pipeline_id" + t.integer "user_id" + end + + add_index "ci_pipeline_subscriptions", ["ci_pipeline_id"], name: "index_ci_pipeline_subscriptions_on_ci_pipeline_id", using: :btree + add_index "ci_pipeline_subscriptions", ["user_id"], name: "index_ci_pipeline_subscriptions_on_user_id", using: :btree + create_table "ci_pipeline_variables", force: :cascade do |t| t.string "key", null: false t.text "value" @@ -492,8 +500,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do create_table "cluster_platforms_kubernetes", force: :cascade do |t| t.integer "cluster_id", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.text "api_url" t.text "ca_cert" t.string "namespace" @@ -509,8 +517,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do create_table "cluster_projects", force: :cascade do |t| t.integer "project_id", null: false t.integer "cluster_id", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false end add_index "cluster_projects", ["cluster_id"], name: "index_cluster_projects_on_cluster_id", using: :btree @@ -520,8 +528,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.integer "cluster_id", null: false t.integer "status" t.integer "num_nodes", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.text "status_reason" t.string "gcp_project_id", null: false t.string "zone", null: false @@ -538,8 +546,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.integer "user_id" t.integer "provider_type" t.integer "platform_type" - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.boolean "enabled", default: true t.string "name", null: false t.string "environment_scope", default: "*", null: false @@ -550,8 +558,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do create_table "clusters_applications_helm", force: :cascade do |t| t.integer "cluster_id", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "status", null: false t.string "version", null: false t.text "status_reason" @@ -559,8 +567,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do create_table "clusters_applications_ingress", force: :cascade do |t| t.integer "cluster_id", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "status", null: false t.integer "ingress_type", null: false t.string "version", null: false @@ -674,8 +682,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.integer "project_id" t.integer "author_id", null: false t.integer "target_id" - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "action", limit: 2, null: false t.string "target_type" end @@ -734,8 +742,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.integer "service_id" t.integer "status" t.integer "gcp_cluster_size", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.boolean "enabled", default: true t.text "status_reason" t.string "project_namespace" @@ -768,8 +776,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do add_index "gpg_key_subkeys", ["keyid"], name: "index_gpg_key_subkeys_on_keyid", unique: true, using: :btree create_table "gpg_keys", force: :cascade do |t| - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "user_id" t.binary "primary_keyid" t.binary "fingerprint" @@ -781,8 +789,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do add_index "gpg_keys", ["user_id"], name: "index_gpg_keys_on_user_id", using: :btree create_table "gpg_signatures", force: :cascade do |t| - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.integer "project_id" t.integer "gpg_key_id" t.binary "commit_sha" @@ -863,7 +871,7 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.datetime "last_edited_at" t.integer "last_edited_by_id" t.boolean "discussion_locked" - t.datetime_with_timezone "closed_at" + t.datetime "closed_at" end add_index "issues", ["author_id"], name: "index_issues_on_author_id", using: :btree @@ -994,8 +1002,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do add_index "members", ["user_id"], name: "index_members_on_user_id", using: :btree create_table "merge_request_diff_commits", id: false, force: :cascade do |t| - t.datetime_with_timezone "authored_date" - t.datetime_with_timezone "committed_date" + t.datetime "authored_date" + t.datetime "committed_date" t.integer "merge_request_diff_id", null: false t.integer "relative_order", null: false t.binary "sha", null: false @@ -1321,8 +1329,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do create_table "project_auto_devops", force: :cascade do |t| t.integer "project_id", null: false - t.datetime_with_timezone "created_at", null: false - t.datetime_with_timezone "updated_at", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false t.boolean "enabled" t.string "domain" end @@ -1686,7 +1694,7 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.datetime "updated_at", null: false t.integer "issue_id" t.integer "merge_request_id" - t.datetime_with_timezone "spent_at" + t.datetime "spent_at" end add_index "timelogs", ["issue_id"], name: "index_timelogs_on_issue_id", using: :btree @@ -1846,6 +1854,9 @@ ActiveRecord::Schema.define(version: 20171213160445) do t.string "preferred_language" t.string "rss_token" t.integer "theme_id", limit: 2 + t.string "webpush_p256dh" + t.string "webpush_auth" + t.string "webpush_endpoint" end add_index "users", ["admin"], name: "index_users_on_admin", using: :btree @@ -1929,6 +1940,8 @@ ActiveRecord::Schema.define(version: 20171213160445) do add_foreign_key "ci_pipeline_schedule_variables", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_41c35fda51", on_delete: :cascade add_foreign_key "ci_pipeline_schedules", "projects", name: "fk_8ead60fcc4", on_delete: :cascade add_foreign_key "ci_pipeline_schedules", "users", column: "owner_id", name: "fk_9ea99f58d2", on_delete: :nullify + add_foreign_key "ci_pipeline_subscriptions", "ci_pipelines" + add_foreign_key "ci_pipeline_subscriptions", "users" add_foreign_key "ci_pipeline_variables", "ci_pipelines", column: "pipeline_id", name: "fk_f29c5f4380", on_delete: :cascade add_foreign_key "ci_pipelines", "ci_pipeline_schedules", column: "pipeline_schedule_id", name: "fk_3d34ab2e06", on_delete: :nullify add_foreign_key "ci_pipelines", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_262d4c2d19", on_delete: :nullify |