[sysconfig] Revert contraint to location table: Breaks default config

Default config is locationid = 0, which obviously doesn't work with
the constraint. Using NULL proves difficult here (dups etc.), so
don't for now, and add code to the cron hook that will clean up
deleted locations.

1 files changed, 6 insertions, 1 deletions

diff --git a/modules-available/sysconfig/hooks/cron.inc.php b/modules-available/sysconfig/hooks/cron.inc.php
index d1f91437..d2457685 100644
--- a/modules-available/sysconfig/hooks/cron.inc.php
+++ b/modules-available/sysconfig/hooks/cron.inc.php
@@ -1,3 +1,8 @@
 <?php
 
-Trigger::ldadp();
\ No newline at end of file
+Trigger::ldadp();
+
+// Cleanup orphaned config<->location where the location has been deleted
+Database::exec("DELETE c FROM configtgz_location c
+			LEFT JOIN location l USING (locationid)
+			WHERE l.locationid IS NULL");