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(),