wp_xfor_orders

Static

Stores order records and related transaction data.

Column Definitions

ColumnTypeNullable
🔑idint(11)NO
roomvarchar(250)YES
start_datedateYES
end_datedateYES
fullnamevarchar(250)YES
emailvarchar(100)YES
telvarchar(16)YES
notyvarchar(255)YES
statusvarchar(50)YES
is_paidtinyint(4)YES
costvarchar(50)YES
guestvarchar(50)YES
JohnDouYES
ilikeYES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_xfor_orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `room` varchar(250) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `fullname` varchar(250) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `tel` varchar(16) DEFAULT NULL, `noty` varchar(255) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `is_paid` tinyint(4) DEFAULT NULL, `cost` varchar(50) DEFAULT NULL, `guest` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "INSERT INTO `wp_xfor_orders` (`room`, `start_date`, `end_date`, `fullname`, `email`, `tel`, `noty`, `status`, `is_paid`, `cost`, `guest`) VALUES ('103', '$start_date', '$end_date', 'John Dou', 'john@mail.com', '99999999', 'i like sleep', 'New', 1, '1000', '1');

Safe to delete?

If you have uninstalled Hotel Booking by Xfor, 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_xfor_orders`;

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

Other tables from Hotel Booking by Xfor