12 lines
327 B
SQL
12 lines
327 B
SQL
-- This makes segments.collection non-nullable.
|
|
CREATE TABLE segments_temp (
|
|
id TEXT PRIMARY KEY,
|
|
type TEXT NOT NULL,
|
|
scope TEXT NOT NULL,
|
|
collection TEXT REFERENCES collection(id) NOT NULL
|
|
);
|
|
|
|
INSERT INTO segments_temp SELECT * FROM segments;
|
|
DROP TABLE segments;
|
|
ALTER TABLE segments_temp RENAME TO segments;
|