Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save Edwynn/5d6fd72750163eb240be6fe120a2b913 to your computer and use it in GitHub Desktop.
Save Edwynn/5d6fd72750163eb240be6fe120a2b913 to your computer and use it in GitHub Desktop.
Please note the wp_ prefix and change accordingly if needed! Also check the table names so you don't drop data of tables already there!
/*
* Please note the wp_ prefix and change accordingly if needed!
* Also check the table names so you don't drop data of tables already there!
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for wp_wc_reserved_stock
-- ----------------------------
DROP TABLE IF EXISTS `wp_wc_reserved_stock`;
CREATE TABLE `wp_wc_reserved_stock` (
`order_id` bigint(20) NOT NULL,
`product_id` bigint(20) NOT NULL,
`stock_quantity` double NOT NULL DEFAULT '0',
`timestamp` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
`expires` datetime NOT NULL DEFAULT '0000-01-01 00:00:00',
PRIMARY KEY (`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
-- ----------------------------
-- Records of wp_wc_reserved_stock
-- ----------------------------
BEGIN;
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment