wp_wcfm_fbc_offline_messages

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_daily_analysis` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `is_shop` tinyint(1) NOT NULL default 0, `is_store` tinyint(1) NOT NULL default 0, `is_product` tinyint(1) NOT NULL default 0, `product_id` bigint(20) NOT NULL default 0, `author_id` bigint(20) NOT NULL default 0, `count` bigint(20) NOT NULL default 0, `visited` DATE NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`ID`), CONSTRAINT daily_analysis UNIQUE ( product_id, author_id, visited ) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_detailed_analysis` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `is_shop` tinyint(1) NOT NULL default 0, `is_store` tinyint(1) NOT NULL default 0, `is_product` tinyint(1) NOT NULL default 0, `product_id` bigint(20) NOT NULL default 0, `author_id` bigint(20) NOT NULL default 0, `referer` text NOT NULL, `ip_address` VARCHAR(60) NOT NULL, `country` VARCHAR(30) NOT NULL, `state` VARCHAR(30) NOT NULL, `city` VARCHAR(100) NOT NULL, `visited` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) $collate;"; //$create_tables_query[] = "ALTER TABLE `" . wp_"wcfm_detailed_analysis` ADD `ip_address` VARCHAR(60) AFTER `referer`"; //$create_tables_query[] = "ALTER TABLE `" . wp_"wcfm_detailed_analysis` ADD `country` VARCHAR(30) AFTER `ip_address`"; //$create_tables_query[] = "ALTER TABLE `" . wp_"wcfm_detailed_analysis` ADD `state` VARCHAR(30) AFTER `country`"; //$create_tables_query[] = "ALTER TABLE `" . wp_"wcfm_detailed_analysis` ADD `city` VARCHAR(100) AFTER `state`"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_messages` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `message` longtext NOT NULL, `author_id` bigint(20) NOT NULL default 0, `reply_to` bigint(20) NOT NULL default 0, `message_to` bigint(20) NOT NULL default -1, `author_is_admin` tinyint(1) NOT NULL default 0, `author_is_vendor` tinyint(1) NOT NULL default 0, `author_is_customer` tinyint(1) NOT NULL default 0, `is_notice` tinyint(1) NOT NULL default 0, `is_direct_message` tinyint(1) NOT NULL default 0, `is_pined` tinyint(1) NOT NULL default 0, `message_type` VARCHAR(100) NOT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) $collate;"; //$create_tables_query[] = "ALTER TABLE `" . wp_"wcfm_messages` ADD `message_type` VARCHAR(100) AFTER `is_pined`"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_messages_modifier` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `message` bigint(20) NOT NULL default 0, `is_read` tinyint(1) NOT NULL default 0, `read_by` bigint(20) NOT NULL default 0, `read_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `is_trashed` tinyint(1) NOT NULL default 0, `trashed_by` bigint(20) NOT NULL default 0, `trashed_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_messages_stat` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `message` bigint(20) NOT NULL default 0, `is_liked` tinyint(1) NOT NULL default 0, `liked_by` bigint(20) NOT NULL default 0, `liked_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `is_disliked` tinyint(1) NOT NULL default 0, `disliked_by` bigint(20) NOT NULL default 0, `disliked_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_enquiries` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `enquiry` longtext NOT NULL, `reply` longtext NOT NULL, `product_id` bigint(20) NOT NULL default 0, `author_id` bigint(20) NOT NULL default 0, `vendor_id` bigint(20) NOT NULL default 0, `customer_id` bigint(20) NOT NULL default 0, `customer_name` VARCHAR(200) NOT NULL, `customer_email` VARCHAR(200) NOT NULL, `reply_by` bigint(20) NOT NULL default 0, `is_private` tinyint(1) NOT NULL default 0, `posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `replied` DATE NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_enquiries_meta` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `enquiry_id` bigint(20) NOT NULL default 0, `key` VARCHAR(200) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_enquiries_response` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `enquiry_id` bigint(20) NOT NULL default 0, `product_id` bigint(20) NOT NULL default 0, `vendor_id` bigint(20) NOT NULL default 0, `customer_id` bigint(20) NOT NULL default 0, `customer_name` VARCHAR(200) NOT NULL, `customer_email` VARCHAR(200) NOT NULL, `reply` longtext NOT NULL, `reply_by` bigint(20) NOT NULL default 0, `posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_enquiries_response_meta` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `enquiry_response_id` bigint(20) NOT NULL default 0, `key` VARCHAR(200) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_support` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `order_id` bigint(20) NOT NULL default 0, `item_id` bigint(20) NOT NULL default 0, `product_id` bigint(20) NOT NULL default 0, `author_id` bigint(20) NOT NULL default 0, `vendor_id` bigint(20) NOT NULL default 0, `customer_id` bigint(20) NOT NULL default 0, `customer_name` VARCHAR(200) NOT NULL, `customer_email` VARCHAR(200) NOT NULL, `query` longtext NOT NULL, `category` longtext NOT NULL, `priority` VARCHAR(200) NOT NULL, `status` VARCHAR(200) NOT NULL, `posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_support_meta` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `support_id` bigint(20) NOT NULL default 0, `key` VARCHAR(200) NOT NULL, `value` longtext NOT NULL, `type` VARCHAR(200) NOT NULL, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_support_response` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `support_id` bigint(20) NOT NULL default 0, `order_id` bigint(20) NOT NULL default 0, `item_id` bigint(20) NOT NULL default 0, `product_id` bigint(20) NOT NULL default 0, `vendor_id` bigint(20) NOT NULL default 0, `customer_id` bigint(20) NOT NULL default 0, `reply` longtext NOT NULL, `reply_by` bigint(20) NOT NULL default 0, `posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_support_response_meta` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `support_response_id` bigint(20) NOT NULL default 0, `key` VARCHAR(200) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS `" . wp_"wcfm_following_followers` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL default 0, `user_name` VARCHAR(200) NOT NULL, `user_email` VARCHAR(200) NOT NULL, `follower_id` bigint(20) NOT NULL default 0, `follower_name` VARCHAR(200) NOT NULL, `follower_email` VARCHAR(200) NOT NULL, `notify` tinyint(1) NOT NULL default 1, `posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS wp_wcfm_fbc_offline_messages ( id int NOT NULL AUTO_INCREMENT, user_name longtext NOT NULL, user_email longtext NOT NULL, user_message longtext NOT NULL, user_info longtext NOT NULL, mail_date date NOT NULL DEFAULT '0000-00-00', mail_read boolean NOT NULL DEFAULT false, vendor_id varchar(30) NOT NULL DEFAULT '', PRIMARY KEY (id) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS wp_wcfm_fbc_chat_rows ( message_id varchar(30) NOT NULL DEFAULT '', conversation_id varchar(30) NOT NULL, user_id varchar(30) NOT NULL DEFAULT '', user_name varchar(32) DEFAULT NULL, msg text NOT NULL, msg_time bigint(13) unsigned NOT NULL, UNIQUE KEY message_id (message_id) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS wp_wcfm_fbc_chat_sessions ( conversation_id varchar(30) NOT NULL DEFAULT '', user_id varchar(30) NOT NULL DEFAULT '', evaluation varchar(30) NOT NULL DEFAULT '', created_at bigint(13) unsigned NOT NULL, duration varchar(30) NOT NULL DEFAULT '00:00:00', receive_copy boolean NOT NULL DEFAULT false, UNIQUE KEY conversation_id (conversation_id), KEY created_at (created_at) ) $collate;"; $create_tables_query[] = "CREATE TABLE IF NOT EXISTS wp_wcfm_fbc_chat_visitors ( user_id varchar(30) NOT NULL DEFAULT '', user_type varchar(12) NOT NULL DEFAULT '', user_name varchar(32) DEFAULT NULL, user_ip int(11) unsigned DEFAULT NULL, user_email varchar(90) DEFAULT NULL, last_online bigint(13) unsigned DEFAULT NULL, vendor_id varchar(30) NOT NULL DEFAULT '', UNIQUE KEY user_id (user_id) ) $collate;"; foreach ($create_tables_query as $create_table_query) { $wpdb->query($create_table_query);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_wcfm_fbc_offline_messages`;

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

Other tables from WCFM – Frontend Manager for WooCommerce along with Bookings Subscription Listings Compatible