WC_CUSTOMER_LOOKUP table structure is buggy?

Hi there, I recently did a database cleanup because i was having a lot of bugs on my site regarding new content and SQL insert. I came to a conclusion that my database was corrupted, during the cleanup i stumbled upon a TABLE:

CREATE TABLE {$wpdb->prefix}wc_customer_lookup (
	customer_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
	user_id BIGINT UNSIGNED DEFAULT NULL,
	username varchar(60) DEFAULT '' NOT NULL,
	first_name varchar(255) NOT NULL,
	last_name varchar(255) NOT NULL,
	email varchar(100) NULL default NULL,
	date_last_active timestamp NULL default null,
	date_registered timestamp NULL default null,
	country char(2) DEFAULT '' NOT NULL,
	postcode varchar(20) DEFAULT '' NOT NULL,
	city varchar(100) DEFAULT '' NOT NULL,
	state varchar(100) DEFAULT '' NOT NULL,
	PRIMARY KEY (customer_id),
	UNIQUE KEY user_id (user_id),
	KEY email (email)
	)

What is the purpose of this table, the collision after the database cleanup still exists because of sql error #1062 - Duplicate entry '2' for key 'user_id'

user_id is marked as UNIQUE in this table is this the desired behavior with this table, what is the purpose of this table, and how did the duplicates got created in the first place?

• This topic was modified 4 years, 6 months ago by Marius.