From 6343c1d2a7d8526178eba0c14cc73538c5ea792e Mon Sep 17 00:00:00 2001
From: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
Date: Tue, 9 Apr 2019 15:21:26 +0300
Subject: [PATCH] Create tables for dependency proxy feature

Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
---
 db/schema.rb                                  | 21 ++++++++++++++
 ...304223216_create_dependency_proxy_blobs.rb | 28 +++++++++++++++++++
 ..._create_dependency_proxy_group_settings.rb | 23 +++++++++++++++
 3 files changed, 72 insertions(+)
 create mode 100644 ee/db/migrate/20190304223216_create_dependency_proxy_blobs.rb
 create mode 100644 ee/db/migrate/20190304223220_create_dependency_proxy_group_settings.rb

diff --git a/db/schema.rb b/db/schema.rb
index 8841aed85c0c0e..232bf89929d557 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -991,6 +991,25 @@
     t.float "percentage_service_desk_issues", default: 0.0, null: false
   end
 
+  create_table "dependency_proxy_blobs", force: :cascade do |t|
+    t.integer "group_id", null: false
+    t.datetime_with_timezone "created_at", null: false
+    t.datetime_with_timezone "updated_at", null: false
+    t.bigint "size"
+    t.integer "file_store"
+    t.string "file_name", null: false
+    t.text "file", null: false
+    t.index ["group_id", "file_name"], name: "index_dependency_proxy_blobs_on_group_id_and_file_name", using: :btree
+  end
+
+  create_table "dependency_proxy_group_settings", force: :cascade do |t|
+    t.integer "group_id", null: false
+    t.datetime_with_timezone "created_at", null: false
+    t.datetime_with_timezone "updated_at", null: false
+    t.boolean "enabled", default: false, null: false
+    t.index ["group_id"], name: "index_dependency_proxy_group_settings_on_group_id", using: :btree
+  end
+
   create_table "deploy_keys_projects", force: :cascade do |t|
     t.integer "deploy_key_id", null: false
     t.integer "project_id", null: false
@@ -3479,6 +3498,8 @@
   add_foreign_key "clusters_kubernetes_namespaces", "clusters", on_delete: :cascade
   add_foreign_key "clusters_kubernetes_namespaces", "projects", on_delete: :nullify
   add_foreign_key "container_repositories", "projects"
+  add_foreign_key "dependency_proxy_blobs", "namespaces", column: "group_id", on_delete: :cascade
+  add_foreign_key "dependency_proxy_group_settings", "namespaces", column: "group_id", on_delete: :cascade
   add_foreign_key "deploy_keys_projects", "projects", name: "fk_58a901ca7e", on_delete: :cascade
   add_foreign_key "deployments", "projects", name: "fk_b9a3851b82", on_delete: :cascade
   add_foreign_key "design_management_designs", "issues", on_delete: :cascade
diff --git a/ee/db/migrate/20190304223216_create_dependency_proxy_blobs.rb b/ee/db/migrate/20190304223216_create_dependency_proxy_blobs.rb
new file mode 100644
index 00000000000000..35f5d4664277a4
--- /dev/null
+++ b/ee/db/migrate/20190304223216_create_dependency_proxy_blobs.rb
@@ -0,0 +1,28 @@
+# frozen_string_literal: true
+
+class CreateDependencyProxyBlobs < ActiveRecord::Migration[5.0]
+  include Gitlab::Database::MigrationHelpers
+
+  DOWNTIME = false
+
+  def change
+    create_table :dependency_proxy_blobs do |t|
+      t.references :group,
+        references: :namespace,
+        column: :group_id,
+        index: false,
+        null: false
+
+      t.foreign_key :namespaces, column: :group_id, on_delete: :cascade
+
+      t.timestamps_with_timezone null: false
+
+      t.bigint :size
+      t.integer :file_store
+      t.string :file_name, null: false
+      t.text :file, null: false
+
+      t.index [:group_id, :file_name]
+    end
+  end
+end
diff --git a/ee/db/migrate/20190304223220_create_dependency_proxy_group_settings.rb b/ee/db/migrate/20190304223220_create_dependency_proxy_group_settings.rb
new file mode 100644
index 00000000000000..c3fe064d30d3b8
--- /dev/null
+++ b/ee/db/migrate/20190304223220_create_dependency_proxy_group_settings.rb
@@ -0,0 +1,23 @@
+# frozen_string_literal: true
+
+class CreateDependencyProxyGroupSettings < ActiveRecord::Migration[5.0]
+  include Gitlab::Database::MigrationHelpers
+
+  DOWNTIME = false
+
+  def change
+    create_table :dependency_proxy_group_settings do |t|
+      t.references :group,
+        references: :namespace,
+        column: :group_id,
+        index: true,
+        null: false
+
+      t.foreign_key :namespaces, column: :group_id, on_delete: :cascade
+
+      t.timestamps_with_timezone null: false
+
+      t.boolean :enabled, default: false, null: false
+    end
+  end
+end
-- 
GitLab