You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

The GROUPS and NODEGROUP tables are used to defined pages that specifically combine results for a set of nodes into a results page.

Currently, these must be entered manually into the database by an account with write privileges into the database. 

For example the following SQL statement will enter a group in the GROUPS table, and automatically assign it a 'groupid' (say 1):

insert into GROUPS (groupname,comment) values ('ULTRALIGHT', 'Ultralight Nodes');

The following command will enter a nodeid and its groupid into the NODEGROUP table:

insert into NODEGROUP (groupid, nodeid) values (1, 10);

Node that the 'nodeid' is the 'nodeid' field in the NODES table.

  • No labels