wp_fct_orders
LiveStores order records and related transaction data.
CREATE TABLE Statement
CREATE TABLE `wp_fct_orders` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'draft' COMMENT 'draft / pending / on-hold / processing / completed / failed / refunded / partial-refund',\n `parent_id` bigint unsigned DEFAULT NULL,\n `receipt_number` bigint unsigned DEFAULT NULL,\n `invoice_no` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\n `fulfillment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'physical',\n `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'payment',\n `mode` enum('live','test') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'live' COMMENT 'live / test',\n `shipping_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'unshipped / shipped / delivered / unshippable',\n `customer_id` bigint unsigned DEFAULT NULL,\n `payment_method` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `payment_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n `payment_method_title` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `subtotal` bigint NOT NULL DEFAULT '0',\n `discount_tax` bigint NOT NULL DEFAULT '0',\n `manual_discount_total` bigint NOT NULL DEFAULT '0',\n `coupon_discount_total` bigint NOT NULL DEFAULT '0',\n `shipping_tax` bigint NOT NULL DEFAULT '0',\n `shipping_total` bigint NOT NULL DEFAULT '0',\n `tax_total` bigint NOT NULL DEFAULT '0',\n `total_amount` bigint NOT NULL DEFAULT '0',\n `total_paid` bigint NOT NULL DEFAULT '0',\n `total_refund` bigint NOT NULL DEFAULT '0',\n `rate` decimal(12,4) NOT NULL DEFAULT '1.0000',\n `tax_behavior` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 => no_tax, 1 => exclusive, 2 => inclusive',\n `note` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `ip_address` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `completed_at` datetime DEFAULT NULL,\n `refunded_at` datetime DEFAULT NULL,\n `uuid` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `config` json DEFAULT NULL,\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `wp_fct_ord__invoice_no` (`invoice_no`(191)),\n KEY `wp_fct_ord__status_type` (`type`),\n KEY `wp_fct_ord__customer_id` (`customer_id`),\n KEY `wp_fct_ord__date_created_completed` (`created_at`,`completed_at`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ciSafe to delete?
If you have uninstalled FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler, 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_fct_orders`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler