From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001
From: Sven Eisenhauer <sven@sven-eisenhauer.net>
Date: Fri, 10 Nov 2023 15:11:48 +0100
Subject: add new repo

---
 Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql | 89 +++++++++++++++++++++++++++
 1 file changed, 89 insertions(+)
 create mode 100644 Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql

(limited to 'Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql')

diff --git a/Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql b/Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql
new file mode 100644
index 0000000..38d6429
--- /dev/null
+++ b/Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql	
@@ -0,0 +1,89 @@
+/*==============================================================*/
+/* Database name:  CONCEPTUALDATAMODEL_1                        */
+/* DBMS name:      ORACLE Version 9i                            */
+/* Created on:     29.03.2006 09:46:49                          */
+/*==============================================================*/
+
+
+alter table AUDIO
+   drop constraint FK_AUDIO_INHERITAN_LEIHOBJE
+/
+
+
+alter table AUSLEIHE
+   drop constraint FK_AUSLEIHE_RELATIONS_LEIHOBJE
+/
+
+
+alter table AUSLEIHE
+   drop constraint FK_AUSLEIHE_RELATIONS_ENTLEIHE
+/
+
+
+alter table AUTOR_BUCH
+   drop constraint FK_AUTOR_BU_AUTOR_BUC_BUCH
+/
+
+
+alter table AUTOR_BUCH
+   drop constraint FK_AUTOR_BU_AUTOR_BUC_AUTOR
+/
+
+
+alter table BUCH
+   drop constraint FK_BUCH_INHERITAN_LEIHOBJE
+/
+
+
+alter table ZEITSCHRIFT
+   drop constraint FK_ZEITSCHR_INHERITAN_LEIHOBJE
+/
+
+
+drop index RELATIONSHIP_4_FK
+/
+
+
+drop index RELATIONSHIP_5_FK
+/
+
+
+drop index AUTOR_BUCH2_FK
+/
+
+
+drop index AUTOR_BUCH_FK
+/
+
+
+drop table AUDIO cascade constraints
+/
+
+
+drop table AUSLEIHE cascade constraints
+/
+
+
+drop table AUTOR cascade constraints
+/
+
+
+drop table AUTOR_BUCH cascade constraints
+/
+
+
+drop table BUCH cascade constraints
+/
+
+
+drop table ENTLEIHER cascade constraints
+/
+
+
+drop table LEIHOBJEKT cascade constraints
+/
+
+
+drop table ZEITSCHRIFT cascade constraints
+/
+
-- 
cgit v1.2.3

