HOME   UP  

picture

CERA SQL: Basic Tools

This directory contains SQL scripts of CERA tools to:
- checkEntities.sql: check data integrity of entities (their primary keys should refer to an ENTRY),
- cleanEntities.sql: re-adjust data integrity of entities (=delete entity where necessary),
- checkHierarchies.sql: check data integrity of hierarchies (TOPIC, LOCATION: valid pointers and levels),
- delEntry.sql: delete an entry from all CERA tables,
- saveCERA.sql: save a backup copy of all CERA tables as SAVE_* .
Jul 06 1999 : checkEntities.sql ( 1920 Bytes )

Jan 29 1999 : checkHierarchies.sql ( 1939 Bytes )

Jan 21 1999 : cleanEntities.sql ( 1344 Bytes )

Jul 21 1999 : delEntry.sql ( 5899 Bytes )

Jul 30 1999 : saveCERA.sql ( 7033 Bytes )

Pages are optimized for NETSCAPE. For comments and suggestions contact CERA Admin.

Last change: Mon Jul 23 15:39:48 NFT 2001