6 lines
301 B
SQL
6 lines
301 B
SQL
-- V4: Assign existing notes without an owner to userid=1 (first admin)
|
|
-- This ensures production data created before multi-user isolation is not lost.
|
|
UPDATE note SET userid = 1 WHERE userid IS NULL OR userid = 0;
|
|
|
|
INSERT OR IGNORE INTO db_version (version, applied_at) VALUES (4, datetime('now'));
|