XUhR4qsq

1BEGIN TRANSACTION;
2CREATE TABLE IF NOT EXISTS `surname` (
3	`ID`	INTEGER,
4	`AGE`	INTEGER,
5	`PHONE`	INTEGER,
6	PRIMARY KEY(`ID`)
7);
8INSERT INTO `surname` VALUES (1,28,1);
9INSERT INTO `surname` VALUES (2,45,2);
10INSERT INTO `surname` VALUES (3,28,2);
11INSERT INTO `surname` VALUES (4,12,3);
12INSERT INTO `surname` VALUES (5,28,1);
13INSERT INTO `surname` VALUES (6,28,4);
14CREATE TABLE IF NOT EXISTS `phone` (
15	`ID`	INTEGER,
16	`PHONE`	TEXT,
17	`OS_ID`	INTEGER,
18	PRIMARY KEY(`ID`)
19);
20INSERT INTO `phone` VALUES (1,'samsung',3);
21INSERT INTO `phone` VALUES (2,'xiaomi',3);
22INSERT INTO `phone` VALUES (3,'samsung',2);
23INSERT INTO `phone` VALUES (4,'htc',1);
24CREATE TABLE IF NOT EXISTS `os` (
25	`ID`	INTEGER,
26	`OS_ID`	TEXT,
27	`OS_NAME`	TEXT,
28	PRIMARY KEY(`ID`)
29);
30INSERT INTO `os` VALUES (1,'7','android');
31INSERT INTO `os` VALUES (2,'8.2','android');
32INSERT INTO `os` VALUES (3,'8.1','android');
33INSERT INTO `os` VALUES (4,'6','android');
34INSERT INTO `os` VALUES (5,'4','ios');
35CREATE TABLE IF NOT EXISTS `client` (
36	`ID`	INTEGER,
37	`NAME`	TEXT,
38	`SURNAME`	TEXT,
39	`AGE`	INTEGER,
40	PRIMARY KEY(`ID`)
41);
42INSERT INTO `client` VALUES (1,'Dima','Pidor',1);
43INSERT INTO `client` VALUES (2,'Dima','Pidor',3);
44INSERT INTO `client` VALUES (3,'Vasya','NePidor',2);
45INSERT INTO `client` VALUES (4,'Kevin','Padla',1);
46INSERT INTO `client` VALUES (5,'Dima','Pidor',4);
47COMMIT;