5iUe9M42

1DROP TABLE IF EXISTS [Koszyk]
2GO
3DROP TABLE IF EXISTS [Towar]
4GO 
5DROP TABLE IF EXISTS [Zakup] 
6GO 
7DROP TABLE IF EXISTS [Klient]
8GO 
9
10CREATE TABLE [Klient] (
11	id INT PRIMARY KEY IDENTITY(1,1),
12	imie VARCHAR(20) NOT NULL, 
13	nazwisko VARCHAR(30) NOT NULL
14)
15GO 
16
17CREATE TABLE [Towar] ( 
18	id INT PRIMARY KEY IDENTITY(1,1),
19	nazwa VARCHAR(30) UNIQUE NOT NULL, 
20	opis TEXT NOT NULL,
21	ilosc_sztuk INT, 
22	cena_netto MONEY NOT NULL,
23	podatek MONEY
24)
25GO 
26
27CREATE TABLE [Zakup] (
28	id INT PRIMARY KEY IDENTITY(1,1),
29	klient_id INT FOREIGN KEY REFERENCES [Klient] (id),
30	data_zakupu DATETIME NOT NULL
31)
32GO
33
34CREATE TABLE [Koszyk] ( 
35	id INT PRIMARY KEY IDENTITY(1,1),
36	zakup_id INT FOREIGN KEY REFERENCES [Zakup] (id),
37	towar_id INT FOREIGN KEY REFERENCES [Towar] (id),
38	ilosc INT, 
39	cena_netto MONEY, 
40	podatek MONEY
41)
42GO
43
44INSERT INTO [Klient] VALUES 
45	('Jakub', 'Silded'),
46	('Marcinek', 'Ruszniekiewcz'),
47	('Piter', 'Rutkewsci'),
48	('Krzysiu', 'Kononowicz')
49GO
50
51INSERT INTO [Towar] VALUES 
52	('Szprota', 'Prosto z morza', 40, 2.50, 0.38),
53	('Karp', 'Idealny na swieta', 10, 7.50, 0.99),
54	('Szczupak', 'Grozny drapieznik', 5, 15.00, 2.32),
55	('Okon', 'Ostry jak brzytwa', 100, 5.20, 0.15),
56	('Lin', 'Dodaj a', 25, 3.80, 0.76)
57GO
58
59INSERT INTO [Zakup] VALUES 
60	(2, GETDATE()),
61	(4, GETDATE()),
62	(3, GETDATE()),
63	(4, GETDATE())
64GO
65
66INSERT INTO [Koszyk] (zakup_id, towar_id, ilosc) VALUES 
67	(1, 3, 20)
68GO