Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop database Prawo_jazdy;
- create database Prawo_jazdy;
- use Prawo_jazdy;
- create table uczestnicy
- (
- pesel varchar(11) primary key not null,
- imie varchar(20) not null,
- nazwisko varchar(25) not null,
- telefon varchar(20),
- id_kursu int(10),
- FOREIGN KEY (id_kursu) REFERENCES kursy(id_kursu),
- jazdy date default '0000-00-00'
- );
- create table kursy
- (
- id_kursu int(10) primary key not null,
- kursy_uczniow varchar(50)
- );
- insert into uczestnicy values
- ("12345678901","Krystian","Kowal","3423423",1,'2019-02-13'),
- ("12345322323","Adam","Kowalski","6653",2,"2019-02-13"),
- ("98765433333","Michal","Nowak","987554",1,"2019-02-13");
- insert into kursy values
- (1,"Kurs kategorii A"),
- (2,"Kurs kategorii B"),
- (3,"Kurs kategorii C"),
- (4,"Kurs kategorii D");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement