UwQrxn3F

1DROP DATABASE  IF EXISTS `dbcontact`;
2
3CREATE DATABASE `dbcontact` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
4use dbcontact ;
5
6CREATE TABLE `names` (
7  `contactid` smallint(100) NOT NULL AUTO_INCREMENT,
8  `firstname` varchar(50) DEFAULT NULL,
9  `lastname` varchar(50) DEFAULT NULL,
10  `birthdate` date DEFAULT NULL,
11  PRIMARY KEY (`contactid`)
12) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
13
14
15CREATE TABLE `address` (
16  `contactid` smallint(100) DEFAULT NULL,
17  `streetaddress` varchar(50) DEFAULT NULL,
18  `city` varchar(20) DEFAULT NULL,
19  `state` varchar(20) DEFAULT NULL,
20  `zip` varchar(15) DEFAULT NULL,
21  `country` varchar(20) DEFAULT NULL
22) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
23
24CREATE TABLE `emails` (
25  `contactid` smallint(100) DEFAULT NULL,
26  `email` varchar(50) DEFAULT NULL
27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
28
29
30CREATE TABLE `telephones` (
31  `contactid` smallint(100) DEFAULT NULL,
32  `telephonehome` varchar(50) DEFAULT NULL,
33  `telephonework` varchar(50) DEFAULT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
35
36CREATE TABLE `companydetails` (
37  `contactid` smallint(100) DEFAULT NULL,
38  `companyname` varchar(50) DEFAULT NULL,
39  `designation` varchar(50) DEFAULT NULL
40) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
41
42Insert into names( contactid, firstname, lastname, birthdate) values
43('1', 'Mike', 'Mamba', '2001-01-01'),
44('2', 'Jenny', 'Sweet', '2002-03-05'),
45('3', 'John', 'Short', '2002-05-15'),
46('4', 'Seeyo', 'See ya', '2002-03-05'),
47('5', 'Vellai', 'Green', '2002-03-05'),
48('6', 'Olay', 'Yaa', '2002-03-05'),
49('7', 'Jeremy', 'Late', '2002-05-15');
50
51Insert Into address () values 
52('1', '51 Jalan Satu', 'Petaling Jaya', 'Selangor', '47301', 'Malaysia'),
53('2', '10 Jalan Baru', 'Petaling Jaya', 'Selangor', '47301', 'Malaysia'),
54('3',	'2A Jalan Wangi',	'Shah Alam',	'Selangor',	'40000',	'Malaysia'),
55('4', '57 Jalan Kosong', 'Kuaa Lumpur', 'WP', '51200', 'Malaysia'),
56('5','15 Jalan Wangi','Shah Alam', 'Selangor','41000',	'Malaysia'),
57('6','7 Jalan Banjir','Kuala Lumpur', 'WP','51200',	'Malaysia'),
58('7','81 Jalan Utara','Petaling Jaya', 'Selangor','51200',	'Malaysia');
59
60INSERT INTO emails() VALUES
61('1','Mike@gmail.com'),
62('2','Jenny@gmail.com'),
63('3','John@gmail.com'),
64('4','Seeyo@gmail.com'),
65('5','Vellai@gmail.com'),
66('6','Olay@gmail.com'),
67('7','Jeremy@gmail.com');
68
69INSERT INTO companydetails() VALUES
70('1','ABC co', 'Manager'),
71('2','YXC Company', 'Director'),
72('3','Mike me Pvt Ltd', 'General Manager'),
73('4','ABC co', 'GM'),
74('5','ABC co', 'Sales Manager'),
75('6','YXC Company', 'Teller'),
76('7','Mike me Pvt Ltd', 'Admin Clerk');
77
78INSERT INTO telephones() VALUES
79('1','03765235', '36528941'),
80('2','45156446', '45245342'),
81('3','47123454', '78547224'),
82('4','85684266', '75863257'),
83('5','45278634', '45632874'),
84('6','35426897', '74568922'),
85('7','25563458', '78456589');