drop database testdb;
create database testdb;
use testdb;
create table people (id integer primary key, name char(40));
create table staff (id integer primary key, forename char(40),
                    surname char(40), salary float, statusid integer);
create table status (id integer primary key, name char(30));
create table creditors (id integer primary key, forename char(40),
                        surname char(40), city char(30));
create table prices (id integer primary key, name char(40), price float);
create table invoiceitem (id integer primary key, 
                          pricesid integer, quantity integer,
                          paiddate date);
insert into status (id, name) values (1, 'Chief');
insert into status (id, name) values (2, 'Programmer');
insert into status (id, name) values (3, 'Secretary');
insert into staff (id, forename, surname, salary, statusid)
            values (1, "Hugo", "Hurtig", 12340.50, 1);
insert into staff (id, forename, surname, salary, statusid)
            values (2, "Alfred E.", "Neumann", 5678.90, 2);
insert into staff (id, forename, surname, salary, statusid)
            values (3, "Agate Schnell", "Fertig", 1234.56, 3);
