🗄️What WP Table Is This?
Home / 3DPrint Lite / wp_p3dlite_price_requests

wp_p3dlite_price_requests

Verified

Stores p3dlite price requests data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_p3dlite_price_requests` (\n  `id` mediumint NOT NULL AUTO_INCREMENT,\n  `status` tinyint(1) NOT NULL DEFAULT '0',\n  `product_id` bigint NOT NULL DEFAULT '0',\n  `printer_id` mediumint NOT NULL DEFAULT '0',\n  `material_id` mediumint NOT NULL DEFAULT '0',\n  `coating_id` mediumint NOT NULL DEFAULT '0',\n  `quantity` mediumint NOT NULL DEFAULT '1',\n  `printer` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `material` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `coating` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `infill` float NOT NULL DEFAULT '0',\n  `cutting_instructions` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `model_file` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `original_filename` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `unit` varchar(16) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `scale` float NOT NULL DEFAULT '1',\n  `scale_x` float NOT NULL DEFAULT '1',\n  `scale_y` float NOT NULL DEFAULT '1',\n  `scale_z` float NOT NULL DEFAULT '1',\n  `weight` float NOT NULL DEFAULT '0',\n  `email_address` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `email` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `request_comment` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `admin_comment` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `admin_attachment` varchar(1024) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `admin_attachment_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `admin_delivery` varchar(256) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `buynow_link` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `thumbnail_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `attributes` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `price` float NOT NULL DEFAULT '0',\n  `estimated_price` float NOT NULL DEFAULT '0',\n  `estimated_price_currency` varchar(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n  `request_key` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled 3DPrint Lite, 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_p3dlite_price_requests`;

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

Other tables from 3DPrint Lite