CREATE TABLE products (
  id BIGSERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  brand TEXT,
  description TEXT,
  price NUMERIC NOT NULL,
  old_price NUMERIC,
  category TEXT,
  badge TEXT,
  emoji TEXT DEFAULT '💊',
  image_url TEXT,
  image_url_2 TEXT,
  rating INTEGER DEFAULT 5,
  reviews INTEGER DEFAULT 0,
  active BOOLEAN DEFAULT true,
  created_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE products ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON products FOR ALL USING (true);

CREATE TABLE settings (
  id INTEGER PRIMARY KEY DEFAULT 1,
  store_name TEXT DEFAULT 'ناتورا كير',
  logo_url TEXT,
  hero_image_1 TEXT,
  hero_image_2 TEXT,
  hero_image_3 TEXT,
  shipping_price INTEGER DEFAULT 50,
  free_shipping_threshold INTEGER DEFAULT 1000,
  phone TEXT DEFAULT '01037254330',
  whatsapp TEXT DEFAULT '201037236711',
  promo_codes JSONB DEFAULT '[]',
  updated_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE settings ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON settings FOR ALL USING (true);
INSERT INTO settings (id) VALUES (1) ON CONFLICT DO NOTHING;

CREATE TABLE orders (
  id BIGSERIAL PRIMARY KEY,
  order_number TEXT,
  customer_name TEXT,
  phone TEXT,
  address TEXT,
  payment_method TEXT,
  products TEXT,
  total_price NUMERIC,
  status TEXT DEFAULT 'pending',
  created_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE orders ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all" ON orders FOR ALL USING (true);