-- Supabase → SQL Editor এ পেস্ট করুন create table if not exists prem_series ( id serial primary key, name text not null, thumbnail text default '', created_at timestamp default now() ); create table if not exists prem_episodes ( id serial primary key, series_id integer references prem_series(id) on delete cascade, series_name text, title text not null, voe_link text default '', embed_code text default '', thumbnail text default '', is_new boolean default false, created_at timestamp default now() ); create table if not exists golpo_series ( id serial primary key, name text not null, thumbnail text default '', created_at timestamp default now() ); create table if not exists golpo_episodes ( id serial primary key, series_id integer references golpo_series(id) on delete cascade, series_name text, title text not null, voe_link text default '', embed_code text default '', thumbnail text default '', is_new boolean default false, created_at timestamp default now() ); create table if not exists deshi_videos ( id serial primary key, title text not null, voe_link text default '', embed_code text default '', thumbnail text default '', is_new boolean default false, created_at timestamp default now() ); create table if not exists hero_slides ( id serial primary key, section text default 'home', title text not null, badge text default '', description text default '', image_url text default '', bg_gradient text default '', btn1_text text default '', btn1_link text default 'premium', btn2_text text default '', btn2_link text default '', sort_order integer default 1, created_at timestamp default now() ); -- পুরনো টেবিলে নতুন কলাম: alter table prem_series add column if not exists thumbnail text default ''; alter table prem_episodes add column if not exists embed_code text default ''; alter table prem_episodes add column if not exists thumbnail text default ''; alter table golpo_series add column if not exists thumbnail text default ''; alter table golpo_episodes add column if not exists embed_code text default ''; alter table golpo_episodes add column if not exists thumbnail text default ''; alter table deshi_videos add column if not exists embed_code text default ''; alter table deshi_videos add column if not exists thumbnail text default ''; alter table hero_slides add column if not exists section text default 'home'; -- episode_num কলাম drop: alter table prem_episodes drop column if exists episode_num; alter table golpo_episodes drop column if exists episode_num; -- RLS বন্ধ: alter table prem_series disable row level security; alter table prem_episodes disable row level security; alter table golpo_series disable row level security; alter table golpo_episodes disable row level security; alter table deshi_videos disable row level security; alter table hero_slides disable row level security; -- বিজ্ঞাপন টেবিল: create table if not exists ad_codes ( id serial primary key, position text not null, code text default '', is_active boolean default false, created_at timestamp default now() ); alter table ad_codes disable row level security;