Insert contacts.sql

--
 
-- Dumping data for table `my_address_book`.`address_type`
 
--
 
 
 
INSERT INTO `address_type` (`ADDRESS_TYPE_ID`,`ADDRESS_CATEGORY`) VALUES
 
('1','HOME ADDRESS'),
 
('2','ALTERNATIVE HOME ADDRESS'),
 
('3','WORK ADDRESS'),
 
('4','ALTERNATIVE WORK ADDRESS'),
 
('5','NEXT OF KIN HOME ADDRESS'),
 
('6','NEXT OF KIN WORK ADDRESS'),
 
('7','POSTAL ADDRESS'),
 
('8','BILLING ADDRESS'),
 
('9','FORWARDING ADDRESS'),
 
('10','WORK POSTAL ADDRESS');
 
 
 
--
 
-- Dumping data for table `my_address_book`.`event_type`
 
--
 
 
 
INSERT INTO `event_type` (`EVENT_TYPE_ID`,`EVENT_NAME`) VALUES
 
('1','BIRTHDAY'),
 
('2','WEDDING ANNIVERSARY'),
 
('3','AGM'),
 
('4','MEDICAL APPOINTMENT'),
 
('5','CHARITY EVENT'),
 
('6','SPORTS EVENT'),
 
('7','RELIGIOUS EVENT'),
 
('8','NATIONAL HOLIDAY'),
 
('9','ANNUAL VACATION'),
 
('10','MEMORIAL');
 
 
 
--
 
-- Dumping data for table `my_address_book`.`phone_type`
 
--
 
 
 
INSERT INTO `phone_type` (`PHONE_TYPE_ID`,`PHONE_CATEGORY`) VALUES
 
('1','HOME PHONE'),
 
('2','MOBILE PHONE1'),
 
('3','MOBILE PHONE2'),
 
('4','WORK LAND LINE1'),
 
('5','WORK LAND LINE2'),
 
('6','WORK MOBILE PHONE1'),
 
('7','WORK MOBILE PHONE2'),
 
('8','NEXT OF KIN HOME PHONE'),
 
('9','NEXT OF KIN MOBILE PHONE'),
 
('10','NEXT OF KIN WORK PHONE');
 
 
 
--
 
-- Dumping data for table `my_address_book`.`contacts`
 
--
 
 
 
INSERT INTO `contacts` (`CONTACT_ID`,`FIRST_NAME`,`MIDDLE_NAME`,`LAST_NAME`,`EMAIL`) VALUES
 
('1','Alex','Mutuku','Mbolonzi','almbolonzi@yahoo.com'),
 
('2','Antony','Mutua','Mbolonzi','ambolonzi@yahoo.com'),
 
('3','Lilian','Muluka','Mbolonzi','lilmbolonzi@yahoo.com'),
 
('4','Ann','Mathei','Mbolonzi','anmbolonzi@yahoo.com'),
 
('5','Nick','Muli','Nzioka','nnzioka@yahoo.com'),
 
('6','Tom','Mwalali','Ndoyo','tmwalali@yahoo.com'),
 
('7','Soni','','Muthoni','sonii@gmail.com'),
 
('8','Flora','','Wambui','fwambui@yahoo.com'),
 
('9','Sam','','Nyamwea','snyamwea@yahoo.com'),
 
('10','Melvin','Murinyo','Gichamba','murinyo@yahoo.com');
 
 
 
--
 
-- Dumping data for table `my_address_book`.`address_detail`
 
--
 
 
 
INSERT INTO `address_detail` (`ADDRESS_DETAIL_ID`,`ADDRESS_TYPE_ID`,`CONTACT_ID`,`COUNTRY`,`CITY`,`STREET`,`EXTRA_DETAIL`) VALUES
 
('1','1','1','KENYA','NAIROBI','SOUTH C','HSE No. 35'),
 
('2','3','1','KENYA','NAIROBI','MOI AVENUE','UNION TOWERS 11th FLOOR'),
 
('3','1','2','KENYA','NAIROBI','LANGATA','HSE No.10'),
 
('4','1','3','KENYA','NAIROBI','SOUTH C','HSE No. 35'),
 
('5','3','5','KENYA','NAIROBI','GPO','ROOM No. 3'),
 
('6','1','6','KENYA','NAIROBI','WESTLANDS','HSE No. 22'),
 
('7','1','7','KENYA','NAIROBI','WESTLANDS','HSE No. 22'),
 
('8','3','8','KENYA','NAIROBI','WESTLANDS','UNGA HOUSE 10th FLOOR'),
 
('9','3','9','KENYA','NAIROBI','CHAI HOUSE','6th Floor'),
 
('10','1','10','KENYA','NAIROBI','NGONG','ZAMBIA APARTMENTS APT No.6');
 
 
 
--
 
-- Dumping data for table `my_address_book`.`event_detail`
 
--
 
 
 
INSERT INTO `event_detail` (`EVENT_DETAIL_ID`,`EVENT_TYPE_ID`,`CONTACT_ID`,`DATE`) VALUES
 
('1','1','1','1980-06-28'),
 
('2','1','2','1976-05-28'),
 
('3','1','3','1978-07-04'),
 
('4','1','4','1988-09-23'),
 
('5','1','5','1979-12-09'),
 
('6','1','6','1980-12-10'),
 
('7','1','7','1984-10-28'),
 
('8','1','8','1980-01-28'),
 
('9','1','9','1980-03-19'),
 
('10','1','10','1980-01-05');
 
 
 
--
 
-- Dumping data for table `my_address_book`.`phone_detail`
 
--
 
 
 
INSERT INTO `phone_detail` (`PHONE_DETAIL_ID`,`PHONE_TYPE_ID`,`CONTACT_ID`,`PHONE_NUMBER`) VALUES
 
('1','2','1','722259541'),
 
('2','2','2','734712489'),
 
('3','2','3','722822874'),
 
('4','2','4','722884587'),
 
('5','2','5','722491664'),
 
('6','2','6','721428482'),
 
('7','2','7','721475750'),
 
('8','2','8','722290404'),
 
('9','2','9','722320347'),
 
('10','2','10','736643813');