IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Jun 2, 2008, 2:31:57 PM (18 years ago)
Author:
jhoblitt
Message:

conditionally drop so the delete process doesn't halt if one table is missing

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/pxadmin_drop_tables.sql

    r17854 r17880  
    11SET FOREIGN_KEY_CHECKS=0;
    2 DROP TABLE pzDataStore;
    3 DROP TABLE summitExp;
    4 DROP TABLE summitImfile;
    5 DROP TABLE pzDownloadExp;
    6 DROP TABLE pzDownloadImfile;
    7 DROP TABLE newExp;
    8 DROP TABLE newImfile;
    9 DROP TABLE rawExp;
    10 DROP TABLE rawImfile;
    11 DROP TABLE guidePendingExp;
    12 DROP TABLE chipRun;
    13 DROP TABLE chipProcessedImfile;
    14 DROP TABLE chipMask;
    15 DROP TABLE camRun;
    16 DROP TABLE camProcessedExp;
    17 DROP TABLE camMask;
    18 DROP TABLE detRun;
    19 DROP TABLE detInputExp;
    20 DROP TABLE detProcessedImfile;
    21 DROP TABLE detProcessedExp;
    22 DROP TABLE detStackedImfile;
    23 DROP TABLE detNormalizedStatImfile;
    24 DROP TABLE detNormalizedImfile;
    25 DROP TABLE detNormalizedExp;
    26 DROP TABLE detResidImfile;
    27 DROP TABLE detResidExp;
    28 DROP TABLE detRunSummary;
    29 DROP TABLE detRegisteredImfile;
    30 DROP TABLE warpRun;
    31 DROP TABLE warpSkyCellMap;
    32 DROP TABLE warpSkyfile;
    33 DROP TABLE warpMask;
    34 DROP TABLE diffRun;
    35 DROP TABLE diffInputSkyfile;
    36 DROP TABLE diffSkyfile;
    37 DROP TABLE stackRun;
    38 DROP TABLE stackInputSkyfile;
    39 DROP TABLE stackSumSkyfile;
    40 DROP TABLE magicRun;
    41 DROP TABLE magicInputSkyfile;
    42 DROP TABLE magicTree;
    43 DROP TABLE magicNodeResult;
    44 DROP TABLE magicMask;
    45 DROP TABLE magicSkyfileMask;
    46 DROP TABLE calDB;
    47 DROP TABLE calRun;
    48 DROP TABLE flatcorrRun;
    49 DROP TABLE flatcorrExp;
    50 DROP TABLE pstampDataStore;
    51 DROP TABLE pstampRequest;
    52 DROP TABLE pstampJob;
     2DROP TABLE IF EXISTS pzDataStore;
     3DROP TABLE IF EXISTS summitExp;
     4DROP TABLE IF EXISTS summitImfile;
     5DROP TABLE IF EXISTS pzDownloadExp;
     6DROP TABLE IF EXISTS pzDownloadImfile;
     7DROP TABLE IF EXISTS newExp;
     8DROP TABLE IF EXISTS newImfile;
     9DROP TABLE IF EXISTS rawExp;
     10DROP TABLE IF EXISTS rawImfile;
     11DROP TABLE IF EXISTS guidePendingExp;
     12DROP TABLE IF EXISTS chipRun;
     13DROP TABLE IF EXISTS chipProcessedImfile;
     14DROP TABLE IF EXISTS chipMask;
     15DROP TABLE IF EXISTS camRun;
     16DROP TABLE IF EXISTS camProcessedExp;
     17DROP TABLE IF EXISTS camMask;
     18DROP TABLE IF EXISTS detRun;
     19DROP TABLE IF EXISTS detInputExp;
     20DROP TABLE IF EXISTS fakeRun;
     21DROP TABLE IF EXISTS fakeProcessedImfile;
     22DROP TABLE IF EXISTS detProcessedImfile;
     23DROP TABLE IF EXISTS detProcessedExp;
     24DROP TABLE IF EXISTS detStackedImfile;
     25DROP TABLE IF EXISTS detNormalizedStatImfile;
     26DROP TABLE IF EXISTS detNormalizedImfile;
     27DROP TABLE IF EXISTS detNormalizedExp;
     28DROP TABLE IF EXISTS detResidImfile;
     29DROP TABLE IF EXISTS detResidExp;
     30DROP TABLE IF EXISTS detRunSummary;
     31DROP TABLE IF EXISTS detRegisteredImfile;
     32DROP TABLE IF EXISTS warpRun;
     33DROP TABLE IF EXISTS warpSkyCellMap;
     34DROP TABLE IF EXISTS warpSkyfile;
     35DROP TABLE IF EXISTS warpMask;
     36DROP TABLE IF EXISTS diffRun;
     37DROP TABLE IF EXISTS diffInputSkyfile;
     38DROP TABLE IF EXISTS diffSkyfile;
     39DROP TABLE IF EXISTS stackRun;
     40DROP TABLE IF EXISTS stackInputSkyfile;
     41DROP TABLE IF EXISTS stackSumSkyfile;
     42DROP TABLE IF EXISTS magicRun;
     43DROP TABLE IF EXISTS magicInputSkyfile;
     44DROP TABLE IF EXISTS magicTree;
     45DROP TABLE IF EXISTS magicNodeResult;
     46DROP TABLE IF EXISTS magicMask;
     47DROP TABLE IF EXISTS magicSkyfileMask;
     48DROP TABLE IF EXISTS calDB;
     49DROP TABLE IF EXISTS calRun;
     50DROP TABLE IF EXISTS flatcorrRun;
     51DROP TABLE IF EXISTS flatcorrExp;
     52DROP TABLE IF EXISTS pstampDataStore;
     53DROP TABLE IF EXISTS pstampRequest;
     54DROP TABLE IF EXISTS pstampJob;
    5355SET FOREIGN_KEY_CHECKS=1
Note: See TracChangeset for help on using the changeset viewer.