{"slug":"3dprint-lite","name":"3DPrint Lite","description":"A plugin for selling 3D printing services.","author":"fuzzoid","active_installs":700,"version":"2.1.3.9","wp_org_url":"https://wordpress.org/plugins/3dprint-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"p3dlite_coatings","full_table_name":"wp_p3dlite_coatings","description":"Stores p3dlite coatings data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_p3dlite_coatings` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `status` tinyint(1) NOT NULL DEFAULT '1',\\n  `name` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `description` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `photo` varchar(2048) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `price` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'cm2',\\n  `price1` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type1` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'cm2',\\n  `min_price` float DEFAULT '0',\\n  `color` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `shininess` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'plastic',\\n  `glow` tinyint(1) NOT NULL DEFAULT '0',\\n  `transparency` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'opaque',\\n  `materials` varchar(8192) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `sort_order` smallint NOT NULL DEFAULT '0',\\n  `group_name` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"p3dlite_discount","full_table_name":"wp_p3dlite_discount","description":"Stores p3dlite discount data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"p3dlite_infills","full_table_name":"wp_p3dlite_infills","description":"Stores p3dlite infills data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_p3dlite_infills` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `status` tinyint(1) NOT NULL DEFAULT '1',\\n  `name` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `description` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `photo` varchar(2048) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `infill` float NOT NULL DEFAULT '100',\\n  `price` varchar(256) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pct',\\n  `price1` varchar(256) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type1` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pct',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"p3dlite_materials","full_table_name":"wp_p3dlite_materials","description":"Stores p3dlite materials data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_p3dlite_materials` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `status` tinyint(1) NOT NULL DEFAULT '1',\\n  `name` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `description` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `photo` varchar(2048) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `type` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'filament',\\n  `length` smallint NOT NULL DEFAULT '0',\\n  `density` float NOT NULL DEFAULT '0',\\n  `diameter` float NOT NULL DEFAULT '0',\\n  `weight` float NOT NULL DEFAULT '0',\\n  `price` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'cm3',\\n  `price1` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type1` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'cm3',\\n  `price2` varchar(128) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',\\n  `price_type2` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'cm3',\\n  `roll_price` float NOT NULL DEFAULT '0',\\n  `color` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `shininess` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'plastic',\\n  `transparency` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'opaque',\\n  `glow` tinyint(1) NOT NULL DEFAULT '0',\\n  `sort_order` smallint NOT NULL DEFAULT '0',\\n  `group_name` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"p3dlite_price_requests","full_table_name":"wp_p3dlite_price_requests","description":"Stores p3dlite price requests data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"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"},{"table_name":"p3dlite_printers","full_table_name":"wp_p3dlite_printers","description":"Stores p3dlite printers data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_p3dlite_printers` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `status` tinyint(1) DEFAULT '1',\\n  `name` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `description` text COLLATE utf8mb4_unicode_520_ci,\\n  `photo` varchar(2048) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `type` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT 'fff',\\n  `full_color` tinyint(1) DEFAULT '0',\\n  `platform_shape` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT 'rectangle',\\n  `width` smallint DEFAULT '400',\\n  `length` smallint DEFAULT '300',\\n  `height` smallint DEFAULT '300',\\n  `diameter` smallint DEFAULT '0',\\n  `min_side` float DEFAULT '1',\\n  `infills` varchar(256) COLLATE utf8mb4_unicode_520_ci DEFAULT '0,10,20,30,40,50,60,70,80,90,100',\\n  `default_infill` varchar(8) COLLATE utf8mb4_unicode_520_ci DEFAULT '20',\\n  `materials` varchar(8192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `price` varchar(128) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `price_type` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT 'box_volume',\\n  `price1` varchar(128) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `price_type1` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT 'box_volume',\\n  `price2` varchar(128) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `price_type2` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT 'box_volume',\\n  `price3` varchar(128) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `price_type3` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT 'box_volume',\\n  `price4` varchar(128) COLLATE utf8mb4_unicode_520_ci DEFAULT '0',\\n  `price_type4` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT 'box_volume',\\n  `sort_order` smallint DEFAULT '0',\\n  `group_name` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":6}