diff options
| author | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-09-09 11:16:37 +0200 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-09-12 14:11:58 +0200 |
| commit | b5851d0ff8318549c2356b20df36401b879fc5a2 (patch) | |
| tree | 49c1f9a615715f10d9d3852a7ad02d9ead2f178a /sonar-db/src/test/resources | |
| parent | 0fc1b325a335c9ecad906908d2c8d87c12f0f976 (diff) | |
| download | sonarqube-b5851d0ff8318549c2356b20df36401b879fc5a2.tar.gz sonarqube-b5851d0ff8318549c2356b20df36401b879fc5a2.zip | |
SONAR-7851 copy activities to qprofile_changes
Diffstat (limited to 'sonar-db/src/test/resources')
| -rw-r--r-- | sonar-db/src/test/resources/org/sonar/db/version/v61/CopyActivitiesToQprofileChangesTest/schema.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/sonar-db/src/test/resources/org/sonar/db/version/v61/CopyActivitiesToQprofileChangesTest/schema.sql b/sonar-db/src/test/resources/org/sonar/db/version/v61/CopyActivitiesToQprofileChangesTest/schema.sql new file mode 100644 index 00000000000..1ad0dd1d259 --- /dev/null +++ b/sonar-db/src/test/resources/org/sonar/db/version/v61/CopyActivitiesToQprofileChangesTest/schema.sql @@ -0,0 +1,22 @@ +CREATE TABLE "ACTIVITIES" ( + "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), + "LOG_KEY" VARCHAR(250), + "PROFILE_KEY" VARCHAR(255) NOT NULL, + "CREATED_AT" TIMESTAMP, + "USER_LOGIN" VARCHAR(255), + "LOG_TYPE" VARCHAR(250), + "LOG_ACTION" VARCHAR(250), + "LOG_MESSAGE" VARCHAR(250), + "DATA_FIELD" CLOB(2147483647) +); +CREATE UNIQUE INDEX "ACTIVITIES_LOG_KEY" ON "ACTIVITIES" ("LOG_KEY"); + +CREATE TABLE "QPROFILE_CHANGES" ( + "KEE" VARCHAR(40) NOT NULL PRIMARY KEY, + "QPROFILE_KEY" VARCHAR(255) NOT NULL, + "CHANGE_TYPE" VARCHAR(20) NOT NULL, + "CREATED_AT" BIGINT NOT NULL, + "USER_LOGIN" VARCHAR(255), + "DATA" CLOB +); +CREATE INDEX "QPROFILE_CHANGES_QPROFILE_KEY" ON "QPROFILE_CHANGES" ("QPROFILE_KEY"); |