1 files changed, 39 insertions, 0 deletions
diff --git a/src/lib/models/shared/GuildCount.ts b/src/lib/models/shared/GuildCount.ts
new file mode 100644
index 0000000..51e571a
--- /dev/null
+++ b/src/lib/models/shared/GuildCount.ts
@@ -0,0 +1,39 @@
+import { type Sequelize } from 'sequelize';
+import { Environment } from '../../../../config/Config.js';
+const { DataTypes, Model } = (await import('sequelize')).default;
+
+export interface GuildCountModel {
+	timestamp: Date;
+	environment: Environment;
+	guildCount: number;
+}
+
+export interface GuildCountCreationAttributes {
+	timestamp?: Date;
+	environment: Environment;
+	guildCount: number;
+}
+
+/**
+ * The number of guilds that the bot is in for each environment.
+ */
+export class GuildCount extends Model<GuildCountModel, GuildCountCreationAttributes> implements GuildCountModel {
+	public declare timestamp: Date;
+	public declare environment: Environment;
+	public declare guildCount: number;
+
+	/**
+	 * Initializes the model.
+	 * @param sequelize The sequelize instance.
+	 */
+	public static initModel(sequelize: Sequelize): void {
+		GuildCount.init(
+			{
+				timestamp: { type: DataTypes.DATE, allowNull: false, defaultValue: DataTypes.NOW },
+				environment: { type: DataTypes.STRING, allowNull: false },
+				guildCount: { type: DataTypes.BIGINT, allowNull: false }
+			},
+			{ sequelize, timestamps: false }
+		);
+	}
+}