wp_comic_collection

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_comic_collection ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, title varchar(255) NOT NULL, story_title varchar(255) DEFAULT '', subtitle varchar(255) DEFAULT '', issue_number varchar(50) DEFAULT '', issue_ext varchar(10) DEFAULT '', edition varchar(200) DEFAULT '', printing smallint unsigned DEFAULT 1, publisher varchar(100) DEFAULT '', imprint varchar(100) DEFAULT '', series varchar(200) DEFAULT '', series_group varchar(100) DEFAULT '', volume varchar(50) DEFAULT '', year smallint DEFAULT NULL, cover_date varchar(50) DEFAULT '', release_date date DEFAULT NULL, format varchar(50) DEFAULT 'Comic', age_category varchar(20) DEFAULT '', country varchar(50) DEFAULT '', language varchar(50) DEFAULT '', page_count smallint DEFAULT NULL, condition_grade varchar(50) DEFAULT '', condition_score decimal(3,1) DEFAULT NULL, is_slabbed tinyint(1) DEFAULT 0, slab_company varchar(20) DEFAULT '', slab_grade decimal(3,1) DEFAULT NULL, cert_number varchar(50) DEFAULT '', grader_notes text, purchase_price decimal(10,2) DEFAULT NULL, cover_price decimal(10,2) DEFAULT NULL, estimated_value decimal(10,2) DEFAULT NULL, price_floor decimal(10,2) DEFAULT NULL, plot text, notes text, genres varchar(255) DEFAULT '', story_arc varchar(200) DEFAULT '', crossover varchar(200) DEFAULT '', key_issue varchar(20) DEFAULT '', key_reason text, key_categories varchar(255) DEFAULT '', signees varchar(255) DEFAULT '', location varchar(100) DEFAULT '', store varchar(100) DEFAULT '', is_read tinyint(1) DEFAULT 0, my_rating tinyint DEFAULT 0, quantity smallint DEFAULT 1, barcode varchar(50) DEFAULT '', image_id bigint(20) unsigned DEFAULT NULL, cover_url text, comic_vine_id varchar(50) DEFAULT '', clz_id varchar(50) DEFAULT '', clz_hash varchar(100) DEFAULT '', purchase_date date DEFAULT NULL, status varchar(20) DEFAULT 'collection', wc_product_id bigint(20) unsigned DEFAULT NULL, listed_price decimal(10,2) DEFAULT NULL, listed_at datetime DEFAULT NULL, price_updated_at datetime DEFAULT NULL, price_source varchar(50) DEFAULT '', price_confidence varchar(10) DEFAULT 'normal', price_sample smallint unsigned DEFAULT NULL, pricecharting_id int unsigned DEFAULT NULL, price_locked tinyint(1) DEFAULT 0, cgc_census_total int unsigned DEFAULT NULL, cgc_census_grade_count int unsigned DEFAULT NULL, allow_offers tinyint(1) DEFAULT 0, is_variant tinyint(1) DEFAULT 0, variant_description varchar(255) DEFAULT '', cover_artist varchar(255) DEFAULT '', parent_id bigint(20) DEFAULT NULL, variant_type varchar(100) DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_status (status), KEY idx_publisher (publisher), KEY idx_barcode (barcode), KEY idx_wc_product (wc_product_id), KEY idx_clz_id (clz_id), KEY idx_clz_hash (clz_hash), KEY idx_parent_id (parent_id) ) $charset; CREATE TABLE wp_comic_sold ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, comic_id bigint(20) unsigned DEFAULT NULL, title varchar(255) NOT NULL, story_title varchar(255) DEFAULT '', issue_number varchar(50) DEFAULT '', edition varchar(200) DEFAULT '', is_variant tinyint(1) DEFAULT 0, variant_description varchar(255) DEFAULT '', cover_artist varchar(255) DEFAULT '', publisher varchar(100) DEFAULT '', series varchar(200) DEFAULT '', volume varchar(50) DEFAULT '', year smallint DEFAULT NULL, condition_grade varchar(50) DEFAULT '', condition_score decimal(3,1) DEFAULT NULL, is_slabbed tinyint(1) DEFAULT 0, slab_company varchar(20) DEFAULT '', slab_grade decimal(3,1) DEFAULT NULL, cert_number varchar(50) DEFAULT '', key_issue varchar(20) DEFAULT '', key_reason text, purchase_price decimal(10,2) DEFAULT NULL, cover_price decimal(10,2) DEFAULT NULL, sale_price decimal(10,2) DEFAULT NULL, profit decimal(10,2) DEFAULT NULL, wc_order_id bigint(20) unsigned DEFAULT NULL, image_id bigint(20) unsigned DEFAULT NULL, notes text, clz_hash varchar(100) DEFAULT '', sold_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id) ) $charset; CREATE TABLE wp_comic_price_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, comic_id bigint(20) unsigned NOT NULL, source varchar(50) DEFAULT 'ebay', price decimal(10,2) DEFAULT NULL, condition_text varchar(100) DEFAULT '', fetched_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_comic (comic_id) ) $charset; CREATE TABLE wp_comic_offers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, comic_id bigint(20) unsigned NOT NULL, comic_title varchar(255) NOT NULL DEFAULT '', offer_name varchar(200) NOT NULL, offer_email varchar(200) NOT NULL, offer_amount decimal(10,2) NOT NULL, offer_message text, status varchar(20) DEFAULT 'pending', admin_notes text, ip_address varchar(45) DEFAULT '', email_sent tinyint(1) DEFAULT 0, offer_token varchar(64) DEFAULT '', parent_id bigint(20) unsigned DEFAULT 0, counter_amount decimal(10,2) DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_comic (comic_id), KEY idx_status (status), KEY idx_token (offer_token), KEY idx_parent (parent_id) ) $charset; CREATE TABLE wp_comic_custom_field_values ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, comic_id bigint(20) unsigned NOT NULL, field_id varchar(100) NOT NULL, field_value text DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY comic_field (comic_id, field_id), KEY idx_comic_id (comic_id) ) $charset; CREATE TABLE wp_comic_annotations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, comic_id bigint(20) unsigned NOT NULL, author_name varchar(100) NOT NULL, author_email varchar(200) NOT NULL, annotation_text text NOT NULL, annotation_type enum('first_appearance','key_story','creator_note','variant_note','historical','other') DEFAULT 'other', status enum('pending','approved','rejected') DEFAULT 'pending', submitted_at datetime DEFAULT CURRENT_TIMESTAMP, approved_at datetime DEFAULT NULL, approved_by bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (id), KEY comic_id (comic_id), KEY status (status), KEY submitted_at (submitted_at) ) $charset; CREATE TABLE wp_comic_pull_series ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, title varchar(255) NOT NULL, publisher varchar(100) DEFAULT '', cv_volume_id bigint(20) unsigned DEFAULT NULL, cv_volume_url varchar(500) DEFAULT '', cover_image_url varchar(500) DEFAULT '', start_year smallint DEFAULT NULL, is_active tinyint(1) DEFAULT 1, last_cv_check datetime DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_user_active (user_id, is_active), KEY idx_cv_volume (cv_volume_id), UNIQUE KEY uniq_user_volume (user_id, cv_volume_id) ) $charset; CREATE TABLE wp_comic_pull_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, series_id bigint(20) unsigned DEFAULT NULL, list_id bigint(20) unsigned DEFAULT NULL, title varchar(255) NOT NULL, issue_number varchar(50) DEFAULT '', publisher varchar(100) DEFAULT '', variant_description varchar(255) DEFAULT '', cv_issue_id bigint(20) unsigned DEFAULT NULL, cv_issue_url varchar(500) DEFAULT '', cover_image_url varchar(500) DEFAULT '', cover_date varchar(50) DEFAULT '', release_date date DEFAULT NULL, status enum('upcoming','pulled','skipped','missed') DEFAULT 'upcoming', comic_id bigint(20) unsigned DEFAULT NULL, notes text, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_user (user_id), KEY idx_user_status (user_id, status), KEY idx_series (series_id), KEY idx_list (list_id), KEY idx_release_date (release_date), KEY idx_cv_issue (cv_issue_id), KEY idx_comic (comic_id), UNIQUE KEY uniq_user_cv_issue (user_id, cv_issue_id) ) $charset; "; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_comic_collection`;

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

Other tables from Comic Collector