-- Organization Support Migration
-- Adds session context columns and team tables for better-auth organization plugin
-- ============================================================================
-- SESSION TABLE: Add organization context columns
-- ============================================================================
ALTER TABLE session ADD COLUMN active_organization_id TEXT;
ALTER TABLE session ADD COLUMN active_team_id TEXT;
-- ============================================================================
-- TEAM TABLE
-- ============================================================================
CREATE TABLE team (
id TEXT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
organization_id TEXT NOT NULL REFERENCES organization(id) ON DELETE CASCADE,
created_at INTEGER NOT NULL,
updated_at INTEGER NOT NULL
);
CREATE INDEX idx_team_org ON team(organization_id);
-- ============================================================================
-- TEAM MEMBER TABLE
-- ============================================================================
CREATE TABLE team_member (
id TEXT PRIMARY KEY NOT NULL,
team_id TEXT NOT NULL REFERENCES team(id) ON DELETE CASCADE,
user_id TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,
created_at INTEGER NOT NULL,
UNIQUE(team_id, user_id)
);
CREATE INDEX idx_team_member_team ON team_member(team_id);
CREATE INDEX idx_team_member_user ON team_member(user_id);
