Advertisement
badlogic

Migration script for manage user

Aug 22nd, 2016
237
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.49 KB | None | 0 0
  1. USE `dps_hris_db`;
  2.  
  3. UPDATE `app_users` SET
  4. `user_id` = '359',
  5. `emp_id` = '8',
  6. `ud_id` = '5',
  7. `user_name` = '15-136',
  8. `user_fullname` = 'Ms. Menche',
  9. `user_password` = md5('15-136'),
  10. `user_type` = 'CASHIER',
  11. `user_status` = '1'
  12. WHERE `user_id` = '359';
  13.  
  14. DELETE FROM `app_users`
  15. WHERE ((`user_id` = '362'));
  16.  
  17. UPDATE `app_users` SET
  18. `user_id` = '380',
  19. `emp_id` = '26',
  20. `ud_id` = '10',
  21. `user_name` = '15-154',
  22. `user_fullname` = 'Lyramhel Gatus',
  23. `user_password` = '67e81932dcaaa38cd562f7c92c0ecb34',
  24. `user_type` = 'GS Teacher',
  25. `user_status` = '1'
  26. WHERE `user_id` = '380';
  27.  
  28. UPDATE `app_users` SET
  29. `user_id` = '360',
  30. `emp_id` = '25',
  31. `ud_id` = '10',
  32. `user_name` = '08-021',
  33. `user_fullname` = 'Racvel Atienza',
  34. `user_password` = md5('08-021'),
  35. `user_type` = 'REG',
  36. `user_status` = '1'
  37. WHERE `user_id` = '360';
  38.  
  39. UPDATE `app_users` SET
  40. `user_id` = '358',
  41. `emp_id` = '7',
  42. `ud_id` = '6',
  43. `user_name` = '05-009',
  44. `user_fullname` = 'Dane Cruz',
  45. `user_password` = md5('05-009'),
  46. `user_type` = 'CASHIER',
  47. `user_status` = '1'
  48. WHERE `user_id` = '358';
  49.  
  50. UPDATE `app_users` SET
  51. `user_id` = '359',
  52. `emp_id` = '8',
  53. `ud_id` = '5',
  54. `user_name` = '15-136',
  55. `user_fullname` = 'Menche Barlan',
  56. `user_password` = '68a9bb932a9cb68b4fcb2b8d80e54e82',
  57. `user_type` = 'CASHIER',
  58. `user_status` = '1'
  59. WHERE `user_id` = '359';
  60.  
  61. DELETE FROM `app_users`
  62. WHERE ((`user_id` = '361'));
  63.  
  64. DELETE FROM `app_users`
  65. WHERE ((`user_id` = '379'));
  66.  
  67. DELETE FROM `app_users`
  68. WHERE ((`user_id` = '358'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement