/** Datei: plugins/users/migrations/2025_01_07_create_users_table.php **/
<?php
	
	/**
	 * Initial Migration for Users Table
	 *
	 * Creates the `users` table with required columns.
	 *
	 * @author          Sparky
	 * @version         1.0.0
	 */
	
	namespace ARUNOX\Migrations;
	
	use ARUNOX\Core\Database;
	
	class CreateUsersTable
	{
		/**
		 * Apply the migration.
		 */
		public static function up(): void
		{
			$query = "
				CREATE TABLE users (
					id INT AUTO_INCREMENT PRIMARY KEY,
					username VARCHAR(50) NOT NULL UNIQUE,
					email VARCHAR(100) NOT NULL UNIQUE,
					password_hash VARCHAR(255) NOT NULL,
					created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
					updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
				) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
			";
			
			Database::query($query);
		}
		
		/**
		 * Rollback the migration.
		 */
		public static function down(): void
		{
			$query = "DROP TABLE IF EXISTS users;";
			Database::query($query);
		}
	}