Guest User

Untitled

a guest
Aug 9th, 2017
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.01 KB | None | 0 0
  1. INSERT INTO address (address_id, address_building_number, address_street, address_locality, address_city, address_zip_postal, address_state_province_county, address_country) VALUES (4, '555', 'ge', NULL, 'San Francisco', '91001', 'California', 'US');
  2. INSERT INTO address (address_id, address_building_number, address_street, address_locality, address_city, address_zip_postal, address_state_province_county, address_country) VALUES (1, '555', 'ge', NULL, 'Los Angeles', '91001', 'California', 'US');
  3. INSERT INTO address (address_id, address_building_number, address_street, address_locality, address_city, address_zip_postal, address_state_province_county, address_country) VALUES (2, '555', 'Trainsignal', NULL, 'Toronto', '7777', 'Ontario', 'Canada');
  4. INSERT INTO address (address_id, address_building_number, address_street, address_locality, address_city, address_zip_postal, address_state_province_county, address_country) VALUES (3, '555', 'ge', 'Boonies', 'Somewhere', '11111', 'Maine', 'US');
  5.  
  6.  
  7.  
  8. INSERT INTO email_address (email_address_id, email_address_person_id, email_address) VALUES (1, 1, 'virat.kohli@mail.com');
  9. INSERT INTO email_address (email_address_id, email_address_person_id, email_address) VALUES (2, 1, 'jonf@anothermail.com');
  10.  
  11. INSERT INTO email_address (email_address_id, email_address_person_id, email_address) VALUES (4, 3, 'fritz@mail.com');
  12. INSERT INTO email_address (email_address_id, email_address_person_id, email_address) VALUES (5, NULL, 'aaron@mail.com');
  13.  
  14. INSERT INTO person (person_id, person_first_name, person_last_name, person_contacted_number,person_date_last_contacted,person_date_added ) VALUES (1, 'Virat', 'Kohli', 5,'2013-09-14 11:43:31','2013-01-14 11:43:31');
  15. INSERT INTO person (person_id, person_first_name, person_last_name, person_contacted_number,person_date_last_contacted,person_date_added) VALUES (2, 'Shannon', 'Ahern', 0,'2013-08-14 11:43:31','2013-02-14 11:43:31');
  16. INSERT INTO person (person_id, person_first_name, person_last_name, person_contacted_number,person_date_last_contacted,person_date_added) VALUES (3, 'Fritz', 'Onion', 1,'2013-07-14 11:43:31','2013-03-14 11:43:31');
  17.  
  18. INSERT INTO person_address (person_address_id, person_address_person_id, person_address_address_id) VALUES (1, 1, 1);
  19. INSERT INTO person_address (person_address_id, person_address_person_id, person_address_address_id) VALUES (3, 2, 1);
  20. INSERT INTO person_address (person_address_id, person_address_person_id, person_address_address_id) VALUES (4, 2, 2);
  21. INSERT INTO person_address (person_address_id, person_address_person_id, person_address_address_id) VALUES (5, 3, 3);
  22.  
  23.  
  24. INSERT INTO phone_number (phone_number_id, phone_number_person_id, phone_number) VALUES (1, 1, '555-1212');
  25. INSERT INTO phone_number (phone_number_id, phone_number_person_id, phone_number) VALUES (2, 2, '555-1213');
  26. INSERT INTO phone_number (phone_number_id, phone_number_person_id, phone_number) VALUES (3, 3, '555-1214');
  27. INSERT INTO phone_number (phone_number_id, phone_number_person_id, phone_number) VALUES (4, 3, '555-1215');
Add Comment
Please, Sign In to add comment