-- Run this script in your Supabase SQL Editor:
CREATE TABLE site_settings (
    id BIGINT PRIMARY KEY,
    project_name TEXT,
    offer_title TEXT,
    offer_start_date DATE,
    offer_end_date DATE,
    main_road_width TEXT,
    sub_road_width TEXT,
    contact_phone TEXT
);

CREATE TABLE plots_info (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    plot_number TEXT UNIQUE,
    plot_size TEXT,
    facing TEXT,
    status TEXT, -- Available, Booked, Sold
    price_per_katha TEXT
);

CREATE TABLE banners_info (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    banner_title TEXT,
    image_url TEXT,
    link_url TEXT,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

INSERT INTO site_settings (id, project_name, offer_title, offer_start_date, offer_end_date, main_road_width, sub_road_width, contact_phone)
VALUES (1, 'মেহেরুন্নেসা সোসাইটি', '১৫ জুন-১৫ জুলাই বিশেষ অফার', '2026-06-15', '2026-07-15', '২০', '১০', '01535491716')
ON CONFLICT (id) DO NOTHING;

-- Disable Row Level Security temporarily for client-side easy setup
ALTER TABLE site_settings DISABLE ROW LEVEL SECURITY;
ALTER TABLE plots_info DISABLE ROW LEVEL SECURITY;
ALTER TABLE banners_info DISABLE ROW LEVEL SECURITY;