/** Datei: plugins/logs/config/schema/v1.0.0.php **/
<?php
	
	return [
		'logs' => [
			'columns' => [
				'id'           => 'INT NOT NULL AUTO_INCREMENT',
				'hashid'       => 'VARCHAR(32) NOT NULL',
				'date_create'  => 'DATETIME NOT NULL',
				'created_by'   => 'VARCHAR(32) NOT NULL',
				'action'       => 'VARCHAR(64) NOT NULL',
				'message'      => 'TEXT NOT NULL',
				'target_id'    => 'VARCHAR(32) DEFAULT NULL',
				'context_data' => 'TEXT DEFAULT NULL',
			],
			'primary' => ['id'],
			'unique' => ['hashid'],
			'indexes' => ['created_by', 'action', 'target_id'],
			'engine' => 'InnoDB',
			'charset' => 'utf8mb3',
		]
	];