Save habits to Supabase (persistent data)
Replace localStorage with Supabase so habits persist across devices:
-- Create habits table
create table habits (
id uuid default gen_random_uuid() primary key,
user_id uuid references profiles(id) on delete cascade,
name text not null,
icon text,
schedule text default 'daily',
is_negative boolean default false,
limit_count int,
created_at timestamp default now()
);
create table habit_logs (
id uuid default gen_random_uuid() primary key,
habit_id uuid references habits(id) on delete cascade,
user_id uuid references profiles(id) on delete cascade,
completed_at date default current_date,
unique(habit_id, completed_at)
);
ENABLES CROSS-DEVICE SYNC