X-Git-Url: https://dev.renevier.net/?a=blobdiff_plain;f=scripts%2Fschema.postgres.sql;h=cbb12a6ca879411c25416dd47a87ec0a944dafe0;hb=9e25156ae46eb12f1801f503c7fdf51534d1c1a9;hp=4c257b3861acb89457cc16067bd3917f540cbc5a;hpb=a64d41557a62ec6051d7fa08d1ba941e089aa5c2;p=syj.git

diff --git a/scripts/schema.postgres.sql b/scripts/schema.postgres.sql
index 4c257b3..cbb12a6 100644
--- a/scripts/schema.postgres.sql
+++ b/scripts/schema.postgres.sql
@@ -100,7 +100,7 @@ DROP TABLE IF EXISTS paths CASCADE;
 CREATE TABLE paths (
     id INTEGER PRIMARY KEY DEFAULT nextval('paths_id_seq'),
     geom GEOGRAPHY (LINESTRING, 4326) NOT NULL,
-    creator INTEGER REFERENCES users ON DELETE CASCADE,
+    creator INTEGER REFERENCES users ON DELETE SET NULL,
     creator_ip INET NOT NULL,
     title VARCHAR(40),
     last_update TIMESTAMP NOT NULL DEFAULT NOW(),