iUezkaP3

1DROP TABLE IF EXISTS pracownicy;  
2DROP TABLE IF EXISTS kontakty;
3DROP TABLE IF EXISTS place;
4DROP TABLE IF EXISTS stanowiska;
5
6
7CREATE TABLE pracownicy
8(
9    id_pracownika INTEGER PRIMARY KEY AUTOINCREMENT,
10	imie TEXT(15),
11	nazwisko TEXT(30),
12	kod STRING(10),
13    miasto_z TEXT(25),
14    ulica TEXT(35),
15    data_u DATE,
16    miasto_u TEXT(30)
17);
18
19CREATE TABLE kontakty
20(
21	id_pracownika INTEGER NOT NULL,
22	typ_k BOOLEAN,
23    kontakt STRING(15),
24    uwagi TEXT(30),
25    FOREIGN KEY(id_pracownika) REFERENCES pracownicy(id_pracownika)
26);
27
28
29CREATE TABLE stanowiska 
30(
31    id_stanowiska INTEGER PRIMARY KEY AUTOINCREMENT,
32    stanowisko TEXT(30)
33);
34
35
36CREATE TABLE place
37(
38    id_p INTEGER NOT NULL,
39    id_s INTEGER NOT NULL,
40    placa INTEGER,
41    data_z DATE,
42    FOREIGN KEY (id_p) REFERENCES kontakty(id_pracownika),
43    FOREIGN KEY (id_s) REFERENCES stanowiska(id_stanowiska)
44    
45);
46
47
48/*
49INSERT INTO tbCustomers(customer_id, customer_name, adress) VALUES (NULL, 'Allie Rahaim', '123 Broadway');
50INSERT INTO tbCustomers VALUES (NULL, 'Jacquline Diddle', '456 Park Ave');
51INSERT INTO tbSubscriptions(subscription_id, description, price_per_month, subscription_length)
52VALUES (NULL, 'Politics Magazine', 10, '12 months' );