From 161e6d31110c591b041b76717a98024f5963a3f7 Mon Sep 17 00:00:00 2001
From: Baodong <wwwicbd@gmail.com>
Date: Sat, 14 Aug 2021 18:07:32 +0800
Subject: [PATCH] Create table zentao_tracker_data

See: https://gitlab.com/gitlab-org/gitlab/-/issues/338178

Changelog: added
---
 ...210813101742_create_zentao_tracker_data.rb | 18 ++++++++++
 db/schema_migrations/20210813101742           |  1 +
 db/structure.sql                              | 34 +++++++++++++++++++
 3 files changed, 53 insertions(+)
 create mode 100644 db/migrate/20210813101742_create_zentao_tracker_data.rb
 create mode 100644 db/schema_migrations/20210813101742

diff --git a/db/migrate/20210813101742_create_zentao_tracker_data.rb b/db/migrate/20210813101742_create_zentao_tracker_data.rb
new file mode 100644
index 00000000000000..93d9cde3371065
--- /dev/null
+++ b/db/migrate/20210813101742_create_zentao_tracker_data.rb
@@ -0,0 +1,18 @@
+# frozen_string_literal: true
+
+class CreateZentaoTrackerData < ActiveRecord::Migration[6.1]
+  def change
+    create_table :zentao_tracker_data do |t|
+      t.references :integration, foreign_key: { on_delete: :cascade }, type: :bigint, index: true, null: false
+      t.timestamps_with_timezone
+      t.binary :encrypted_url
+      t.binary :encrypted_url_iv
+      t.binary :encrypted_api_url
+      t.binary :encrypted_api_url_iv
+      t.binary :encrypted_zentao_product_xid
+      t.binary :encrypted_zentao_product_xid_iv
+      t.binary :encrypted_api_token
+      t.binary :encrypted_api_token_iv
+    end
+  end
+end
diff --git a/db/schema_migrations/20210813101742 b/db/schema_migrations/20210813101742
new file mode 100644
index 00000000000000..f711612a8dc7c2
--- /dev/null
+++ b/db/schema_migrations/20210813101742
@@ -0,0 +1 @@
+4401423fc602a6d5df95857282bb84851fa99ddeb6c3d1ce4614f12c1dc4ec87
\ No newline at end of file
diff --git a/db/structure.sql b/db/structure.sql
index f107a569313672..4341ad37626610 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -19948,6 +19948,30 @@ CREATE SEQUENCE x509_issuers_id_seq
 
 ALTER SEQUENCE x509_issuers_id_seq OWNED BY x509_issuers.id;
 
+CREATE TABLE zentao_tracker_data (
+    id bigint NOT NULL,
+    integration_id bigint NOT NULL,
+    created_at timestamp with time zone NOT NULL,
+    updated_at timestamp with time zone NOT NULL,
+    encrypted_url bytea,
+    encrypted_url_iv bytea,
+    encrypted_api_url bytea,
+    encrypted_api_url_iv bytea,
+    encrypted_zentao_product_xid bytea,
+    encrypted_zentao_product_xid_iv bytea,
+    encrypted_api_token bytea,
+    encrypted_api_token_iv bytea
+);
+
+CREATE SEQUENCE zentao_tracker_data_id_seq
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+ALTER SEQUENCE zentao_tracker_data_id_seq OWNED BY zentao_tracker_data.id;
+
 CREATE TABLE zoom_meetings (
     id bigint NOT NULL,
     project_id bigint NOT NULL,
@@ -20885,6 +20909,8 @@ ALTER TABLE ONLY x509_commit_signatures ALTER COLUMN id SET DEFAULT nextval('x50
 
 ALTER TABLE ONLY x509_issuers ALTER COLUMN id SET DEFAULT nextval('x509_issuers_id_seq'::regclass);
 
+ALTER TABLE ONLY zentao_tracker_data ALTER COLUMN id SET DEFAULT nextval('zentao_tracker_data_id_seq'::regclass);
+
 ALTER TABLE ONLY zoom_meetings ALTER COLUMN id SET DEFAULT nextval('zoom_meetings_id_seq'::regclass);
 
 ALTER TABLE ONLY product_analytics_events_experimental
@@ -22654,6 +22680,9 @@ ALTER TABLE ONLY x509_commit_signatures
 ALTER TABLE ONLY x509_issuers
     ADD CONSTRAINT x509_issuers_pkey PRIMARY KEY (id);
 
+ALTER TABLE ONLY zentao_tracker_data
+    ADD CONSTRAINT zentao_tracker_data_pkey PRIMARY KEY (id);
+
 ALTER TABLE ONLY zoom_meetings
     ADD CONSTRAINT zoom_meetings_pkey PRIMARY KEY (id);
 
@@ -25627,6 +25656,8 @@ CREATE INDEX index_x509_commit_signatures_on_x509_certificate_id ON x509_commit_
 
 CREATE INDEX index_x509_issuers_on_subject_key_identifier ON x509_issuers USING btree (subject_key_identifier);
 
+CREATE INDEX index_zentao_tracker_data_on_integration_id ON zentao_tracker_data USING btree (integration_id);
+
 CREATE INDEX index_zoom_meetings_on_issue_id ON zoom_meetings USING btree (issue_id);
 
 CREATE UNIQUE INDEX index_zoom_meetings_on_issue_id_and_issue_status ON zoom_meetings USING btree (issue_id, issue_status) WHERE (issue_status = 1);
@@ -27673,6 +27704,9 @@ ALTER TABLE ONLY required_code_owners_sections
 ALTER TABLE ONLY dast_site_profiles
     ADD CONSTRAINT fk_rails_83e309d69e FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
 
+ALTER TABLE ONLY zentao_tracker_data
+    ADD CONSTRAINT fk_rails_84efda7be0 FOREIGN KEY (integration_id) REFERENCES integrations(id) ON DELETE CASCADE;
+
 ALTER TABLE ONLY boards_epic_user_preferences
     ADD CONSTRAINT fk_rails_851fe1510a FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
 
-- 
GitLab