Warning: Array to string conversion in /home/customer/www/docs.automatorplugin.com/public_html/wp-content/themes/wporg-developer/inc/template-tags.php on line 825
Automator_DB::get_schema()
Return create queries for Automator tables
Return Return
(string)
Source Source
File: src/core/class-automator-db.php
public static function get_schema() { global $wpdb; $charset_collate = $wpdb->get_charset_collate(); // Automator Recipe log $tbl_recipe_log = $wpdb->prefix . 'uap_recipe_log'; //Automator trigger log $tbl_trigger_log = $wpdb->prefix . 'uap_trigger_log'; //Automator trigger meta data log $tbl_trigger_log_meta = $wpdb->prefix . 'uap_trigger_log_meta'; // Automator Action log $tbl_action_log = $wpdb->prefix . 'uap_action_log'; //Automator action meta data log $tbl_action_log_meta = $wpdb->prefix . 'uap_action_log_meta'; // Automator Closure Log $tbl_closure_log = $wpdb->prefix . 'uap_closure_log'; //Automator closure meta data log $tbl_closure_log_meta = $wpdb->prefix . 'uap_closure_log_meta'; return "CREATE TABLE {$tbl_recipe_log} ( `ID` bigint unsigned NOT NULL auto_increment, `date_time` datetime DEFAULT CURRENT_TIMESTAMP, `user_id` bigint unsigned NOT NULL, `automator_recipe_id` bigint unsigned NOT NULL, `completed` tinyint(1) NOT NULL, `run_number` mediumint unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`ID`), KEY completed (`completed`), KEY user_id (`user_id`), KEY automator_recipe_id (`automator_recipe_id`) ) ENGINE=InnoDB {$charset_collate}; CREATE TABLE {$tbl_trigger_log} ( `ID` bigint unsigned NOT NULL auto_increment, `date_time` datetime DEFAULT CURRENT_TIMESTAMP, `user_id` bigint unsigned NOT NULL, `automator_trigger_id` bigint unsigned NOT NULL, `automator_recipe_id` bigint unsigned NOT NULL, `automator_recipe_log_id` bigint unsigned NULL, `completed` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`ID`), KEY user_id (`user_id`), KEY completed (`completed`), KEY automator_recipe_id (`automator_recipe_id`), KEY automator_trigger_id (`automator_trigger_id`), KEY automator_recipe_log_id (`automator_recipe_log_id`) ) ENGINE=InnoDB {$charset_collate}; CREATE TABLE {$tbl_trigger_log_meta} ( `ID` bigint unsigned NOT NULL auto_increment, `user_id` bigint unsigned NOT NULL, `automator_trigger_log_id` bigint unsigned NULL, `automator_trigger_id` bigint unsigned NOT NULL, `meta_key` varchar(255) DEFAULT '' NOT NULL, `meta_value` longtext NULL, `run_number` mediumint unsigned NOT NULL DEFAULT 1, `run_time` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`), KEY user_id (`user_id`), KEY run_number (`run_number`), KEY automator_trigger_id (`automator_trigger_id`), KEY automator_trigger_log_id (`automator_trigger_log_id`), KEY meta_key (meta_key(20)) ) ENGINE=InnoDB {$charset_collate}; CREATE TABLE {$tbl_action_log} ( `ID` bigint unsigned NOT NULL auto_increment, `date_time` datetime DEFAULT CURRENT_TIMESTAMP, `user_id` bigint unsigned NOT NULL, `automator_action_id` bigint unsigned NOT NULL, `automator_recipe_id` bigint unsigned NOT NULL, `automator_recipe_log_id` bigint unsigned NULL, `completed` tinyint(1) unsigned NOT NULL, `error_message` longtext NULL, PRIMARY KEY (`ID`), KEY user_id (`user_id`), KEY completed (`completed`), KEY automator_action_id (`automator_action_id`), KEY automator_recipe_log_id (`automator_recipe_log_id`), KEY automator_recipe_id (`automator_recipe_id`) ) ENGINE=InnoDB {$charset_collate}; CREATE TABLE {$tbl_action_log_meta} ( `ID` bigint unsigned NOT NULL auto_increment, `user_id` bigint unsigned NOT NULL, `automator_action_log_id` bigint unsigned NULL, `automator_action_id` bigint unsigned NOT NULL, `meta_key` varchar(255) DEFAULT '' NOT NULL, `meta_value` longtext NULL, PRIMARY KEY (`ID`), KEY user_id (`user_id`), KEY automator_action_log_id (`automator_action_log_id`), KEY automator_action_id (`automator_action_id`), KEY meta_key (meta_key(20)) ) ENGINE=InnoDB {$charset_collate}; CREATE TABLE {$tbl_closure_log} ( `ID` bigint unsigned NOT NULL auto_increment, `date_time` datetime DEFAULT CURRENT_TIMESTAMP, `user_id` bigint unsigned NOT NULL, `automator_closure_id` bigint unsigned NOT NULL, `automator_recipe_id` bigint unsigned NOT NULL, `completed` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`ID`), KEY user_id (`user_id`), KEY automator_recipe_id (`automator_recipe_id`), KEY automator_closure_id (`automator_closure_id`), KEY completed (`completed`) ) ENGINE=InnoDB {$charset_collate}; CREATE TABLE {$tbl_closure_log_meta} ( `ID` bigint unsigned NOT NULL auto_increment, `user_id` bigint unsigned NOT NULL, `automator_closure_id` bigint unsigned NOT NULL, `meta_key` varchar(255) DEFAULT '' NOT NULL, `meta_value` longtext NULL, PRIMARY KEY (`ID`), KEY user_id (`user_id`), KEY automator_closure_id (`automator_closure_id`), KEY meta_key (meta_key(15)) ) ENGINE=InnoDB {$charset_collate};"; }
Expand full source code Collapse full source code View on Github
Changelog Changelog
Version | Description |
---|---|
3.0 | Introduced. |