Reply To: problem when installing the wallet

[alexg]

Thank you very much. Your version is recent.

Can you try the following and tell me if it works please?

CREATE TABLE wp_wallets_adds (
	id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	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('old','current') NOT NULL COMMENT 'all addresses are used to perform deposits, but only the current one is displayed',
	PRIMARY KEY (id),
	INDEX retrieve_idx (account,symbol),
	INDEX lookup_idx (address),
	UNIQUE KEY 'uq_ad_idx' ('address', 'symbol', 'extra')
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

If this works I will add the fix to the next version of wallets. Some versions of MySQL seems to have a problem with defining default values for enum columns explicitly.

Looking forward to your reply.

regards