Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO m_employee_job(
- partner_code, employee_job, username,
- version, create_datetime, create_username,
- update_datetime, update_username)
- VALUES ('DESINTA', 'PURCH', 'Desinta',
- 1, '20160729000000','Nadia',
- '20160729000000', 'Nadia'),
- ('NADIA', 'SALES', 'Nadia',
- 2, '20160808000000','Desinta',
- '20160808000000', 'Desinta');
- INSERT INTO m_partner(
- partner_code, partner_name, flg_customer, flg_supplier, flg_employee,
- address1, address2, city, state_or_province, zip_code, country,
- phone1, phone2, fax1, fax2, email, rating, default_gross_sell_price,
- default_gross_buy_price, active, active_datetime, non_active_datetime,
- version, create_datetime, create_username, update_datetime, update_username)
- VALUES ('DESINTA', 'IKA', 'Y', 'Y', 'Y',
- 'Pamulang Timur', 'Pamulang', 'Tangerang', 'Banten','15417', 'Indonesia',
- '0217413971','087809002724','0217413971','','[email protected]', 5, 9.5,
- 9.5, 'Y','20160523000000', ' ',
- 0,'20160523000000', 'Nadia', '20160524000000', 'Nadia'),
- ('NADIA', 'RESKY', 'Y', 'Y', 'Y',
- 'Pamulang Barat', 'Pamulang', 'Tangerang', 'Banten','15427', 'Indonesia',
- '0217413971','087809002724','0217413971','','[email protected]', 5, 9.5,
- 9.5, 'Y','20160523000000', ' ',
- 0,'20160523000000', 'Desinta', '20160524000000', 'Desinta');
- INSERT INTO t_user(
- user_id, tenant_id, username, email, fullname, password, phone,
- role_default_id, private_key, create_datetime, create_user_id,
- update_datetime, update_user_id, version, active, active_datetime,
- non_active_datetime, ou_default_id, policy_default_id)
- VALUES (10, 10, 'Desinta', '[email protected]', 'User Satu', 'user1', '083464363',
- 10, '9457c7ca3ae0dc907ad1703c15287d5c', '20160419194303', -1,
- '20160419194303', -1, 2, 'Y', '20160419194303',
- '', 10, 10),
- (20, 20, 'Nadia', 'user2gmail.com', 'User Dua', 'user2', '083464364',
- 10, '9457c7ca3ae0dc907ad1703c15287d5d', '20160419194304', -1,
- '20160419194304', -1, 2, 'Y', '20160419194304',
- '', 20, 20);
- INSERT INTO t_combo (
- combo_id, combo_name, description, combo_type,
- create_datetime, create_user_id, update_datetime, update_user_id,
- version )
- VALUES ('EMPLOYEEJOB', 'Combo Employee JOb', 'Constant Combo Employee Job', 'FIX',
- '20160726000000', -1, '20160726000000', -1,0 );
- INSERT INTO t_combo_value(
- combo_id, code, prop_key, code_group,
- sort_no, create_datetime, create_user_id, update_datetime,
- update_user_id, "version")
- VALUES('EMPLOYEEJOB', 'SALES', 'Sales', 'EMPLOYEE',
- 1, '20160726000000', -1, '20160726000000',
- -1, 0 ),
- ('EMPLOYEEJOB', 'PURCH', 'Purch', 'EMPLOYEE',
- 1, '20160726000000', -1, '20160726000000',
- -1, 0 ),
- ('EMPLOYEEJOB', 'FINANCE', 'Finance', 'EMPLOYEE',
- 1, '20160726000000', -1, '20160726000000',
- -1, 0 );
Add Comment
Please, Sign In to add comment