create table users(id bigint primary key generated always as identity,name text,username text unique,password text,role text);
insert into users(name,username,password,role)values('Admin','admin','stockedu@2026','Admin'),('Raj','raj','raj@123','Counsellor'),('Neeraj','neeraj','neeraj@123','Receptionist');
create table students(id bigint primary key generated always as identity,student_id text unique,name text,mobile text,email text,whatsapp text,gender text,dob text,course text,batch text,trading_bg text,profession text,guardian text,city text,status text default 'Active',fees_status text default 'Pending',notes text,joined_date text,created_at timestamptz default now());
create table leads(id bigint primary key generated always as identity,name text,mobile text,email text,course_interest text,source text,trading_exp text,budget text,stage text default 'New',counsellor text,followup_date text,notes text,created_at timestamptz default now());
create table fees(id bigint primary key generated always as identity,receipt_no text,student_name text,student_id_ref text,course text,amount numeric,discount numeric default 0,payment_mode text,installment text,transaction_ref text,collected_by text,remarks text,payment_date text,created_at timestamptz default now());
create table expenses(id bigint primary key generated always as identity,category text,amount numeric,description text,payment_mode text,expense_date text,created_at timestamptz default now());
alter table users enable row level security;
alter table students enable row level security;
alter table leads enable row level security;
alter table fees enable row level security;
alter table expenses enable row level security;
create policy "allow all" on users for all using(true) with check(true);
create policy "allow all" on students for all using(true) with check(true);
create policy "allow all" on leads for all using(true) with check(true);
create policy "allow all" on fees for all using(true) with check(true);
create policy "allow all" on expenses for all using(true) with check(true);