Login

wht · 17-06-23, 10:31 AM

Database Leaked signifycrm.com

Format - .SQL
Size sql file - 1,7GB
Date - 2023
All Rows - 4,6kk
Website - signifycrm.com

 Code:
    INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `email`, `password`, `mobile_phone`, `office_phone`, `remember_token`, `created_at`, `updated_at`, `active`, `verify_token`, `verified_at`, `crm_contact_id`, `is_admin`, `active_customer`, `last_login_at`, `login_at`, `last_order_billing`, `last_order_shipping`) VALUES

    INSERT INTO `caseline_s` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `assigned_user_id`, `no_s`, `current_status_s`, `status_s`, `case_id_s`, `date_s`) VALUES

INSERT INTO `cases` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `assigned_user_id`, `case_number`, `type`, `status`, `priority`, `resolution`, `work_log`, `account_id`, `category_id`, `document_id`, `due_date`, `first_response_date`, `location_id`, `mood`, `origin`, `provider_group_id`, `reference`, `reference_status`, `reference_type`, `request_date`, `resolution_date`, `resolve_first_call`, `response_date`, `show_portal`, `sla_profile`, `sla_profile_id`, `subject`, `ticket_id`, `expected_response_date`, `percent_complete_s`, `est_time_s`, `act_time_s`, `over_sla_s`, `work_log_s`, `is_send_mail_to_cr_contact_s`, `is_send_mail_resolution_s`, `is_send_email_worklog_s`, `already_send_mail_to_cr_contact_s`, `count_send_mail_s`, `segment_s_id`, `opportunity_id`, `contact_id`, `case_relate_id`, `script_id`, `currency_id`, `sub_total`, `tax_id`, `tax_rate`, `tax_amt`, `total`, `latitude_s`, `longitude_s`, `date_timestamp`, `work_target_id`) VALUES​

SAMPLE

Code:

INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `email`, `password`, `mobile_phone`, `office_phone`, `remember_token`, `created_at`, `updated_at`, `active`, `verify_token`, `verified_at`, `crm_contact_id`, `is_admin`, `active_customer`, `last_login_at`, `login_at`, `last_order_billing`, `last_order_shipping`) VALUES



(1, 'Super', 'Admin', 'serveradmin', '[email protected]', '$2y$10$pVv7v56RprJHbsDWD4mhjO0lwqU9iQx4spKVJQDBHVvWsyxK1kvs2', NULL, NULL, 'aKwzQLOS0VIC9ZcZpn4Jk8Dtd80Y80uNJIUWSB3tawsGW8nja07X2gCf9YPZ', '2021-04-20 02:58:30', '2021-04-20 02:58:30', 1, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL),

(2, 'keattisak', 'boonta', 'keattisakboonta', '[email protected]', '$2y$10$Y5SBvCXctfN95Z/lkaWv8uLLTiAQ3/1tOZpD3kfOa20JUbJ29YwUK', '', '', 'If1qHSO9ceo2tYRyjMA7ySqkS5vg12uJI7kNdAhxRFfGHYiIAmdauabv1eui', '2021-04-28 00:31:16', '2022-03-11 03:05:35', 1, '', '2021-04-28 14:31:28', 'ad35d4e7-bcd0-35d2-eda2-58773fbbc580', 0, 1, '2022-03-03 10:41:15', '2022-03-11 10:05:35', NULL, NULL),

(3, 'Wichak', 'Chongudomlert', 'wichak', '[email protected]', '$2y$10$S5IDOdG3gIyA0HsdMt3jnOuNq9lXg0G.vHCc7ultyrigxjzmHLfua', '', '', 'Wos43IEut57VAFxo4KZS3Umsr3iZh7kgVgwz69KNFMAZh4E1a3TT9W7YPXlt', '2021-04-28 00:31:16', '2022-01-05 06:02:23', 1, '', '2021-04-28 14:31:28', '6f0902cc-0ff5-4975-41d8-5449d79352dd', 0, 1, '2021-12-22 08:50:48', '2022-01-05 13:02:23', NULL, NULL),

(4, 'Daranee', 'P.', 'tracafe953', '[email protected]', '$2y$10$sc4CXFMA4VPqLoxE1Ik9IuserSghDiqnAzJY9YNY2SMjTBh9OM2OK', '', '', '', '2021-04-28 00:31:16', '2021-07-21 00:35:38', 1, '', '2021-04-28 14:31:28', '38b34483-102f-73c1-a535-5530bec356b0', 0, 1, '2021-07-02 16:21:23', '2021-07-21 14:35:38', NULL, NULL),

(5, 'Wichak', 'Chongudomlert', 'wichakc', '[email protected]', '$2y$10$sc4CXFMA4VPqLoxE1Ik9IuserSghDiqnAzJY9YNY2SMjTBh9OM2OK', '+66867660808', '+6628636038', '', '2021-04-28 00:31:16', '2021-07-21 00:35:38', 1, '', '2021-04-28 14:31:28', '69de0eb7-ffac-6b1a-d265-557a6ce41e13', 0, 1, '2021-07-02 16:21:23', '2021-07-21 14:35:38', NULL, NULL),

(6, 'pornpun', 'Aemisaard', 'pornpun', '[email protected]', '$2y$10$sc4CXFMA4VPqLoxE1Ik9IuserSghDiqnAzJY9YNY2SMjTBh9OM2OK', '+66814486277', '+662584966', '', '2021-04-28 00:31:16', '2021-07-21 00:35:38', 1, '', '2021-04-28 14:31:28', 'bdc8230a-5a81-98e0-191d-55a5c8db1ef5', 0, 1, '2021-07-02 16:21:23', '2021-07-21 14:35:38', NULL, NULL),

(7, 'Kanthima', 'Pongsri', 'kanthima', '[email protected]', '$2y$10$sc4CXFMA4VPqLoxE1Ik9IuserSghDiqnAzJY9YNY2SMjTBh9OM2OK', '', '+662-8122021', '', '2021-04-28 00:31:16', '2021-07-21 00:35:38', 1, '', '2021-04-28 14:31:28', '3946ed0a-99d5-6c09-fe73-55aca2cbcccb', 0, 1, '2021-07-02 16:21:23', '2021-07-21 14:35:38', NULL, NULL),

(8, 'Presale', 'Presale', 'presale', '[email protected]', '$2y$10$sc4CXFMA4VPqLoxE1Ik9IuserSghDiqnAzJY9YNY2SMjTBh9OM2OK', '', '', '', '2021-04-28 00:31:16', '2021-07-21 00:35:38', 1, '', '2021-04-28 14:31:28', 'a98fda84-d3b8-97a3-6b34-55e3cf582326', 0, 1, '2021-07-02 16:21:23', '2021-07-21 14:35:38', NULL, NULL),

(9, 'Weerapong', 'Ladsena', 'weerapongl', '[email protected]', '$2y$10$sc4CXFMA4VPqLoxE1Ik9IuserSghDiqnAzJY9YNY2SMjTBh9OM2OK', '+66941916362', '+66941916362', '', '2021-04-28 00:31:16', '2021-07-21 00:35:38', 1, '', '2021-04-28 14:31:28', '52b1e5a2-1b48-b92d-e341-562613a317d1', 0, 1, '2021-07-02 16:21:23', '2021-07-21 14:35:38', NULL, NULL),





INSERT INTO `caseline_s` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `assigned_user_id`, `no_s`, `current_status_s`, `status_s`, `case_id_s`, `date_s`) VALUES



('42fdefb5-c743-ad15-085e-595b40c4e677', 'Save By :: Narumol Seekhao', '2017-07-04 07:14:38', '2017-07-04 07:14:38', '4dfd6b72-f4a7-cf7c-eddd-53edb46bbe76', '4dfd6b72-f4a7-cf7c-eddd-53edb46bbe76', 'Status   :: In Progress\r', 0, '31be65dd-9a87-1951-19a2-56e67d262f93', NULL, 'In Progress', NULL, '83571f33-c10b-1c87-9d52-5954ea4bebe1', NULL),

('42ff76a8-743b-3e6a-cbd2-5a44df02f9bf', 'Save By :: Theewarin Poolthavee', '2017-12-28 12:10:07', '2017-12-28 12:10:07', '6c2c6af1-e8f3-c18c-fc8f-5530cd2bab63', '6c2c6af1-e8f3-c18c-fc8f-5530cd2bab63', 'Status   :: Closed\r', 0, '6c2c6af1-e8f3-c18c-fc8f-5530cd2bab63', NULL, 'Closed', NULL, '45889fab-2380-14e4-8144-5a44d64e23eb', NULL),

('430092fb-f96e-8b39-9811-5bcd7076da85', 'Save By :: dc3 corporation', '2018-10-22 06:39:36', '2018-10-22 06:39:36', '84124145-0aae-c802-d92c-5a5f05a4423e', '84124145-0aae-c802-d92c-5a5f05a4423e', 'Priority :: Medium\rStatus   :: Closed\rType     :: Carrot\r', 0, '84124145-0aae-c802-d92c-5a5f05a4423e', NULL, 'Closed', NULL, 'd2a148e3-d4da-d676-79e0-5bcd70b0880d', NULL),

('4300adf6-59ba-d145-d96c-550bd7c9cf64', 'Save By :: Ungkarn Ratana', '2015-03-20 08:16:53', '2015-03-20 08:16:53', '62a1e508-fbaa-6e3a-0e10-5477ec626f67', '62a1e508-fbaa-6e3a-0e10-5477ec626f67', 'Priority :: Medium\rStatus   :: Closed\rType     :: Carrot\r', 0, '62a1e508-fbaa-6e3a-0e10-5477ec626f67', NULL, 'Closed', NULL, '162bb2df-f00d-1f57-9633-550bd773ede5', NULL),

('4300e204-57be-9807-065d-5b7aa3014e17', 'Save By :: Narumol Seekhao', '2018-08-20 11:17:37', '2018-08-20 11:17:37', '4dfd6b72-f4a7-cf7c-eddd-53edb46bbe76', '4dfd6b72-f4a7-cf7c-eddd-53edb46bbe76', 'Status   :: Opened\r', 0, '475b92ec-f3c4-ff15-a30c-5a9384d8cd3e', NULL, 'Opened', NULL, 'ca5f3222-ff52-398c-bfb6-5b7a60b7db09', NULL),

('4301fca1-3a2f-60d6-a25c-63720dc93ea4', 'Save By :: Sirinun Sanepood', '2022-11-14 09:41:11', '2022-11-14 09:41:11', 'c6fe4147-8f5d-76cc-8ef2-53edfc1f459b', 'c6fe4147-8f5d-76cc-8ef2-53edfc1f459b', 'Status   :: Opened\r', 0, 'b315654e-d658-f6d3-d177-5a5f02447ea7', NULL, 'Opened', NULL, 'c8a11c87-0e0b-e4c6-3629-6371fffdb0b2', '2000-01-01'),

('4302485c-fdb7-64ca-0cff-5a0cf415646d', 'Save By :: Kanokrat Khanom', '2017-11-16 02:12:58', '2017-11-16 02:12:58', '2c0e0047-bf4e-c623-2234-55ee5d22842e', '2c0e0047-bf4e-c623-2234-55ee5d22842e', 'Status   :: Closed\r', 0, '31be65dd-9a87-1951-19a2-56e67d262f93', NULL, 'Closed', NULL, '1ffbb765-a321-0987-535f-5a06dcce361d', NULL),

('430355cf-26d0-52fc-16d3-59a64adba83b', 'Save By :: Theewarin Poolthavee', '2017-08-30 05:17:46', '2017-08-30 05:17:46', '6c2c6af1-e8f3-c18c-fc8f-5530cd2bab63', '6c2c6af1-e8f3-c18c-fc8f-5530cd2bab63', 'Priority :: Medium\rStatus   :: Closed\rType     :: Carrot\r', 0, '6c2c6af1-e8f3-c18c-fc8f-5530cd2bab63', NULL, 'Closed', NULL, '1c4c4d22-9419-1152-8408-59a64a765d36', NULL),





INSERT INTO `cases` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `assigned_user_id`, `case_number`, `type`, `status`, `priority`, `resolution`, `work_log`, `account_id`, `category_id`, `document_id`, `due_date`, `first_response_date`, `location_id`, `mood`, `origin`, `provider_group_id`, `reference`, `reference_status`, `reference_type`, `request_date`, `resolution_date`, `resolve_first_call`, `response_date`, `show_portal`, `sla_profile`, `sla_profile_id`, `subject`, `ticket_id`, `expected_response_date`, `percent_complete_s`, `est_time_s`, `act_time_s`, `over_sla_s`, `work_log_s`, `is_send_mail_to_cr_contact_s`, `is_send_mail_resolution_s`, `is_send_email_worklog_s`, `already_send_mail_to_cr_contact_s`, `count_send_mail_s`, `segment_s_id`, `opportunity_id`, `contact_id`, `case_relate_id`, `script_id`, `currency_id`, `sub_total`, `tax_id`, `tax_rate`, `tax_amt`, `total`, `latitude_s`, `longitude_s`, `date_timestamp`, `work_target_id`) VALUES



('81b34299-1e4c-f290-412e-5a8fe5976cd0', 'CS-18036182', '2018-02-23 09:59:21', '2018-02-23 10:00:22', 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', 'Subject : à¸£à¸§à¸µà¸žà¸£ à¸¥à¸¹à¸à¸„à¹‰à¸²à¸•à¹‰à¸à¸‡à¸à¸²à¸£à¹€à¸›à¸¥à¸µà¹ˆà¸¢à¸™à¹à¸›à¸¥à¸‡ email\r\nName : à¸£à¸§à¸µà¸žà¸£   \r\nSN : 0880001593214\r\nEmail : [email protected]\r\nTel : 0920945148\r\nDetail :à¸¥à¸¹à¸à¸„à¹‰à¸²à¸•à¹‰à¸à¸‡à¸à¸²à¸£à¹€à¸›à¸¥à¸µà¹ˆà¸¢à¸™à¹à¸›à¸¥à¸‡ email à¹€à¸”à¸´à¸¡[email protected] à¹€à¸›à¹‡à¸™[email protected]', 0, 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', NULL, 'Carrot', 'Closed', 'P2', NULL, NULL, '', '19f7c4ef-d939-3bca-6583-5434c9edbe36', '', '2018-02-24 10:00:00', '2018-02-23 09:45:00', NULL, NULL, 'Telephone', '196acd8f-cb0e-c78f-f72a-5427c4085d5b', NULL, 'Draft', 'CR Doc', '2018-02-23 10:00:00', NULL, 1, '2018-02-23', NULL, 'Carrot_Profile update_Medium', 'a3df391f-b1cf-b6ad-6564-543a109bff30', 'à¸¥à¸¹à¸à¸„à¹‰à¸²à¸•à¹‰à¸à¸‡à¸à¸²à¸£à¹€à¸›à¸¥à¸µà¹ˆà¸¢à¸™à¹à¸›à¸¥à¸‡ email', NULL, '2018-02-23 10:00:00', NULL, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 1, '', NULL, 'd8ad036c-cb71-625c-485b-566fdb45736d', NULL, NULL, NULL, 0.00, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, NULL),

('81b5c82a-517d-f382-8b52-630efc5d55a9', 'CS-22075192', '2022-08-31 06:17:25', '2022-08-31 06:19:22', '475b92ec-f3c4-ff15-a30c-5a9384d8cd3e', '475b92ec-f3c4-ff15-a30c-5a9384d8cd3e', 'Subject : à¹€à¸£à¸§à¸”à¸µ Carrot_Terminate Account - à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µ\r\nName : à¹€à¸£à¸§à¸”à¸µ\r\nSN : \r\nEmail :[email protected]\r\nTel :  0877941582\r\nPoint :0\r\nDetail : à¸•à¹‰à¸à¸‡à¸à¸²à¸£à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µ  à¹€à¸›à¸¥à¸µà¹ˆà¸¢à¸™à¹€à¸›à¹‡à¸™  [email protected] à¹€à¸žà¸·à¹ˆà¸à¹€à¸›à¹‡à¸™à¸à¸²à¸£à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µ " \r\n', 0, '475b92ec-f3c4-ff15-a30c-5a9384d8cd3e', NULL, 'Carrot', 'Closed', 'P01', NULL, NULL, NULL, 'd331c495-6859-216c-bf55-58d1e60dd301', NULL, '2022-09-01 06:12:00', NULL, NULL, NULL, 'Telephone', '196acd8f-cb0e-c78f-f72a-5427c4085d5b', NULL, 'Draft', 'CR Doc', '2022-08-31 06:12:00', NULL, 0, '0000-00-00', 1, 'Carrot_Terminate Account _Normal', '96b4b77e-a08e-c822-91b4-614bfd1863a5', 'à¹€à¸£à¸§à¸”à¸µ Carrot_Terminate Account - à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µ', 'T6546070461', '2022-08-31 06:12:00', 0.00, 0.00, 0.00, 0, NULL, 0, 0, 0, 0, 0, NULL, NULL, '59db1504-6b64-9cad-2f26-630efc72e8ab', NULL, NULL, '5b62e76a-3bee-6b84-bc82-5d8888986da5', 0.00, NULL, NULL, 0.00, 0.00, NULL, NULL, NULL, NULL),

('81b82975-f610-ae65-33d2-5ad5c10631a7', 'CS-18038849', '2018-04-17 09:40:35', '2018-04-17 09:42:46', 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', 'Subject :  à¸›à¸£à¸±à¸Šà¸à¸² Profile update\r\nName :   à¸›à¸£à¸±à¸Šà¸à¸² \r\nSN : 0880002121627\r\nEmail : [email protected]\r\nTel : 0840263348\r\nDetail :  à¸¥à¸¹à¸à¸„à¹‰à¸²à¸•à¹‰à¸à¸‡à¸à¸²à¸£à¹€à¸›à¸¥à¸µà¹ˆà¸¢à¸™à¹à¸›à¸¥à¸‡  email à¹€à¸”à¸´à¸¡  [email protected] à¹€à¸›à¹‡à¸™ [email protected]', 0, 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', NULL, 'Carrot', 'Closed', 'P2', NULL, NULL, '', '19f7c4ef-d939-3bca-6583-5434c9edbe36', '', '2018-04-18 06:30:00', NULL, NULL, NULL, 'Telephone', '196acd8f-cb0e-c78f-f72a-5427c4085d5b', NULL, 'Draft', 'CR Doc', '2018-04-17 06:30:00', '2018-04-17 04:00:00', 1, '2018-04-17', NULL, 'Carrot_Profile update_Medium', 'a3df391f-b1cf-b6ad-6564-543a109bff30', 'à¸›à¸£à¸±à¸Šà¸à¸² Profile update', NULL, '2018-04-17 06:30:00', NULL, 0.00, 0.00, 0, NULL, NULL, NULL, NULL, NULL, 1, '', NULL, '3d6a6b12-3b45-f417-e479-5ad5c15ccbc8', NULL, NULL, NULL, 0.00, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, NULL),

('81ba0310-18ed-fd96-b510-5abde40c4703', 'CS-18038171', '2018-03-30 07:15:45', '2018-03-30 07:15:45', 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', 'Subject : Rotsukhon à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µà¸ªà¸¡à¸²à¸Šà¸´à¸\r\nName : Rotsukhon    \r\nSN : -\r\nEmail : [email protected]\r\nTel : 0809009590\r\nDetail : à¸•à¹‰à¸à¸‡à¸à¸²à¸£à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µ [email protected] à¹€à¸›à¸¥à¸µà¹ˆà¸¢à¸™à¹€à¸›à¹‡à¸™ [email protected] à¹€à¸žà¸·à¹ˆà¸à¹€à¸›à¹‡à¸™à¸à¸²à¸£à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µ ', 0, 'c6fba9d4-c78b-59ab-14bc-5a5ef6476d73', NULL, 'Carrot', 'Closed', 'P2', '', NULL, NULL, 'd331c495-6859-216c-bf55-58d1e60dd301', '', NULL, NULL, NULL, NULL, 'Telephone', '196acd8f-cb0e-c78f-f72a-5427c4085d5b', '', 'Draft', 'CR Doc', '2018-03-30 07:15:00', '2018-03-30 04:00:00', 1, '2018-03-30', NULL, '', '', 'Rotsukhon à¸¢à¸à¹€à¸¥à¸´à¸à¸šà¸±à¸à¸Šà¸µà¸ªà¸¡à¸²à¸Šà¸´à¸', NULL, NULL, NULL, 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 0, '', NULL, '9ec283e3-7c2e-5086-3dc8-5abde4eb9d46', NULL, NULL, NULL, 0.00, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, NULL),

('81bac1a0-0575-d26a-8684-58b4e3d7f1ad', 'CS-17024465', '2017-02-28 02:42:18', '2017-02-28 02:42:18', '682004b3-b7d3-da28-f7fd-543f2e73948f', '682004b3-b7d3-da28-f7fd-543f2e73948f', '', 0, '682004b3-b7d3-da28-f7fd-543f2e73948f', NULL, 'Carrot', 'Closed', 'P2', '', NULL, NULL, '19f7c4ef-d939-3bca-6583-5434c9edbe36', '', '2017-03-01 02:45:00', NULL, NULL, NULL, '', '196acd8f-cb0e-c78f-f72a-5427c4085d5b', '', 'Draft', 'CR Doc', '2017-02-28 02:45:00', NULL, 0, '2017-02-28', NULL, 'Carrot_Profile update_Medium', 'a3df391f-b1cf-b6ad-6564-543a109bff30', 'Update profile', NULL, '2017-02-28 02:45:00', NULL, 0.00, 0.00, 0, '', NULL, NULL, NULL, NULL, 0, '', NULL, '98c1d750-8619-4739-683e-58b3b00c87bc', NULL, NULL, NULL, 0.00, NULL, NULL, NULL, 0.00, NULL, NULL, NULL, NULL),

Hidden Content

You must register or login to view this content.

wirocnwiwogmailcom · 17-11-23, 01:44 PM

thank you

white1212 · 17-11-23, 06:10 PM

thanks!
Working

FancyGrad · 29-07-24, 08:13 PM

Thank you

Extras

Account

Useful Links

ABOUT US

Login


Lost Password? Remember me