summaryrefslogtreecommitdiffstats
path: root/examples/SQL/testdb_mysql.sql
blob: 144d4c90ffc88c9a2f59b4b92505d574c92eb398 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
drop database testdb;
create database testdb;
use testdb;

create table people (id integer primary key auto_increment,
                     name char(40));

create table staff (id integer primary key auto_increment,
                    forename char(40),
                    surname char(40),
                    salary float(10,2),
                    statusid integer);

create table status (id integer primary key,
                     name char(30));

create table creditors (id integer primary key auto_increment,
                        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 auto_increment, 
                          pricesid integer,
                          quantity integer,
                          paiddate date);

insert into staff (forename, surname, salary, statusid) values
            ("Hugo", "Hurtig", 123450.50, 0),
            ("Alfred E.", "Neumann", 56780.90, 1),
            ("Agate", "Schnell-Fertig", 12340.56, 2),
            ("Emil", "Dotterschreck", -5670.23, 3),
            ("Eugen", "Nutzlos", -7833.56, 3),
            ("Harald", "Schmidt", -150000.0, 3),
            ("Urmel", "auf dem Eis", 7778.0, 2);

insert into status (id, name) values
            (0, 'Chief'),
            (1, 'Programmer'),
            (2, 'Secretary'),
            (3, 'Driver');

insert into prices (id, name, price) values
            (0, "Waschbecken", 150.25),
            (1, "Wellensittich", 27.95),
            (2, "Roter Papagei", 850.0),
            (3, "Spam & Eggs", -7.50),
            (4, "Renault Espace", 9000.0),
            (5, "Tux, der Pinguin", 65.35),
            (6, "Makroskop", 985000.0),
            (7, "Regenbaum", 1235.65),
            (8, "Bluterguß", 23.95),
            (9, "Weltmeisterschaft", 2.95),
            (10, "Premiere Dekoder", -185.75);