Postgresql definitions
Shiny - March 31, 2006 - 11:28
| Project: | Taxonomy assoc |
| Version: | 4.6.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Jump to:
Description
The following has been tested in postgresql 7.4 and 8.0
CREATE TABLE taxonomy_assoc (
txnid SERIAL,
nid integer NOT NULL default 0,
tid integer NOT NULL default 0,
PRIMARY KEY (txnid)
);
CREATE INDEX txn_nid on taxonomy_assoc (nid);
CREATE INDEX txn_tid on taxonomy_assoc (tid);
#1