feat: add migration for user related tables

donaldp · donaldp · commit f80d4d90e0ec · 2025-04-17T11:35:56.000+02:00
diff --git a/database/migrations/20250314170132_create_users_table.js b/database/migrations/20250314170132_create_users_table.js
@@ -0,0 +1,44 @@
+const { Database } = require('@formidablejs/framework');
+
+/** @param {Database} DB */
+exports.up = ({ schema }) => {
+	schema.createTable('users', (table) => {
+		table.increments('id').primary();
+		table.string('name');
+		table.string('email').unique();
+		table.timestamp('email_verified_at').nullable();
+		table.string('password');
+		table.rememberToken();
+		table.timestamps(true, true);
+	});
+
+
+	schema.createTable('password_resets', (table) => {
+		table.string('email').primary().unique();
+		table.string('token');
+		table.timestamp('created_at').defaultTo(fn.now());
+	});
+
+	schema.createTable('personal_access_tokens', (table) => {
+		table.increments('id').primary();
+		table.string('tokenable_type');
+		table.bigInteger('tokenable_id').index().unsigned();
+		table.string('name');
+		table.string('abilities').nullable();
+		table.text('payload').nullable();
+		table.bigInteger('ttl').index().unsigned().nullable();
+		table.timestamp('last_used_at').nullable();
+		table.timestamps();
+	});
+
+	return schema;
+}
+
+/** @param {Database} DB */
+exports.down = ({ schema }) => {
+	schema.dropTable('users');
+	schema.dropTable('password_resets');
+	schema.dropTable('personal_access_tokens');
+
+	return schema;
+}
