Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save conschneider/18ffe31665bdc9e6cb29b849143426e3 to your computer and use it in GitHub Desktop.
Save conschneider/18ffe31665bdc9e6cb29b849143426e3 to your computer and use it in GitHub Desktop.
This SQL command creates the Action Action Scheduler 3 tables for WooCommerce 4 manually.
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for wp_actionscheduler_actions
-- INFO: This uses the prefix wp_ - change accordingly.
-- ----------------------------
DROP TABLE IF EXISTS `wp_actionscheduler_actions`;
CREATE TABLE `wp_actionscheduler_actions` (
`action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
`scheduled_date_gmt` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
`scheduled_date_local` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
`args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
`schedule` longtext COLLATE utf8mb4_unicode_520_ci,
`group_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`attempts` int(11) NOT NULL DEFAULT '0',
`last_attempt_gmt` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
`last_attempt_local` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
`claim_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
PRIMARY KEY (`action_id`),
KEY `hook` (`hook`),
KEY `status` (`status`),
KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
KEY `args` (`args`),
KEY `group_id` (`group_id`),
KEY `last_attempt_gmt` (`last_attempt_gmt`),
KEY `claim_id` (`claim_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11778 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- ----------------------------
-- Table structure for wp_actionscheduler_claims
-- INFO: This uses the prefix wp_ - change accordingly.
-- ----------------------------
DROP TABLE IF EXISTS `wp_actionscheduler_claims`;
CREATE TABLE `wp_actionscheduler_claims` (
`claim_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`date_created_gmt` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
PRIMARY KEY (`claim_id`),
KEY `date_created_gmt` (`date_created_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- ----------------------------
-- Table structure for wp_actionscheduler_groups
-- INFO: This uses the prefix wp_ - change accordingly.
-- ----------------------------
DROP TABLE IF EXISTS `wp_actionscheduler_groups`;
CREATE TABLE `wp_actionscheduler_groups` (
`group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
PRIMARY KEY (`group_id`),
KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- ----------------------------
-- Table structure for wp_actionscheduler_logs
-- INFO: This uses the prefix wp_ - change accordingly.
-- ----------------------------
DROP TABLE IF EXISTS `wp_actionscheduler_logs`;
CREATE TABLE `wp_actionscheduler_logs` (
`log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`action_id` bigint(20) unsigned NOT NULL,
`message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
`log_date_gmt` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
`log_date_local` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
PRIMARY KEY (`log_id`),
KEY `action_id` (`action_id`),
KEY `log_date_gmt` (`log_date_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=10558 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
SET FOREIGN_KEY_CHECKS = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment