Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS pracownicy (
- id INT(5) NOT NULL AUTO_INCREMENT,
- nr_ew INT(10)NOT NULL,
- imie VARCHAR(50)NOT NULL,
- nazwisko VARCHAR(50)NOT NULL,
- data_ur DATE NOT NULL,
- data_za DATE NOT NULL,
- stanowisko_id int(5)NOT null,
- wydzial_id int(5) NOT null,
- PRIMARY KEY (id),
- FOREIGN KEY (stanowisko_id) REFERENCES stanowiska(stanowisko_id),
- FOREIGN KEY (wydzial_id) REFERENCES wydzialy(wydzial_id)
- ) ENGINE=InnoDB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement