Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE SCHEMA sklep267513 AUTHORIZATION postgres;
- GRANT ALL ON SCHEMA public TO postgres;
- CREATE TABLE sklep267513.produkty(
- id_produktu INT NOT NULL,
- nazwa TEXT NOT NULL,
- cena INT NOT NULL,
- id_producenta INT NOT NULL
- );
- ALTER TABLE sklep267513.produkty ADD PRIMARY KEY ( id_produktu );
- CREATE TABLE sklep267513.producenci(
- id_producenta INT NOT NULL,
- nazwa TEXT NOT NULL,
- mail TEXT NOT NULL,
- telefon TEXT NOT NULL
- );
- ALTER TABLE sklep267513.producenci ADD PRIMARY KEY ( id_producenta );
- ALTER TABLE sklep267513.produkty ADD CONSTRAINT id_producenta FOREIGN KEY (id_producenta) REFERENCES sklep267513.producenci ON DELETE NO ACTION;
- CREATE TABLE sklep267513.zamowienia(
- id_zamowienia INT NOT NULL,
- id_produktu INT NOT NULL,
- sztuk INT NOT NULL,
- data DATE
- );
- ALTER TABLE sklep267513.zamowienia ADD PRIMARY KEY ( id_zamowienia );
- ALTER TABLE sklep267513.zamowienia ADD CONSTRAINT id_produktu FOREIGN KEY (id_produktu) REFERENCES sklep267513.produkty ON DELETE CASCADE;
- CREATE INDEX ind1 ON sklep267513.zamowienia (id_zamowienia);
- CREATE TABLE sklep267513.klienci(
- id_klienta INT NOT NULL,
- email TEXT NOT NULL,
- telefon TEXT
- );
- ALTER TABLE sklep267513.klienci ADD PRIMARY KEY ( id_klienta );
- INSERT INTO sklep267513.producenci VALUES
- (1, 'Januszex', 'januszex@eample.com', '1112223333'),
- (2, 'Kowlaex', 'mail2@mail.com', '124234645'),
- (3, 'Firma3', 'mail3@mail.com', '333645256'),
- (4, 'Jaks firma', 'mail4@mail.com', '253235463'),
- (5, 'Inna firma', 'mail5@mail.com', '111111111'),
- (6, 'Firma6', 'mail6@mail.com', '222222222'),
- (7, 'Firma7', 'mail7@mail.com', '333333333'),
- (8, 'ABCD', 'mail8@mail.com', '444444444'),
- (9, 'LG', 'mail9@mail.com', '555555555'),
- (10, 'HP', 'mail10@mail.com', '666666666');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement