Version 3 by Connie Logg
on Sep 01, 2006 11:52.

<< Changes from 2 to 3
compared with
Current by Connie Logg
on Sep 06, 2006 14:09.

 
Key
These lines were removed. This word was removed.
These lines were added. This word was added.

View page history


There are 2 changes. View first change.

 The [GROUPS|http://www.slac.stanford.edu/comp/net/iepm-bw.slac.stanford.edu/table-structure.html#GROUPS] and [NODEGROUP|http://www.slac.stanford.edu/comp/net/iepm-bw.slac.stanford.edu/table-structure.html#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&nbsp;with write privileges into the database.&nbsp;
  
 For example the following SQL statement will enter a group in the GROUPS table, and automatically assign it a 'groupid' (say 1):
 {code}
 insert into GROUPS (groupname,comment) values ('ULTRALIGHT', 'Ultralight Nodes');
  insert into GROUPS (groupname,comment,active) values ('ULTRALIGHT', 'Ultralight Nodes',1);
 {code}
 The following command will enter a nodeid and its groupid into the NODEGROUP table:
 {code}
 insert into NODEGROUP (groupid, nodeid) values (1, 10);
 {code}
 Node that the 'nodeid' is the&nbsp;'nodeid' field&nbsp;in the [NODES |http://www.slac.stanford.edu/comp/net/iepm-bw.slac.stanford.edu/table-structure.html#NODES]table.
  Node that the 'nodeid' is the&nbsp;'nodeid' field&nbsp;in the [NODES |http://www.slac.stanford.edu/comp/net/iepm-bw.slac.stanford.edu/table-structure.html#NODES]table and 'groupid' is the groupid field in the [GROUPS|http://www.slac.stanford.edu/comp/net/iepm-bw.slac.stanford.edu/table-structure.html#GROUPS] table.