DROP DATABASE  IF EXISTS `mydatabase`;

CREATE DATABASE `mydatabase` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
use mydatabase ;

CREATE TABLE `names` (
  `contactid` smallint(100) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  PRIMARY KEY (`contactid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `address` (
  `contactid` smallint(100) DEFAULT NULL,
  `streetaddress` varchar(50) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `zip` varchar(15) DEFAULT NULL,
  `country` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `emails` (
  `contactid` smallint(100) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


CREATE TABLE `telephones` (
  `contactid` smallint(100) DEFAULT NULL,
  `telephonehome` varchar(50) DEFAULT NULL,
  `telephonework` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `companydetails` (
  `contactid` smallint(100) DEFAULT NULL,
  `companyname` varchar(50) DEFAULT NULL,
  `designation` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Insert into names( contactid, firstname, lastname, birthdate) values
('1', 'Mike', 'Mamba', '2001-01-01'),
('2', 'Jenny', 'Sweet', '2002-03-05'),
('3', 'John', 'Short', '2002-05-15'),
('4', 'Seeyo', 'See ya', '2002-03-05'),
('5', 'Vellai', 'Green', '2002-03-05'),
('6', 'Olay', 'Yaa', '2002-03-05'),
('7', 'Jeremy', 'Late', '2002-05-15');

Insert Into address () values
('1', '51 Jalan Satu', 'Petaling Jaya', 'Selangor', '47301', 'Malaysia'),
('2', '10 Jalan Baru', 'Petaling Jaya', 'Selangor', '47301', 'Malaysia'),
('3',	'2A Jalan Wangi',	'Shah Alam',	'Selangor',	'40000',	'Malaysia'),
('4', '57 Jalan Kosong', 'Kuaa Lumpur', 'WP', '51200', 'Malaysia'),
('5','15 Jalan Wangi','Shah Alam', 'Selangor','41000',	'Malaysia'),
('6','7 Jalan Banjir','Kuala Lumpur', 'WP','51200',	'Malaysia'),
('7','81 Jalan Utara','Petaling Jaya', 'Selangor','51200',	'Malaysia');

INSERT INTO emails() VALUES
('1','Mike@gmail.com'),
('2','Jenny@gmail.com'),
('3','John@gmail.com'),
('4','Seeyo@gmail.com'),
('5','Vellai@gmail.com'),
('6','Olay@gmail.com'),
('7','Jeremy@gmail.com');

INSERT INTO companydetails() VALUES
('1','ABC co', 'Manager'),
('2','YXC Company', 'Director'),
('3','Mike me Pvt Ltd', 'General Manager'),
('4','ABC co', 'GM'),
('5','ABC co', 'Sales Manager'),
('6','YXC Company', 'Teller'),
('7','Mike me Pvt Ltd', 'Admin Clerk');

INSERT INTO telephones() VALUES
('1','03765235', '36528941'),
('2','45156446', '45245342'),
('3','47123454', '78547224'),
('4','85684266', '75863257'),
('5','45278634', '45632874'),
('6','35426897', '74568922'),
('7','25563458', '78456589');