HKZqWtQa

1<?php
2$servername = "niisku.lamk.fi";
3$dbname = "user_turutimo";
4$username = "turutimo";
5$password = "turutimo";
6$tables = "servside2017%";
7$tbc = 2;
8$dbcreatestatements = "drop table if exists servside2017_users;"
9    ."drop table if exists servside2017_persons;"
10    ."create table if not exists servside2017_persons (id char(11) primary key, fname varchar(40) not null, sname varchar(40) not null);"
11    ."create 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);"
12    ."insert into servside2017_persons (id, fname, sname) values ('12345678901', 'Kalle', 'Ankka');"
13    ."insert into servside2017_users (user, pwd, pri, id, description) values ('ankkkall', md5('kalle'), '0', '12345678901', 'Pääkäyttäjä');"
14    ;