SMART BREEDING Admin

-- 1. TABEL PENGGUNA DAFTAR PETERNAK
CREATE TABLE IF NOT EXISTS ternak_users (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    nama TEXT NOT NULL,
    email TEXT UNIQUE NOT NULL,
    phone TEXT NOT NULL,
    ring_name TEXT,
    kota TEXT,
    password TEXT NOT NULL,
    is_premium BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) NOT NULL
);

-- 2. TABEL BACKUP SINKRONISASI ROOM DATABASE
CREATE TABLE IF NOT EXISTS ternak_backups (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    email TEXT NOT NULL,
    label TEXT NOT NULL,
    birds_json TEXT NOT NULL DEFAULT '[]',
    couples_json TEXT NOT NULL DEFAULT '[]',
    journals_json TEXT NOT NULL DEFAULT '[]',
    transactions_json TEXT NOT NULL DEFAULT '[]',
    reminders_json TEXT NOT NULL DEFAULT '[]',
    created_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()) NOT NULL
);

-- 3. JAMIN AKSESIBILITAS BACKEND BYPASS RLS (Row Level Security)
ALTER TABLE ternak_users DISABLE ROW LEVEL SECURITY;
ALTER TABLE ternak_backups DISABLE ROW LEVEL SECURITY;