diff options
| author | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2018-04-23 11:30:32 +0200 |
|---|---|---|
| committer | SonarTech <sonartech@sonarsource.com> | 2018-05-28 20:20:44 +0200 |
| commit | 984ac870408a5ad6c444693ff7b06af103aad734 (patch) | |
| tree | 6d19a603d9f1ce60061b551544e2aeedddcecda2 /server/sonar-server/src/test/resources | |
| parent | e8d18a35e2d2e60328b1abab78d36d0a8ab9340d (diff) | |
| download | sonarqube-984ac870408a5ad6c444693ff7b06af103aad734.tar.gz sonarqube-984ac870408a5ad6c444693ff7b06af103aad734.zip | |
SONAR-10430 populate FILE_SOURCES.LINE_COUNT at beginning of analysis
Diffstat (limited to 'server/sonar-server/src/test/resources')
| -rw-r--r-- | server/sonar-server/src/test/resources/org/sonar/server/computation/task/projectanalysis/dbmigration/PopulateFileSourceLineCountTest/file_sources.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/server/sonar-server/src/test/resources/org/sonar/server/computation/task/projectanalysis/dbmigration/PopulateFileSourceLineCountTest/file_sources.sql b/server/sonar-server/src/test/resources/org/sonar/server/computation/task/projectanalysis/dbmigration/PopulateFileSourceLineCountTest/file_sources.sql new file mode 100644 index 00000000000..bb379b9e112 --- /dev/null +++ b/server/sonar-server/src/test/resources/org/sonar/server/computation/task/projectanalysis/dbmigration/PopulateFileSourceLineCountTest/file_sources.sql @@ -0,0 +1,17 @@ +CREATE TABLE "FILE_SOURCES" ( + "ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), + "PROJECT_UUID" VARCHAR(50) NOT NULL, + "FILE_UUID" VARCHAR(50) NOT NULL, + "LINE_HASHES" CLOB, + "LINE_COUNT" INTEGER NOT NULL, + "BINARY_DATA" BLOB, + "DATA_TYPE" VARCHAR(20), + "DATA_HASH" VARCHAR(50), + "SRC_HASH" VARCHAR(50), + "REVISION" VARCHAR(100), + "CREATED_AT" BIGINT NOT NULL, + "UPDATED_AT" BIGINT NOT NULL +); +CREATE INDEX "FILE_SOURCES_PROJECT_UUID" ON "FILE_SOURCES" ("PROJECT_UUID"); +CREATE UNIQUE INDEX "FILE_SOURCES_UUID_TYPE" ON "FILE_SOURCES" ("FILE_UUID", "DATA_TYPE"); +CREATE INDEX "FILE_SOURCES_UPDATED_AT" ON "FILE_SOURCES" ("UPDATED_AT"); |