00-oracle-clear-schema-SYGAL.sql 20.9 KB
Newer Older
Bertrand Gauthier's avatar
Bertrand Gauthier committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
DROP TRIGGER /*SYGAL.*/INDIVIDU_RECH_UPDATE;
DROP VIEW /*SYGAL.*/SRC_ACTEUR;
DROP VIEW /*SYGAL.*/SRC_DOCTORANT;
DROP VIEW /*SYGAL.*/SRC_ECOLE_DOCT;
DROP VIEW /*SYGAL.*/SRC_ETABLISSEMENT;
DROP VIEW /*SYGAL.*/SRC_FINANCEMENT;
DROP VIEW /*SYGAL.*/SRC_INDIVIDU;
DROP VIEW /*SYGAL.*/SRC_ROLE;
DROP VIEW /*SYGAL.*/SRC_STRUCTURE;
DROP VIEW /*SYGAL.*/SRC_THESE;
DROP VIEW /*SYGAL.*/SRC_THESE_ANNEE_UNIV;
DROP VIEW /*SYGAL.*/SRC_TITRE_ACCES;
DROP VIEW /*SYGAL.*/SRC_UNITE_RECH;
DROP VIEW /*SYGAL.*/SRC_VARIABLE;
DROP VIEW /*SYGAL.*/V_DIFF_ACTEUR;
DROP VIEW /*SYGAL.*/V_DIFF_DOCTORANT;
DROP VIEW /*SYGAL.*/V_DIFF_ECOLE_DOCT;
DROP VIEW /*SYGAL.*/V_DIFF_ETABLISSEMENT;
DROP VIEW /*SYGAL.*/V_DIFF_FINANCEMENT;
DROP VIEW /*SYGAL.*/V_DIFF_INDIVIDU;
DROP VIEW /*SYGAL.*/V_DIFF_ROLE;
DROP VIEW /*SYGAL.*/V_DIFF_STRUCTURE;
DROP VIEW /*SYGAL.*/V_DIFF_THESE;
DROP VIEW /*SYGAL.*/V_DIFF_THESE_ANNEE_UNIV;
DROP VIEW /*SYGAL.*/V_DIFF_TITRE_ACCES;
DROP VIEW /*SYGAL.*/V_DIFF_UNITE_RECH;
DROP VIEW /*SYGAL.*/V_DIFF_VARIABLE;
DROP VIEW /*SYGAL.*/V_IMPORT_TAB_COLS;
DROP VIEW /*SYGAL.*/V_INDIVIDU_ROLE;
DROP VIEW /*SYGAL.*/V_SITU_ARCHIVAB_VA;
DROP VIEW /*SYGAL.*/V_SITU_ARCHIVAB_VAC;
DROP VIEW /*SYGAL.*/V_SITU_ARCHIVAB_VO;
DROP VIEW /*SYGAL.*/V_SITU_ARCHIVAB_VOC;
DROP VIEW /*SYGAL.*/V_SITU_ATTESTATIONS;
DROP VIEW /*SYGAL.*/V_SITU_ATTESTATIONS_VOC;
DROP VIEW /*SYGAL.*/V_SITU_AUTORIS_DIFF_THESE;
DROP VIEW /*SYGAL.*/V_SITU_AUTORIS_DIFF_THESE_VOC;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_PV_SOUT;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_RAPPORT_SOUT;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_VA;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_VAC;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_VC_VALID_DIR;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_VC_VALID_DOCT;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_VO;
DROP VIEW /*SYGAL.*/V_SITU_DEPOT_VOC;
DROP VIEW /*SYGAL.*/V_SITU_RDV_BU_SAISIE_BU;
DROP VIEW /*SYGAL.*/V_SITU_RDV_BU_SAISIE_DOCT;
DROP VIEW /*SYGAL.*/V_SITU_RDV_BU_VALIDATION_BU;
DROP VIEW /*SYGAL.*/V_SITU_SIGNALEMENT_THESE;
DROP VIEW /*SYGAL.*/V_SITU_VALIDATION_PAGE_COUV;
DROP VIEW /*SYGAL.*/V_SITU_VERIF_VA;
DROP VIEW /*SYGAL.*/V_SITU_VERIF_VAC;
DROP VIEW /*SYGAL.*/V_SITU_VERSION_PAPIER_CORRIGEE;
DROP VIEW /*SYGAL.*/V_THESE_ANNEE_UNIV_FIRST;
DROP VIEW /*SYGAL.*/V_TMP_ANOMALIE;
DROP VIEW /*SYGAL.*/V_WF_ETAPE_PERTIN;
DROP VIEW /*SYGAL.*/V_WORKFLOW;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_61;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_1;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_2;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_3;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_4;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_5;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_6;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_7;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_81;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_62;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_21;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_RECHERCHE_THESE;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_101_bis;
DROP MATERIALIZED VIEW /*SYGAL.*/MV_INDICATEUR_101;
DROP FUNCTION /*SYGAL.*/INDIVIDU_HAYSTACK;
DROP FUNCTION /*SYGAL.*/GEN_TABLE_INSERTS;
DROP PACKAGE /*SYGAL.*/UNICAEN_ORACLE;
DROP PACKAGE /*SYGAL.*/UNICAEN_IMPORT;
DROP PACKAGE /*SYGAL.*/APP_WORKFLOW;
DROP PACKAGE /*SYGAL.*/APP_IMPORT;
DROP SEQUENCE /*SYGAL.*/ACTEUR_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/API_LOG_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/ATTESTATION_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/DIFFUSION_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/DOCTORANT_COMPL_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/DOCTORANT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/DOMAINE_SCIENTIFIQUE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/ECOLE_DOCT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/ETABLISSEMENT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/ETABLISSEMENT_RATTACH_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/FAQ_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/FINANCEMENT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/IMPORT_NOTIF_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/IMPORT_OBSERV_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/IMPORT_OBSERV_RESULT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/INDICATEUR_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/INDIVIDU_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/INDIVIDU_ROLE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/INFORMATION_FICHIER_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/INFORMATION_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/MAIL_CONFIRMATION_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/METADONNEE_THESE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/NOTIF_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/NOTIF_RESULT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/ORIGINE_FINANCEMENT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/PRIVILEGE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/PROFIL_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/RDV_BU_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/ROLE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/STRUCTURE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/STRUCTURE_SUBSTIT_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/SYNCHRO_LOG_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/SYNC_LOG_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/THESE_ANNEE_UNIV_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/THESE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/TITRE_ACCES_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/UNITE_RECH_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/UTILISATEUR_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/VALIDATION_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/VALIDITE_FICHIER_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/VARIABLE_ID_SEQ;
DROP SEQUENCE /*SYGAL.*/WF_ETAPE_ID_SEQ;
ALTER TABLE /*SYGAL.*/STRUCTURE drop CONSTRAINT STRUCTURE_SOURCE_FK;
ALTER TABLE /*SYGAL.*/STRUCTURE drop CONSTRAINT STRUCTURE_HMFK;
ALTER TABLE /*SYGAL.*/STRUCTURE drop CONSTRAINT STRUCTURE_HDFK;
ALTER TABLE /*SYGAL.*/STRUCTURE drop CONSTRAINT STRUCTURE_HCFK;
ALTER TABLE /*SYGAL.*/PROFIL_TO_ROLE drop CONSTRAINT PROFIL_TO_ROLE_ROLE_ID_FK;
ALTER TABLE /*SYGAL.*/PROFIL_TO_ROLE drop CONSTRAINT PROFIL_TO_ROLE_PROFIL_ID_FK;
ALTER TABLE /*SYGAL.*/INFORMATION drop CONSTRAINT INFORMATION_HDFK;
ALTER TABLE /*SYGAL.*/INFORMATION drop CONSTRAINT INFORMATION_HMFK;
ALTER TABLE /*SYGAL.*/INFORMATION drop CONSTRAINT INFORMATION_HCFK;
ALTER TABLE /*SYGAL.*/THESE_ANNEE_UNIV drop CONSTRAINT THESE_ANNEE_UNIV_HD_FK;
ALTER TABLE /*SYGAL.*/THESE_ANNEE_UNIV drop CONSTRAINT THESE_ANNEE_UNIV_HM_FK;
ALTER TABLE /*SYGAL.*/THESE_ANNEE_UNIV drop CONSTRAINT THESE_ANNEE_UNIV_HC_FK;
ALTER TABLE /*SYGAL.*/THESE_ANNEE_UNIV drop CONSTRAINT THESE_ANNEE_UNIV_THESE_ID_FK;
ALTER TABLE /*SYGAL.*/THESE_ANNEE_UNIV drop CONSTRAINT THESE_ANNEE_UNIV_SOURCE_FK;
ALTER TABLE /*SYGAL.*/PROFIL_PRIVILEGE drop CONSTRAINT PROFIL_PRIVILEGE_PROFIL_ID_FK;
ALTER TABLE /*SYGAL.*/SOURCE drop CONSTRAINT SOURCE_ETABLISSEMENT_ID_FK;
ALTER TABLE /*SYGAL.*/FINANCEMENT drop CONSTRAINT FINANCEMENT_HDFK;
ALTER TABLE /*SYGAL.*/FINANCEMENT drop CONSTRAINT FINANCEMENT_HMFK;
ALTER TABLE /*SYGAL.*/FINANCEMENT drop CONSTRAINT FINANCEMENT_HCFK;
ALTER TABLE /*SYGAL.*/FINANCEMENT drop CONSTRAINT FINANCEMENT_SOURCE_FK;
ALTER TABLE /*SYGAL.*/ORIGINE_FINANCEMENT drop CONSTRAINT ORIGINE_FINANCEMENT_HDFK;
ALTER TABLE /*SYGAL.*/ORIGINE_FINANCEMENT drop CONSTRAINT ORIGINE_FINANCEMENT_HMFK;
ALTER TABLE /*SYGAL.*/ORIGINE_FINANCEMENT drop CONSTRAINT ORIGINE_FINANCEMENT_HCFK;
ALTER TABLE /*SYGAL.*/ORIGINE_FINANCEMENT drop CONSTRAINT ORIGINE_FINANCEMENT_SOURCE_FK;
ALTER TABLE /*SYGAL.*/TITRE_ACCES drop CONSTRAINT TITRE_ACCES_HD_FK;
ALTER TABLE /*SYGAL.*/TITRE_ACCES drop CONSTRAINT TITRE_ACCES_HM_FK;
ALTER TABLE /*SYGAL.*/TITRE_ACCES drop CONSTRAINT TITRE_ACCES_HC_FK;
ALTER TABLE /*SYGAL.*/TITRE_ACCES drop CONSTRAINT TITRE_ACCES_THESE_ID_FK;
ALTER TABLE /*SYGAL.*/TITRE_ACCES drop CONSTRAINT TITRE_ACCES_SOURCE_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_ETAB_ID_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_UNITE_RECH_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_ECOLE_DOCT_FK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT_RATTACH drop CONSTRAINT RATTACHEMENT_ETAB_ID;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT_RATTACH drop CONSTRAINT RATTACHEMENT_UNITE_ID;
ALTER TABLE /*SYGAL.*/STRUCTURE_SUBSTIT drop CONSTRAINT STR_SUBSTIT_DESTRUCTEUR_FK;
ALTER TABLE /*SYGAL.*/STRUCTURE_SUBSTIT drop CONSTRAINT STR_SUBSTIT_MODIFICATEUR_FK;
ALTER TABLE /*SYGAL.*/STRUCTURE_SUBSTIT drop CONSTRAINT STR_SUBSTIT_CREATEUR_FK;
ALTER TABLE /*SYGAL.*/STRUCTURE_SUBSTIT drop CONSTRAINT STR_SUBSTIT_STR_TO_FK;
ALTER TABLE /*SYGAL.*/STRUCTURE_SUBSTIT drop CONSTRAINT STR_SUBSTIT_STR_FROM_FK;
ALTER TABLE /*SYGAL.*/MAIL_CONFIRMATION drop CONSTRAINT MAILCONFIRMATION_INDIVIDUID_FK;
ALTER TABLE /*SYGAL.*/PROFIL drop CONSTRAINT ROLEMODELE_STRUCTURETYPE_FK;
ALTER TABLE /*SYGAL.*/PROFIL_PRIVILEGE drop CONSTRAINT ROLE_PRIV_MOD_PRIV_ID_FK;
ALTER TABLE /*SYGAL.*/ROLE_PRIVILEGE drop CONSTRAINT ROLE_PRIVILEGE_PRIV_ID_FK;
ALTER TABLE /*SYGAL.*/ROLE_PRIVILEGE drop CONSTRAINT ROLE_PRIVILEGE_ROLE_ID_FK;
ALTER TABLE /*SYGAL.*/INDIVIDU_ROLE drop CONSTRAINT INDIVIDU_ROLE_ROLE_ID_FK;
ALTER TABLE /*SYGAL.*/INDIVIDU_ROLE drop CONSTRAINT INDIVIDU_ROLE_IND_ID_FK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_TYPE_STRUCT_ID_FK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_STRUCTURE_ID_FK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_HD_FK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_HM_FK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_HC_FK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_SOURCE_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_HD_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_HM_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_HC_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_SOURCE_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_THESE_FK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_INDIV_FK;
ALTER TABLE /*SYGAL.*/RDV_BU drop CONSTRAINT RDV_BU_HD_FK;
ALTER TABLE /*SYGAL.*/RDV_BU drop CONSTRAINT RDV_BU_HM_FK;
ALTER TABLE /*SYGAL.*/RDV_BU drop CONSTRAINT RDV_BU_HC_FK;
ALTER TABLE /*SYGAL.*/RDV_BU drop CONSTRAINT RDV_BU_FK;
ALTER TABLE /*SYGAL.*/VALIDITE_FICHIER drop CONSTRAINT VALIDITE_FICHIER_HDFK;
ALTER TABLE /*SYGAL.*/VALIDITE_FICHIER drop CONSTRAINT VALIDITE_FICHIER_HMFK;
ALTER TABLE /*SYGAL.*/VALIDITE_FICHIER drop CONSTRAINT VALIDITE_FICHIER_HCFK;
ALTER TABLE /*SYGAL.*/VALIDITE_FICHIER drop CONSTRAINT CONFORMITE_FICHIER_FFK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_HDFK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_HMFK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_HCFK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_INDIVIDU_ID_FK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_THESE_FK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_TYPE_VALIDATION_FK;
ALTER TABLE /*SYGAL.*/UNITE_RECH drop CONSTRAINT UNITE_RECH_STRUCT_FK;
ALTER TABLE /*SYGAL.*/UNITE_RECH drop CONSTRAINT UNITE_RECH_COMPL_HDFK;
ALTER TABLE /*SYGAL.*/UNITE_RECH drop CONSTRAINT UNITE_RECH_COMPL_HMFK;
ALTER TABLE /*SYGAL.*/UNITE_RECH drop CONSTRAINT UNITE_RECH_COMPL_HCFK;
ALTER TABLE /*SYGAL.*/UNITE_RECH drop CONSTRAINT UNITE_RECH_SOURCE_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT_COMPL drop CONSTRAINT THESARD_COMPL_HDFK;
ALTER TABLE /*SYGAL.*/DOCTORANT_COMPL drop CONSTRAINT THESARD_COMPL_HMFK;
ALTER TABLE /*SYGAL.*/DOCTORANT_COMPL drop CONSTRAINT THESARD_COMPL_HCFK;
ALTER TABLE /*SYGAL.*/DOCTORANT_COMPL drop CONSTRAINT DOCTORANT_COMPL_DOCTORANT_FK;
ALTER TABLE /*SYGAL.*/ECOLE_DOCT drop CONSTRAINT ECOLE_DOCT_STRUCT_FK;
ALTER TABLE /*SYGAL.*/ECOLE_DOCT drop CONSTRAINT ECOLE_DOCT_SOURCE_FK;
ALTER TABLE /*SYGAL.*/ECOLE_DOCT drop CONSTRAINT ECOLE_DOCT_HDFK;
ALTER TABLE /*SYGAL.*/ECOLE_DOCT drop CONSTRAINT ECOLE_DOCT_HMFK;
ALTER TABLE /*SYGAL.*/ECOLE_DOCT drop CONSTRAINT ECOLE_DOCT_HCFK;
ALTER TABLE /*SYGAL.*/DIFFUSION drop CONSTRAINT DIFFUSION_HD_FK;
ALTER TABLE /*SYGAL.*/DIFFUSION drop CONSTRAINT DIFFUSION_HM_FK;
ALTER TABLE /*SYGAL.*/DIFFUSION drop CONSTRAINT DIFFUSION_HC_FK;
ALTER TABLE /*SYGAL.*/DIFFUSION drop CONSTRAINT MISE_EN_LIGNE_THESE_FK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_NATURE_FICHIER_ID_FK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_HDFK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_HMFK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_HCFK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_VERSION_FK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_THESE_FK;
ALTER TABLE /*SYGAL.*/ATTESTATION drop CONSTRAINT ATTESTATION_HD_FK;
ALTER TABLE /*SYGAL.*/ATTESTATION drop CONSTRAINT ATTESTATION_HM_FK;
ALTER TABLE /*SYGAL.*/ATTESTATION drop CONSTRAINT ATTESTATION_HC_FK;
ALTER TABLE /*SYGAL.*/ATTESTATION drop CONSTRAINT ATTESTATION_THESE_FK;
ALTER TABLE /*SYGAL.*/VARIABLE drop CONSTRAINT VARIABLE_HD_FK;
ALTER TABLE /*SYGAL.*/VARIABLE drop CONSTRAINT VARIABLE_HM_FK;
ALTER TABLE /*SYGAL.*/VARIABLE drop CONSTRAINT VARIABLE_HC_FK;
ALTER TABLE /*SYGAL.*/VARIABLE drop CONSTRAINT VARIABLE_SOURCE_FK;
ALTER TABLE /*SYGAL.*/VARIABLE drop CONSTRAINT VARIABLE_ETAB_FK;
ALTER TABLE /*SYGAL.*/METADONNEE_THESE drop CONSTRAINT METADONNEE_THESE_THESE_ID_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_HD_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_HM_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_HC_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_SOURCE_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_DOCTORANT_FK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_ETAB_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_HD_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_HM_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_HC_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_SOURCE_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_INDIV_FK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_ETAB_FK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT drop CONSTRAINT ETABLISSEMENT_SOURCE_FK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT drop CONSTRAINT ETAB_UTIL_DESTRUCTEUR_FK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT drop CONSTRAINT ETAB_UTIL_MODIFICATEUR_FK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT drop CONSTRAINT ETAB_UTIL_CREATEUR_FK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT drop CONSTRAINT ETAB_STRUCT_FK;
ALTER TABLE /*SYGAL.*/STRUCTURE drop CONSTRAINT STRUCTURE_TYPE_STRUCTURE_ID_FK;
ALTER TABLE /*SYGAL.*/IMPORT_OBS_RESULT_NOTIF drop CONSTRAINT IORNR__NR_FK;
ALTER TABLE /*SYGAL.*/IMPORT_OBS_RESULT_NOTIF drop CONSTRAINT IORNR__IOR_FK;
ALTER TABLE /*SYGAL.*/IMPORT_OBS_NOTIF drop CONSTRAINT IOND__N_FK;
ALTER TABLE /*SYGAL.*/IMPORT_OBS_NOTIF drop CONSTRAINT IOND__IO_FK;
ALTER TABLE /*SYGAL.*/IMPORT_OBSERV_RESULT drop CONSTRAINT IMPORT_OBSERV_RESULT__IO_FK;
ALTER TABLE /*SYGAL.*/NOTIF_RESULT drop CONSTRAINT NOTIF_RESULT__NOTIF_FK;
ALTER TABLE /*SYGAL.*/UTILISATEUR drop CONSTRAINT UTILISATEUR_INDIVIDU_FK;
ALTER TABLE /*SYGAL.*/INDIVIDU drop CONSTRAINT INDIVIDU_HD_FK;
ALTER TABLE /*SYGAL.*/INDIVIDU drop CONSTRAINT INDIVIDU_HM_FK;
ALTER TABLE /*SYGAL.*/INDIVIDU drop CONSTRAINT INDIVIDU_HC_FK;
ALTER TABLE /*SYGAL.*/INDIVIDU drop CONSTRAINT INDIVIDU_SOURCE_FK;
ALTER TABLE /*SYGAL.*/PRIVILEGE drop CONSTRAINT SYS_C006123;
ALTER TABLE /*SYGAL.*/PARAMETRE drop CONSTRAINT PARAMETRE_PK;
ALTER TABLE /*SYGAL.*/INFORMATION_FICHIER drop CONSTRAINT INFORMATION_FICHIER_PK;
ALTER TABLE /*SYGAL.*/PROFIL_TO_ROLE drop CONSTRAINT PROFIL_TO_ROLE_PK;
ALTER TABLE /*SYGAL.*/PROFIL_PRIVILEGE drop CONSTRAINT PROFIL_PRIVILEGE_PK;
ALTER TABLE /*SYGAL.*/INFORMATION drop CONSTRAINT INFORMATION_PK;
ALTER TABLE /*SYGAL.*/THESE_ANNEE_UNIV drop CONSTRAINT THESE_ANNEE_UNIV_PK;
ALTER TABLE /*SYGAL.*/SYNCHRO_LOG drop CONSTRAINT SYNCHRO_LOG_PK;
ALTER TABLE /*SYGAL.*/FINANCEMENT drop CONSTRAINT SYS_C0012288;
ALTER TABLE /*SYGAL.*/ORIGINE_FINANCEMENT drop CONSTRAINT SYS_C0012274;
ALTER TABLE /*SYGAL.*/TITRE_ACCES drop CONSTRAINT TITRE_ACCES_PK;
ALTER TABLE /*SYGAL.*/MV_INDICATEUR_1 drop CONSTRAINT THESE_PK1;
ALTER TABLE /*SYGAL.*/INDICATEUR drop CONSTRAINT SYS_C009540;
ALTER TABLE /*SYGAL.*/UNITE_DOMAINE_LINKER drop CONSTRAINT SYS_C0010859;
ALTER TABLE /*SYGAL.*/DOMAINE_SCIENTIFIQUE drop CONSTRAINT SYS_C006550;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT_RATTACH drop CONSTRAINT SYS_C006545;
ALTER TABLE /*SYGAL.*/STRUCTURE_SUBSTIT drop CONSTRAINT STR_SUBSTIT_PK;
ALTER TABLE /*SYGAL.*/MAIL_CONFIRMATION drop CONSTRAINT SYS_C006512;
ALTER TABLE /*SYGAL.*/INDIVIDU_RECH drop CONSTRAINT INDIVIDU_RECH_PK;
ALTER TABLE /*SYGAL.*/PROFIL drop CONSTRAINT SYS_C006505;
ALTER TABLE /*SYGAL.*/ROLE_PRIVILEGE drop CONSTRAINT ROLE_PRIVILEGE_PK;
ALTER TABLE /*SYGAL.*/INDIVIDU_ROLE drop CONSTRAINT INDIVIDU_ROLE_PK;
ALTER TABLE /*SYGAL.*/ROLE drop CONSTRAINT ROLE_PK;
ALTER TABLE /*SYGAL.*/ACTEUR drop CONSTRAINT ACTEUR_PK;
ALTER TABLE /*SYGAL.*/RDV_BU drop CONSTRAINT RDV_BU_PK;
ALTER TABLE /*SYGAL.*/VALIDITE_FICHIER drop CONSTRAINT CONFORMITE_FICHIER_PK;
ALTER TABLE /*SYGAL.*/VALIDATION drop CONSTRAINT VALIDATION_PK;
ALTER TABLE /*SYGAL.*/UNITE_RECH drop CONSTRAINT UNITE_RECH_PK;
ALTER TABLE /*SYGAL.*/DOCTORANT_COMPL drop CONSTRAINT THESARD_COMPL_PK;
ALTER TABLE /*SYGAL.*/ECOLE_DOCT drop CONSTRAINT ECOLE_DOCT_PK;
ALTER TABLE /*SYGAL.*/DIFFUSION drop CONSTRAINT MISE_EN_LIGNE_PK;
ALTER TABLE /*SYGAL.*/FICHIER drop CONSTRAINT FICHIER_PK;
ALTER TABLE /*SYGAL.*/ATTESTATION drop CONSTRAINT ATTESTATION_PK;
ALTER TABLE /*SYGAL.*/VARIABLE drop CONSTRAINT VARIABLE_PK;
ALTER TABLE /*SYGAL.*/METADONNEE_THESE drop CONSTRAINT METADONNEE_THESE_PK;
ALTER TABLE /*SYGAL.*/THESE drop CONSTRAINT THESE_PK;
ALTER TABLE /*SYGAL.*/DOCTORANT drop CONSTRAINT DOCTORANT_PK;
ALTER TABLE /*SYGAL.*/ETABLISSEMENT drop CONSTRAINT ETAB_PK;
ALTER TABLE /*SYGAL.*/STRUCTURE drop CONSTRAINT STRUCTURE_PK;
ALTER TABLE /*SYGAL.*/TYPE_STRUCTURE drop CONSTRAINT TYPE_STRUCTURE_PK;
ALTER TABLE /*SYGAL.*/IMPORT_NOTIF drop CONSTRAINT IMPORT_NOTIF_PK;
ALTER TABLE /*SYGAL.*/SYNC_LOG drop CONSTRAINT SYNC_LOG_PK;
ALTER TABLE /*SYGAL.*/IMPORT_OBS_RESULT_NOTIF drop CONSTRAINT IORNR_PK;
ALTER TABLE /*SYGAL.*/IMPORT_OBS_NOTIF drop CONSTRAINT IOND_PK;
ALTER TABLE /*SYGAL.*/IMPORT_OBSERV_RESULT drop CONSTRAINT IMPORT_OBSERV_RESULT_PK;
ALTER TABLE /*SYGAL.*/IMPORT_OBSERV drop CONSTRAINT IMPORT_OBSERV_PK;
ALTER TABLE /*SYGAL.*/NOTIF_RESULT drop CONSTRAINT NOTIF_RESULT_PK;
ALTER TABLE /*SYGAL.*/NOTIF drop CONSTRAINT NOTIF_PK;
ALTER TABLE /*SYGAL.*/WF_ETAPE drop CONSTRAINT WF_ETAPE_PK;
ALTER TABLE /*SYGAL.*/TYPE_VALIDATION drop CONSTRAINT TYPE_VALIDATION_PK;
ALTER TABLE /*SYGAL.*/INDIVIDU drop CONSTRAINT INDIVIDU_PK;
ALTER TABLE /*SYGAL.*/PRIVILEGE drop CONSTRAINT SYS_C006122;
ALTER TABLE /*SYGAL.*/FAQ drop CONSTRAINT FAQ_PK;
ALTER TABLE /*SYGAL.*/VERSION_FICHIER drop CONSTRAINT VERSION_FICHIER_PK;
ALTER TABLE /*SYGAL.*/NATURE_FICHIER drop CONSTRAINT SYS_C006109;
ALTER TABLE /*SYGAL.*/CATEGORIE_PRIVILEGE drop CONSTRAINT SYS_C006106;
ALTER TABLE /*SYGAL.*/UTILISATEUR drop CONSTRAINT UTILISATEUR_PK;
ALTER TABLE /*SYGAL.*/API_LOG drop CONSTRAINT API_LOG_PK;
ALTER TABLE /*SYGAL.*/SOURCE drop CONSTRAINT SOURCE_PK;
DROP TABLE /*SYGAL.*/TMP_TITRE_ACCES PURGE;
DROP TABLE /*SYGAL.*/INDIVIDU_RECH PURGE;
DROP TABLE /*SYGAL.*/ORIGINE_FINANCEMENT PURGE;
DROP TABLE /*SYGAL.*/DOCTORANT PURGE;
DROP TABLE /*SYGAL.*/NOTIF PURGE;
DROP TABLE /*SYGAL.*/UTILISATEUR PURGE;
DROP TABLE /*SYGAL.*/TYPE_STRUCTURE PURGE;
DROP TABLE /*SYGAL.*/STRUCTURE PURGE;
DROP TABLE /*SYGAL.*/ETABLISSEMENT PURGE;
DROP TABLE /*SYGAL.*/FINANCEMENT PURGE;
DROP TABLE /*SYGAL.*/INDIVIDU PURGE;
DROP TABLE /*SYGAL.*/INFORMATION PURGE;
DROP TABLE /*SYGAL.*/SOURCE PURGE;
DROP TABLE /*SYGAL.*/DOMAINE_SCIENTIFIQUE PURGE;
DROP TABLE /*SYGAL.*/IMPORT_NOTIF PURGE;
DROP TABLE /*SYGAL.*/IMPORT_OBSERV PURGE;
DROP TABLE /*SYGAL.*/IMPORT_OBSERV_RESULT PURGE;
DROP TABLE /*SYGAL.*/NATURE_FICHIER PURGE;
DROP TABLE /*SYGAL.*/VERSION_FICHIER PURGE;
DROP TABLE /*SYGAL.*/FICHIER PURGE;
DROP TABLE /*SYGAL.*/SYNCHRO_LOG PURGE;
DROP TABLE /*SYGAL.*/TMP_THESE_ANNEE_UNIV PURGE;
DROP TABLE /*SYGAL.*/THESE_ANNEE_UNIV PURGE;
DROP TABLE /*SYGAL.*/DOCTORANT_COMPL PURGE;
DROP TABLE /*SYGAL.*/ACTEUR PURGE;
DROP TABLE /*SYGAL.*/TMP_STRUCTURE PURGE;
DROP TABLE /*SYGAL.*/THESE PURGE;
DROP TABLE /*SYGAL.*/METADONNEE_THESE PURGE;
DROP TABLE /*SYGAL.*/RDV_BU PURGE;
DROP TABLE /*SYGAL.*/TYPE_VALIDATION PURGE;
DROP TABLE /*SYGAL.*/WF_ETAPE PURGE;
DROP TABLE /*SYGAL.*/ROLE PURGE;
DROP TABLE /*SYGAL.*/INDIVIDU_ROLE PURGE;
DROP TABLE /*SYGAL.*/VALIDATION PURGE;
DROP TABLE /*SYGAL.*/ATTESTATION PURGE;
DROP TABLE /*SYGAL.*/DIFFUSION PURGE;
DROP TABLE /*SYGAL.*/VALIDITE_FICHIER PURGE;
DROP TABLE /*SYGAL.*/PROFIL PURGE;
DROP TABLE /*SYGAL.*/CATEGORIE_PRIVILEGE PURGE;
DROP TABLE /*SYGAL.*/PRIVILEGE PURGE;
DROP TABLE /*SYGAL.*/PROFIL_PRIVILEGE PURGE;
DROP TABLE /*SYGAL.*/ROLE_PRIVILEGE PURGE;
DROP TABLE /*SYGAL.*/TMP_VARIABLE PURGE;
DROP TABLE /*SYGAL.*/API_LOG PURGE;
DROP TABLE /*SYGAL.*/VARIABLE PURGE;
DROP TABLE /*SYGAL.*/TMP_INDIVIDU PURGE;
DROP TABLE /*SYGAL.*/TMP_DOCTORANT PURGE;
DROP TABLE /*SYGAL.*/TMP_THESE PURGE;
DROP TABLE /*SYGAL.*/TMP_ROLE PURGE;
DROP TABLE /*SYGAL.*/TMP_ACTEUR PURGE;
DROP TABLE /*SYGAL.*/TMP_ETABLISSEMENT PURGE;
DROP TABLE /*SYGAL.*/TMP_ECOLE_DOCT PURGE;
DROP TABLE /*SYGAL.*/ECOLE_DOCT PURGE;
DROP TABLE /*SYGAL.*/TMP_UNITE_RECH PURGE;
DROP TABLE /*SYGAL.*/UNITE_RECH PURGE;
DROP TABLE /*SYGAL.*/UNITE_DOMAINE_LINKER PURGE;
DROP TABLE /*SYGAL.*/TMP_ORIGINE_FINANCEMENT PURGE;
DROP TABLE /*SYGAL.*/TMP_FINANCEMENT PURGE;
DROP TABLE /*SYGAL.*/SYNC_LOG PURGE;
DROP TABLE /*SYGAL.*/MAIL_CONFIRMATION PURGE;
DROP TABLE /*SYGAL.*/INDICATEUR PURGE;
DROP TABLE /*SYGAL.*/TITRE_ACCES PURGE;
DROP TABLE /*SYGAL.*/STRUCTURE_SUBSTIT PURGE;
DROP TABLE /*SYGAL.*/ETABLISSEMENT_RATTACH PURGE;
DROP TABLE /*SYGAL.*/PROFIL_TO_ROLE PURGE;
DROP TABLE /*SYGAL.*/INFORMATION_FICHIER PURGE;
DROP TABLE /*SYGAL.*/PARAMETRE PURGE;
DROP TABLE /*SYGAL.*/IMPORT_OBS_RESULT_NOTIF PURGE;
DROP TABLE /*SYGAL.*/IMPORT_OBS_NOTIF PURGE;
DROP TABLE /*SYGAL.*/NOTIF_RESULT PURGE;
DROP TABLE /*SYGAL.*/FAQ PURGE;