Yes, apologies, there was a comma missing in there. Please try:
CREATE TABLE wp_wallets_adds (
id int(10) UNSIGNED NOT NULL,
blog_id bigint(20) NOT NULL DEFAULT '1' COMMENT 'blog_id for multisite installs',
account bigint(20) UNSIGNED NOT NULL COMMENT 'wp_users.ID',
symbol varchar(5) COLLATE latin1_bin NOT NULL COMMENT 'coin symbol (e.g. BTC for Bitcoin)',
address varchar(255) COLLATE latin1_bin NOT NULL,
extra varchar(255) COLLATE latin1_bin NOT NULL DEFAULT '' COMMENT 'extra info required by some coins such as XMR',
created_time datetime NOT NULL COMMENT 'when address was requested in GMT',
status enum('current','old') NOT NULL DEFAULT 'old' COMMENT 'all addresses are used to perform deposits, but only the current one is displayed'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;Index creation was correct:
ALTER TABLE wp_wallets_adds
ADD PRIMARY KEY (id),
ADD UNIQUE KEY uq_ad_idx (address,symbol,extra),
ADD KEY retrieve_idx (account,symbol),
ADD KEY lookup_idx (address);Do let me know.
regards