wp_fct_subscriptions
LiveStores fct subscriptions data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_fct_subscriptions` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `uuid` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `customer_id` bigint unsigned NOT NULL,\n `parent_order_id` bigint unsigned NOT NULL,\n `product_id` bigint unsigned NOT NULL,\n `item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `quantity` int NOT NULL DEFAULT '1',\n `variation_id` bigint unsigned NOT NULL,\n `billing_interval` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `signup_fee` bigint unsigned NOT NULL DEFAULT '0',\n `initial_tax_total` bigint unsigned NOT NULL DEFAULT '0',\n `recurring_amount` bigint unsigned NOT NULL DEFAULT '0',\n `recurring_tax_total` bigint unsigned NOT NULL DEFAULT '0',\n `recurring_total` bigint unsigned NOT NULL DEFAULT '0',\n `bill_times` bigint unsigned NOT NULL DEFAULT '0',\n `bill_count` int unsigned NOT NULL DEFAULT '0',\n `expire_at` datetime DEFAULT NULL,\n `trial_ends_at` datetime DEFAULT NULL,\n `canceled_at` datetime DEFAULT NULL,\n `restored_at` datetime DEFAULT NULL,\n `collection_method` enum('automatic','manual','system') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'automatic',\n `next_billing_date` datetime DEFAULT NULL,\n `trial_days` int unsigned NOT NULL DEFAULT '0',\n `vendor_customer_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `vendor_plan_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `vendor_subscription_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `status` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `original_plan` longtext COLLATE utf8mb4_unicode_520_ci,\n `vendor_response` longtext COLLATE utf8mb4_unicode_520_ci,\n `current_payment_method` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT 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_index__order_subscription_idx` (`parent_order_id`)\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_subscriptions`;
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