MatrixTreeEncoding/sql/01_create_table.sql at master · agustinuslaw/MatrixTreeEncoding · GitHub

14 lines (11 loc) · 403 Bytes

create table HazelTree (	/* Note we need length 140 name for the worst case number 2^27   */	name nvarchar(150) primary key,-- name containing the path 	parent nvarchar(150), -- for traditional recursive search comparison 	number int not null, -- node element		/* matrix tree encoding */    e11 bigint not null,    e21 bigint not null,    e12 bigint not null,    e22 bigint not null,    );