36 lines
745 B
Python
36 lines
745 B
Python
s = """
|
|
CREATE TABLE kunde
|
|
(
|
|
id INTEGER PRIMARY KEY,
|
|
name CHARACTER VARYING NOT NULL,
|
|
email CHARACTER VARYING NOT NULL,
|
|
password CHARACTER VARYING NOT NULL
|
|
);
|
|
|
|
CREATE TABLE bestellung
|
|
(
|
|
id INTEGER PRIMARY KEY,
|
|
kunde_id INTEGER NOT NULL,
|
|
datum DATE NOT NULL
|
|
);
|
|
|
|
CREATE TABLE produkt
|
|
(
|
|
id INTEGER PRIMARY KEY,
|
|
name CHARACTER VARYING NOT NULL,
|
|
beschreibung CHARACTER VARYING NOT NULL,
|
|
anzahl INTEGER NOT NULL,
|
|
preis NUMERIC(8,2) NOT NULL
|
|
);
|
|
|
|
CREATE TABLE bestellung_produkt
|
|
(
|
|
bestellung_id INTEGER NOT NULL,
|
|
produkt_id INTEGER NOT NULL,
|
|
anzahl INTEGER NOT NULL
|
|
);
|
|
"""
|
|
|
|
for command in s.split(';'):
|
|
print(command)
|
|
print('-----------------------') |