Advertisement
Guest User

Untitled

a guest
Feb 27th, 2015
387
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.19 KB | None | 0 0
  1. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role, staff_job_salary, staff_ni_num, staff_employed_date)
  2.   VALUES (1, 'bobch', 'password', 'Bob', 'Cherry', '123 Sesame Street', '', 'M15 6UU', 'Manchester', 0, 07587472576, 'fake@email.com', 'sales', 2000, 'N23 34 CD C', '14-APR-2001');
  3.  
  4. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role, staff_job_salary, staff_ni_num, staff_employed_date)
  5.   VALUES (2, 'tomru', 'password', 'Tom', 'Rutherford', '456 Bamboo Lane', '', 'NF5 8GF', 'Manchester', 04869356475, 07835635687, 'fake2@email.com', 'maintenance', 2500, 'N23 35 CD C', '21-JAN-2006');
  6.  
  7. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role, staff_job_salary, staff_ni_num, staff_employed_date)
  8.   VALUES (3, 'leighed', 'password', 'Leigh', 'Edwards', '213 Not Real Street', 'Apartment 4', 'M45 5ND', 'Manchester', 0, 07483959604, 'fake3@email.com', 'receptionist', 1500, 'N24 34 CD C', '09-MAR-2003');
  9.  
  10. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role,  staff_job_salary, staff_ni_num, staff_employed_date)
  11.   VALUES (4, 'tedbu', '123', 'Ted', 'Bucklands', '34 This Street', '', 'M54 7GB', 'Manchester', 0, 07482749576, 'fake4@email.com', 'maintenance', 2500, 'N24 35 CD C', '23-OCT-2002');
  12.  
  13. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role, staff_job_salary, staff_ni_num, staff_employed_date)
  14.   VALUES (5, 'rayho', 'password', 'Ray', 'Houdini', '49 Bucky Road', '', 'L35 9FG', 'Manchester', 0, 07938475927, 'fake5@email.com', 'manager', 5000, 'N32 23 DC C', '01-APR-2000');
  15.  
  16. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role, staff_job_salary, staff_ni_num, staff_employed_date)
  17.   VALUES (6, 'jakepe', 'password', 'Jake', 'Peralta', '34 Made Up Lane', '', 'M35 6FV', 'Manchester', 0,  07836475836, 'fake6@email.com', 'sales', 2000, 'N43 56 DC C', '20-MAY-2008');
  18.  
  19. INSERT INTO rr_staff (staff_id, staff_username, staff_password, staff_forename, staff_surname, staff_addr_line1, staff_addr_line2, staff_addr_postcode, staff_addr_city, staff_tele_home, staff_tele_mobile, staff_email, staff_job_role, staff_job_salary, staff_ni_num, staff_employed_date)
  20.   VALUES (7, '', 'password', '', '', '', '', '', '', 0,  0, 'fake6@email.com', '', 0, '', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement