5.x/prisma/schema.prisma

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

datasource db {
    provider = "postgresql"
    url      = env("DB_URL")
}

enum InfractionType {
    BAN
    KICK
    MUTE
    WARNING
    MASSBAN
    TEMPBAN
    SOFTBAN
    MASSKICK
    UNBAN
    UNMUTE
    BULK_DELETE_MESSAGE
    TIMEOUT
    TIMEOUT_REMOVE
    BEAN
    NOTE
}

model Infraction {
    id          Int            @id @default(autoincrement())
    type        InfractionType
    userId      String
    guildId     String
    reason      String?
    moderatorId String
    expiresAt   DateTime?
    metadata    Json?
    createdAt   DateTime       @default(now())
    updatedAt   DateTime       @default(now()) @updatedAt
    queueId     Int?

    @@map("infractions")
}

model SpamRecord {
    id        Int      @id @default(autoincrement())
    user_id   String
    guild_id  String
    level     Int      @default(1)
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@map("spam_records")
}

model Queue {
    id         Int      @id @default(autoincrement())
    user_id    String
    guild_id   String
    channel_id String?
    message_id String?
    file_name  String
    name       String
    args       String[] @default([])
    createdAt  DateTime @default(now())
    willRunAt  DateTime

    @@map("queues")
}

model Snippet {
    id               Int              @id @default(autoincrement())
    name             String
    user_id          String
    guild_id         String
    roles            String[]         @default([])
    channels         String[]         @default([])
    users            String[]         @default([])
    attachments      String[]         @default([])
    content          String[]         @default([])
    randomize        Boolean          @default(false)
    permission_roles PermissionRole[]
    level            Int?
    createdAt        DateTime         @default(now())
    updatedAt        DateTime         @default(now()) @updatedAt

    @@map("snippets")
}

model ChannelLock {
    id          Int      @id @default(autoincrement())
    guild_id    String
    channel_id  String
    permissions Json
    createdAt   DateTime @default(now())
    updatedAt   DateTime @default(now()) @updatedAt

    @@map("channel_locks")
}

model PermissionRole {
    id                 Int      @id @default(autoincrement())
    name               String
    guild_id           String
    roles              String[] @default([])
    users              String[] @default([])
    grantedPermissions String[] @default([])
    level              Int?
    createdAt          DateTime @default(now())
    updatedAt          DateTime @default(now()) @updatedAt
    snippet            Snippet? @relation(fields: [snippetId], references: [id])
    snippetId          Int?

    @@map("permission_roles")
}

model ReactionRole {
    id                  Int      @id @default(autoincrement())
    emoji               String
    isBuiltInEmoji      Boolean
    guildId             String
    channelId           String
    messageId           String
    roles               String[]
    requiredRoles       String[] @default([])
    blacklistedUsers    String[] @default([])
    requiredPermissions String[] @default([])
    level               Int?
    single              Boolean  @default(false)
    createdAt           DateTime @default(now())
    updatedAt           DateTime @default(now()) @updatedAt

    @@map("reaction_roles")
}

model User {
    id             Int       @id @default(autoincrement())
    name           String?
    username       String
    discordId      String
    guilds         String[]  @default([])
    password       String
    token          String?
    createdAt      DateTime  @default(now())
    tokenExpiresAt DateTime?
    updatedAt      DateTime  @default(now()) @updatedAt

    @@map("users")
}

model BoostRoleEntries {
    id        Int      @id @default(autoincrement())
    role_id   String
    user_id   String
    guild_id  String
    createdAt DateTime @default(now())

    @@map("boost_role_entries")
}

model AfkEntry {
    id        Int      @id @default(autoincrement())
    reason    String?
    userId    String
    guildId   String
    mentions  String[] @default([])
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@map("afk_entries")
}

enum PermissionLogicMode {
    OR
    AND
}

model CommandPermissionOverwrites {
    id                     Int                 @id @default(autoincrement())
    guildId                String
    commands               String[]
    requiredPermissions    String[]            @default([])
    requiredPermissionMode PermissionLogicMode @default(AND)
    mode                   PermissionLogicMode @default(AND)
    requiredRoles          String[]            @default([])
    requiredUsers          String[]            @default([])
    requiredChannels       String[]            @default([])
    requiredLevel          Int?
    createdAt              DateTime            @default(now())
    updatedAt              DateTime            @default(now()) @updatedAt

    @@map("command_permission_overwrites")
}

model Ballot {
    id        Int      @id @default(autoincrement())
    guildId   String
    channelId String
    messageId String
    userId    String
    content   String
    anonymous Boolean  @default(false)
    files     String[] @default([])
    upvotes   String[] @default([])
    downvotes String[] @default([])
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@map("ballots")
}
1	rakinar2	577	generator client {
2			provider = "prisma-client-js"
3			}
4
5			datasource db {
6			provider = "postgresql"
7			url = env("DB_URL")
8			}
9
10			enum InfractionType {
11			BAN
12			KICK
13			MUTE
14			WARNING
15			MASSBAN
16			TEMPBAN
17			SOFTBAN
18			MASSKICK
19			UNBAN
20			UNMUTE
21			BULK_DELETE_MESSAGE
22			TIMEOUT
23			TIMEOUT_REMOVE
24			BEAN
25			NOTE
26			}
27
28			model Infraction {
29			id Int @id @default(autoincrement())
30			type InfractionType
31			userId String
32			guildId String
33			reason String?
34			moderatorId String
35			expiresAt DateTime?
36			metadata Json?
37			createdAt DateTime @default(now())
38			updatedAt DateTime @default(now()) @updatedAt
39			queueId Int?
40
41			@@map("infractions")
42			}
43
44			model SpamRecord {
45			id Int @id @default(autoincrement())
46			user_id String
47			guild_id String
48			level Int @default(1)
49			createdAt DateTime @default(now())
50			updatedAt DateTime @default(now()) @updatedAt
51
52			@@map("spam_records")
53			}
54
55			model Queue {
56			id Int @id @default(autoincrement())
57			user_id String
58			guild_id String
59			channel_id String?
60			message_id String?
61			file_name String
62			name String
63			args String[] @default([])
64			createdAt DateTime @default(now())
65			willRunAt DateTime
66
67			@@map("queues")
68			}
69
70			model Snippet {
71			id Int @id @default(autoincrement())
72			name String
73			user_id String
74			guild_id String
75			roles String[] @default([])
76			channels String[] @default([])
77			users String[] @default([])
78			attachments String[] @default([])
79			content String[] @default([])
80			randomize Boolean @default(false)
81			permission_roles PermissionRole[]
82			level Int?
83			createdAt DateTime @default(now())
84			updatedAt DateTime @default(now()) @updatedAt
85
86			@@map("snippets")
87			}
88
89			model ChannelLock {
90			id Int @id @default(autoincrement())
91			guild_id String
92			channel_id String
93			permissions Json
94			createdAt DateTime @default(now())
95			updatedAt DateTime @default(now()) @updatedAt
96
97			@@map("channel_locks")
98			}
99
100			model PermissionRole {
101			id Int @id @default(autoincrement())
102			name String
103			guild_id String
104			roles String[] @default([])
105			users String[] @default([])
106			grantedPermissions String[] @default([])
107			level Int?
108			createdAt DateTime @default(now())
109			updatedAt DateTime @default(now()) @updatedAt
110			snippet Snippet? @relation(fields: [snippetId], references: [id])
111			snippetId Int?
112
113			@@map("permission_roles")
114			}
115
116			model ReactionRole {
117			id Int @id @default(autoincrement())
118			emoji String
119			isBuiltInEmoji Boolean
120			guildId String
121			channelId String
122			messageId String
123			roles String[]
124			requiredRoles String[] @default([])
125			blacklistedUsers String[] @default([])
126			requiredPermissions String[] @default([])
127			level Int?
128			single Boolean @default(false)
129			createdAt DateTime @default(now())
130			updatedAt DateTime @default(now()) @updatedAt
131
132			@@map("reaction_roles")
133			}
134
135			model User {
136			id Int @id @default(autoincrement())
137			name String?
138			username String
139			discordId String
140			guilds String[] @default([])
141			password String
142			token String?
143			createdAt DateTime @default(now())
144			tokenExpiresAt DateTime?
145			updatedAt DateTime @default(now()) @updatedAt
146
147			@@map("users")
148			}
149
150			model BoostRoleEntries {
151			id Int @id @default(autoincrement())
152			role_id String
153			user_id String
154			guild_id String
155			createdAt DateTime @default(now())
156
157			@@map("boost_role_entries")
158			}
159
160			model AfkEntry {
161			id Int @id @default(autoincrement())
162			reason String?
163			userId String
164			guildId String
165			mentions String[] @default([])
166			createdAt DateTime @default(now())
167			updatedAt DateTime @default(now()) @updatedAt
168
169			@@map("afk_entries")
170			}
171
172			enum PermissionLogicMode {
173			OR
174			AND
175			}
176
177			model CommandPermissionOverwrites {
178			id Int @id @default(autoincrement())
179			guildId String
180			commands String[]
181			requiredPermissions String[] @default([])
182			requiredPermissionMode PermissionLogicMode @default(AND)
183			mode PermissionLogicMode @default(AND)
184			requiredRoles String[] @default([])
185			requiredUsers String[] @default([])
186			requiredChannels String[] @default([])
187			requiredLevel Int?
188			createdAt DateTime @default(now())
189			updatedAt DateTime @default(now()) @updatedAt
190
191			@@map("command_permission_overwrites")
192			}
193
194			model Ballot {
195			id Int @id @default(autoincrement())
196			guildId String
197			channelId String
198			messageId String
199			userId String
200			content String
201			anonymous Boolean @default(false)
202			files String[] @default([])
203			upvotes String[] @default([])
204			downvotes String[] @default([])
205			createdAt DateTime @default(now())
206			updatedAt DateTime @default(now()) @updatedAt
207
208			@@map("ballots")
209			}