451aed8983
* feat(db): add support for multiple users and organizations * feat: backfill entities with new organization id * refactor: filter all backend queries to surface only organization specific entities * refactor: each org has its own restic password * test: ensure organization is created * chore: pr feedbacks * refactor: filter by org id in all places * refactor: download restic password from stored db password * refactor(navigation): use volume id in urls instead of name * feat: disable registrations * refactor(auth): bubble up auth error to hono * refactor: use async local storage for cleaner context sharing * refactor: enable user registration vs disabling it * test: multi-org isolation * chore: final cleanup
15 lines
651 B
SQL
15 lines
651 B
SQL
UPDATE volumes_table
|
|
SET organization_id = (SELECT id FROM organization ORDER BY created_at ASC LIMIT 1)
|
|
WHERE organization_id IS NULL;
|
|
--> statement-breakpoint
|
|
UPDATE backup_schedules_table
|
|
SET organization_id = (SELECT id FROM organization ORDER BY created_at ASC LIMIT 1)
|
|
WHERE organization_id IS NULL;
|
|
--> statement-breakpoint
|
|
UPDATE notification_destinations_table
|
|
SET organization_id = (SELECT id FROM organization ORDER BY created_at ASC LIMIT 1)
|
|
WHERE organization_id IS NULL;
|
|
--> statement-breakpoint
|
|
UPDATE repositories_table
|
|
SET organization_id = (SELECT id FROM organization ORDER BY created_at ASC LIMIT 1)
|
|
WHERE organization_id IS NULL;
|