ActionScheduler_LoggerSchema.php — WP Mail SMTP by WPForms – The Most Popular SMTP and Email Log Plugin 3.0.3

wp-mail-smtp / vendor / woocommerce / action-scheduler / classes / schema / ActionScheduler_LoggerSchema.php

wp-mail-smtp / vendor / woocommerce / action-scheduler / classes / schema Last commit date

ActionScheduler_LoggerSchema.php

48 lines

1	<?php
2
3	/**
4	* Class ActionScheduler_LoggerSchema
5	*
6	* @codeCoverageIgnore
7	*
8	* Creates a custom table for storing action logs
9	*/
10	class ActionScheduler_LoggerSchema extends ActionScheduler_Abstract_Schema {
11	const LOG_TABLE = 'actionscheduler_logs';
12
13	/**
14	* @var int Increment this value to trigger a schema update.
15	*/
16	protected $schema_version = 2;
17
18	public function __construct() {
19	$this->tables = [
20	self::LOG_TABLE,
21	];
22	}
23
24	protected function get_table_definition( $table ) {
25	global $wpdb;
26	$table_name = $wpdb->$table;
27	$charset_collate = $wpdb->get_charset_collate();
28	switch ( $table ) {
29
30	case self::LOG_TABLE:
31
32	return "CREATE TABLE {$table_name} (
33	log_id bigint(20) unsigned NOT NULL auto_increment,
34	action_id bigint(20) unsigned NOT NULL,
35	message text NOT NULL,
36	log_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
37	log_date_local datetime NOT NULL default '0000-00-00 00:00:00',
38	PRIMARY KEY (log_id),
39	KEY action_id (action_id),
40	KEY log_date_gmt (log_date_gmt)
41	) $charset_collate";
42
43	default:
44	return '';
45	}
46	}
47	}
48