From 318f987493a1083f9817374b797fd9a90ff7eaf7 Mon Sep 17 00:00:00 2001 From: Steve Abrams Date: Thu, 5 Sep 2019 22:12:35 -0600 Subject: Create packages_conan_file_metadata table Create conan metadata table for conan package registry functionality. --- ...190906035623_create_packages_conan_file_metadata.rb | 18 ++++++++++++++++++ db/schema.rb | 13 ++++++++++++- 2 files changed, 30 insertions(+), 1 deletion(-) create mode 100644 db/migrate/20190906035623_create_packages_conan_file_metadata.rb diff --git a/db/migrate/20190906035623_create_packages_conan_file_metadata.rb b/db/migrate/20190906035623_create_packages_conan_file_metadata.rb new file mode 100644 index 00000000000..aad3559fa7d --- /dev/null +++ b/db/migrate/20190906035623_create_packages_conan_file_metadata.rb @@ -0,0 +1,18 @@ +# frozen_string_literal: true + +class CreatePackagesConanFileMetadata < ActiveRecord::Migration[5.2] + include Gitlab::Database::MigrationHelpers + + DOWNTIME = false + + def change + create_table :packages_conan_file_metadata do |t| + t.references :package_file, index: { unique: true }, null: false, foreign_key: { to_table: :packages_package_files, on_delete: :cascade }, type: :integer + t.string "recipe", null: false, limit: 255 + t.string "path", null: false, limit: 255 + t.string "revision", null: false, default: "0", limit: 255 + + t.timestamps_with_timezone + end + end +end diff --git a/db/schema.rb b/db/schema.rb index 61f7787f192..e55bfba9221 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -10,7 +10,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 2019_09_05_223900) do +ActiveRecord::Schema.define(version: 2019_09_06_035623) do # These are extensions that must be enabled in order to support this database enable_extension "pg_trgm" @@ -2427,6 +2427,16 @@ ActiveRecord::Schema.define(version: 2019_09_05_223900) do t.index ["project_id", "token_encrypted"], name: "index_feature_flags_clients_on_project_id_and_token_encrypted", unique: true end + create_table "packages_conan_file_metadata", force: :cascade do |t| + t.integer "package_file_id", null: false + t.string "recipe", limit: 255, null: false + t.string "path", limit: 255, null: false + t.string "revision", limit: 255, default: "0", null: false + t.datetime_with_timezone "created_at", null: false + t.datetime_with_timezone "updated_at", null: false + t.index ["package_file_id"], name: "index_packages_conan_file_metadata_on_package_file_id", unique: true + end + create_table "packages_maven_metadata", force: :cascade do |t| t.bigint "package_id", null: false t.datetime_with_timezone "created_at", null: false @@ -3966,6 +3976,7 @@ ActiveRecord::Schema.define(version: 2019_09_05_223900) do add_foreign_key "operations_feature_flag_scopes", "operations_feature_flags", column: "feature_flag_id", on_delete: :cascade add_foreign_key "operations_feature_flags", "projects", on_delete: :cascade add_foreign_key "operations_feature_flags_clients", "projects", on_delete: :cascade + add_foreign_key "packages_conan_file_metadata", "packages_package_files", column: "package_file_id", on_delete: :cascade add_foreign_key "packages_maven_metadata", "packages_packages", column: "package_id", name: "fk_be88aed360", on_delete: :cascade add_foreign_key "packages_package_files", "packages_packages", column: "package_id", name: "fk_86f0f182f8", on_delete: :cascade add_foreign_key "packages_packages", "projects", on_delete: :cascade -- cgit v1.2.1