Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE DATABASE work;
USE work;
CREATE TABLE node
(
`node_hash` BLOB(64) not null,
`ancestor_hash` BLOB(64) not null,
`ancestor_name` VARCHAR(255) not null,
`depth` SMALLINT,
PRIMARY KEY (`node_hash`(64), `ancestor_hash`(64), `ancestor_name`, `depth`)
) CHARACTER SET ='utf8';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.