the Script (lineage.pgsql) in zip Download is like about:
CREATE TABLE term_lineage (
tid integer NOT NULL default '0',
lineage varchar(255) NOT NULL default ''
depth integer varchar(255) NOT NULL default ''
);
CREATE INDEX term_lineage_tid_idx ON term_lineage(tid);
CREATE INDEX term_lineage_lineage_idx ON term_lineage(lineage);
1) The field depth is Integer
2) The character "," is missing in line 3
This script will working correctly:
CREATE TABLE term_lineage (
tid integer NOT NULL default '0',
lineage varchar(255) NOT NULL default '',
depth integer NOT NULL default '0'
);
CREATE INDEX term_lineage_tid_idx ON term_lineage(tid);
CREATE INDEX term_lineage_lineage_idx ON term_lineage(lineage);
Comments
Comment #1
merlinofchaos commentedI appear to have fixed this a month ago and just forgot to close the issue.
Comment #2
(not verified) commented