Fanadia_Friska

init employee

Sep 1st, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.15 KB | None | 0 0
  1. INSERT INTO m_employee_job(
  2. partner_code, employee_job, username,
  3. version, create_datetime, create_username,
  4. update_datetime, update_username)
  5. VALUES ('DESINTA', 'PURCH', 'Desinta',
  6. 1, '20160729000000','Nadia',
  7. '20160729000000', 'Nadia'),
  8. ('NADIA', 'SALES', 'Nadia',
  9. 2, '20160808000000','Desinta',
  10. '20160808000000', 'Desinta');
  11.  
  12.  
  13.  
  14.  
  15. INSERT INTO m_partner(
  16. partner_code, partner_name, flg_customer, flg_supplier, flg_employee,
  17. address1, address2, city, state_or_province, zip_code, country,
  18. phone1, phone2, fax1, fax2, email, rating, default_gross_sell_price,
  19. default_gross_buy_price, active, active_datetime, non_active_datetime,
  20. version, create_datetime, create_username, update_datetime, update_username)
  21. VALUES ('DESINTA', 'IKA', 'Y', 'Y', 'Y',
  22. 'Pamulang Timur', 'Pamulang', 'Tangerang', 'Banten','15417', 'Indonesia',
  23. '0217413971','087809002724','0217413971','','[email protected]', 5, 9.5,
  24. 9.5, 'Y','20160523000000', ' ',
  25. 0,'20160523000000', 'Nadia', '20160524000000', 'Nadia'),
  26. ('NADIA', 'RESKY', 'Y', 'Y', 'Y',
  27. 'Pamulang Barat', 'Pamulang', 'Tangerang', 'Banten','15427', 'Indonesia',
  28. '0217413971','087809002724','0217413971','','[email protected]', 5, 9.5,
  29. 9.5, 'Y','20160523000000', ' ',
  30. 0,'20160523000000', 'Desinta', '20160524000000', 'Desinta');
  31.  
  32.  
  33.  
  34. INSERT INTO t_user(
  35. user_id, tenant_id, username, email, fullname, password, phone,
  36. role_default_id, private_key, create_datetime, create_user_id,
  37. update_datetime, update_user_id, version, active, active_datetime,
  38. non_active_datetime, ou_default_id, policy_default_id)
  39. VALUES (10, 10, 'Desinta', '[email protected]', 'User Satu', 'user1', '083464363',
  40. 10, '9457c7ca3ae0dc907ad1703c15287d5c', '20160419194303', -1,
  41. '20160419194303', -1, 2, 'Y', '20160419194303',
  42. '', 10, 10),
  43. (20, 20, 'Nadia', 'user2gmail.com', 'User Dua', 'user2', '083464364',
  44. 10, '9457c7ca3ae0dc907ad1703c15287d5d', '20160419194304', -1,
  45. '20160419194304', -1, 2, 'Y', '20160419194304',
  46. '', 20, 20);
  47.  
  48.  
  49. INSERT INTO t_combo (
  50. combo_id, combo_name, description, combo_type,
  51. create_datetime, create_user_id, update_datetime, update_user_id,
  52. version )
  53. VALUES ('EMPLOYEEJOB', 'Combo Employee JOb', 'Constant Combo Employee Job', 'FIX',
  54. '20160726000000', -1, '20160726000000', -1,0 );
  55.  
  56. INSERT INTO t_combo_value(
  57. combo_id, code, prop_key, code_group,
  58. sort_no, create_datetime, create_user_id, update_datetime,
  59. update_user_id, "version")
  60. VALUES('EMPLOYEEJOB', 'SALES', 'Sales', 'EMPLOYEE',
  61. 1, '20160726000000', -1, '20160726000000',
  62. -1, 0 ),
  63. ('EMPLOYEEJOB', 'PURCH', 'Purch', 'EMPLOYEE',
  64. 1, '20160726000000', -1, '20160726000000',
  65. -1, 0 ),
  66. ('EMPLOYEEJOB', 'FINANCE', 'Finance', 'EMPLOYEE',
  67. 1, '20160726000000', -1, '20160726000000',
  68. -1, 0 );
Add Comment
Please, Sign In to add comment