diff options
| author | Fabrice Bellingard <bellingard@gmail.com> | 2012-03-26 18:56:38 +0200 |
|---|---|---|
| committer | Fabrice Bellingard <bellingard@gmail.com> | 2012-03-26 18:56:38 +0200 |
| commit | 3c98441e049fe73982ee3471ea0b9baa58fbaa91 (patch) | |
| tree | 9f1e5f4d306deffc18fb4d360d29eaf664fb4830 /sonar-core/src/main/resources | |
| parent | e93d3eb4d95d89051eb9ea6f6ab6b8f2f6751487 (diff) | |
| download | sonarqube-3c98441e049fe73982ee3471ea0b9baa58fbaa91.tar.gz sonarqube-3c98441e049fe73982ee3471ea0b9baa58fbaa91.zip | |
SONAR-3352 Change boolean columns to non-nullable in migration script
Diffstat (limited to 'sonar-core/src/main/resources')
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/persistence/rows-derby.sql | 1 | ||||
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl | 4 |
2 files changed, 3 insertions, 2 deletions
diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/rows-derby.sql b/sonar-core/src/main/resources/org/sonar/core/persistence/rows-derby.sql index 01697d00a17..cd59e806017 100644 --- a/sonar-core/src/main/resources/org/sonar/core/persistence/rows-derby.sql +++ b/sonar-core/src/main/resources/org/sonar/core/persistence/rows-derby.sql @@ -181,6 +181,7 @@ INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('262'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('263'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('280'); INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('281'); +INSERT INTO SCHEMA_MIGRATIONS(VERSION) VALUES ('282'); INSERT INTO USERS(ID, LOGIN, NAME, EMAIL, CRYPTED_PASSWORD, SALT, CREATED_AT, UPDATED_AT, REMEMBER_TOKEN, REMEMBER_TOKEN_EXPIRES_AT) VALUES (1, 'admin', 'Administrator', '', 'a373a0e667abb2604c1fd571eb4ad47fe8cc0878', '48bc4b0d93179b5103fd3885ea9119498e9d161b', '2011-09-26 22:27:48.0', '2011-09-26 22:27:48.0', null, null); ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 2; diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl index 4df7a9a18ad..334c5c8edb3 100644 --- a/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl +++ b/sonar-core/src/main/resources/org/sonar/core/persistence/schema-derby.ddl @@ -314,8 +314,8 @@ CREATE TABLE "REVIEWS" ( "RESOURCE_LINE" INTEGER, "RESOLUTION" VARCHAR(200), "RULE_ID" INTEGER, - "MANUAL_VIOLATION" BOOLEAN, - "MANUAL_SEVERITY" BOOLEAN + "MANUAL_VIOLATION" BOOLEAN NOT NULL, + "MANUAL_SEVERITY" BOOLEAN NOT NULL ); CREATE TABLE "ACTIVE_FILTERS" ( |