/**
 remove existing tables..
*/

drop table pizza_type;
drop table bestellung;

/**
 Define Pizza-Types
*/
CREATE TABLE `pizza_type` (
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 100 ) NOT NULL ,
`preis` DOUBLE NOT NULL ,
PRIMARY KEY ( `id` ) 
);


/**
 Define Bestellung
*/
create table bestellung (
  id            integer auto_increment,
  id_pizza      integer,
  anzahl        integer
);


/**  
 insert testdata
*/
INSERT INTO `pizza_type` ( `id` , `name` , `preis` ) VALUES ('', 'Diavola', '2');
INSERT INTO `pizza_type` ( `id` , `name` , `preis` ) VALUES ('', 'Hawaii', '2.5');
INSERT INTO `pizza_type` ( `id` , `name` , `preis` ) VALUES ('', 'Prosciutto', '2.5');
INSERT INTO `pizza_type` ( `id` , `name` , `preis` ) VALUES ('', 'Tiroler', '4');
