7.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)
    permissions    String[]            @default([])
    permissionMode PermissionLogicMode @default(AND)
    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 PermissionOverwrite {
    id                 Int      @id @default(autoincrement())
    name               String?
    guildId            String
    roles              String[] @default([])
    users              String[] @default([])
    grantedPermissions String[] @default([])
    createdAt          DateTime @default(now())
    updatedAt          DateTime @default(now()) @updatedAt

    @@map("permission_overwrites")
}

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?
    recoveryToken          String?
    recoveryCode           String?
    recoveryAttempts       Int       @default(0)
    recoveryTokenExpiresAt DateTime?
    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([])
    global    Boolean  @default(false)
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@map("afk_entries")
}

enum PermissionLogicMode {
    OR
    AND
}

// TODO: Add 'requiredPermissionOverwrites' field, type: @relation with PermissionOverwrite[]

model CommandPermissionOverwrite {
    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")
}

model PermissionLevel {
    id                 Int      @id @default(autoincrement())
    guildId            String
    level              Int
    disabled           Boolean  @default(false)
    grantedPermissions String[] @default([])
    roles              String[] @default([])
    users              String[] @default([])
    createdAt          DateTime @default(now())
    updatedAt          DateTime @default(now()) @updatedAt

    @@map("permission_levels")
}

model Review {
    id            Int      @id @default(autoincrement())
    reviewer      String?
    content       String
    rating        Int
    discordId     String?
    email         String?
    aboutReviewer String?
    approved      Boolean  @default(false)
    ip            String?
    createdAt     DateTime @default(now())
    updatedAt     DateTime @default(now()) @updatedAt

    @@map("reviews")
}

model VerificationEntry {
    id        Int      @id @default(autoincrement())
    userId    String
    token     String   @unique
    guildId   String
    attempts  Int      @default(0)
    meta      Json?
    createdAt DateTime @default(now())
    updatedAt DateTime @default(now()) @updatedAt

    @@map("verification_entries")
}

model GlobalUserBan {
    id         Int      @id @default(autoincrement())
    userId     String   @unique
    reason     String?
    executorId String
    notified   Boolean  @default(false)
    createdAt  DateTime @default(now())
    updatedAt  DateTime @default(now()) @updatedAt

    @@map("global_user_bans")
}

model UserStatistics {
    id              Int      @id @default(autoincrement())
    userId          String
    guildId         String
    messagesSent    Int      @default(0)
    messagesEdited  Int      @default(0)
    messagesDeleted Int      @default(0)
    createdAt       DateTime @default(now())
    updatedAt       DateTime @default(now()) @updatedAt

    @@map("user_statistics")
}
1	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	permissions String[] @default([])
82	permissionMode PermissionLogicMode @default(AND)
83	level Int?
84	createdAt DateTime @default(now())
85	updatedAt DateTime @default(now()) @updatedAt
86
87	@@map("snippets")
88	}
89
90	model ChannelLock {
91	id Int @id @default(autoincrement())
92	guild_id String
93	channel_id String
94	permissions Json
95	createdAt DateTime @default(now())
96	updatedAt DateTime @default(now()) @updatedAt
97
98	@@map("channel_locks")
99	}
100
101	model PermissionOverwrite {
102	id Int @id @default(autoincrement())
103	name String?
104	guildId String
105	roles String[] @default([])
106	users String[] @default([])
107	grantedPermissions String[] @default([])
108	createdAt DateTime @default(now())
109	updatedAt DateTime @default(now()) @updatedAt
110
111	@@map("permission_overwrites")
112	}
113
114	model ReactionRole {
115	id Int @id @default(autoincrement())
116	emoji String
117	isBuiltInEmoji Boolean
118	guildId String
119	channelId String
120	messageId String
121	roles String[]
122	requiredRoles String[] @default([])
123	blacklistedUsers String[] @default([])
124	requiredPermissions String[] @default([])
125	level Int?
126	single Boolean @default(false)
127	createdAt DateTime @default(now())
128	updatedAt DateTime @default(now()) @updatedAt
129
130	@@map("reaction_roles")
131	}
132
133	model User {
134	id Int @id @default(autoincrement())
135	name String?
136	username String
137	discordId String
138	guilds String[] @default([])
139	password String
140	token String?
141	recoveryToken String?
142	recoveryCode String?
143	recoveryAttempts Int @default(0)
144	recoveryTokenExpiresAt DateTime?
145	createdAt DateTime @default(now())
146	tokenExpiresAt DateTime?
147	updatedAt DateTime @default(now()) @updatedAt
148
149	@@map("users")
150	}
151
152	model BoostRoleEntries {
153	id Int @id @default(autoincrement())
154	role_id String
155	user_id String
156	guild_id String
157	createdAt DateTime @default(now())
158
159	@@map("boost_role_entries")
160	}
161
162	model AfkEntry {
163	id Int @id @default(autoincrement())
164	reason String?
165	userId String
166	guildId String
167	mentions String[] @default([])
168	global Boolean @default(false)
169	createdAt DateTime @default(now())
170	updatedAt DateTime @default(now()) @updatedAt
171
172	@@map("afk_entries")
173	}
174
175	enum PermissionLogicMode {
176	OR
177	AND
178	}
179
180	// TODO: Add 'requiredPermissionOverwrites' field, type: @relation with PermissionOverwrite[]
181
182	model CommandPermissionOverwrite {
183	id Int @id @default(autoincrement())
184	guildId String
185	commands String[]
186	requiredPermissions String[] @default([])
187	requiredPermissionMode PermissionLogicMode @default(AND)
188	mode PermissionLogicMode @default(AND)
189	requiredRoles String[] @default([])
190	requiredUsers String[] @default([])
191	requiredChannels String[] @default([])
192	requiredLevel Int?
193	createdAt DateTime @default(now())
194	updatedAt DateTime @default(now()) @updatedAt
195
196	@@map("command_permission_overwrites")
197	}
198
199	model Ballot {
200	id Int @id @default(autoincrement())
201	guildId String
202	channelId String
203	messageId String
204	userId String
205	content String
206	anonymous Boolean @default(false)
207	files String[] @default([])
208	upvotes String[] @default([])
209	downvotes String[] @default([])
210	createdAt DateTime @default(now())
211	updatedAt DateTime @default(now()) @updatedAt
212
213	@@map("ballots")
214	}
215
216	model PermissionLevel {
217	id Int @id @default(autoincrement())
218	guildId String
219	level Int
220	disabled Boolean @default(false)
221	grantedPermissions String[] @default([])
222	roles String[] @default([])
223	users String[] @default([])
224	createdAt DateTime @default(now())
225	updatedAt DateTime @default(now()) @updatedAt
226
227	@@map("permission_levels")
228	}
229
230	model Review {
231	id Int @id @default(autoincrement())
232	reviewer String?
233	content String
234	rating Int
235	discordId String?
236	email String?
237	aboutReviewer String?
238	approved Boolean @default(false)
239	ip String?
240	createdAt DateTime @default(now())
241	updatedAt DateTime @default(now()) @updatedAt
242
243	@@map("reviews")
244	}
245
246	model VerificationEntry {
247	id Int @id @default(autoincrement())
248	userId String
249	token String @unique
250	guildId String
251	attempts Int @default(0)
252	meta Json?
253	createdAt DateTime @default(now())
254	updatedAt DateTime @default(now()) @updatedAt
255
256	@@map("verification_entries")
257	}
258
259	model GlobalUserBan {
260	id Int @id @default(autoincrement())
261	userId String @unique
262	reason String?
263	executorId String
264	notified Boolean @default(false)
265	createdAt DateTime @default(now())
266	updatedAt DateTime @default(now()) @updatedAt
267
268	@@map("global_user_bans")
269	}
270
271	model UserStatistics {
272	id Int @id @default(autoincrement())
273	userId String
274	guildId String
275	messagesSent Int @default(0)
276	messagesEdited Int @default(0)
277	messagesDeleted Int @default(0)
278	createdAt DateTime @default(now())
279	updatedAt DateTime @default(now()) @updatedAt
280
281	@@map("user_statistics")
282	}