diff options
| author | Fabrice Bellingard <bellingard@gmail.com> | 2012-03-27 09:36:25 +0200 |
|---|---|---|
| committer | Fabrice Bellingard <bellingard@gmail.com> | 2012-03-27 09:36:25 +0200 |
| commit | 2d4f0cd2bb0b768f401ca776eb256d7f31957976 (patch) | |
| tree | ff3ad10a1c01ecb5866615b75d306a6da5cbf714 /sonar-server/src/main/webapp | |
| parent | 2d407aeb481218fdcf9cdc498008942d92252f04 (diff) | |
| download | sonarqube-2d4f0cd2bb0b768f401ca776eb256d7f31957976.tar.gz sonarqube-2d4f0cd2bb0b768f401ca776eb256d7f31957976.zip | |
Improve DB readme file.
Diffstat (limited to 'sonar-server/src/main/webapp')
| -rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/db/migrate/README.txt | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/README.txt b/sonar-server/src/main/webapp/WEB-INF/db/migrate/README.txt index f1d93735e13..906efdf97d2 100644 --- a/sonar-server/src/main/webapp/WEB-INF/db/migrate/README.txt +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/README.txt @@ -12,7 +12,11 @@ HOW TO ADD A MIGRATION RECOMMENDATIONS -* Prefer to add nullable columns to avoid problems during migration. +* Prefer to add nullable columns to avoid problems during migration, EXCEPT for booleans. For booleans: + + * columns must be NON-nullable but default value (false) must NOT be set in database. It allows to fully define the model programmatically. + * column names must be chosen so that the default value is actually false. + * E.g.: rule_failures.switched_off * Always create an index with a name : add_index "action_plans", "project_id", :name => "action_plans_project_id" Note that this name is limited to 30 characters because of Oracle constraint. |