Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/pi-hole/pi-hole.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'advanced/Scripts/database_migration/gravity-db.sh')
-rw-r--r--advanced/Scripts/database_migration/gravity-db.sh8
1 files changed, 8 insertions, 0 deletions
diff --git a/advanced/Scripts/database_migration/gravity-db.sh b/advanced/Scripts/database_migration/gravity-db.sh
index 28054643..bc650d3f 100644
--- a/advanced/Scripts/database_migration/gravity-db.sh
+++ b/advanced/Scripts/database_migration/gravity-db.sh
@@ -72,4 +72,12 @@ upgrade_gravityDB(){
sqlite3 "${database}" < "${scriptPath}/6_to_7.sql"
version=7
fi
+ if [[ "$version" == "7" ]]; then
+ # This migration script recreated the group table
+ # to ensure uniqueness on the group name
+ # We also add date_added and date_modified columns
+ echo -e " ${INFO} Upgrading gravity database from version 7 to 8"
+ sqlite3 "${database}" < "${scriptPath}/7_to_8.sql"
+ version=8
+ fi
}