25yTF6VF

1drop table if exists servside2017_users;
2drop table if exists servside2017_persons;
3create table if not exists servside2017_persons (id char(11) primary key, fname varchar(40) not null, sname varchar(40) not null);
4create table if not exists servside2017_users (user varchar(20) primary key, pwd varchar(40) not null, pri int not null default '0', id char(11) not null, description varchar(80), foreign key (id) references servside2017_persons(id) on delete cascade);
5insert into servside2017_persons (id, fname, sname) values ('12345678901', 'Kalle', 'Ankka');
6insert into servside2017_users (user, pwd, pri, id, description) values ('ankkkall', md5('kalle'), '0', '12345678901', 'P‰‰k‰ytt‰j‰');
7show tables like 'servside2017%';
8select 1 from servside2017_users;
9select user, description, fname, sname from servside2017_users as u join servside2017_persons as p where u.id = p.id;