wp_epbk_services

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_epbk_services ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, business_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, category VARCHAR(100) NOT NULL DEFAULT '', subcategory VARCHAR(100) NOT NULL DEFAULT '', name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, price DECIMAL(10,2) NOT NULL DEFAULT 0.00, duration INT(11) NOT NULL DEFAULT 60, metadata LONGTEXT DEFAULT NULL, status VARCHAR(20) NOT NULL DEFAULT 'active', wc_product_id BIGINT(20) UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_business_id (business_id), KEY idx_category (category), KEY idx_status (status) ) {$charset_collate};"; // Bookings table. $sql[] = "CREATE TABLE wp_epbk_bookings ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, service_id BIGINT(20) UNSIGNED NOT NULL, customer_name VARCHAR(255) NOT NULL DEFAULT '', customer_email VARCHAR(255) NOT NULL DEFAULT '', customer_phone VARCHAR(50) NOT NULL DEFAULT '', booking_date DATE NOT NULL, booking_time TIME NOT NULL, end_time TIME DEFAULT NULL, party_size INT(11) NOT NULL DEFAULT 1, status VARCHAR(20) NOT NULL DEFAULT 'pending', payment_status VARCHAR(20) NOT NULL DEFAULT 'unpaid', payment_method VARCHAR(50) NOT NULL DEFAULT '', payment_id VARCHAR(255) DEFAULT NULL, amount DECIMAL(10,2) NOT NULL DEFAULT 0.00, notes TEXT DEFAULT NULL, wc_order_id BIGINT(20) UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_service_id (service_id), KEY idx_booking_date (booking_date), KEY idx_status (status), KEY idx_payment_status (payment_status), KEY idx_customer_email (customer_email) ) {$charset_collate};"; // Availability table. $sql[] = "CREATE TABLE wp_epbk_availability ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, service_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, day_of_week TINYINT(1) DEFAULT NULL, start_time TIME NOT NULL, end_time TIME NOT NULL, is_blocked TINYINT(1) NOT NULL DEFAULT 0, specific_date DATE DEFAULT NULL, buffer_minutes INT(11) NOT NULL DEFAULT 0, max_bookings INT(11) NOT NULL DEFAULT 1, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_service_id (service_id), KEY idx_day_of_week (day_of_week), KEY idx_specific_date (specific_date) ) {$charset_collate};"; // Service categories table. $sql[] = "CREATE TABLE wp_epbk_service_categories ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, business_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', slug VARCHAR(255) NOT NULL DEFAULT '', sort_order INT(11) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_business_id (business_id), UNIQUE KEY idx_slug (slug) ) {$charset_collate};"; // Service-to-category relationships table. $sql[] = "CREATE TABLE wp_epbk_service_category_relationships ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, service_id BIGINT(20) UNSIGNED NOT NULL, category_id BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (id), UNIQUE KEY idx_service_category (service_id, category_id), KEY idx_category_id (category_id) ) {$charset_collate};"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($sql as $query) { dbDelta($query);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_epbk_services`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from EasyPeasy Booking