/[volute]/trunk/projects/theory/snapdm/build/dropDDL.jdbc
ViewVC logotype

Diff of /trunk/projects/theory/snapdm/build/dropDDL.jdbc

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 464 by bourges.laurent, Sun May 11 19:29:40 2008 UTC revision 465 by bourges.laurent, Mon May 12 16:19:59 2008 UTC
# Line 14  Line 14 
14  ALTER TABLE t_ClusterFinder DROP CONSTRAINT FK_t_ClusterFinder_id  ALTER TABLE t_ClusterFinder DROP CONSTRAINT FK_t_ClusterFinder_id
15  ALTER TABLE t_PostProcessing DROP CONSTRAINT FK_t_PostProcessing_primaryExperimentId  ALTER TABLE t_PostProcessing DROP CONSTRAINT FK_t_PostProcessing_primaryExperimentId
16  ALTER TABLE t_PostProcessing DROP CONSTRAINT FK_t_PostProcessing_id  ALTER TABLE t_PostProcessing DROP CONSTRAINT FK_t_PostProcessing_id
17    ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_containerId
18    ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_snapshotId
19  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_physicsId  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_physicsId
20  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_containerId  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_containerId
21  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_propertyId  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_propertyId
22  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_containerId  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_containerId
 ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_containerId  
 ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_snapshotId  
23  ALTER TABLE t_TargetObjectType DROP CONSTRAINT FK_t_TargetObjectType_containerId  ALTER TABLE t_TargetObjectType DROP CONSTRAINT FK_t_TargetObjectType_containerId
24  ALTER TABLE t_TargetObjectType DROP CONSTRAINT FK_t_TargetObjectType_id  ALTER TABLE t_TargetObjectType DROP CONSTRAINT FK_t_TargetObjectType_id
25  ALTER TABLE t_ParameterSetting DROP CONSTRAINT FK_t_ParameterSetting_inputParameterId  ALTER TABLE t_ParameterSetting DROP CONSTRAINT FK_t_ParameterSetting_inputParameterId
26  ALTER TABLE t_ParameterSetting DROP CONSTRAINT FK_t_ParameterSetting_containerId  ALTER TABLE t_ParameterSetting DROP CONSTRAINT FK_t_ParameterSetting_containerId
27  ALTER TABLE t_InputParameter DROP CONSTRAINT FK_t_InputParameter_containerId  ALTER TABLE t_InputParameter DROP CONSTRAINT FK_t_InputParameter_containerId
 ALTER TABLE t_CompositeProtocol DROP CONSTRAINT FK_t_CompositeProtocol_id  
28  ALTER TABLE t_ClusterDetection DROP CONSTRAINT FK_t_ClusterDetection_id  ALTER TABLE t_ClusterDetection DROP CONSTRAINT FK_t_ClusterDetection_id
29    ALTER TABLE t_CompositeProtocol DROP CONSTRAINT FK_t_CompositeProtocol_id
30  ALTER TABLE t_ExperimentRepresentationObject DROP CONSTRAINT FK_t_ExperimentRepresentationObject_typeId  ALTER TABLE t_ExperimentRepresentationObject DROP CONSTRAINT FK_t_ExperimentRepresentationObject_typeId
31  ALTER TABLE t_ExperimentRepresentationObject DROP CONSTRAINT FK_t_ExperimentRepresentationObject_containerId  ALTER TABLE t_ExperimentRepresentationObject DROP CONSTRAINT FK_t_ExperimentRepresentationObject_containerId
32  ALTER TABLE t_ProjectExperiment DROP CONSTRAINT FK_t_ProjectExperiment_experimentId  ALTER TABLE t_ProjectExperiment DROP CONSTRAINT FK_t_ProjectExperiment_experimentId
33  ALTER TABLE t_ProjectExperiment DROP CONSTRAINT FK_t_ProjectExperiment_containerId  ALTER TABLE t_ProjectExperiment DROP CONSTRAINT FK_t_ProjectExperiment_containerId
34  ALTER TABLE t_TargetProcess DROP CONSTRAINT FK_t_TargetProcess_id  ALTER TABLE t_TargetProcess DROP CONSTRAINT FK_t_TargetProcess_id
35  ALTER TABLE t_TargetProcess DROP CONSTRAINT FK_t_TargetProcess_containerId  ALTER TABLE t_TargetProcess DROP CONSTRAINT FK_t_TargetProcess_containerId
 ALTER TABLE t_Project DROP CONSTRAINT FK_t_Project_id  
36  ALTER TABLE t_Characterisation DROP CONSTRAINT FK_t_Characterisation_axisId  ALTER TABLE t_Characterisation DROP CONSTRAINT FK_t_Characterisation_axisId
37  ALTER TABLE t_Characterisation DROP CONSTRAINT FK_t_Characterisation_containerId  ALTER TABLE t_Characterisation DROP CONSTRAINT FK_t_Characterisation_containerId
38    ALTER TABLE t_Project DROP CONSTRAINT FK_t_Project_id
39  ALTER TABLE t_Physics DROP CONSTRAINT FK_t_Physics_containerId  ALTER TABLE t_Physics DROP CONSTRAINT FK_t_Physics_containerId
40  ALTER TABLE t_NumericParameterSetting DROP CONSTRAINT FK_t_NumericParameterSetting_id  ALTER TABLE t_NumericParameterSetting DROP CONSTRAINT FK_t_NumericParameterSetting_id
41  ALTER TABLE t_SubvolumeExtractor DROP CONSTRAINT FK_t_SubvolumeExtractor_id  ALTER TABLE t_SubvolumeExtractor DROP CONSTRAINT FK_t_SubvolumeExtractor_id
# Line 71  Line 71 
71  DROP TABLE t_GenericParameterSetting  DROP TABLE t_GenericParameterSetting
72  DROP TABLE t_ClusterFinder  DROP TABLE t_ClusterFinder
73  DROP TABLE t_PostProcessing  DROP TABLE t_PostProcessing
74    DROP TABLE t_InputDataset
75  DROP TABLE t_AppliedPhysics  DROP TABLE t_AppliedPhysics
76  DROP TABLE t_PropertyGroupMember  DROP TABLE t_PropertyGroupMember
 DROP TABLE t_InputDataset  
77  DROP TABLE t_TargetObjectType  DROP TABLE t_TargetObjectType
78  DROP TABLE t_ParameterSetting  DROP TABLE t_ParameterSetting
79  DROP TABLE t_InputParameter  DROP TABLE t_InputParameter
 DROP TABLE t_CompositeProtocol  
80  DROP TABLE t_ClusterDetection  DROP TABLE t_ClusterDetection
81    DROP TABLE t_CompositeProtocol
82  DROP TABLE t_ExperimentRepresentationObject  DROP TABLE t_ExperimentRepresentationObject
83  DROP TABLE t_ProjectExperiment  DROP TABLE t_ProjectExperiment
84  DROP TABLE t_TargetProcess  DROP TABLE t_TargetProcess
 DROP TABLE t_Project  
85  DROP TABLE t_Characterisation  DROP TABLE t_Characterisation
86    DROP TABLE t_Project
87  DROP TABLE t_Physics  DROP TABLE t_Physics
88  DROP TABLE t_NumericParameterSetting  DROP TABLE t_NumericParameterSetting
89  DROP TABLE t_SubvolumeExtractor  DROP TABLE t_SubvolumeExtractor

Legend:
Removed from v.464  
changed lines
  Added in v.465

msdemlei@ari.uni-heidelberg.de
ViewVC Help
Powered by ViewVC 1.1.26