<?php

include "conndb.php";

$abi2="create table tellijad
(
tellija_id	integer unsigned not null auto_increment primary key,
nimi  		varchar(30) not null,
aadres    	varchar(40)  not null,
linn		varchar(20) not null 
)";

if ($conn->query($abi2) === FALSE)     
    echo "Viga tabeli tellijad loomisel: " . $conn->error;

$abi3="create table tellimused
(
tellimuse_id	integer unsigned not null auto_increment primary key,
tellija_id		integer unsigned not null,
tellimuse_hind	float(8,2),
kuupaev		    date not null
)";
if ($conn->query($abi3) === FALSE)     
    echo "Viga tabeli tellimused loomisel: " . $conn->error;

$abi4="create table raamatud
(
isbn		varchar(13) not null primary key,
autor		varchar(30) not null,
pealkiri	varchar(60) not null,	
hind		float(6,2)
)";
if ($conn->query($abi4) === FALSE)     
    echo "Viga tabeli raamatud loomisel: " . $conn->error;

$abi5="create table tellitud_raamatud
(
tellimuse_id  integer unsigned not null, 
isbn		  varchar(13) not null,
arv		      tinyint unsigned,
primary key(tellimuse_id,isbn)
)";
if ($conn->query($abi5) === FALSE)     
    echo "Viga tabeli tellitud_raamatud loomisel: " . $conn->error;

$abi6="create table r_ylevaated
(
isbn		varchar(13) not null,
ylevaade	text 
)";
if ($conn->query($abi6) === FALSE)     
    echo "Viga tabeli r_ylevaated loomisel: " . $conn->error;
?>