initia/prisma/schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init

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

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

model Account {
  id            Int      @id @default(autoincrement())
  mnemonic      String   @db.VarChar(255)
  address       String   @db.VarChar(100)
  balance       String?  @db.VarChar(50)
  xrpPrivateKey String?  @db.VarChar(255)
  gmail         String?  @db.VarChar(100)
  status        Int      @default(0)
  message       String?  @db.Text
  lastRun       DateTime @db.DateTime(0)
  duid          String?  @db.VarChar(80)
  deviceModel   String?  @db.VarChar(30)
  deviceOS      String?  @db.VarChar(30)
}

model Faucet {
  id                 Int      @id @default(autoincrement())
  mnemonic           String   @db.VarChar(255)
  address            String   @db.VarChar(100)
  balance            BigInt?
  passportPrivateKey String   @db.VarChar(100)
  lastRun            DateTime @db.DateTime(0)
  availableFrom      DateTime @db.DateTime(0)
  message            String?  @db.Text
  tucStatus          Int      @default(0)
}

model RandomTask {
  id       Int    @id @default(autoincrement())
  mnemonic String @db.VarChar(255)
  address  String @db.VarChar(100)
  task2    Int    @default(0)
  task3    Int    @default(0)
  task4    Int    @default(0)
  task5    Int    @default(0)
  task6    Int    @default(0)
  finish   Int    @default(0)
}

model RandomTask2 {
  id        Int     @id @default(autoincrement())
  mnemonic  String  @db.VarChar(255)
  address   String  @db.VarChar(100)
  toAddress String? @db.VarChar(100)
  task1     Int     @default(0)
  task2     Int     @default(0)
  task3     Int     @default(0)
  task4     Int     @default(0)
  task5     Int     @default(0)
  task6     Int     @default(0)
  finish    Int     @default(0)
}