wp_ec_schedule
StaticStores ec schedule data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑schedule_id | int(11) | NO |
| schedule_label | varchar(255) | YES |
| day_of_week | varchar(20) | NO |
| is_holiday | tinyint(1) | NO |
| holiday_date | date | YES |
| apply_to_retail | tinyint(1) | NO |
| apply_to_preorder | tinyint(1) | NO |
| apply_to_restaurant | tinyint(1) | NO |
| retail_start | varchar(32) | NO |
| retail_end | varchar(32) | NO |
| preorder_start | varchar(32) | NO |
| preorder_end | varchar(32) | NO |
| preorder_open_time | varchar(32) | NO |
| preorder_close_time | varchar(32) | NO |
| restaurant_start | varchar(32) | NO |
| restaurant_end | varchar(32) | NO |
| retail_closed | tinyint(1) | NO |
| preorder_closed | tinyint(1) | NO |
| restaurant_closed | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE ec_schedule ( schedule_id int(11) NOT NULL AUTO_INCREMENT, schedule_label varchar(255) DEFAULT '', day_of_week varchar(20) NOT NULL DEFAULT '', is_holiday tinyint(1) NOT NULL DEFAULT 1, holiday_date date DEFAULT NULL, apply_to_retail tinyint(1) NOT NULL DEFAULT 0, apply_to_preorder tinyint(1) NOT NULL DEFAULT 0, apply_to_restaurant tinyint(1) NOT NULL DEFAULT 0, retail_start varchar(32) NOT NULL DEFAULT '', retail_end varchar(32) NOT NULL DEFAULT '', preorder_start varchar(32) NOT NULL DEFAULT '', preorder_end varchar(32) NOT NULL DEFAULT '', preorder_open_time varchar(32) NOT NULL DEFAULT '', preorder_close_time varchar(32) NOT NULL DEFAULT '', restaurant_start varchar(32) NOT NULL DEFAULT '', restaurant_end varchar(32) NOT NULL DEFAULT '', retail_closed tinyint(1) NOT NULL DEFAULT 0, preorder_closed tinyint(1) NOT NULL DEFAULT 0, restaurant_closed tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (schedule_id), UNIQUE KEY schedule_id (schedule_id) ) $collate;" );
Safe to delete?
If you have uninstalled Shopping Cart & eCommerce Store, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_ec_schedule`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Shopping Cart & eCommerce Store