/[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 625 by bourges.laurent, Fri Jun 20 09:58:32 2008 UTC revision 626 by bourges.laurent, Thu Jun 26 10:46:17 2008 UTC
# Line 2  Line 2 
2  ALTER TABLE t_Visualisation DROP CONSTRAINT FK_t_Visualisation_id  ALTER TABLE t_Visualisation DROP CONSTRAINT FK_t_Visualisation_id
3  ALTER TABLE t_Simulator DROP CONSTRAINT FK_t_Simulator_id  ALTER TABLE t_Simulator DROP CONSTRAINT FK_t_Simulator_id
4  ALTER TABLE t_Snapshot DROP CONSTRAINT FK_t_Snapshot_containerId  ALTER TABLE t_Snapshot DROP CONSTRAINT FK_t_Snapshot_containerId
 ALTER TABLE t_ChildObject DROP CONSTRAINT FK_t_ChildObject_containerId  
 ALTER TABLE t_ChildObject DROP CONSTRAINT FK_t_ChildObject_objectId  
 ALTER TABLE t_Protocol DROP CONSTRAINT FK_t_Protocol_id  
5  ALTER TABLE t_RepresentationObjectType DROP CONSTRAINT FK_t_RepresentationObjectType_id  ALTER TABLE t_RepresentationObjectType DROP CONSTRAINT FK_t_RepresentationObjectType_id
6  ALTER TABLE t_RepresentationObjectType DROP CONSTRAINT FK_t_RepresentationObjectType_containerId  ALTER TABLE t_RepresentationObjectType DROP CONSTRAINT FK_t_RepresentationObjectType_containerId
7    ALTER TABLE t_Protocol DROP CONSTRAINT FK_t_Protocol_id
8    ALTER TABLE t_ChildObject DROP CONSTRAINT FK_t_ChildObject_containerId
9    ALTER TABLE t_ChildObject DROP CONSTRAINT FK_t_ChildObject_objectId
10  ALTER TABLE t_ParameterGroup DROP CONSTRAINT FK_t_ParameterGroup_containerId  ALTER TABLE t_ParameterGroup DROP CONSTRAINT FK_t_ParameterGroup_containerId
11  ALTER TABLE t_PropertyGroup DROP CONSTRAINT FK_t_PropertyGroup_containerId  ALTER TABLE t_PropertyGroup DROP CONSTRAINT FK_t_PropertyGroup_containerId
 ALTER TABLE t_GenericParameterSetting DROP CONSTRAINT FK_t_GenericParameterSetting_id  
12  ALTER TABLE t_CompositeExperiment DROP CONSTRAINT FK_t_CompositeExperiment_id  ALTER TABLE t_CompositeExperiment DROP CONSTRAINT FK_t_CompositeExperiment_id
13    ALTER TABLE t_GenericParameterSetting DROP CONSTRAINT FK_t_GenericParameterSetting_id
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
 ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_containerId  
 ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_snapshotId  
17  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_physicsId  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_physicsId
18  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_containerId  ALTER TABLE t_AppliedPhysics DROP CONSTRAINT FK_t_AppliedPhysics_containerId
19  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_propertyId  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_propertyId
20  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_containerId  ALTER TABLE t_PropertyGroupMember DROP CONSTRAINT FK_t_PropertyGroupMember_containerId
21    ALTER TABLE t_InputDataset DROP CONSTRAINT FK_t_InputDataset_containerId
22    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
# Line 48  Line 48 
48  ALTER TABLE t_Experiment DROP CONSTRAINT FK_t_Experiment_protocolId  ALTER TABLE t_Experiment DROP CONSTRAINT FK_t_Experiment_protocolId
49  ALTER TABLE t_ValidValue DROP CONSTRAINT FK_t_ValidValue_containerId  ALTER TABLE t_ValidValue DROP CONSTRAINT FK_t_ValidValue_containerId
50  ALTER TABLE t_WebService DROP CONSTRAINT FK_t_WebService_containerId  ALTER TABLE t_WebService DROP CONSTRAINT FK_t_WebService_containerId
 ALTER TABLE t_ChildExperiment DROP CONSTRAINT FK_t_ChildExperiment_experimentId  
 ALTER TABLE t_ChildExperiment DROP CONSTRAINT FK_t_ChildExperiment_containerId  
51  ALTER TABLE t_Property DROP CONSTRAINT FK_t_Property_containerId  ALTER TABLE t_Property DROP CONSTRAINT FK_t_Property_containerId
52  ALTER TABLE t_Property DROP CONSTRAINT FK_t_Property_id  ALTER TABLE t_Property DROP CONSTRAINT FK_t_Property_id
53    ALTER TABLE t_ChildExperiment DROP CONSTRAINT FK_t_ChildExperiment_experimentId
54    ALTER TABLE t_ChildExperiment DROP CONSTRAINT FK_t_ChildExperiment_containerId
55  ALTER TABLE t_ExperimentProperty DROP CONSTRAINT FK_t_ExperimentProperty_propertyId  ALTER TABLE t_ExperimentProperty DROP CONSTRAINT FK_t_ExperimentProperty_propertyId
56  ALTER TABLE t_ExperimentProperty DROP CONSTRAINT FK_t_ExperimentProperty_containerId  ALTER TABLE t_ExperimentProperty DROP CONSTRAINT FK_t_ExperimentProperty_containerId
57  ALTER TABLE t_ObjectCollection DROP CONSTRAINT FK_t_ObjectCollection_objectTypeId  ALTER TABLE t_ObjectCollection DROP CONSTRAINT FK_t_ObjectCollection_objectTypeId
# Line 66  Line 66 
66  DROP TABLE t_Visualisation  DROP TABLE t_Visualisation
67  DROP TABLE t_Simulator  DROP TABLE t_Simulator
68  DROP TABLE t_Snapshot  DROP TABLE t_Snapshot
 DROP TABLE t_ChildObject  
 DROP TABLE t_Protocol  
69  DROP TABLE t_RepresentationObjectType  DROP TABLE t_RepresentationObjectType
70    DROP TABLE t_Protocol
71    DROP TABLE t_ChildObject
72  DROP TABLE t_ParameterGroup  DROP TABLE t_ParameterGroup
73  DROP TABLE t_PropertyGroup  DROP TABLE t_PropertyGroup
 DROP TABLE t_GenericParameterSetting  
74  DROP TABLE t_CompositeExperiment  DROP TABLE t_CompositeExperiment
75    DROP TABLE t_GenericParameterSetting
76  DROP TABLE t_ClusterFinder  DROP TABLE t_ClusterFinder
77  DROP TABLE t_PostProcessing  DROP TABLE t_PostProcessing
 DROP TABLE t_InputDataset  
78  DROP TABLE t_AppliedPhysics  DROP TABLE t_AppliedPhysics
79  DROP TABLE t_PropertyGroupMember  DROP TABLE t_PropertyGroupMember
80  DROP TABLE t_Party  DROP TABLE t_InputDataset
81  DROP TABLE t_TargetObjectType  DROP TABLE t_TargetObjectType
82    DROP TABLE t_Party
83  DROP TABLE t_ParameterSetting  DROP TABLE t_ParameterSetting
84  DROP TABLE t_InputParameter  DROP TABLE t_InputParameter
85  DROP TABLE t_ClusterDetection  DROP TABLE t_ClusterDetection
# Line 98  Line 98 
98  DROP TABLE t_ValidValue  DROP TABLE t_ValidValue
99  DROP TABLE t_WebService  DROP TABLE t_WebService
100  DROP TABLE t_Field  DROP TABLE t_Field
 DROP TABLE t_ChildExperiment  
101  DROP TABLE t_Property  DROP TABLE t_Property
102    DROP TABLE t_ChildExperiment
103  DROP TABLE t_ExperimentProperty  DROP TABLE t_ExperimentProperty
104  DROP TABLE t_ObjectCollection  DROP TABLE t_ObjectCollection
105  DROP TABLE t_ObjectType  DROP TABLE t_ObjectType

Legend:
Removed from v.625  
changed lines
  Added in v.626

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