CREATE TABLE `hash_chain` (
	`ROWUNQ` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`HASH_SOURCE` VARBINARY(32) NULL DEFAULT '0',
	`HASH_LINKED` VARBINARY(32) NOT NULL DEFAULT '0',
	`HASH_SALTED` VARBINARY(32) NOT NULL DEFAULT '0',
	`HASH_PREVIOUS` VARBINARY(32) NOT NULL DEFAULT '0',
	`HASH_CONFIRMED_BY` VARBINARY(32) NULL DEFAULT 'UNCONFIRMED',
	`BLOCK_NUM` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`BLOCK_PREV` INT(11) NOT NULL DEFAULT '0',
	`BLOCK_NEXT` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`CODEL_TIME` TIMESTAMP NULL DEFAULT NULL,
	`CHAIN_TIME` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	UNIQUE INDEX `HASH_LINKED` (`HASH_LINKED`) USING BTREE,
	UNIQUE INDEX `HASH_SALTED` (`HASH_SALTED`) USING BTREE,
	UNIQUE INDEX `ROWUNQ` (`ROWUNQ`) USING BTREE,
	INDEX `HASH_SOURCE` (`HASH_SOURCE`) USING BTREE,
	INDEX `HASH_CONFIRMED_BY` (`HASH_CONFIRMED_BY`) USING BTREE,
	INDEX `BLOCK_NUM` (`BLOCK_NUM`) USING BTREE
)
COMMENT='CODEL 1.5 '
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
