generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

model Category {
  id        String   @id @default(cuid())
  title     String
  slug      String   @unique
  image     String   @default("")
  sortOrder Int      @default(99)
  createdAt DateTime @default(now())
}

model Product {
  id                 String   @id @default(cuid())
  name               String
  slug               String   @unique
  price              Int      @default(0)
  stock              Int      @default(0)
  status             String   @default("active")
  about              String   @default("")
  images             String   @default("[]") // JSON array of image URLs/paths
  features           String   @default("[]") // JSON array
  brands             String   @default("[]") // JSON array
  categories         String   @default("[]") // JSON array of {title, slug}
  specifications     String   @default("{}") // JSON object
  specificationOrder String   @default("[]") // JSON array
  rating             Float    @default(0)
  reviewCount        Int      @default(0)
  isDeal             Boolean  @default(false)
  createdAt          DateTime @default(now())
  updatedAt          DateTime @updatedAt
}

model AdminUser {
  id           String   @id @default(cuid())
  username     String   @unique
  passwordHash String
  createdAt    DateTime @default(now())
}

model Setting {
  key   String @id
  value String @default("")
}

model HomeSection {
  key       String  @id
  title     String
  enabled   Boolean @default(true)
  sortOrder Int     @default(0)
}