wp_fct_subscriptions

Live

Stores 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_ci

Safe 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