summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/dump.sql4
-rw-r--r--util/updates/update_2.10.sql11
2 files changed, 12 insertions, 3 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 2e2b6cf7..66db690c 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -38,8 +38,7 @@ CREATE TABLE changes (
added timestamptz NOT NULL DEFAULT NOW(),
requester integer NOT NULL DEFAULT 0,
ip inet NOT NULL DEFAULT '0.0.0.0',
- comments text NOT NULL DEFAULT '',
- causedby integer
+ comments text NOT NULL DEFAULT ''
);
-- producers
@@ -365,7 +364,6 @@ CREATE TABLE wlists (
ALTER TABLE changes ADD FOREIGN KEY (requester) REFERENCES users (id);
-ALTER TABLE changes ADD FOREIGN KEY (causedby) REFERENCES changes (id);
ALTER TABLE producers ADD FOREIGN KEY (latest) REFERENCES producers_rev (id) DEFERRABLE INITIALLY DEFERRED;
ALTER TABLE producers ADD FOREIGN KEY (rgraph) REFERENCES relgraphs (id);
ALTER TABLE producers_relations ADD FOREIGN KEY (pid1) REFERENCES producers_rev (id);
diff --git a/util/updates/update_2.10.sql b/util/updates/update_2.10.sql
index e034b6e8..ad2dd1c7 100644
--- a/util/updates/update_2.10.sql
+++ b/util/updates/update_2.10.sql
@@ -182,3 +182,14 @@ $$ LANGUAGE plpgsql;
CREATE TRIGGER release_vncache_update AFTER UPDATE ON releases FOR EACH ROW EXECUTE PROCEDURE release_vncache_update();
+-- remove changes.causedby and give the affected changes to Multi
+UPDATE changes SET requester = 1 WHERE causedby IS NOT NULL;
+ALTER TABLE changes DROP COLUMN causedby;
+UPDATE users SET
+ c_changes = COALESCE((
+ SELECT COUNT(id)
+ FROM changes
+ WHERE requester = users.id
+ GROUP BY requester
+ ), 0);
+