Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `klienci`(
- `id` INTEGER PRIMARY KEY NOT NULL,
- `imie` VARCHAR(20) NOT NULL,
- `nazwisko` VARCHAR(50))ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `towary`(
- `id` INTEGER PRIMARY KEY NOT NULL,
- `nazwa` VARCHAR(50),
- `grupa` INTEGER NOT NULL,
- `cena` DECIMAL(7,2)
- )ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `zamowienia`(
- `id` INTEGER PRIMARY KEY NOT NULL,
- `klient-id` INTEGER NOT NULL,
- `towar-id` INTEGER NOT NULL,
- `data` DATE NOT NULL,
- `wartosc` DECIMAL(7,2))ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO klienci VALUES
- (1,'Jan','Kowalski'),
- (2,'Andrzej','Nowak'),
- (3,'Janusz','Malinowski'),
- (4,'Adam','Kowalski'),
- (5,'Krzysztof','Nowicki');
- INSERT INTO towary VALUES
- (1,'Śruby', 1, 2.00),
- (2,'Nakrętki',1, 3.00),
- (3,'Kątowniki',2,8.00),
- (4,'Płaskowniki',2,9.00),
- (5,'Gwoździe',1,1.00),
- (6,'Panele',3,15.00),
- (7,'Wkręty',1,4.00),
- (8,'Deski',3,12.00),
- (9,'Płyty',3,19.00);
- INSERT INTO zamowienia VALUES
- (1,1,2,'2012-01-01', 12.44),
- (2,1,4,'2012-01-01', 10.22),
- (3,1,2,'2012-02-12', 15.88),
- (4,2,1,'2012-01-01', 22.35),
- (5,2,1,'2012-02-12', 28.00),
- (6,2,4,'2012-03-01', 2.28),
- (7,3,1,'2012-02-11', 18.48),
- (8,3,4,'2012-01-01', 12.44),
- (9,4,1,'2012-03-11', 15.26),
- (10,5,4,'2012-03-02', 6.11);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement