আমার একটি License Admin Panel আছে (v0/Next.js দিয়ে বানানো)।
এখন আমার Chrome Extension-এর সাথে connect করতে হবে।

Supabase Project Details:

• URL: https://আপনার-project.supabase.co
• Anon Key: আপনার-anon-key
• Service Role Key: আপনার-service-role-key

আমার নিচের Supabase Edge Functions দরকার। প্রতিটি Function-এর
exact input/output নিচে দেওয়া আছে।

──────────────────────────────────────────
FUNCTION 1: validate-license
──────────────────────────────────────────
Path: /functions/v1/validate-license
Method: POST

Request body:
{
"license_key": "QL-XXXXXXXXXXXXXXXX",
"device_id": "hardware-fingerprint-string",
"session_id": "optional-for-heartbeat",
"heartbeat": false,
"max_devices": 2
}

Response (success):
{
"valid": true,
"session_id": "uuid",
"user_name": "John Doe",
"expires_at": "2025-12-31T00:00:00Z",
"activated_at": "2024-01-01T00:00:00Z",
"status": "active",
"message": "Valid License"
}

Response (fail):
{
"valid": false,
"message": "Invalid key" // or "License expired" / "Device limit reached"
}

Logic:

1. licenses টেবিলে license_key খোঁজো
2. status == 'active' এবং expires_at ভবিষ্যৎ কিনা চেক করো
3. license_sessions টেবিলে এই license_key এর unique device_id গুলো গোনো
4. নতুন device হলে max_devices limit চেক করো
5. license_sessions এ upsert করো (license_key + device_id unique)
6. সফল হলে valid:true response দাও

──────────────────────────────────────────
FUNCTION 2: optimize-prompt (optional)
──────────────────────────────────────────
Path: /functions/v1/optimize-prompt
Method: POST
Headers: x-license-key

Request: { "prompt": "user prompt text" }
Response: { "optimized": "improved prompt text" }

Logic: license_key valid কিনা চেক করো, তারপর prompt return করো
(AI দিয়ে optimize করলে ভালো, না হলে same prompt return করো)

──────────────────────────────────────────
DATABASE TABLES (SQL):
──────────────────────────────────────────

-- RLS Policy দরকার:
-- licenses: anon can SELECT by license_key
-- notifications: anon can SELECT all
-- extension_versions: anon can SELECT all
-- packages: anon can SELECT where is_active=true
-- user_roles: authenticated can SELECT own role
-- feature_flags: anon can SELECT all
-- license_sessions: service role only (Edge Function ব্যবহার করবে)

-- Enable RLS on all tables
-- licenses table: anon SELECT policy
ALTER TABLE licenses ENABLE ROW LEVEL SECURITY;
CREATE POLICY "anon_read_license" ON licenses
FOR SELECT TO anon
USING (true);

-- notifications: public read
ALTER TABLE notifications ENABLE ROW LEVEL SECURITY;
CREATE POLICY "public_read_notifications" ON notifications
FOR SELECT TO anon USING (true);

-- extension_versions: public read
ALTER TABLE extension_versions ENABLE ROW LEVEL SECURITY;
CREATE POLICY "public_read_versions" ON extension_versions
FOR SELECT TO anon USING (true);

-- packages: public read active
ALTER TABLE packages ENABLE ROW LEVEL SECURITY;
CREATE POLICY "public_read_packages" ON packages
FOR SELECT TO anon USING (is_active = true);

-- feature_flags: public read
ALTER TABLE feature_flags ENABLE ROW LEVEL SECURITY;
CREATE POLICY "public_read_flags" ON feature_flags
FOR SELECT TO anon USING (true);

──────────────────────────────────────────
ADMIN PANEL এ যা থাকা দরকার:
──────────────────────────────────────────

1. লাইসেন্স তৈরি করার সময় key format: "QL-" + 16 random hex uppercase
2. Admin login: Supabase Auth email/password + user_roles table check
3. Extension version আপলোড: Supabase Storage bucket নাম "extension-releases"
   (public bucket হতে হবে)
4. Storage path: extension-releases/{filename.zip}
   Admin Panel এ version তৈরির সময় file_path field এ শুধু filename দিলেই হবে

──────────────────────────────────────────
TEST LICENSE:
──────────────────────────────────────────
licenses টেবিলে একটি test entry দিন:

• license_key: ********
• user_name: Test User
• status: active
• expires_at: 2026-12-31
• max_devices: 2