HOME
UP
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),
- nullCheck.sql: check data integrity of all tables (no NULLs are allowed),
- null2default.sql: re-adjust data integrity of all tables (set NULLs to
defaults),
- checkHierarchies.sql: check data integrity of hierarchies (TOPIC,
LOCATION: valid pointers and levels),
- drop*.sql: drop all CERA tables (e.g. after a test installation of the
CERA system),
- getRAW.sql: spool all table contents into an ASCII file for a certain entry,
- getMOST.sql: spool most table contents into an ASCII file for a certain entry,
- delEntry.sql: delete an entry from all CERA tables,
- saveCERA.sql: save a backup copy of all CERA tables as SAV_* .
Sorry - these contents is outdated (i.e., not CERA-2.5)
Go to bottom of document
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 )
Oct 27 1998 : dropALL.sql ( 361 Bytes )
Apr 04 2000 : dropCERA.sql ( 3370 Bytes )
Mar 24 1998 : dropDATA_ACC.sql ( 476 Bytes )
Mar 24 1998 : dropDATA_ORG.sql ( 804 Bytes )
Jul 06 1999 : dropMETADATA_STA.sql ( 90 Bytes )
Jul 06 1999 : dropMODEL_INPUT.sql ( 308 Bytes )
May 29 1998 : getMOST.sql ( 5364 Bytes )
Jul 07 1998 : getRAW.sql ( 5501 Bytes )
Mar 03 1999 : null2default.sql ( 28871 Bytes )
Sep 09 1998 : nullCheck.sql ( 20419 Bytes )
Jul 30 1999 : saveCERA.sql ( 7033 Bytes )
Go to top of document.
Pages are optimized for NETSCAPE.
For comments and suggestions contact
CERA Admin.
Last change: Wed Mar 28 13:55:32 NFT 2001