0XJAR02k

1<?php
2require_once 'settings.php';
3
4$sql='
5CREATE TABLE if not exists tausleihen (
6 VidNummer int(11) NOT NULL,
7 KunNummer int(11) NOT NULL,
8 AusVon date,
9 AusBis date
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11ALTER TABLE tausleihen ADD PRIMARY KEY (VidNummer,KunNummer);
12
13CREATE TABLE if not exists tkunden (
14 KunNummer int(11) PRIMARY KEY AUTO_INCREMENT,
15 KunAnrede varchar(30),
16 KunVorname varchar(30),
17 KunNachname varchar(30),
18 KunStrasse varchar(30),
19 KunPLZ varchar(30),
20 KunOrt varchar(30),
21 KunGebDatum varchar(30),
22 KunTelefon varchar(30)
23) ENGINE=InnoDB DEFAULT CHARSET=utf8;
24ALTER TABLE tkunden AUTO_INCREMENT=1000;
25
26
27CREATE TABLE if not exists tvideos (
28 VidNummer int(11) PRIMARY KEY AUTO_INCREMENT,
29 VidTitel varchar(30),
30 VidDauer int(11),
31 VidKategorie varchar(30),
32 VidJahr int(11),
33 VidFreiAb int(2),
34 VidPreisProTag double,
35 VidEinkaufsPreis double,
36 VidLagerbestand int(11)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;';
38
39$db = mysqli_connect("$dbhost", "$dbusername", "$dbpassword")or die("Error " . mysqli_error($db));
40
41if(mysqli_query($db,"CREATE DATABASE IF NOT EXISTS $dbname CHARACTER SET = utf8 COLLATE = utf8_general_ci;
42"))
43{
44  $db = mysqli_connect("$dbhost", "$dbusername", "$dbpassword","$dbname")or die("Error " . mysqli_error($db));
45}
46
47if(mysqli_multi_query($db,$sql
48))
49        {
50            echo "DB set up ";
51             echo "<br>You should delete this file for security reasons ";
52
53        }
54       else
55
56       {
57                   printf("Error: %s\n", mysqli_error($db));
58       }
59
60       mysqli_close($db);