diff options
| author | Sven Eisenhauer <sven@sven-eisenhauer.net> | 2023-11-10 15:11:48 +0100 |
|---|---|---|
| committer | Sven Eisenhauer <sven@sven-eisenhauer.net> | 2023-11-10 15:11:48 +0100 |
| commit | 33613a85afc4b1481367fbe92a17ee59c240250b (patch) | |
| tree | 670b842326116b376b505ec2263878912fca97e2 /Bachelor/Datenbanken/tmp/CineCity/init.sql | |
| download | Studium-master.tar.gz Studium-master.tar.bz2 | |
Diffstat (limited to 'Bachelor/Datenbanken/tmp/CineCity/init.sql')
| -rw-r--r-- | Bachelor/Datenbanken/tmp/CineCity/init.sql | 83 |
1 files changed, 83 insertions, 0 deletions
diff --git a/Bachelor/Datenbanken/tmp/CineCity/init.sql b/Bachelor/Datenbanken/tmp/CineCity/init.sql new file mode 100644 index 0000000..2d6ab2e --- /dev/null +++ b/Bachelor/Datenbanken/tmp/CineCity/init.sql @@ -0,0 +1,83 @@ +DROP DATABASE IF EXISTS cinecity;
+CREATE DATABASE cinecity;
+USE cinecity;
+
+# --------------------------------------------------------
+CREATE TABLE tblArtikel (
+ artikelnummer varchar(50) NOT NULL PRIMARY KEY,
+ bezeichnung varchar(50) NOT NULL,
+ einkaufspreis decimal(4,2),
+ verkaufspreis decimal(4,2)
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblArtikel.csv" INTO TABLE tblArtikel LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+CREATE TABLE tblArtikelverkauf (
+ nr int NOT NULL PRIMARY KEY,
+ datum date,
+ artikelnummer varchar(50),
+ anzahl int
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblArtikelverkauf.csv" INTO TABLE tblArtikelverkauf LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+CREATE TABLE tblKinos (
+ kinonr int NOT NULL PRIMARY KEY,
+ kino varchar(50) NOT NULL,
+ plaetze int,
+ turnaround int,
+ kommentar text
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblKinos.csv" INTO TABLE tblKinos LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+CREATE TABLE tblFilme (
+ filmnr int NOT NULL PRIMARY KEY,
+ filmtitel varchar(100) NOT NULL,
+ plakat varchar(1),
+ fsk tinyint,
+ laenge int,
+ website varchar(100),
+ originaltitel varchar(100),
+ sonderveranstaltung tinyint,
+ zusatztext text,
+ bundesstartdatum date,
+ werbetext varchar(1)
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblFilme.csv" INTO TABLE tblFilme LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+CREATE TABLE tblKinokasse (
+ eintrittskartenr int NOT NULL PRIMARY KEY,
+ verkaufsdatum date,
+ terminnr int,
+ anzahlpersonen int,
+ betrag decimal(4,2),
+ vorstellungsdatum date
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblKinokasse.csv" INTO TABLE tblKinokasse LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+CREATE TABLE tblTermine (
+ terminnr int NOT NULL PRIMARY KEY,
+ wochennr int,
+ kinonr int,
+ kommentar text,
+ tag tinyint,
+ zeit time
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblTermine.csv" INTO TABLE tblTermine LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+CREATE TABLE tblWochen (
+ wochennr int NOT NULL PRIMARY KEY,
+ filmnr int,
+ kalenderwoche date,
+ lfdwoche int,
+ preis decimal(4,2),
+ kommentar text
+);
+
+LOAD DATA LOCAL INFILE "../tmp/CineCity/tblWochen.csv" INTO TABLE tblWochen LINES TERMINATED BY '\r\n';
+# --------------------------------------------------------
+
|