Error in pgsql Script lineage.pgsql

mslxp - January 9, 2006 - 17:33
Project:Taxonomy Lineage
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed
Description

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);

#1

merlinofchaos - February 12, 2006 - 01:23
Status:active» fixed

I appear to have fixed this a month ago and just forgot to close the issue.

#2

Anonymous - February 26, 2006 - 01:31
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.