(11135,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6ImF5dTlyUmc0UzBPMHpRVFM1Qlp3RUE9PSIsInZhbHVlIjoiTGNmYjlPejdVZ0hkdmp6TlY2VE9PWWV0dkRORjgrVW92UE85VVlnNFVUNDh3NnFXVE1HbGsvSWVzd2RKRmVqRCIsIm1hYyI6ImRkMzdiNmMwMGU1ODc0YjI4NTQwMzUxMjVlMjA5OGE1YjRlMjUwZWY0MTRiY2M5Njc4YmVhMWIzMmQ1N2RlMWEiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:25:56'),
(11136,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Imd3U0c2cDQyTWRqTlJCeC9VYkRVS1E9PSIsInZhbHVlIjoiWjBnVEhIOVlNdTdWb1o1NUVkanRxY01ZM2pOWGxKTGt6QmdBVFF1ZjJpdFpwWU5OZE1OQ1p4Y01MajkxeVhPZSIsIm1hYyI6IjBmOGRjN2YwYzRhMzQzYjM3YmVmNTg2NzAxMzQxZmE1OGZhNjI4N2I3MWM3NzYzYjc2OTljNmI3N2YxNWFhNmYiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:27:46'),
(11137,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6InptZGwwcFROaDNkSU1OVXZRaXpKOXc9PSIsInZhbHVlIjoiRjBPSk9xWFpKREt4ajV6bUhYV2FCc0lPRHNVS282SWxUNjk2bE1URFRRazJrdU1kK3phZUlsNThsOU5SanQ3TyIsIm1hYyI6IjFkYzdkNDhhMDFiZmRlZTU5ZTY4ZWM4ZDAxYTlhYjczYzczZDNjNjgzYTMzYTVjZTJlNmI4ODM2YzIwM2IwYjQiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:31:22'),
(11138,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6ImJPRVp3ZEUvQnBRTE5MVXdmOTVsdXc9PSIsInZhbHVlIjoiTkQ3RGd5UmJST1BtSGtOaHVLK1NHd25JYlN3SjlONklMQjlIa1IwVzBTZVdJd2Uvb0ZIVjQ2OWcxdDYzbytVTCIsIm1hYyI6IjQ1OTYwZjM2NjkxYjljYjI3N2IzYzQ3NDM0ZDk3YjZmZDU4YzA5MTEyMjkyMTYzNGQ3M2U5NzI4MDU3OTJmNTEiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:31:58'),
(11139,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6ImRpRTVOSXVkNllscW1Vc3NMUkdhM2c9PSIsInZhbHVlIjoiMFRtM3hEN1FDdWFMMlNERzZCUVF6cG5OYTNPWlB1dmZVVytWN3JJcVQ2V0NaTk9TZ1hFZ1J2cktMLzJCMUF0RCIsIm1hYyI6IjJjYmJhYjJmNDA0ZTJkZjhkNzNmMjMwYjM2MjllNTYzNjNkMWFjN2JmZTU4ZjEyMzkwZTk5Mjc0YjkwZDE3ZDMiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:32:15'),
(11140,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6IkszNHJUdFBhQjZXNTZPN0dHVTVML0E9PSIsInZhbHVlIjoiQWlQcVV5MWJNYzBPMmt3aTJRQ1dxY2pNZjk3NmdxQkFxVnlMYUMvaVJtTWpZZWp5YVduTkk3TXJ2UWxqN1pzeCIsIm1hYyI6IjZiOWVmZTkwZWI0MzU4Njk5ZTY0ZDY2OTA4ZDNjN2Q2NThlZjA0ODg1YzQ0MDNjNDBjMmE2NjA3NTc0NDkwZjMiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:32:25'),
(11141,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6InZDdGpGZWw4YXRlam9Bb3dsMW9zMlE9PSIsInZhbHVlIjoiV3hmcE5ydDFiYXJuTmxRZ0dBdnJ6eTd4VjAySTgrT1lobFBlUUI0ekR0YTZuZkRJY1Y0dEVqcW1UZHkxQmlUYSIsIm1hYyI6ImFiY2FjODJjNDI5NGVlZDJhNTY4NDY5NmNmZWZiMzFkMWRhZWZiZWY3NDFhYTZiYjRiZjI2ZTQ5NWIyMzY2NzYiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:32:40'),
(11142,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6InhhKzFibmIwVkN2cUkxVnQxOTA5QkE9PSIsInZhbHVlIjoiRnNMc3VRa3FiYjRqN1UxRzZXdEthSUdLTnU1bVFsN3RDeStVR0RTWStlVUM1WGl1RGk3TlVlMy9wTUVjK1hRcSIsIm1hYyI6ImJhYjllY2I0YTM1ODY4YjQ3OGYxMGRhMTJlMDAzODcyZGU1ZDJjNTIwM2IxYWRhMGNhZTgxZWY5ZTljYzI3NWUiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:32:51'),
(11143,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Ik1STnBCVzJKeU5Oem8yUmUxS1RDWGc9PSIsInZhbHVlIjoiaTNzanZ6dlQ3R1ZhU250bzFwVmRoVVl5dHhQSEZWSW9kQmRCeDlOblBoT3V3MEZEQmd2dVVSS1pVSVd3YkdoaiIsIm1hYyI6ImIyNGMyNjAwOTlkMjM4ODZkYTlhMTQ3M2ZhNjdlZjkwYjcyZmQ1NjVhNjg1MmVmODQxNThkMTBhNWUzODIzMDciLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:32:57'),
(11144,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6IkxTdDRMaUF3cDZtaGVnVDhvZkUvT2c9PSIsInZhbHVlIjoibXk4ZkdEZkFydDB0YmRDVGhsRm9QWDVUSk8yK2FXS05ZYUEzOE84cWo4a3VpOFhhcTQwQlMyTFR2cHlXT2t0OSIsIm1hYyI6IjRkMzIzYjk2N2MyMThlNDAzYzUwYjNmNTcxZmUwZTVkYTNjMDU4Y2NhOGMxN2E3ZDIyMmY2NjBkM2M2NjU1NzUiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:33:02'),
(11145,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6ImJJOHBxVUNBdUJ3YUJjbm1jcmhmMFE9PSIsInZhbHVlIjoielMxUnZHUHgyYkJLdjdpTWswUzlPRnk3YnRBcGtSeUt3MDJyeUpwU0ZJRUVicCtVT2pXTHMxNFMxNmM5Z25YZiIsIm1hYyI6Ijc0N2I5YzJlNDQ2NDNjMThiNjE0MjRlOWRiYjM2MmFkMTZkNzkyYjU1NDUwYTY4YzgyNzU2MjI2MmU1NTRiNzIiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:33:21'),
(11146,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6InNGNkdCczNJcHhCR09DWGJuTnZqL3c9PSIsInZhbHVlIjoid1JlR0JrUlZzWERHcXA1YllSTTFidGlEbU50ZitxVnFlTlFTRFNkSEdSM2ZOTmtGTytOWjZaNG1DSWZSUXNqUCIsIm1hYyI6ImNjNTAzYTdiOGNkZDFhZTY0Mjg1NWI0MDdkMzMxZWM0MWJkMzIxZjBiOGNhZWIyZmJhYjkyODZkNTAwYTcxMzUiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:37:02'),
(11147,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6Ik04Y1RiL1JjTkp3cXgvRHhVd0ZUUnc9PSIsInZhbHVlIjoiZlJ3WVZvMTNaaEh2bVgvNXF2Y2VLQT09IiwibWFjIjoiNDA4ZjgyNTRjMTBhZmZmNWE1ZjQ0YzZhY2I5YWRjZWYwMjU3YmVlZTRmOTgzMzhhMDI3NzljYjliYTM1ZTc2ZiIsInRhZyI6IiJ9',	NULL,	'[encoded data, 5176 characters]',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:37:12'),
(11148,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkREM3laUU0wRk40a3JZN25oclVGaWc9PSIsInZhbHVlIjoiaVpOV2lBeld6clA3bkl5cHIzR0pCZz09IiwibWFjIjoiMzYxY2U0OWQ4NmI2ODRlODRkZjBiOWFhNmZmODZhNzhiODZkMWU0NjVjNWJkYmRhNzZlNjcxMjE4ZTkyZjViZCIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Imt2SjBHVHdqdUVRSFVuTUpVMDZacXc9PSIsInZhbHVlIjoiZ1c0VTlMbzZ5aEtnSkFVaHJUcEYzSnN3NnlzS3RNNEFTNnptTlFWOW9FdWE4QWVSTElTdHNvTk41SU1sNjR0VCIsIm1hYyI6ImY0OWIyNjcxZThhNmZhODViMTI1YTZkMzlkZDA1ZTNmOTEwZTk4NDM5ODY1ZmNkNzMyNzQyZjJlOTAzMDJhMWMiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:49:09'),
(11149,	'http://localhost/laravel/browsepets/public/place-ad/health-tests/eyJpdiI6Iit0eWcwTXpSU2FEZXJrZ0gwbzJYZGc9PSIsInZhbHVlIjoiTkVERVJ2NE5ZVEVWT3N1SE91alpsdz09IiwibWFjIjoiODgzZDI5MzMxZTlmZTgxNTIwNTA3ODEwNTNhZjRlNDdjNzk1YmE1N2EwYTk2ZjcxOGJhNzZmYzQ2ZDJmOWZkNiIsInRhZyI6IiJ9',	NULL,	NULL,	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:49:29'),
(11150,	'http://localhost/laravel/browsepets/public/place-ad/pedigrees-search',	NULL,	'eyJpdiI6IlFENWZSSlJJTG1wMHRQV0VTOFd1YUE9PSIsInZhbHVlIjoiTTl2RVEvTloyZGMxcEoxZ2hWb20vQldZamJmVkE4R2tzNTNMZi90TFc2OUFmVEYzZUtiVE5kQ3Fva1VBZWpMeiIsIm1hYyI6IjI1MWQzOTZmY2I0MWRmYzg4NDMxNTdlMTMxMTBhZTU1ZGY0OWI3NWY1NGQ3MDIzZmEwMGJjYmRiNzA0OGVkMzEiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:49:34'),
(11151,	'http://localhost/laravel/browsepets/public/place-ad/pedigrees-search',	NULL,	'eyJpdiI6IkNuVWtONllCODVSUHI3Ky93aWVUZ1E9PSIsInZhbHVlIjoiY1cyaEVhLzlESE0yMCt1cTQweHZzNE9ldnVkNjdyQjdNby9obERBR21mQXBDTnRDOHJUdTl0QkF5YmtEZEdsN1lxNm92WHNpZERhU0JaNlg3K2FmSXc9PSIsIm1hYyI6Ijk5YWZiYmU4OTc5M2I1YjYzZDIxODcxMTU1YjIzNjkzOGJmZjkwMWVkZDNmZjhiZjRkMjM3YjFiMDMyYTFlZDMiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:49:35'),
(11152,	'http://localhost/laravel/browsepets/public/place-ad/health-tests/eyJpdiI6ImJsdnNiRFRITWRkNDI2K2swdVI3WkE9PSIsInZhbHVlIjoiZ0lUVFE4SUhLcVRpYWRCMzlzbGRTZz09IiwibWFjIjoiZWEzYjI1ODUzYzQzNDhlYjhmOWFhMzg1NjM5YjNkYmUwZTRmNWZlOWVjYzkzODNhMGFhYWIyOTZkZDkxZmQxNyIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Ik5Qc0todzR6OGZpWVdpT0pFLzZvYUE9PSIsInZhbHVlIjoiUTEzek5iSVh4NU9KeWN2eXlHdUs1dTZKZk1vdGJ5Slh3K1QwSEJLNy84SzBqcWFFRXFjeUZ6ZkRtZ1NGT1dMd1JNR3ljdnAxUzJFUlhqbzFiY0FvNnphYVhiWFJCZnlXVnVudUFvcEFOb3RCaWpnSFJoS3lKL0tVZ3NONG9BdTEiLCJtYWMiOiJjZjMzMTdiMzdjOGZlN2FhMzNiZGI2NWJjZDkxY2ExNDI0NTYzNzEwNzg0YTdhNmZmZWEyYTY3MWZlYmMwYzZlIiwidGFnIjoiIn0=',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:49:37'),
(11153,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6ImFWYnJRUWEzRS96T1lqL2hyb3hLOXc9PSIsInZhbHVlIjoiOWthSHNxSlVDenc4UENUZFJOUjNBQT09IiwibWFjIjoiNTBkODUzM2MwYjBlYmFhNjVlYTA1NjY5ZTFkNGFlZWUyMjgwYWRjY2RkODc3NzhiNmQ5NjAzNDEzYTc0ZDY0NyIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6ImRseVUwbUpTaE1tK1RzN1hhQ2xNMWc9PSIsInZhbHVlIjoiZGs1dXVVSWhMWFA2U1MyUmVYVDdNVDQxWXNCd2dwNVRzT1RNbHJYbWVzdVZqMm5HaEZQWlAvMTQwRStUeWkvRiIsIm1hYyI6ImQxOWE4MWExMWVmOWNkZGFmNjYxMTgwYzFlOTYxMWYxZTBiZDFlODM1MzM5MTkzNDVjNGJkYWE4MDdiZWU2NGEiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:49:37'),
(11154,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6ImFWYnJRUWEzRS96T1lqL2hyb3hLOXc9PSIsInZhbHVlIjoiOWthSHNxSlVDenc4UENUZFJOUjNBQT09IiwibWFjIjoiNTBkODUzM2MwYjBlYmFhNjVlYTA1NjY5ZTFkNGFlZWUyMjgwYWRjY2RkODc3NzhiNmQ5NjAzNDEzYTc0ZDY0NyIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6IkxyRzZlUUlCbmFvQVFWOHpOQ3E3T2c9PSIsInZhbHVlIjoiUlRvNXNsRDBSTjVFMWljL1BsMW1lS1c2azRiRFdJTU82TEN3dUR2aVJ2eEZON0Y3Y3Rsa2xwSHVKV2lhRXNSMSIsIm1hYyI6IjViMGI1Mjg4ZDc4ZDNjMTEzMzQ5ZWFkYTk1N2NhYmFjZGE2M2QwNjZjNDdmZTgxZjk0OGYyZjc4MTg2MTY1ZGYiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:52:10'),
(11155,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IncvSzJjUGZMdVcxc05JRFFQVU1qWmc9PSIsInZhbHVlIjoidEFwZ2NDZ2o4SUdVSmNqTGJJNCtIZz09IiwibWFjIjoiYTcwN2ZhODI4ZjM2N2UzMWZmOTc3OTUyNDJmMjE3NzMzODFiMDI5OTkxZWYxMmU0M2FmZDc5NjA0OTEyOTgzNyIsInRhZyI6IiJ9',	NULL,	'[encoded data, 5236 characters]',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:52:17'),
(11156,	'http://localhost/laravel/browsepets/public/place-ad/plans/eyJpdiI6IjdoOGM2V09uS1dWSmE1ZWtCb24vblE9PSIsInZhbHVlIjoiOGJGQW9BWCsyT3R6TUFBWkhidHhnZz09IiwibWFjIjoiOThmNjRjNDZlZDVjZmE2OGNkOWM0NjM3YjdiNWFlYTkwM2EyZWVhZDc5Mzc1NjhjOGQxMzVhMDAyMWQyY2ZiZSIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Ik12dUp6UUpYK2tJWHExeGNwaEhVQlE9PSIsInZhbHVlIjoiNmZURGw3cEthQVVwQUFlVS9NMUovNmZNZzhyQjkrbG1KdGlyY0sxL2ZNSUVYTWRNSS95T3QyaFZsR1dIVjRveCIsIm1hYyI6ImU1NDQ5ZmI0NDVmOTM0MDNiYzdmOGFjN2FkZDc5YzM1ZTZlZWVjOTY3ZjM4MDk3NmZkMGRkMWUxNmYxYWRjNWUiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:52:18'),
(11157,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6ImFWYnJRUWEzRS96T1lqL2hyb3hLOXc9PSIsInZhbHVlIjoiOWthSHNxSlVDenc4UENUZFJOUjNBQT09IiwibWFjIjoiNTBkODUzM2MwYjBlYmFhNjVlYTA1NjY5ZTFkNGFlZWUyMjgwYWRjY2RkODc3NzhiNmQ5NjAzNDEzYTc0ZDY0NyIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6IjlsTDVjclMzOUxDMUE2Vm01UFpZMHc9PSIsInZhbHVlIjoiNFVhZXJwdDZKNXg2L0c5WGJiekJ3UUg1dk1NZUowRzVFNGRDYkhqcmlla0R5YklNVEl2eTNOeEROMUlzT3huZyIsIm1hYyI6IjhlOWU4NTI0Njk5MWQ2MTg2MTI2M2U5MmEwOTFmY2UwMjM2YTdmM2FlZWNkM2E2NDAxYWU1ZGRiMmM3ZTRiMzAiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:52:56'),
(11158,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6ImFWYnJRUWEzRS96T1lqL2hyb3hLOXc9PSIsInZhbHVlIjoiOWthSHNxSlVDenc4UENUZFJOUjNBQT09IiwibWFjIjoiNTBkODUzM2MwYjBlYmFhNjVlYTA1NjY5ZTFkNGFlZWUyMjgwYWRjY2RkODc3NzhiNmQ5NjAzNDEzYTc0ZDY0NyIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Im1uSUtBejhJRUVXT0xNTHNCSXI0V0E9PSIsInZhbHVlIjoiVHh2QVlPWTRjYSt2WThIalRWcTZnTlF1QkpPSlNJeGE2QzRXbEw0VHRUZHBxZkpJN09sVUU2c0dHTTZIREFUWSIsIm1hYyI6IjkxZTg4MjRhMWRkZmFjZjcwZGY0MTdkMjNkZDY0NmJlOTI0ZTgyYTZhOWY4NmE0YWU0NzdlODk0MjI2MmFkYmYiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:55:54'),
(11159,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IlB3SExZdUtoWTE5b0UrMExQRDdMbFE9PSIsInZhbHVlIjoiYUNudzVnd3ZZUTIyb0hQOHZyVFV2QT09IiwibWFjIjoiOTE1ZGEzYzViMjcxMGI1YWVhYjgxNDA5ZTcwM2RhODA2MTI1NDY4YjU3ZWIwNmEwZjE1YzI1YTdlMmMxY2RjOCIsInRhZyI6IiJ9',	NULL,	'[encoded data, 5236 characters]',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:55:57'),
(11160,	'http://localhost/laravel/browsepets/public/place-ad/plans/eyJpdiI6Ink1MVN5eksvTXBMRkRkMWhrbFlTSWc9PSIsInZhbHVlIjoieWd5cnE4WUxrUEJjMUY2YjlKNVdRdz09IiwibWFjIjoiNjJiNjRmZmEwZWYzNDc0NjJkNTQ3OWIzMWY0NzlkNDlkN2I4NzdhZWQ5YWJiNWE4MWI5YmNlYTU1MTExMTM2NiIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6InJkQndVVVVDTEp5QmxveEpHMU5rdEE9PSIsInZhbHVlIjoicEZWZEV0SDZJZGhJUW9SVjlFeFhqTStiUnhHcTdJTk1tbkk0K2FTWkg2eXRveDhXcDN3SGRIWFJmR3JsazZVYSIsIm1hYyI6IjFjYTQwNmM0OGMyNTc1M2UzMzAyYTBkODcwNjI3M2I5ZTRkNGZkNDgwYWI0OTVmMjJhMDc3MmZkZWI1MDk2NGUiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 18:55:57'),
(11161,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkpKcmtWQ1F4Yks1aDd6UWV0Q0dlMHc9PSIsInZhbHVlIjoiSTZPOFV2R1l4dUh0SS9SL1FVRG0yQT09IiwibWFjIjoiMmY3YjY2NTRjYmE2YTc2MDExMGVlMTQ4NGFmZTJhZTdkYzhjZWVhMWE2OTVkZjI5MTUyNmVlYjgzMjBhZTM4MSIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Ik1xSS9jcnZEU2g0bzc2TXNQRG9oT0E9PSIsInZhbHVlIjoiUmkvS0x5MEE5Q1dZVEZIM1lWZk9WVkk4dk1mK0EvTnkyM2s2ZTMxRkpnSE5rQ2RKQ3A4MjFmekF0T2FUaldxeCIsIm1hYyI6IjI0NzZkOTJjZDU4YTgxMjUxNTE0Y2QwNzVjODY5YzExMmIxMDU5NjA3MGRhZmVmZGQ1NDYwMzRjODdhOWJiMjIiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 19:13:40'),
(11162,	'http://localhost/laravel/browsepets/public/place-ad/pedigree/eyJpdiI6IkpKcmtWQ1F4Yks1aDd6UWV0Q0dlMHc9PSIsInZhbHVlIjoiSTZPOFV2R1l4dUh0SS9SL1FVRG0yQT09IiwibWFjIjoiMmY3YjY2NTRjYmE2YTc2MDExMGVlMTQ4NGFmZTJhZTdkYzhjZWVhMWE2OTVkZjI5MTUyNmVlYjgzMjBhZTM4MSIsInRhZyI6IiJ9',	NULL,	'eyJpdiI6Imk3dTFIc2lPWDNhWjVRTDg3d1IvTkE9PSIsInZhbHVlIjoib2tmRWdNdUtuT0VXODhxemJQQnA0L2NEcGpQeEF0Y1VwWmNXUTN4VFBrK1p5NWV3cHFxWXN1MysvdmcxWE1NQSIsIm1hYyI6IjQzMjZkMzc0Yzc2M2EyN2UzODZkZWMxNmI4NDU2NTkxMjFjMGFkZDJhZWQ5NTQ1ZGM0ZmYwM2IwZTYzMjBjNjIiLCJ0YWciOiIifQ==',	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 19:13:43'),
(11163,	'http://localhost/laravel/browsepets/public',	NULL,	NULL,	NULL,	NULL,	'::1',	'Windows 10 x64',	'Chrome',	'2022-12-27 19:22:08');

CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `otp` varchar(50) DEFAULT NULL,
  `otp_sent_on` datetime DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `address` tinytext DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `admins` (`id`, `first_name`, `last_name`, `email`, `password`, `phonenumber`, `last_login`, `is_admin`, `otp`, `otp_sent_on`, `token`, `image`, `created_by`, `status`, `deleted_at`, `created`, `address`, `modified`) VALUES
(7,	'Browse4Pets',	'Admin',	'admin@globiz.com',	'$2y$10$w1UHx/8gB62cidQlN3SJt.Cl2yGxp51vxOzN2LpQrHeq3gFOFsblm',	'+448845241732',	'2022-12-09 16:42:16',	1,	NULL,	NULL,	'GacSmCOgkgEJ4SrcP5B51PnjqorJQuN8',	'/uploads/admins/1660298297322-element.png',	1,	1,	NULL,	'2021-02-20 08:48:20',	'Dummy Address , Ludhiana - 141001',	'2022-12-09 11:12:16');

CREATE TABLE `admin_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_id` int(11) NOT NULL,
  `admin_id` int(11) NOT NULL,
  `mode` enum('listing','create','update','delete') COLLATE utf8_bin NOT NULL,
  `created_by` int(11) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `permission_id` (`permission_id`),
  KEY `admin_id` (`admin_id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `admin_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_permissions_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_permissions_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


CREATE TABLE `breeds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `breeds_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `breeds` (`id`, `title`, `slug`, `image`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(2,	'Akita',	'akita',	NULL,	7,	NULL,	'2022-07-19 13:06:17',	'2022-07-19 07:36:17'),
(3,	'Basenji',	'basenji',	NULL,	7,	NULL,	'2022-07-19 13:06:30',	'2022-07-19 07:36:30'),
(4,	'Bulldog',	'bulldog',	NULL,	7,	NULL,	'2022-07-19 13:06:56',	'2022-07-19 07:36:56'),
(5,	'Bearded Collie',	'bearded-collie',	NULL,	7,	NULL,	'2022-07-19 13:07:19',	'2022-07-19 07:37:19'),
(6,	'Cairn Terrier',	'cairn-terrier',	NULL,	7,	NULL,	'2022-07-19 13:07:33',	'2022-07-19 07:37:36'),
(7,	'Dalmatian',	'dalmatian',	NULL,	7,	NULL,	'2022-07-19 13:07:50',	'2022-07-19 07:37:50'),
(8,	'English Setter',	'english-setter',	NULL,	7,	NULL,	'2022-07-19 13:08:07',	'2022-07-19 07:38:11');

CREATE TABLE `cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `state_id` (`state_id`),
  CONSTRAINT `cities_ibfk_1` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `cities` (`id`, `name`, `state_id`, `status`, `created`, `modified`) VALUES
(1,	'Default',	1,	1,	'2022-09-13 11:11:00',	'2022-09-13 05:41:00');


CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `contact_us` (`id`, `first_name`, `last_name`, `email`, `phonenumber`, `subject`, `message`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(2,	'SURESH',	'KHANNA',	'suresh.globiztechnology@gmail.com',	NULL,	'hello',	'hello hi',	1,	NULL,	NULL,	'2022-08-27 12:21:59',	'2022-08-27 06:51:59'),
(3,	'123',	'123',	'123@gmail.com',	NULL,	'123',	'123',	1,	NULL,	NULL,	'2022-08-27 12:23:20',	'2022-08-27 06:53:20'),
(4,	'123@',	'123@',	'123g@gmail.com',	NULL,	'123@@@',	'qwerty',	1,	NULL,	NULL,	'2022-08-27 12:26:01',	'2022-08-27 06:56:01');

CREATE TABLE `countries` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `iso2` char(2) DEFAULT NULL,
  `short_name` varchar(80) NOT NULL DEFAULT '',
  `long_name` varchar(80) NOT NULL DEFAULT '',
  `iso3` char(3) DEFAULT NULL,
  `numcode` varchar(6) DEFAULT NULL,
  `un_member` varchar(12) DEFAULT NULL,
  `calling_code` varchar(8) DEFAULT NULL,
  `cctld` varchar(5) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `countries` (`id`, `iso2`, `short_name`, `long_name`, `iso3`, `numcode`, `un_member`, `calling_code`, `cctld`, `status`, `created`, `modified`) VALUES
(1,	'AF',	'Afghanistan',	'Islamic Republic of Afghanistan',	'AFG',	'004',	'yes',	'93',	'.af',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(2,	'AX',	'Aland Islands',	'&Aring;land Islands',	'ALA',	'248',	'no',	'358',	'.ax',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(3,	'AL',	'Albania',	'Republic of Albania',	'ALB',	'008',	'yes',	'355',	'.al',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(4,	'DZ',	'Algeria',	'People\'s Democratic Republic of Algeria',	'DZA',	'012',	'yes',	'213',	'.dz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(5,	'AS',	'American Samoa',	'American Samoa',	'ASM',	'016',	'no',	'1+684',	'.as',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(6,	'AD',	'Andorra',	'Principality of Andorra',	'AND',	'020',	'yes',	'376',	'.ad',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(7,	'AO',	'Angola',	'Republic of Angola',	'AGO',	'024',	'yes',	'244',	'.ao',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(8,	'AI',	'Anguilla',	'Anguilla',	'AIA',	'660',	'no',	'1+264',	'.ai',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(9,	'AQ',	'Antarctica',	'Antarctica',	'ATA',	'010',	'no',	'672',	'.aq',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(10,	'AG',	'Antigua and Barbuda',	'Antigua and Barbuda',	'ATG',	'028',	'yes',	'1+268',	'.ag',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(11,	'AR',	'Argentina',	'Argentine Republic',	'ARG',	'032',	'yes',	'54',	'.ar',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(12,	'AM',	'Armenia',	'Republic of Armenia',	'ARM',	'051',	'yes',	'374',	'.am',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(13,	'AW',	'Aruba',	'Aruba',	'ABW',	'533',	'no',	'297',	'.aw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(14,	'AU',	'Australia',	'Commonwealth of Australia',	'AUS',	'036',	'yes',	'61',	'.au',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(15,	'AT',	'Austria',	'Republic of Austria',	'AUT',	'040',	'yes',	'43',	'.at',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(16,	'AZ',	'Azerbaijan',	'Republic of Azerbaijan',	'AZE',	'031',	'yes',	'994',	'.az',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(17,	'BS',	'Bahamas',	'Commonwealth of The Bahamas',	'BHS',	'044',	'yes',	'1+242',	'.bs',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(18,	'BH',	'Bahrain',	'Kingdom of Bahrain',	'BHR',	'048',	'yes',	'973',	'.bh',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(19,	'BD',	'Bangladesh',	'People\'s Republic of Bangladesh',	'BGD',	'050',	'yes',	'880',	'.bd',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(20,	'BB',	'Barbados',	'Barbados',	'BRB',	'052',	'yes',	'1+246',	'.bb',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(21,	'BY',	'Belarus',	'Republic of Belarus',	'BLR',	'112',	'yes',	'375',	'.by',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(22,	'BE',	'Belgium',	'Kingdom of Belgium',	'BEL',	'056',	'yes',	'32',	'.be',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(23,	'BZ',	'Belize',	'Belize',	'BLZ',	'084',	'yes',	'501',	'.bz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(24,	'BJ',	'Benin',	'Republic of Benin',	'BEN',	'204',	'yes',	'229',	'.bj',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(25,	'BM',	'Bermuda',	'Bermuda Islands',	'BMU',	'060',	'no',	'1+441',	'.bm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(26,	'BT',	'Bhutan',	'Kingdom of Bhutan',	'BTN',	'064',	'yes',	'975',	'.bt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(27,	'BO',	'Bolivia',	'Plurinational State of Bolivia',	'BOL',	'068',	'yes',	'591',	'.bo',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(28,	'BQ',	'Bonaire, Sint Eustatius and Saba',	'Bonaire, Sint Eustatius and Saba',	'BES',	'535',	'no',	'599',	'.bq',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(29,	'BA',	'Bosnia and Herzegovina',	'Bosnia and Herzegovina',	'BIH',	'070',	'yes',	'387',	'.ba',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(30,	'BW',	'Botswana',	'Republic of Botswana',	'BWA',	'072',	'yes',	'267',	'.bw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(31,	'BV',	'Bouvet Island',	'Bouvet Island',	'BVT',	'074',	'no',	'NONE',	'.bv',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(32,	'BR',	'Brazil',	'Federative Republic of Brazil',	'BRA',	'076',	'yes',	'55',	'.br',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(33,	'IO',	'British Indian Ocean Territory',	'British Indian Ocean Territory',	'IOT',	'086',	'no',	'246',	'.io',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(34,	'BN',	'Brunei',	'Brunei Darussalam',	'BRN',	'096',	'yes',	'673',	'.bn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(35,	'BG',	'Bulgaria',	'Republic of Bulgaria',	'BGR',	'100',	'yes',	'359',	'.bg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(36,	'BF',	'Burkina Faso',	'Burkina Faso',	'BFA',	'854',	'yes',	'226',	'.bf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(37,	'BI',	'Burundi',	'Republic of Burundi',	'BDI',	'108',	'yes',	'257',	'.bi',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(38,	'KH',	'Cambodia',	'Kingdom of Cambodia',	'KHM',	'116',	'yes',	'855',	'.kh',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(39,	'CM',	'Cameroon',	'Republic of Cameroon',	'CMR',	'120',	'yes',	'237',	'.cm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(40,	'CA',	'Canada',	'Canada',	'CAN',	'124',	'yes',	'1',	'.ca',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(41,	'CV',	'Cape Verde',	'Republic of Cape Verde',	'CPV',	'132',	'yes',	'238',	'.cv',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(42,	'KY',	'Cayman Islands',	'The Cayman Islands',	'CYM',	'136',	'no',	'1+345',	'.ky',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(43,	'CF',	'Central African Republic',	'Central African Republic',	'CAF',	'140',	'yes',	'236',	'.cf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(44,	'TD',	'Chad',	'Republic of Chad',	'TCD',	'148',	'yes',	'235',	'.td',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(45,	'CL',	'Chile',	'Republic of Chile',	'CHL',	'152',	'yes',	'56',	'.cl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(46,	'CN',	'China',	'People\'s Republic of China',	'CHN',	'156',	'yes',	'86',	'.cn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(47,	'CX',	'Christmas Island',	'Christmas Island',	'CXR',	'162',	'no',	'61',	'.cx',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(48,	'CC',	'Cocos (Keeling) Islands',	'Cocos (Keeling) Islands',	'CCK',	'166',	'no',	'61',	'.cc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(49,	'CO',	'Colombia',	'Republic of Colombia',	'COL',	'170',	'yes',	'57',	'.co',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(50,	'KM',	'Comoros',	'Union of the Comoros',	'COM',	'174',	'yes',	'269',	'.km',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(51,	'CG',	'Congo',	'Republic of the Congo',	'COG',	'178',	'yes',	'242',	'.cg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(52,	'CK',	'Cook Islands',	'Cook Islands',	'COK',	'184',	'some',	'682',	'.ck',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(53,	'CR',	'Costa Rica',	'Republic of Costa Rica',	'CRI',	'188',	'yes',	'506',	'.cr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(54,	'CI',	'Cote d\'ivoire (Ivory Coast)',	'Republic of C&ocirc;te D\'Ivoire (Ivory Coast)',	'CIV',	'384',	'yes',	'225',	'.ci',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(55,	'HR',	'Croatia',	'Republic of Croatia',	'HRV',	'191',	'yes',	'385',	'.hr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(56,	'CU',	'Cuba',	'Republic of Cuba',	'CUB',	'192',	'yes',	'53',	'.cu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(57,	'CW',	'Curacao',	'Cura&ccedil;ao',	'CUW',	'531',	'no',	'599',	'.cw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(58,	'CY',	'Cyprus',	'Republic of Cyprus',	'CYP',	'196',	'yes',	'357',	'.cy',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(59,	'CZ',	'Czech Republic',	'Czech Republic',	'CZE',	'203',	'yes',	'420',	'.cz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(60,	'CD',	'Democratic Republic of the Congo',	'Democratic Republic of the Congo',	'COD',	'180',	'yes',	'243',	'.cd',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(61,	'DK',	'Denmark',	'Kingdom of Denmark',	'DNK',	'208',	'yes',	'45',	'.dk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(62,	'DJ',	'Djibouti',	'Republic of Djibouti',	'DJI',	'262',	'yes',	'253',	'.dj',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(63,	'DM',	'Dominica',	'Commonwealth of Dominica',	'DMA',	'212',	'yes',	'1+767',	'.dm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(64,	'DO',	'Dominican Republic',	'Dominican Republic',	'DOM',	'214',	'yes',	'1+809, 8',	'.do',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(65,	'EC',	'Ecuador',	'Republic of Ecuador',	'ECU',	'218',	'yes',	'593',	'.ec',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(66,	'EG',	'Egypt',	'Arab Republic of Egypt',	'EGY',	'818',	'yes',	'20',	'.eg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(67,	'SV',	'El Salvador',	'Republic of El Salvador',	'SLV',	'222',	'yes',	'503',	'.sv',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(68,	'GQ',	'Equatorial Guinea',	'Republic of Equatorial Guinea',	'GNQ',	'226',	'yes',	'240',	'.gq',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(69,	'ER',	'Eritrea',	'State of Eritrea',	'ERI',	'232',	'yes',	'291',	'.er',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(70,	'EE',	'Estonia',	'Republic of Estonia',	'EST',	'233',	'yes',	'372',	'.ee',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(71,	'ET',	'Ethiopia',	'Federal Democratic Republic of Ethiopia',	'ETH',	'231',	'yes',	'251',	'.et',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(72,	'FK',	'Falkland Islands (Malvinas)',	'The Falkland Islands (Malvinas)',	'FLK',	'238',	'no',	'500',	'.fk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(73,	'FO',	'Faroe Islands',	'The Faroe Islands',	'FRO',	'234',	'no',	'298',	'.fo',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(74,	'FJ',	'Fiji',	'Republic of Fiji',	'FJI',	'242',	'yes',	'679',	'.fj',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(75,	'FI',	'Finland',	'Republic of Finland',	'FIN',	'246',	'yes',	'358',	'.fi',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(76,	'FR',	'France',	'French Republic',	'FRA',	'250',	'yes',	'33',	'.fr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(77,	'GF',	'French Guiana',	'French Guiana',	'GUF',	'254',	'no',	'594',	'.gf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(78,	'PF',	'French Polynesia',	'French Polynesia',	'PYF',	'258',	'no',	'689',	'.pf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(79,	'TF',	'French Southern Territories',	'French Southern Territories',	'ATF',	'260',	'no',	NULL,	'.tf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(80,	'GA',	'Gabon',	'Gabonese Republic',	'GAB',	'266',	'yes',	'241',	'.ga',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(81,	'GM',	'Gambia',	'Republic of The Gambia',	'GMB',	'270',	'yes',	'220',	'.gm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(82,	'GE',	'Georgia',	'Georgia',	'GEO',	'268',	'yes',	'995',	'.ge',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(83,	'DE',	'Germany',	'Federal Republic of Germany',	'DEU',	'276',	'yes',	'49',	'.de',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(84,	'GH',	'Ghana',	'Republic of Ghana',	'GHA',	'288',	'yes',	'233',	'.gh',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(85,	'GI',	'Gibraltar',	'Gibraltar',	'GIB',	'292',	'no',	'350',	'.gi',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(86,	'GR',	'Greece',	'Hellenic Republic',	'GRC',	'300',	'yes',	'30',	'.gr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(87,	'GL',	'Greenland',	'Greenland',	'GRL',	'304',	'no',	'299',	'.gl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(88,	'GD',	'Grenada',	'Grenada',	'GRD',	'308',	'yes',	'1+473',	'.gd',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(89,	'GP',	'Guadaloupe',	'Guadeloupe',	'GLP',	'312',	'no',	'590',	'.gp',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(90,	'GU',	'Guam',	'Guam',	'GUM',	'316',	'no',	'1+671',	'.gu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(91,	'GT',	'Guatemala',	'Republic of Guatemala',	'GTM',	'320',	'yes',	'502',	'.gt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(92,	'GG',	'Guernsey',	'Guernsey',	'GGY',	'831',	'no',	'44',	'.gg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(93,	'GN',	'Guinea',	'Republic of Guinea',	'GIN',	'324',	'yes',	'224',	'.gn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(94,	'GW',	'Guinea-Bissau',	'Republic of Guinea-Bissau',	'GNB',	'624',	'yes',	'245',	'.gw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(95,	'GY',	'Guyana',	'Co-operative Republic of Guyana',	'GUY',	'328',	'yes',	'592',	'.gy',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(96,	'HT',	'Haiti',	'Republic of Haiti',	'HTI',	'332',	'yes',	'509',	'.ht',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(97,	'HM',	'Heard Island and McDonald Islands',	'Heard Island and McDonald Islands',	'HMD',	'334',	'no',	'NONE',	'.hm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(98,	'HN',	'Honduras',	'Republic of Honduras',	'HND',	'340',	'yes',	'504',	'.hn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(99,	'HK',	'Hong Kong',	'Hong Kong',	'HKG',	'344',	'no',	'852',	'.hk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(100,	'HU',	'Hungary',	'Hungary',	'HUN',	'348',	'yes',	'36',	'.hu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(101,	'IS',	'Iceland',	'Republic of Iceland',	'ISL',	'352',	'yes',	'354',	'.is',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(102,	'IN',	'India',	'Republic of India',	'IND',	'356',	'yes',	'91',	'.in',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(103,	'ID',	'Indonesia',	'Republic of Indonesia',	'IDN',	'360',	'yes',	'62',	'.id',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(104,	'IR',	'Iran',	'Islamic Republic of Iran',	'IRN',	'364',	'yes',	'98',	'.ir',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(105,	'IQ',	'Iraq',	'Republic of Iraq',	'IRQ',	'368',	'yes',	'964',	'.iq',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(106,	'IE',	'Ireland',	'Ireland',	'IRL',	'372',	'yes',	'353',	'.ie',	1,	'2022-04-25 17:26:59',	'2022-04-27 11:54:48'),
(107,	'IM',	'Isle of Man',	'Isle of Man',	'IMN',	'833',	'no',	'44',	'.im',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(108,	'IL',	'Israel',	'State of Israel',	'ISR',	'376',	'yes',	'972',	'.il',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(109,	'IT',	'Italy',	'Italian Republic',	'ITA',	'380',	'yes',	'39',	'.jm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(110,	'JM',	'Jamaica',	'Jamaica',	'JAM',	'388',	'yes',	'1+876',	'.jm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(111,	'JP',	'Japan',	'Japan',	'JPN',	'392',	'yes',	'81',	'.jp',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(112,	'JE',	'Jersey',	'The Bailiwick of Jersey',	'JEY',	'832',	'no',	'44',	'.je',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(113,	'JO',	'Jordan',	'Hashemite Kingdom of Jordan',	'JOR',	'400',	'yes',	'962',	'.jo',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(114,	'KZ',	'Kazakhstan',	'Republic of Kazakhstan',	'KAZ',	'398',	'yes',	'7',	'.kz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(115,	'KE',	'Kenya',	'Republic of Kenya',	'KEN',	'404',	'yes',	'254',	'.ke',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(116,	'KI',	'Kiribati',	'Republic of Kiribati',	'KIR',	'296',	'yes',	'686',	'.ki',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(117,	'XK',	'Kosovo',	'Republic of Kosovo',	'---',	'---',	'some',	'381',	'',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(118,	'KW',	'Kuwait',	'State of Kuwait',	'KWT',	'414',	'yes',	'965',	'.kw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(119,	'KG',	'Kyrgyzstan',	'Kyrgyz Republic',	'KGZ',	'417',	'yes',	'996',	'.kg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(120,	'LA',	'Laos',	'Lao People\'s Democratic Republic',	'LAO',	'418',	'yes',	'856',	'.la',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(121,	'LV',	'Latvia',	'Republic of Latvia',	'LVA',	'428',	'yes',	'371',	'.lv',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(122,	'LB',	'Lebanon',	'Republic of Lebanon',	'LBN',	'422',	'yes',	'961',	'.lb',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(123,	'LS',	'Lesotho',	'Kingdom of Lesotho',	'LSO',	'426',	'yes',	'266',	'.ls',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(124,	'LR',	'Liberia',	'Republic of Liberia',	'LBR',	'430',	'yes',	'231',	'.lr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(125,	'LY',	'Libya',	'Libya',	'LBY',	'434',	'yes',	'218',	'.ly',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(126,	'LI',	'Liechtenstein',	'Principality of Liechtenstein',	'LIE',	'438',	'yes',	'423',	'.li',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(127,	'LT',	'Lithuania',	'Republic of Lithuania',	'LTU',	'440',	'yes',	'370',	'.lt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(128,	'LU',	'Luxembourg',	'Grand Duchy of Luxembourg',	'LUX',	'442',	'yes',	'352',	'.lu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(129,	'MO',	'Macao',	'The Macao Special Administrative Region',	'MAC',	'446',	'no',	'853',	'.mo',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(130,	'MK',	'Macedonia',	'The Former Yugoslav Republic of Macedonia',	'MKD',	'807',	'yes',	'389',	'.mk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(131,	'MG',	'Madagascar',	'Republic of Madagascar',	'MDG',	'450',	'yes',	'261',	'.mg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(132,	'MW',	'Malawi',	'Republic of Malawi',	'MWI',	'454',	'yes',	'265',	'.mw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(133,	'MY',	'Malaysia',	'Malaysia',	'MYS',	'458',	'yes',	'60',	'.my',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(134,	'MV',	'Maldives',	'Republic of Maldives',	'MDV',	'462',	'yes',	'960',	'.mv',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(135,	'ML',	'Mali',	'Republic of Mali',	'MLI',	'466',	'yes',	'223',	'.ml',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(136,	'MT',	'Malta',	'Republic of Malta',	'MLT',	'470',	'yes',	'356',	'.mt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(137,	'MH',	'Marshall Islands',	'Republic of the Marshall Islands',	'MHL',	'584',	'yes',	'692',	'.mh',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(138,	'MQ',	'Martinique',	'Martinique',	'MTQ',	'474',	'no',	'596',	'.mq',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(139,	'MR',	'Mauritania',	'Islamic Republic of Mauritania',	'MRT',	'478',	'yes',	'222',	'.mr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(140,	'MU',	'Mauritius',	'Republic of Mauritius',	'MUS',	'480',	'yes',	'230',	'.mu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(141,	'YT',	'Mayotte',	'Mayotte',	'MYT',	'175',	'no',	'262',	'.yt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(142,	'MX',	'Mexico',	'United Mexican States',	'MEX',	'484',	'yes',	'52',	'.mx',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(143,	'FM',	'Micronesia',	'Federated States of Micronesia',	'FSM',	'583',	'yes',	'691',	'.fm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(144,	'MD',	'Moldava',	'Republic of Moldova',	'MDA',	'498',	'yes',	'373',	'.md',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(145,	'MC',	'Monaco',	'Principality of Monaco',	'MCO',	'492',	'yes',	'377',	'.mc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(146,	'MN',	'Mongolia',	'Mongolia',	'MNG',	'496',	'yes',	'976',	'.mn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(147,	'ME',	'Montenegro',	'Montenegro',	'MNE',	'499',	'yes',	'382',	'.me',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(148,	'MS',	'Montserrat',	'Montserrat',	'MSR',	'500',	'no',	'1+664',	'.ms',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(149,	'MA',	'Morocco',	'Kingdom of Morocco',	'MAR',	'504',	'yes',	'212',	'.ma',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(150,	'MZ',	'Mozambique',	'Republic of Mozambique',	'MOZ',	'508',	'yes',	'258',	'.mz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(151,	'MM',	'Myanmar (Burma)',	'Republic of the Union of Myanmar',	'MMR',	'104',	'yes',	'95',	'.mm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(152,	'NA',	'Namibia',	'Republic of Namibia',	'NAM',	'516',	'yes',	'264',	'.na',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(153,	'NR',	'Nauru',	'Republic of Nauru',	'NRU',	'520',	'yes',	'674',	'.nr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(154,	'NP',	'Nepal',	'Federal Democratic Republic of Nepal',	'NPL',	'524',	'yes',	'977',	'.np',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(155,	'NL',	'Netherlands',	'Kingdom of the Netherlands',	'NLD',	'528',	'yes',	'31',	'.nl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(156,	'NC',	'New Caledonia',	'New Caledonia',	'NCL',	'540',	'no',	'687',	'.nc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(157,	'NZ',	'New Zealand',	'New Zealand',	'NZL',	'554',	'yes',	'64',	'.nz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(158,	'NI',	'Nicaragua',	'Republic of Nicaragua',	'NIC',	'558',	'yes',	'505',	'.ni',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(159,	'NE',	'Niger',	'Republic of Niger',	'NER',	'562',	'yes',	'227',	'.ne',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(160,	'NG',	'Nigeria',	'Federal Republic of Nigeria',	'NGA',	'566',	'yes',	'234',	'.ng',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(161,	'NU',	'Niue',	'Niue',	'NIU',	'570',	'some',	'683',	'.nu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(162,	'NF',	'Norfolk Island',	'Norfolk Island',	'NFK',	'574',	'no',	'672',	'.nf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(163,	'KP',	'North Korea',	'Democratic People\'s Republic of Korea',	'PRK',	'408',	'yes',	'850',	'.kp',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(164,	'MP',	'Northern Mariana Islands',	'Northern Mariana Islands',	'MNP',	'580',	'no',	'1+670',	'.mp',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(165,	'NO',	'Norway',	'Kingdom of Norway',	'NOR',	'578',	'yes',	'47',	'.no',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(166,	'OM',	'Oman',	'Sultanate of Oman',	'OMN',	'512',	'yes',	'968',	'.om',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(167,	'PK',	'Pakistan',	'Islamic Republic of Pakistan',	'PAK',	'586',	'yes',	'92',	'.pk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(168,	'PW',	'Palau',	'Republic of Palau',	'PLW',	'585',	'yes',	'680',	'.pw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(169,	'PS',	'Palestine',	'State of Palestine (or Occupied Palestinian Territory)',	'PSE',	'275',	'some',	'970',	'.ps',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(170,	'PA',	'Panama',	'Republic of Panama',	'PAN',	'591',	'yes',	'507',	'.pa',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(171,	'PG',	'Papua New Guinea',	'Independent State of Papua New Guinea',	'PNG',	'598',	'yes',	'675',	'.pg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(172,	'PY',	'Paraguay',	'Republic of Paraguay',	'PRY',	'600',	'yes',	'595',	'.py',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(173,	'PE',	'Peru',	'Republic of Peru',	'PER',	'604',	'yes',	'51',	'.pe',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(174,	'PH',	'Phillipines',	'Republic of the Philippines',	'PHL',	'608',	'yes',	'63',	'.ph',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(175,	'PN',	'Pitcairn',	'Pitcairn',	'PCN',	'612',	'no',	'NONE',	'.pn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(176,	'PL',	'Poland',	'Republic of Poland',	'POL',	'616',	'yes',	'48',	'.pl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(177,	'PT',	'Portugal',	'Portuguese Republic',	'PRT',	'620',	'yes',	'351',	'.pt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(178,	'PR',	'Puerto Rico',	'Commonwealth of Puerto Rico',	'PRI',	'630',	'no',	'1+939',	'.pr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(179,	'QA',	'Qatar',	'State of Qatar',	'QAT',	'634',	'yes',	'974',	'.qa',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(180,	'RE',	'Reunion',	'R&eacute;union',	'REU',	'638',	'no',	'262',	'.re',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(181,	'RO',	'Romania',	'Romania',	'ROU',	'642',	'yes',	'40',	'.ro',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(182,	'RU',	'Russia',	'Russian Federation',	'RUS',	'643',	'yes',	'7',	'.ru',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(183,	'RW',	'Rwanda',	'Republic of Rwanda',	'RWA',	'646',	'yes',	'250',	'.rw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(184,	'BL',	'Saint Barthelemy',	'Saint Barth&eacute;lemy',	'BLM',	'652',	'no',	'590',	'.bl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(185,	'SH',	'Saint Helena',	'Saint Helena, Ascension and Tristan da Cunha',	'SHN',	'654',	'no',	'290',	'.sh',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(186,	'KN',	'Saint Kitts and Nevis',	'Federation of Saint Christopher and Nevis',	'KNA',	'659',	'yes',	'1+869',	'.kn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(187,	'LC',	'Saint Lucia',	'Saint Lucia',	'LCA',	'662',	'yes',	'1+758',	'.lc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(188,	'MF',	'Saint Martin',	'Saint Martin',	'MAF',	'663',	'no',	'590',	'.mf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(189,	'PM',	'Saint Pierre and Miquelon',	'Saint Pierre and Miquelon',	'SPM',	'666',	'no',	'508',	'.pm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(190,	'VC',	'Saint Vincent and the Grenadines',	'Saint Vincent and the Grenadines',	'VCT',	'670',	'yes',	'1+784',	'.vc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(191,	'WS',	'Samoa',	'Independent State of Samoa',	'WSM',	'882',	'yes',	'685',	'.ws',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(192,	'SM',	'San Marino',	'Republic of San Marino',	'SMR',	'674',	'yes',	'378',	'.sm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(193,	'ST',	'Sao Tome and Principe',	'Democratic Republic of S&atilde;o Tom&eacute; and Pr&iacute;ncipe',	'STP',	'678',	'yes',	'239',	'.st',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(194,	'SA',	'Saudi Arabia',	'Kingdom of Saudi Arabia',	'SAU',	'682',	'yes',	'966',	'.sa',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(195,	'SN',	'Senegal',	'Republic of Senegal',	'SEN',	'686',	'yes',	'221',	'.sn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(196,	'RS',	'Serbia',	'Republic of Serbia',	'SRB',	'688',	'yes',	'381',	'.rs',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(197,	'SC',	'Seychelles',	'Republic of Seychelles',	'SYC',	'690',	'yes',	'248',	'.sc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(198,	'SL',	'Sierra Leone',	'Republic of Sierra Leone',	'SLE',	'694',	'yes',	'232',	'.sl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(199,	'SG',	'Singapore',	'Republic of Singapore',	'SGP',	'702',	'yes',	'65',	'.sg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(200,	'SX',	'Sint Maarten',	'Sint Maarten',	'SXM',	'534',	'no',	'1+721',	'.sx',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(201,	'SK',	'Slovakia',	'Slovak Republic',	'SVK',	'703',	'yes',	'421',	'.sk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(202,	'SI',	'Slovenia',	'Republic of Slovenia',	'SVN',	'705',	'yes',	'386',	'.si',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(203,	'SB',	'Solomon Islands',	'Solomon Islands',	'SLB',	'090',	'yes',	'677',	'.sb',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(204,	'SO',	'Somalia',	'Somali Republic',	'SOM',	'706',	'yes',	'252',	'.so',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(205,	'ZA',	'South Africa',	'Republic of South Africa',	'ZAF',	'710',	'yes',	'27',	'.za',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(206,	'GS',	'South Georgia and the South Sandwich Islands',	'South Georgia and the South Sandwich Islands',	'SGS',	'239',	'no',	'500',	'.gs',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(207,	'KR',	'South Korea',	'Republic of Korea',	'KOR',	'410',	'yes',	'82',	'.kr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(208,	'SS',	'South Sudan',	'Republic of South Sudan',	'SSD',	'728',	'yes',	'211',	'.ss',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(209,	'ES',	'Spain',	'Kingdom of Spain',	'ESP',	'724',	'yes',	'34',	'.es',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(210,	'LK',	'Sri Lanka',	'Democratic Socialist Republic of Sri Lanka',	'LKA',	'144',	'yes',	'94',	'.lk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(211,	'SD',	'Sudan',	'Republic of the Sudan',	'SDN',	'729',	'yes',	'249',	'.sd',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(212,	'SR',	'Suriname',	'Republic of Suriname',	'SUR',	'740',	'yes',	'597',	'.sr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(213,	'SJ',	'Svalbard and Jan Mayen',	'Svalbard and Jan Mayen',	'SJM',	'744',	'no',	'47',	'.sj',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(214,	'SZ',	'Swaziland',	'Kingdom of Swaziland',	'SWZ',	'748',	'yes',	'268',	'.sz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(215,	'SE',	'Sweden',	'Kingdom of Sweden',	'SWE',	'752',	'yes',	'46',	'.se',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(216,	'CH',	'Switzerland',	'Swiss Confederation',	'CHE',	'756',	'yes',	'41',	'.ch',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(217,	'SY',	'Syria',	'Syrian Arab Republic',	'SYR',	'760',	'yes',	'963',	'.sy',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(218,	'TW',	'Taiwan',	'Republic of China (Taiwan)',	'TWN',	'158',	'former',	'886',	'.tw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(219,	'TJ',	'Tajikistan',	'Republic of Tajikistan',	'TJK',	'762',	'yes',	'992',	'.tj',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(220,	'TZ',	'Tanzania',	'United Republic of Tanzania',	'TZA',	'834',	'yes',	'255',	'.tz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(221,	'TH',	'Thailand',	'Kingdom of Thailand',	'THA',	'764',	'yes',	'66',	'.th',	0,	'2022-04-25 17:26:59',	'2022-04-27 11:34:01'),
(222,	'TL',	'Timor-Leste (East Timor)',	'Democratic Republic of Timor-Leste',	'TLS',	'626',	'yes',	'670',	'.tl',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(223,	'TG',	'Togo',	'Togolese Republic',	'TGO',	'768',	'yes',	'228',	'.tg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(224,	'TK',	'Tokelau',	'Tokelau',	'TKL',	'772',	'no',	'690',	'.tk',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(225,	'TO',	'Tonga',	'Kingdom of Tonga',	'TON',	'776',	'yes',	'676',	'.to',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(226,	'TT',	'Trinidad and Tobago',	'Republic of Trinidad and Tobago',	'TTO',	'780',	'yes',	'1+868',	'.tt',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(227,	'TN',	'Tunisia',	'Republic of Tunisia',	'TUN',	'788',	'yes',	'216',	'.tn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(228,	'TR',	'Turkey',	'Republic of Turkey',	'TUR',	'792',	'yes',	'90',	'.tr',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(229,	'TM',	'Turkmenistan',	'Turkmenistan',	'TKM',	'795',	'yes',	'993',	'.tm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(230,	'TC',	'Turks and Caicos Islands',	'Turks and Caicos Islands',	'TCA',	'796',	'no',	'1+649',	'.tc',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(231,	'TV',	'Tuvalu',	'Tuvalu',	'TUV',	'798',	'yes',	'688',	'.tv',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(232,	'UG',	'Uganda',	'Republic of Uganda',	'UGA',	'800',	'yes',	'256',	'.ug',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(233,	'UA',	'Ukraine',	'Ukraine',	'UKR',	'804',	'yes',	'380',	'.ua',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(234,	'AE',	'United Arab Emirates',	'United Arab Emirates',	'ARE',	'784',	'yes',	'971',	'.ae',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(235,	'GB',	'United Kingdom',	'United Kingdom of Great Britain and Nothern Ireland',	'GBR',	'826',	'yes',	'44',	'.uk',	1,	'2022-04-25 17:26:59',	'2022-04-27 11:36:08'),
(236,	'US',	'United States',	'United States of America',	'USA',	'840',	'yes',	'1',	'.us',	0,	'2022-04-25 17:26:59',	'2022-04-29 07:07:27'),
(237,	'UM',	'United States Minor Outlying Islands',	'United States Minor Outlying Islands',	'UMI',	'581',	'no',	'NONE',	'NONE',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(238,	'UY',	'Uruguay',	'Eastern Republic of Uruguay',	'URY',	'858',	'yes',	'598',	'.uy',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(239,	'UZ',	'Uzbekistan',	'Republic of Uzbekistan',	'UZB',	'860',	'yes',	'998',	'.uz',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(240,	'VU',	'Vanuatu',	'Republic of Vanuatu',	'VUT',	'548',	'yes',	'678',	'.vu',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(241,	'VA',	'Vatican City',	'State of the Vatican City',	'VAT',	'336',	'no',	'39',	'.va',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(242,	'VE',	'Venezuela',	'Bolivarian Republic of Venezuela',	'VEN',	'862',	'yes',	'58',	'.ve',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(243,	'VN',	'Vietnam',	'Socialist Republic of Vietnam',	'VNM',	'704',	'yes',	'84',	'.vn',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(244,	'VG',	'Virgin Islands, British',	'British Virgin Islands',	'VGB',	'092',	'no',	'1+284',	'.vg',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(245,	'VI',	'Virgin Islands, US',	'Virgin Islands of the United States',	'VIR',	'850',	'no',	'1+340',	'.vi',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(246,	'WF',	'Wallis and Futuna',	'Wallis and Futuna',	'WLF',	'876',	'no',	'681',	'.wf',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(247,	'EH',	'Western Sahara',	'Western Sahara',	'ESH',	'732',	'no',	'212',	'.eh',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(248,	'YE',	'Yemen',	'Republic of Yemen',	'YEM',	'887',	'yes',	'967',	'.ye',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(249,	'ZM',	'Zambia',	'Republic of Zambia',	'ZMB',	'894',	'yes',	'260',	'.zm',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:57:49'),
(250,	'ZW',	'Zimbabwe',	'Republic of Zimbabwe',	'ZWE',	'716',	'yes',	'263',	'.zw',	0,	'2022-04-25 17:26:59',	'2022-04-25 11:59:16'),
(252,	NULL,	'Northern Ireland',	'',	NULL,	NULL,	NULL,	'44',	NULL,	1,	'2022-04-27 17:07:23',	'2022-04-28 11:00:52');

CREATE TABLE `dog_colors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `color_code` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `dog_colors_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `dog_colors` (`id`, `title`, `slug`, `color_code`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(1,	'Red',	'red',	'#FF0000',	1,	7,	NULL,	'2022-07-26 13:25:45',	'2022-07-26 07:55:45'),
(2,	'Green',	'green',	'#008000',	1,	7,	NULL,	'2022-07-26 13:26:46',	'2022-07-26 07:56:46'),
(3,	'Black',	'black',	'#000000',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(4,	'Blue',	'blue',	'#0000FF',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(5,	'Dark Blue',	'dark-blue',	'#00008B',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(6,	'Cyan',	'cyan',	'#00FFFF',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(7,	'Purple',	'purple',	'#800080',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(8,	'Yellow',	'yellow',	'#FFFF00',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(9,	'Orange',	'orange',	'#FFA500',	1,	7,	NULL,	'2022-07-26 13:27:09',	'2022-07-26 07:57:09'),
(10,	'Brown',	'brown',	'#A52A2A',	0,	7,	NULL,	'2022-07-26 13:27:09',	'2022-09-01 06:55:17'),
(13,	'white',	'white-a9By2e',	'#fbeaea',	1,	7,	NULL,	'2022-09-01 13:12:50',	'2022-09-01 07:42:50');

CREATE TABLE `dog_microchips` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(5) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `dog_microchips_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  CONSTRAINT `dog_microchips_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `dog_microchips` (`id`, `country_id`, `title`, `slug`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(1,	235,	'Pethealth',	'pethealth-n2MDpq',	1,	7,	NULL,	'2022-07-26 13:19:54',	'2022-08-12 09:59:06'),
(2,	106,	'911PetChip',	'911petchip-awb7pe',	1,	7,	NULL,	'2022-07-26 13:19:54',	'2022-08-12 09:59:00'),
(3,	235,	'Furreka',	'furreka-Ewerpm',	1,	7,	NULL,	'2022-07-26 13:19:54',	'2022-08-12 09:58:54'),
(4,	235,	'InfoPET',	'infopet-G2Rmp3',	1,	7,	NULL,	'2022-07-26 13:19:54',	'2022-08-12 09:58:48'),
(5,	106,	'Peeva',	'peeva-Kp4M2m',	1,	7,	NULL,	'2022-07-26 13:19:54',	'2022-08-12 09:58:42');

CREATE TABLE `dog_microchip_registration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `microchip_number` varchar(255) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `color` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `check_microchip` tinyint(1) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1 COMMENT '1 = Available, 2 = Hold, 3 = Sold ',
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  KEY `color` (`color`),
  CONSTRAINT `dog_microchip_registration_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dog_microchip_registration_ibfk_3` FOREIGN KEY (`color`) REFERENCES `dog_colors` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `dog_microchip_registration` (`id`, `product_id`, `microchip_number`, `gender`, `color`, `user_id`, `check_microchip`, `status`, `deleted_at`, `created`, `modified`) VALUES
(153,	211,	'ASasASasASasaas',	'male',	4,	NULL,	0,	1,	NULL,	'2022-12-14 13:10:05',	'2022-12-14 07:44:13'),
(156,	214,	'sasasasasasasas',	'male',	3,	NULL,	0,	1,	NULL,	'2022-12-20 19:01:28',	'2022-12-20 13:31:32'),
(157,	215,	'dsadsadsadasdas',	'male',	3,	NULL,	0,	1,	NULL,	'2022-12-20 19:09:47',	'2022-12-20 13:40:21'),
(158,	215,	'dsdsdasdasdasda',	'female',	6,	NULL,	0,	1,	NULL,	'2022-12-20 19:09:56',	'2022-12-20 13:40:21'),
(159,	216,	'gdfgdfgdfgdfgdf',	'female',	6,	NULL,	0,	1,	NULL,	'2022-12-20 19:12:04',	'2022-12-20 13:42:08'),
(160,	217,	'564684646446465',	'male',	3,	NULL,	0,	1,	NULL,	'2022-12-22 13:48:25',	'2022-12-22 08:18:35'),
(161,	218,	'772578237327278',	'female',	3,	NULL,	0,	1,	NULL,	'2022-12-22 13:55:26',	'2022-12-22 08:25:53'),
(162,	218,	'785785785785757',	'male',	4,	NULL,	0,	1,	NULL,	'2022-12-22 13:55:38',	'2022-12-22 08:25:53'),
(163,	218,	'757857527275527',	'male',	4,	NULL,	0,	1,	NULL,	'2022-12-22 13:55:45',	'2022-12-22 08:25:53'),
(164,	219,	'A12345678901234',	'male',	3,	NULL,	0,	1,	NULL,	'2022-12-26 12:33:17',	'2022-12-26 07:04:06'),
(165,	219,	'B12345678998765',	'female',	4,	NULL,	0,	1,	NULL,	'2022-12-26 12:33:28',	'2022-12-26 07:04:06'),
(166,	219,	'C12345678985212',	'male',	5,	NULL,	0,	1,	NULL,	'2022-12-26 12:33:41',	'2022-12-26 07:04:06'),
(167,	219,	'D36925814736925',	'female',	9,	NULL,	0,	1,	NULL,	'2022-12-26 12:33:55',	'2022-12-26 07:04:06'),
(168,	220,	'666666666666666',	'male',	4,	NULL,	0,	1,	NULL,	'2022-12-26 12:56:42',	'2022-12-26 07:26:47'),
(169,	221,	'343434343434343',	'male',	5,	NULL,	0,	1,	NULL,	'2022-12-26 13:09:51',	'2022-12-26 07:40:12');

CREATE TABLE `dog_pedigree` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unique_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `breed` int(11) DEFAULT NULL,
  `color` int(11) DEFAULT NULL,
  `champion` tinyint(1) NOT NULL DEFAULT 0,
  `type` enum('parents','grand_parents','great_grand_parents','great_great_grandparents') DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `color` (`color`),
  KEY `breed` (`breed`),
  KEY `parent_id` (`parent_id`),
  CONSTRAINT `dog_pedigree_ibfk_2` FOREIGN KEY (`color`) REFERENCES `dog_colors` (`id`) ON DELETE SET NULL,
  CONSTRAINT `dog_pedigree_ibfk_3` FOREIGN KEY (`breed`) REFERENCES `product_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `dog_pedigree_ibfk_4` FOREIGN KEY (`parent_id`) REFERENCES `dog_pedigree` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `pedigree_ibtk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `dog_pedigree` (`id`, `unique_id`, `user_id`, `parent_id`, `gender`, `name`, `breed`, `color`, `champion`, `type`, `created`, `modified`) VALUES
(2375,	316642,	1,	NULL,	NULL,	'test',	104,	NULL,	0,	NULL,	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2376,	7433786,	1,	2375,	'male',	'Hillary Marsh',	NULL,	NULL,	0,	'parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2377,	6080558,	1,	2376,	'male',	'Eric Brady',	NULL,	NULL,	0,	'grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2378,	4960600,	1,	2377,	'male',	'Claudia Hudson',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2379,	6102263,	1,	2378,	'male',	'Blaze Bond',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2380,	2663205,	1,	2378,	'female',	'Linus Tucker',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2381,	6402201,	1,	2377,	'female',	'Porter Frazier',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2382,	3980321,	1,	2381,	'male',	'Felix Ross',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2383,	2357328,	1,	2381,	'female',	'Faith Hahn',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2384,	6958049,	1,	2376,	'female',	'Palmer Knight',	NULL,	NULL,	0,	'grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2385,	6208531,	1,	2384,	'male',	'Drew Morton',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2386,	7012047,	1,	2385,	'male',	'Adrian Hyde',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2387,	5881994,	1,	2385,	'female',	'Pamela Flores',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2388,	2877247,	1,	2384,	'female',	'Hakeem Olson',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2389,	7713222,	1,	2388,	'male',	'Alfreda Hayden',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2390,	268087,	1,	2388,	'female',	'Mikayla Potter',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2391,	6682223,	1,	2375,	'female',	'Callum Mcbride',	NULL,	NULL,	0,	'parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2392,	9592131,	1,	2391,	'male',	'Faith Marquez',	NULL,	NULL,	0,	'grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2393,	1234564,	1,	2392,	'male',	'Yuli Garner',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2394,	41968,	1,	2393,	'male',	'Lilah Rhodes',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2395,	3618299,	1,	2393,	'female',	'Vivian Carroll',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2396,	2850578,	1,	2392,	'female',	'Joan Clayton',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2397,	772784,	1,	2396,	'male',	'Gretchen Larsen',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2398,	9163592,	1,	2396,	'female',	'Alea Branch',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2399,	95266,	1,	2391,	'female',	'Nerea Peck',	NULL,	NULL,	0,	'grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2400,	9548067,	1,	2399,	'male',	'Ella Valenzuela',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2401,	9052059,	1,	2400,	'male',	'Jorden Aguirre',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2402,	2633705,	1,	2400,	'female',	'Mercedes Kennedy',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2403,	9247115,	1,	2399,	'female',	'Tyrone Marshall',	NULL,	NULL,	0,	'great_grand_parents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2404,	4734262,	1,	2403,	'male',	'Genevieve Hansen',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31'),
(2405,	5166789,	1,	2403,	'female',	'Arden Klein',	NULL,	NULL,	0,	'great_great_grandparents',	'2022-12-26 19:01:31',	'2022-12-26 13:31:31');

CREATE TABLE `email_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(100) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `from` varchar(100) NOT NULL,
  `to` text NOT NULL,
  `cc` text DEFAULT NULL,
  `bcc` text DEFAULT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT 0,
  `open` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `email_logs` (`id`, `slug`, `subject`, `description`, `from`, `to`, `cc`, `bcc`, `sent`, `open`, `created`, `modified`) VALUES
(1,	'registration',	'Registration Successful.',	'<p>Dear dgdg&nbsp;arfdg</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/eN9hmNDSt1JCFnH2jU7OiYwXpszD8uIDZMTqzUZCL8qrS3dGlvEaG750ljqV63jM\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/eN9hmNDSt1JCFnH2jU7OiYwXpszD8uIDZMTqzUZCL8qrS3dGlvEaG750ljqV63jM</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'eugyweyriu@erterui.com',	NULL,	NULL,	1,	0,	'2022-08-20 11:05:56',	'2022-08-20 05:35:59'),
(2,	'registration',	'Registration Successful.',	'<p>Dear Suresh&nbsp;Khanna</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/ldzO0fVgq7YgovXLUdwNcPmaE4Uz9wREEpaSTW5kfuilGwU8kPMWuuCWYBDTci3G\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/ldzO0fVgq7YgovXLUdwNcPmaE4Uz9wREEpaSTW5kfuilGwU8kPMWuuCWYBDTci3G</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:05:41',	'2022-08-20 06:35:44'),
(3,	'forgot-password',	'Forgot Password',	'<p>Dear Suresh&nbsp;Khanna<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\nhttps://globizcloudserver.com/browsepets/public/recover-password/3WtFKnke6qfXD8YEtVzJI8iqhgoF2pjL<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:08:21',	'2022-08-20 06:38:24'),
(4,	'forgot-password',	'Forgot Password',	'<p>Dear Suresh&nbsp;Khanna<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\nhttps://globizcloudserver.com/browsepets/public/recover-password/C41OK43YHUPvkg7tVrTvDLYC8QhW53YZ<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:09:33',	'2022-08-20 06:39:35'),
(5,	'forgot-password',	'Forgot Password',	'<p>Dear Suresh&nbsp;Khanna<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\nhttps://globizcloudserver.com/browsepets/public/recover-password/rCGYrlPbk0KAdjqDOx1ZeeHgcWeBtZ41<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:10:24',	'2022-08-20 06:40:26'),
(6,	'forgot-password',	'Forgot Password',	'<p>Dear Suresh&nbsp;Khanna<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\nhttps://globizcloudserver.com/browsepets/public/recover-password/dOpxZ4FjtB5coM3quJw0XI5LfkGjXFmi<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:10:42',	'2022-08-20 06:40:44'),
(7,	'registration',	'Registration Successful.',	'<p>Dear Suresh&nbsp;Khanna</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/RsdoK0xXJpJOMsjiwXz69d58gLqNcjaKrX0tTzCGCSj6m11TA748QgXKajvLcYCx\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/RsdoK0xXJpJOMsjiwXz69d58gLqNcjaKrX0tTzCGCSj6m11TA748QgXKajvLcYCx</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:14:11',	'2022-08-20 06:44:14'),
(8,	'phone-verification-otp',	'Your one time password for Browse4Pets',	'<p>Dear Suresh&nbsp;Khanna<br />\r\n<br />\r\nYour account one time password for login is <strong>648655</strong>\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-08-20 12:15:07',	'2022-08-20 06:45:09'),
(9,	'registration',	'Registration Successful.',	'<p>Dear fdhb&nbsp;hf</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/QTdLZ1BxIdjYgui4HYL6shdwmdQc4FiMwtGyVI3eueJgh2Nx6LwDVOYpdFQRuR1d\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/QTdLZ1BxIdjYgui4HYL6shdwmdQc4FiMwtGyVI3eueJgh2Nx6LwDVOYpdFQRuR1d</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'admin@gdfgdfgfdg.com',	NULL,	NULL,	1,	0,	'2022-08-23 11:42:29',	'2022-08-23 06:12:31'),
(10,	'registration',	'Registration Successful.',	'<p>Dear fd&nbsp;wrwr</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/62C7A8ysGu5q8YTtOaV2DVfW2VbZSPqmURpIh4mirTOSCvauO2EAPeFd37rZxkiy\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/62C7A8ysGu5q8YTtOaV2DVfW2VbZSPqmURpIh4mirTOSCvauO2EAPeFd37rZxkiy</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'admin@dsfsgsdgsdg.com',	NULL,	NULL,	1,	0,	'2022-08-23 12:09:19',	'2022-08-23 06:39:21'),
(11,	'customer-admin-registration',	'Registration Successful.',	'<p>Dear Test@!123&nbsp;Kumar@123<br />\r\n<br />\r\nYou account has been registered on Browse4Pets. Please use the below credentails for login.<br />\r\n<br />\r\n<a href=\"https://globizcloudserver.com/browsepets/public\" target=\"_blank\">https://globizcloudserver.com/browsepets/public</a><br />\r\nEmail: testkumar123@gmail.com<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'testkumar123@gmail.com',	NULL,	NULL,	1,	0,	'2022-09-05 11:06:39',	'2022-09-05 05:36:42'),
(12,	'forgot-password',	'Forgot Password',	'<p>Dear Suresh&nbsp;Khanna<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\nhttps://globizcloudserver.com/browsepets/public/recover-password/cX9cZUeT7SumhbLifFIcE1oGh673nkDV<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.globiztechnology@gmail.com',	NULL,	NULL,	1,	0,	'2022-09-05 11:44:28',	'2022-09-05 06:14:31'),
(13,	'registration',	'Registration Successful.',	'<p>Dear efwg&nbsp;wgeg</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/WDVfCKHrBP6kRWTvAAIVlcU0O7kSZYk2VtJDCtitTjM5eTwUsxOdHQ5PMCESybhO\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/WDVfCKHrBP6kRWTvAAIVlcU0O7kSZYk2VtJDCtitTjM5eTwUsxOdHQ5PMCESybhO</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'ghd@gc.ghrth',	NULL,	NULL,	1,	0,	'2022-09-12 12:14:50',	'2022-09-12 06:44:53'),
(14,	'registration',	'Registration Successful.',	'<p>Dear SKKhanna&nbsp;Ludhiana</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/wymgvnHpgnyfi4zdZzp0LbvhhtbCzw8pIZYrCCJATGxqDcvs82ChlxKDqL5xIfxu\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/wymgvnHpgnyfi4zdZzp0LbvhhtbCzw8pIZYrCCJATGxqDcvs82ChlxKDqL5xIfxu</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'suresh.khanna894@gmail.com',	NULL,	NULL,	1,	0,	'2022-09-12 12:18:51',	'2022-09-12 06:48:53'),
(15,	'registration',	'Registration Successful.',	'<p>Dear SKKhanna&nbsp;Ludhiana</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/wymgvnHpgnyfi4zdZzp0LbvhhtbCzw8pIZYrCCJATGxqDcvs82ChlxKDqL5xIfxu\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/wymgvnHpgnyfi4zdZzp0LbvhhtbCzw8pIZYrCCJATGxqDcvs82ChlxKDqL5xIfxu</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'suresh.khanna894@gmail.com',	NULL,	NULL,	1,	0,	'2022-09-12 12:23:37',	'2022-09-12 06:53:39'),
(16,	'phone-verification-otp',	'Your one time password for Browse4Pets',	'<p>Dear SKKhanna&nbsp;Ludhiana<br />\r\n<br />\r\nYour account one time password for login is <strong>035065</strong>\r\n<br />\r\nThanks</p>',	'info@example.com',	'suresh.khanna894@gmail.com',	NULL,	NULL,	1,	0,	'2022-09-12 12:25:04',	'2022-09-12 06:55:06'),
(17,	'registration',	'Registration Successful.',	'<p>Dear Roth&nbsp;Kirby</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p><a href=\"https://globizcloudserver.com/browsepets/public/email-verification/7Muq4EZZ8yd6jryw65EDLS9ZuTmEqKyO9atUTQlSrnBmhUenAxdu3zw33Qu1iUOk\" target=\"_blank\">https://globizcloudserver.com/browsepets/public/email-verification/7Muq4EZZ8yd6jryw65EDLS9ZuTmEqKyO9atUTQlSrnBmhUenAxdu3zw33Qu1iUOk</a></p>\r\n\r\n<p>Thanks</p>',	'info@example.com',	'zojagesat@mailinator.com',	NULL,	NULL,	1,	0,	'2022-11-03 17:32:47',	'2022-11-03 12:02:50'),
(18,	'phone-verification-otp',	'Your one time password for Browse4Pets',	'<p>Dear Roth&nbsp;Kirby<br />\r\n<br />\r\nYour account one time password for login is <strong>827425</strong>\r\n<br />\r\nThanks</p>',	'info@example.com',	'zojagesat@mailinator.com',	NULL,	NULL,	1,	0,	'2022-11-03 17:33:39',	'2022-11-03 12:03:42'),
(19,	'admin-forgot-password',	'Forgot Password',	'<p><img src=\"https://globizcloudserver.com/phew/public/uploads/editor/16183353227299-screenshot-2021-01-08-at-12.png\" style=\"max-width: 100%; max-height: 400px;\" /></p>\r\n\r\n<p>Dear Browse4Pets&nbsp;Admin<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\nhttp://localhost/laravel/browsepets/public/admin/recover-password/GacSmCOgkgEJ4SrcP5B51PnjqorJQuN8<br />\r\n<br />\r\nThanks</p>',	'info@example.com',	'admin@globiz.com',	NULL,	NULL,	1,	0,	'2022-11-05 13:05:12',	'2022-11-05 07:35:18');

CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `type` enum('admin','client') DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `short_codes` tinytext DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `email_templates` (`id`, `title`, `slug`, `type`, `subject`, `description`, `short_codes`, `created`, `modified`) VALUES
(1,	'Admin Registration',	'admin-registration',	'admin',	'Admin Registration Successful.',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nYou account has been registered on {company_name}. Please use the below credentails for login.<br />\r\n<br />\r\n{admin_link}<br />\r\nEmail: {email}<br />\r\nPassword: {password}<br />\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{email},{password},{admin_link},{company_name}',	'2021-03-01 12:18:13',	'2021-03-01 02:44:27'),
(2,	'Forgot Password',	'admin-forgot-password',	'admin',	'Forgot Password',	'<p><img src=\"https://globizcloudserver.com/phew/public/uploads/editor/16183353227299-screenshot-2021-01-08-at-12.png\" style=\"max-width: 100%; max-height: 400px;\" /></p>\r\n\r\n<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\n{recovery_link}<br />\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{email},{recovery_link},{admin_link},{company_name}',	'2021-03-01 12:18:09',	'2021-04-13 12:07:09'),
(3,	'Admin Second Auth OTP',	'admin-second-auth-otp',	'admin',	'Your one time password for {company_name}',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nYour account one time password for login is <strong>{one_time_password}</strong>\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{one_time_password},{company_name}',	'2021-03-01 12:18:13',	'2021-03-01 02:44:27'),
(4,	'User Registration',	'registration',	'client',	'Registration Successful.',	'<p>Dear {first_name}&nbsp;{last_name}</p>\r\n\r\n<p>Greetings! Thank you for registration with us. Please verify your email from the link below.</p>\r\n\r\n<p>{verification_link}</p>\r\n\r\n<p>Thanks</p>',	'{first_name},{last_name},{email},{website_link},{verification_link}',	'2021-03-01 12:18:13',	'2021-03-01 02:44:27'),
(5,	'Forgot Password',	'forgot-password',	'client',	'Forgot Password',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nPlease click on below link to reset your account password.<br />\r\n<br />\r\n{recovery_link}<br />\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{email},{code},{website_link},{company_name}',	'2021-03-01 12:18:09',	'2021-08-24 12:39:56'),
(6,	'Customer Registration by Admin',	'customer-admin-registration',	'client',	'Registration Successful.',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nYou account has been registered on {company_name}. Please use the below credentails for login.<br />\r\n<br />\r\n{website_link}<br />\r\nEmail: {email}<br />\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{email},{website_link},{company_name}',	'2021-03-01 12:18:13',	'2021-03-01 02:44:27'),
(7,	'Email Update',	'email-update',	'client',	'Change you email address',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nPlease click on below link to update your email address on {company_name}<br />\r\n\r\n{email_update_link}\r\n\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{website_link},{company_name},{email_update_link}',	'2021-03-01 12:18:13',	'2021-03-01 02:44:27'),
(8,	'Messages Notification',	'message-notification',	'client',	'{from_first_name} sent you a message',	'<h4 style=\"margin: 0 0 20px; font-size: 18px; font-weight: 400; color: #000;\">{from_first_name}, {from_last_name} has sent you a message</h4>\r\n\r\n<p>{view_and_response_button}</p>',	'{from_first_name},{from_last_name}, {to_first_name}, {to_last_name}, {view_and_response_button},{website_link},{company_name},{email_update_link}',	'2021-07-02 18:25:40',	'2021-07-02 09:04:57'),
(9,	'Help support',	'help-support',	'client',	'Help support',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nThank You for submitting your request. We will contact you soon. \r\n\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{email}',	'2021-09-07 15:55:08',	'2021-09-07 10:25:08'),
(10,	'Creator Registration by Admin',	'creator-admin-registration',	'client',	'Registration Successful.',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nYou account has been registered on {company_name}. Please use the below credentails for login.<br />\r\n<br />\r\n{website_link}<br />\r\nEmail: {email}<br />\r\nPassword: {password}<br />\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{email},{password},{website_link},{company_name}',	'2021-03-01 12:18:13',	'2021-03-01 02:44:27'),
(11,	'Contact Request',	'client-contact-request',	'client',	'Request Submitted Successfully',	'<p>Dear {first_name} {last_name}</p>\r\n\r\n<p><br>\r\nThank You for submitting your request. We will contact you soon.</p>\r\n\r\n<p><br>\r\nThanks</p>\r\n',	'{first_name},{last_name},{email},{subject},{message}',	'2021-03-01 12:18:09',	'2021-02-28 21:16:55'),
(12,	'Contact Request',	'admin-contact-request',	'admin',	'New Contact Request',	'<p>New Contact Request Received!!</p>\r\n\r\n<p> </p>\r\n\r\n<p>Name: {first_name} {last_name}</p>\r\n\r\n<p>Email: {email}</p>\r\n\r\n<p>Message: {message}</p>\r\n\r\n<p><br>\r\nThanks</p>\r\n',	'{first_name},{last_name},{email},{subject},{message}',	'2021-03-01 12:18:09',	'2021-02-28 21:16:55'),
(13,	'Client Second Auth OTP',	'client-second-auth-otp',	'client',	'Your one time password for {company_name}',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nYour account one time password for login is <strong>{one_time_password}</strong>\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{one_time_password},{company_name}',	'2022-07-04 09:49:14',	'2022-07-04 04:19:14'),
(14,	'Phone Number Verification OTP',	'phone-verification-otp',	'client',	'Your one time password for {company_name}',	'<p>Dear {first_name}&nbsp;{last_name}<br />\r\n<br />\r\nYour account one time password for login is <strong>{one_time_password}</strong>\r\n<br />\r\nThanks</p>',	'{first_name},{last_name},{one_time_password},{company_name}',	'2022-07-04 09:49:14',	'2022-07-04 04:19:14');

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `faqs_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `faqs` (`id`, `title`, `description`, `slug`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(38,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:15'),
(39,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(40,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(41,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(42,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(43,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(44,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(45,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(46,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(47,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	1,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(48,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	0,	7,	NULL,	'2022-03-17 15:36:08',	'2022-06-28 10:47:49'),
(49,	'Lorem Ipsum is simply dummy text of the printing and typesetting industry.',	'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry',	'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-d20a9n',	0,	7,	NULL,	'2022-03-17 15:36:08',	'2022-09-03 05:45:51'),
(50,	'If you\'re looking for random paragraphs.123456789 1011121314151617181920 21222324252627282930 31323334353637383940 41424344454647484950 51525354555657585960 61626364656667686970 71727374757677787980 81828384858687888990 919293949596979899100 123456789 101',	'If you\'re looking for random paragraphs, you\'ve come to the right place. When a random word or a random sentence isn\'t quite enough, the next logical step is to find a random paragraph.',	'if-youre-looking-for-random-paragraphs123456789-1011121314151617181920-21222324252627282930-31323334353637383940-41424344454647484950-51525354555657585960-61626364656667686970-71727374757677787980-81828384858687888990-919293949596979899100-123456789-10111',	1,	7,	NULL,	'2022-09-03 11:18:59',	'2022-09-03 06:15:45'),
(51,	'A random paragraph can also be an excellent way for a writer to tackle writers\' block. Writing block can often happen due to being stuck with a current project that the writer is trying to complete. By inserting a completely random paragraph from which to',	'Generating random paragraphs can be an excellent way for writers to get their creative flow going at the beginning of the day. The writer has no idea what topic the random paragraph will be about when it appears. This forces the writer to use creativity to complete one of three common writing challenges. The writer can use the paragraph as the first one of a short story and build upon it. A second option is to use the random paragraph somewhere in a short story they create. The third option is to have the random paragraph be the ending paragraph in a short story. No matter which of these challenges is undertaken, the writer is forced to use creativity to incorporate the paragraph into their writing.\r\nIf you do find this paragraph tool useful, please do us a favor and let us know how you\'re using it. It\'s greatly beneficial for us to know the different ways this tool is being used so we can improve it with updates. This is especially true since there are times when the generators we create get used in completely unanticipated ways from when we initially created them. If you have the time, please send us a quick note on what you\'d like to see changed or added to make it better in the future.\r\nHe read about a hike called the incline in the guidebook. It said it was a strenuous hike and to bring plenty of water. “A beautiful hike to the clouds” described one review. “Not for the faint-hearted,” said another. “Not too bad of a workout”, bragged a third review. I thought I’d hike it when I fly in from Maryland on my day off from the senior citizen\'s wellness conference. I hiked 2 miles a day around the neighborhood so I could handle a 1.1-mile hike. What a foolish mistake that was for a 70-year-old low-lander. \r\nThere are usually about 200 words in a paragraph, but this can vary widely. Most paragraphs focus on a single idea that\'s expressed with an introductory sentence, then followed by two or more supporting sentences about the idea. A short paragraph may not reach even 50 words while long paragraphs can be over 400 words long, but generally speaking they tend to be approximately 200 words in length.\r\nFake words are simply made up words that appear to be real, but actually don\'t exist and don\'t have any meaning. They initially appear real because they can be pronounced which makes it seem like they would be real words. This leads to the question of why in the world would anyone needs to find fake words or use a fake word generator? It does seem a bit strange at first, but there are actually a number of legitimate reasons why people find this free nonsense word tool useful. Below we list a few of the more common reasons that people might want to generate random pseudo words.123',	'a-random-paragraph-can-also-be-an-excellent-way-for-a-writer-to-tackle-writers-block-writing-block-can-often-happen-due-to-being-stuck-with-a-current-project-that-the-writer-is-trying-to-complete-by-inserting-a-completely-random-paragraph-from-which-to-5p',	1,	7,	NULL,	'2022-09-03 11:30:55',	'2022-09-03 06:19:55');

CREATE TABLE `feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rating` varchar(20) NOT NULL,
  `category` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `feedback` (`id`, `rating`, `category`, `email`, `description`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(1,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(3,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(4,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(5,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(6,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(7,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(8,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(9,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(10,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(11,	'5',	'complaint',	'irfan.ahmad@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 04:47:56'),
(12,	'5',	'complaint',	'neha@globiztechnology.com',	'dfd fgfdg fgfh fhgf fgh',	1,	NULL,	NULL,	'2022-03-25 10:17:32',	'2022-03-25 11:36:56'),
(13,	'4',	'dsfhg',	'df@gmail.com',	'dgf',	1,	7,	NULL,	'2022-03-25 17:24:37',	'2022-03-25 11:54:37'),
(14,	'4',	'dsfhg',	'df@gmail.com',	'dgf',	1,	7,	NULL,	'2022-03-25 17:24:54',	'2022-03-25 11:54:54'),
(15,	'5',	'asdas',	'dadas',	'dsadsad',	1,	7,	NULL,	'2022-03-25 17:27:09',	'2022-03-25 11:57:09'),
(16,	'5',	'asdas',	'dadas',	'dsadsad',	1,	7,	NULL,	'2022-03-25 17:27:30',	'2022-03-25 12:45:10'),
(17,	'5',	'hhg',	'fyty@gmail.com',	'tyg',	1,	7,	NULL,	'2022-03-25 17:52:45',	'2022-03-25 12:22:45'),
(18,	'',	'complaint',	'jk@gmail.com',	'fd',	1,	7,	NULL,	'2022-03-28 15:24:40',	'2022-03-28 09:54:40'),
(19,	'',	'compliment',	'yhy@gmail.com',	'gh',	1,	7,	NULL,	'2022-03-28 15:26:07',	'2022-03-28 09:56:07'),
(20,	'5',	'complaint',	'fg@gmail.com',	'sf',	1,	7,	NULL,	'2022-03-28 15:29:11',	'2022-03-28 09:59:11'),
(21,	'3',	'compliment',	'df@gmail.com',	'fdhg',	1,	7,	NULL,	'2022-03-28 15:40:15',	'2022-03-28 10:10:15');

CREATE TABLE `health_tests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `type` enum('sire','dam') DEFAULT NULL,
  `sire_name` varchar(100) DEFAULT NULL COMMENT 'Father Name',
  `dam_name` varchar(100) DEFAULT NULL COMMENT 'Mother Name',
  `test_name` varchar(255) NOT NULL,
  `result` varchar(255) NOT NULL,
  `test_date` date DEFAULT NULL,
  `certificate` text DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `health_tests_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `health_tests` (`id`, `product_id`, `type`, `sire_name`, `dam_name`, `test_name`, `result`, `test_date`, `certificate`, `deleted_at`, `created`, `modified`) VALUES
(151,	217,	'sire',	NULL,	NULL,	'Drug Test 1',	'Passed',	'2021-02-03',	'/uploads/sire_certificate/16716972388294-pdf-file-icon.png',	NULL,	'2022-12-22 13:50:40',	'2022-12-22 08:20:57'),
(152,	219,	'sire',	NULL,	NULL,	'UP-123',	'Perpect',	'2022-01-01',	'/uploads/sire_certificate/16720385196080-no-image.jpg',	NULL,	'2022-12-26 12:38:41',	'2022-12-26 07:08:41'),
(153,	219,	'sire',	NULL,	NULL,	'UP-234',	'100%',	'2021-02-02',	'/uploads/sire_certificate/16720385504970-no-image.jpg',	NULL,	'2022-12-26 12:39:12',	'2022-12-26 07:09:12'),
(154,	219,	'sire',	NULL,	NULL,	'UP-345',	'Positive',	'2022-03-03',	'/uploads/sire_certificate/1672038584842-pdf-file-icon.png',	NULL,	'2022-12-26 12:39:45',	'2022-12-26 07:09:45'),
(155,	219,	'dam',	NULL,	NULL,	'UP-987',	'Result 9',	'2021-04-04',	'/uploads/sire_certificate/16720386105606-no-image.jpg',	NULL,	'2022-12-26 12:40:11',	'2022-12-26 07:10:11'),
(156,	219,	'dam',	NULL,	NULL,	'UP-876',	'Result 8',	'2020-04-05',	'/uploads/sire_certificate/16720386362265-no-image.jpg',	NULL,	'2022-12-26 12:40:38',	'2022-12-26 07:10:38'),
(157,	219,	'dam',	NULL,	NULL,	'UP-765',	'Result 7',	'2020-06-07',	'/uploads/sire_certificate/16720386637777-no-image.jpg',	NULL,	'2022-12-26 12:41:05',	'2022-12-26 07:11:05');

CREATE TABLE `help_supports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `help_supports_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `help_supports_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `home_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banner_title` varchar(255) DEFAULT NULL,
  `banner_description` text DEFAULT NULL,
  `banner_image` text DEFAULT NULL,
  `pet_title` varchar(255) DEFAULT NULL,
  `pet_link_title` varchar(255) DEFAULT NULL,
  `pet_link` varchar(255) DEFAULT NULL,
  `pet_image` text DEFAULT NULL,
  `footer_title` varchar(255) DEFAULT NULL,
  `footer_description` text DEFAULT NULL,
  `highlights` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `home_settings_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `home_settings` (`id`, `banner_title`, `banner_description`, `banner_image`, `pet_title`, `pet_link_title`, `pet_link`, `pet_image`, `footer_title`, `footer_description`, `highlights`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(1,	'Find your new best friend',	'Connect safely with a good breeder to find a happy healthy puppy',	'/uploads/homes/16504434449316-banner.png',	'Haven\'t found your Best friend yet?',	'Don\'t miss out',	'#',	'/uploads/homes/16504445639213-foun.png',	'Browse4Pets',	'Connect safely with a good breeder to find a happy healthy puppy',	'[\"161\",\"160\",\"159\"]',	7,	NULL,	'2021-08-18 15:35:45',	'2022-09-03 06:50:11');

CREATE TABLE `memberships` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `price` decimal(11,2) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `currenct_code` varchar(255) NOT NULL,
  `days` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `memberships_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `memberships` (`id`, `title`, `slug`, `price`, `currency`, `currenct_code`, `days`, `description`, `status`, `created_by`, `created`, `modified`) VALUES
(1,	'Annual Plan',	'annual-plan-Ewerpm',	28511.00,	'£',	'THB',	365,	'Demio',	1,	7,	'2022-11-21 18:11:41',	'2022-12-07 05:15:22'),
(2,	'Monthly Plan',	'monthly-plan-Ewerpm',	12556.00,	'£',	'THB',	30,	'Demio',	1,	7,	'2022-11-21 18:11:41',	'2022-12-06 13:13:27');

CREATE TABLE `membership_features` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membership_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `price` decimal(11,2) NOT NULL,
  `type` enum('available','upcoming') NOT NULL,
  `plan_type` enum('bumped','highlight','new') NOT NULL,
  `currency` varchar(255) NOT NULL,
  `currenct_code` varchar(255) NOT NULL,
  `days` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `membership_id` (`membership_id`),
  CONSTRAINT `membership_features_ibfk_1` FOREIGN KEY (`membership_id`) REFERENCES `memberships` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `membership_features` (`id`, `membership_id`, `title`, `slug`, `price`, `type`, `plan_type`, `currency`, `currenct_code`, `days`, `description`, `status`, `created`, `modified`) VALUES
(1,	1,	'New ad',	'new-ad-n2MDpq',	45.00,	'available',	'new',	'£',	'THB',	30,	'Duration 30 days',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:39:23'),
(2,	1,	'Highlighted Ad',	'highlighted-ad-awb7pe',	70.50,	'available',	'highlight',	'£',	'THB',	7,	'Rotate for 7 day',	1,	'2022-11-22 11:05:24',	'2022-12-08 10:29:56'),
(3,	1,	'Bump Ad',	'bump-ad-Ewerpm',	50.00,	'available',	'bumped',	'£',	'THB',	1,	'Set max of 1 bumb a day',	1,	'2022-11-22 11:05:24',	'2022-12-08 10:29:56'),
(4,	1,	'Upcoming Litter (UCL) ad',	'upcoming-litter-ucl-ad-G2Rmp3',	50.00,	'upcoming',	'new',	'£',	'THB',	30,	'Duration 30 days',	1,	'2022-11-22 11:05:24',	'2022-12-08 10:29:56'),
(5,	1,	'Highlighted UCL ad',	'highlighted-ucl-ad-Kp4M2m',	70.50,	'upcoming',	'highlight',	'£',	'THB',	7,	'Rotate for 7 days',	1,	'2022-11-22 11:05:24',	'2022-12-08 10:29:56'),
(6,	1,	'Bump UCL Ad',	'bump-ucl-ad-d20a9n',	45.00,	'upcoming',	'bumped',	'£',	'THB',	1,	'Set max of 1 bumb a day',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:39:23'),
(7,	NULL,	'New ad',	'new-ad-5pvK20',	35.00,	'available',	'new',	'£',	'THB',	30,	'Duration 30 days',	1,	'2022-11-22 11:05:24',	'2022-12-08 08:31:17'),
(8,	NULL,	'Highlighted Ad',	'highlighted-ad-72repd',	45.00,	'available',	'highlight',	'£',	'THB',	7,	'Rotate for 7 day',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:39:23'),
(9,	NULL,	'Bump Ad',	'bump-ad-V9ZlpX',	70.00,	'available',	'bumped',	'£',	'THB',	1,	'Set max of 1 bumb a day',	1,	'2022-11-22 11:05:24',	'2022-12-08 10:29:56'),
(14,	2,	'New ad',	'new-ad-n2MDpq2',	40.00,	'available',	'new',	'£',	'THB',	30,	'Duration 30 days',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:39:23'),
(15,	2,	'Highlighted Ad',	'highlighted-ad-awb7pe2',	70.50,	'available',	'highlight',	'£',	'THB',	7,	'Rotate for 7 day',	1,	'2022-11-22 11:05:24',	'2022-12-09 11:06:19'),
(16,	2,	'Bump Ad',	'bump-ad-Ewerpm2',	35.00,	'available',	'bumped',	'£',	'THB',	1,	'Set max of 1 bumb a day',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:50:43'),
(17,	2,	'Upcoming Litter (UCL) ad',	'upcoming-litter-ucl-ad-G2Rmp32',	35.00,	'upcoming',	'new',	'£',	'THB',	30,	'Duration 30 days',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:50:43'),
(18,	2,	'Highlighted UCL ad',	'highlighted-ucl-ad-Kp4M2m2',	37.50,	'upcoming',	'highlight',	'£',	'THB',	7,	'Rotate for 7 days',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:50:43'),
(19,	2,	'Bump UCL Ad',	'bump-ucl-ad-d20a9n2',	35.00,	'upcoming',	'bumped',	'£',	'THB',	1,	'Set max of 1 bumb a day',	1,	'2022-11-22 11:05:24',	'2022-12-20 07:50:43');

CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment_type` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `read_at` datetime DEFAULT NULL,
  `notify` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `from_id` (`from_id`),
  KEY `to_id` (`to_id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`from_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`to_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rel_id` int(11) DEFAULT NULL,
  `from_id` int(11) DEFAULT NULL,
  `to_id` int(11) DEFAULT NULL,
  `message` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type` enum('audio_uploaded','video_uploaded','meeting_created','meeting_updated','made_announcement','schedule_uploaded','poll_created','poll_submitted','subscribe_creator','renew_creator','changes_in_plan','review_received','review_updated','questions_received','video_likes') CHARACTER SET utf8 DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `cc_user_id` (`rel_id`),
  KEY `from_id` (`from_id`),
  KEY `to_id` (`to_id`),
  CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`from_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notifications_ibfk_2` FOREIGN KEY (`to_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `pages_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `pages` (`id`, `title`, `description`, `slug`, `image`, `meta_title`, `meta_description`, `meta_keywords`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(2,	'Terms & Conditions',	'<h3>Nullam interdum lorem ipsumt dor aliquam lobortis dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.qwerty qwerty 1234567889 123467789</p>\r\n\r\n<p>qwerty1234567</p>\r\n\r\n<h3>&nbsp;</h3>',	'terms-conditions',	'/uploads/pages/16516527821759-element.png',	'Terms & Conditions',	'Terms & Conditions',	'Terms & Conditions',	1,	7,	NULL,	'2020-09-05 15:05:14',	'2022-09-03 07:55:35'),
(3,	'Privacy Policy',	'<h3>Nullam interdum lorem ipsumt dor aliquam lobortis dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>',	'privacy-policy',	'/uploads/pages/16516657181109-element.png',	'Privacy Policy',	'Privacy Policy',	'Privacy Policy',	1,	7,	NULL,	'2020-09-05 15:05:14',	'2022-09-03 08:12:11'),
(4,	'Get in touch',	'',	'contact-us',	'/uploads/pages/16603023111566-mixedsitting-5wr.png',	'Contact Us',	'Contact Us',	'Contact Us',	1,	7,	NULL,	'2020-09-05 15:05:14',	'2022-09-03 08:15:39'),
(5,	'Steps of microchip verification',	'<h3>Nullam interdum lorem ipsumt dor aliquam lobortis dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>',	'microchip-verification',	'/uploads/pages/16516657181109-element.png',	'',	'',	'',	1,	7,	NULL,	'2020-09-05 15:05:14',	'2022-06-27 10:01:40'),
(6,	'Instructions and tips for buying a dog',	'<h3>Nullam interdum lorem ipsumt dor aliquam lobortis dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>\r\n\r\n<h3>lorem ipsum sit dor aliquam dolor</h3>\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum suscipit quam non eleifend ornare. Nullam porta volutpat facilisis. Mauris vehicula nisl eget elit aliquet, id dapibus odio iaculis. Duis id consectetur mi. Vivamus aliquam lorem lacus, ac molestie sapien sagittis eget. Cras eget elementum ligula. Donec efficitur quam ut tortor pretium molestie. Fusce velit purus, cursus at risus non, laoreet tempus diam.</p>',	'instructions-and-tips-for-buying-a-dog',	'/uploads/pages/16516657181109-element.png',	'',	'',	'',	1,	7,	NULL,	'2020-09-05 15:05:14',	'2022-09-03 08:07:39');

CREATE TABLE `pedigree` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unique_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `dog_pedigree_id` int(11) DEFAULT NULL,
  `dog_unique_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `champion` tinyint(1) NOT NULL DEFAULT 0,
  `type` enum('parents','grand_parents','great_grand_parents','great_great_grandparents') DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  KEY `user_id` (`user_id`),
  KEY `dog_pedigree_id` (`dog_pedigree_id`),
  CONSTRAINT `pedigree_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pedigree_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pedigree_ibfk_3` FOREIGN KEY (`dog_pedigree_id`) REFERENCES `dog_pedigree` (`id`) ON DELETE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `pedigree` (`id`, `unique_id`, `product_id`, `dog_pedigree_id`, `dog_unique_id`, `user_id`, `parent_id`, `gender`, `name`, `champion`, `type`, `created`, `modified`) VALUES
(393,	7433786,	211,	2376,	316642,	1,	NULL,	'male',	'Hillary Marsh',	0,	'parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(394,	6080558,	211,	2377,	316642,	1,	393,	'male',	'Eric Brady',	0,	'grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(395,	4960600,	211,	2378,	316642,	1,	394,	'male',	'Claudia Hudson',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(396,	6102263,	211,	2379,	316642,	1,	395,	'male',	'Blaze Bond',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(397,	2663205,	211,	2380,	316642,	1,	395,	'female',	'Linus Tucker',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(398,	6402201,	211,	2381,	316642,	1,	394,	'female',	'Porter Frazier',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(399,	3980321,	211,	2382,	316642,	1,	398,	'male',	'Felix Ross',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(400,	2357328,	211,	2383,	316642,	1,	398,	'female',	'Faith Hahn',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(401,	6958049,	211,	2384,	316642,	1,	393,	'female',	'Palmer Knight',	0,	'grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(402,	6208531,	211,	2385,	316642,	1,	401,	'male',	'Drew Morton',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(403,	7012047,	211,	2386,	316642,	1,	402,	'male',	'Adrian Hyde',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(404,	5881994,	211,	2387,	316642,	1,	402,	'female',	'Pamela Flores',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(405,	2877247,	211,	2388,	316642,	1,	401,	'female',	'Hakeem Olson',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(406,	7713222,	211,	2389,	316642,	1,	405,	'male',	'Alfreda Hayden',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(407,	268087,	211,	2390,	316642,	1,	405,	'female',	'Mikayla Potter',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(408,	6682223,	211,	2391,	316642,	1,	NULL,	'female',	'Callum Mcbride',	0,	'parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(409,	9592131,	211,	2392,	316642,	1,	408,	'male',	'Faith Marquez',	0,	'grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(410,	1234564,	211,	2393,	316642,	1,	409,	'male',	'Yuli Garner',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(411,	41968,	211,	2394,	316642,	1,	410,	'male',	'Lilah Rhodes',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(412,	3618299,	211,	2395,	316642,	1,	410,	'female',	'Vivian Carroll',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(413,	2850578,	211,	2396,	316642,	1,	409,	'female',	'Joan Clayton',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(414,	772784,	211,	2397,	316642,	1,	413,	'male',	'Gretchen Larsen',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(415,	9163592,	211,	2398,	316642,	1,	413,	'female',	'Alea Branch',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(416,	95266,	211,	2399,	316642,	1,	408,	'female',	'Nerea Peck',	0,	'grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(417,	9548067,	211,	2400,	316642,	1,	416,	'male',	'Ella Valenzuela',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(418,	9052059,	211,	2401,	316642,	1,	417,	'male',	'Jorden Aguirre',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(419,	2633705,	211,	2402,	316642,	1,	417,	'female',	'Mercedes Kennedy',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(420,	9247115,	211,	2403,	316642,	1,	416,	'female',	'Tyrone Marshall',	0,	'great_grand_parents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(421,	4734262,	211,	2404,	316642,	1,	420,	'male',	'Genevieve Hansen',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57'),
(422,	5166789,	211,	2405,	316642,	1,	420,	'female',	'Arden Klein',	0,	'great_great_grandparents',	'2022-12-27 18:55:57',	'2022-12-27 13:25:57');

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `permissions` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `permissions` (`id`, `title`, `type`, `permissions`) VALUES
(8,	'Faq',	'faqs',	'{\"listing\":\"1\",\"create\":\"1\",\"update\":\"1\",\"delete\":\"1\"}'),
(9,	'Pages',	'pages',	'{\"listing\":\"1\",\"create\":\"1\",\"update\":\"1\",\"delete\":\"1\"}'),
(10,	'Help support',	'help_support',	'{\"listing\":\"1\",\"create\":\"0\",\"update\":\"0\",\"delete\":\"1\"}'),
(13,	'Products',	'products',	'{\"listing\":\"1\",\"create\":\"1\",\"update\":\"1\",\"delete\":\"1\"}'),
(22,	'Product Cateogories',	'product_categories',	'{\"listing\":\"1\",\"create\":\"1\",\"update\":\"1\",\"delete\":\"1\"}'),
(32,	'Product Orders',	'product_orders',	'{\"listing\":\"1\",\"create\":\"1\",\"update\":\"1\",\"delete\":\"1\"}'),
(33,	'Product Queries',	'product_queries',	'{\"listing\":\"1\",\"create\":\"1\",\"update\":\"1\",\"delete\":\"1\"}');

CREATE TABLE `postal_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `city_id` int(11) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `city_id` (`city_id`),
  CONSTRAINT `postal_codes_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `ad_type` enum('available_dogs','upcoming_litter') DEFAULT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `age` varchar(50) NOT NULL,
  `dob` date DEFAULT NULL,
  `phonenumber` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `image` text DEFAULT NULL,
  `cropped_area` text DEFAULT NULL,
  `video_type` varchar(50) DEFAULT NULL,
  `video` text DEFAULT NULL,
  `facebook` text DEFAULT NULL,
  `youtube` text DEFAULT NULL,
  `country_origin` varchar(50) DEFAULT NULL,
  `price_status` tinyint(1) DEFAULT NULL,
  `country_id` int(5) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `postal_code_id` int(11) DEFAULT NULL,
  `zip_code` varchar(50) DEFAULT NULL,
  `locality` varchar(50) DEFAULT NULL,
  `instructions_and_tips` text DEFAULT NULL,
  `registration_health` text DEFAULT NULL,
  `microchip_registration_id` int(11) DEFAULT NULL,
  `health_test_sire_name` varchar(255) DEFAULT NULL,
  `health_test_dam_name` varchar(255) DEFAULT NULL,
  `display_generations` varchar(10) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `draft` tinyint(1) NOT NULL DEFAULT 0,
  `form_step` tinyint(1) NOT NULL DEFAULT 0,
  `pet_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1 = Available, 2 = Hold, 3 = Sold',
  `created_by` int(11) DEFAULT NULL,
  `posted_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `created_by` (`created_by`),
  KEY `posted_by` (`posted_by`),
  KEY `country_id` (`country_id`),
  KEY `state_id` (`state_id`),
  KEY `city_id` (`city_id`),
  KEY `postal_code_id` (`postal_code_id`),
  KEY `microchip_registration_id` (`microchip_registration_id`),
  CONSTRAINT `products_ibfk_13` FOREIGN KEY (`microchip_registration_id`) REFERENCES `dog_microchips` (`id`) ON DELETE SET NULL,
  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL,
  CONSTRAINT `products_ibfk_3` FOREIGN KEY (`posted_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `products_ibfk_4` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `products_ibfk_5` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `products` (`id`, `title`, `slug`, `ad_type`, `description`, `price`, `gender`, `age`, `dob`, `phonenumber`, `email`, `image`, `cropped_area`, `video_type`, `video`, `facebook`, `youtube`, `country_origin`, `price_status`, `country_id`, `state_id`, `city_id`, `postal_code_id`, `zip_code`, `locality`, `instructions_and_tips`, `registration_health`, `microchip_registration_id`, `health_test_sire_name`, `health_test_dam_name`, `display_generations`, `meta_title`, `meta_keywords`, `meta_description`, `status`, `draft`, `form_step`, `pet_status`, `created_by`, `posted_by`, `deleted_at`, `created`, `modified`) VALUES
(211,	'Test',	'test-B2kVnp',	'available_dogs',	'sdfsdfsd',	123.00,	'',	'',	'2007-01-10',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Samoa',	1,	106,	9,	1,	NULL,	'141007',	'qssaS',	'',	'[\"ikc_registered\",\"vaccinated\"]',	5,	'',	'',	'4',	NULL,	NULL,	NULL,	1,	1,	5,	1,	NULL,	1,	NULL,	'2022-12-14 13:14:13',	'2022-12-27 13:25:57'),
(214,	'asasas',	'asasas-P2LlX2',	'available_dogs',	'asasa',	0.00,	'',	'',	'2014-03-11',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Samoa',	0,	106,	29,	1,	NULL,	'141008',	'77 st no 4',	'',	'[\"vet_checked\"]',	5,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	2,	1,	NULL,	1,	NULL,	'2022-12-20 19:01:32',	'2022-12-20 13:31:35'),
(215,	'asdasd',	'asdasd-L9xQjw',	'upcoming_litter',	'dsadsadsadasdasds',	0.00,	'',	'',	'2022-12-29',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Samoa',	NULL,	106,	31,	1,	NULL,	'',	'dsadsad',	NULL,	NULL,	5,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	2,	1,	NULL,	1,	NULL,	'2022-12-20 19:10:21',	'2022-12-20 13:40:23'),
(216,	'gdfgdfg',	'gdfgdfg-DpYBJ2',	'available_dogs',	'gdfgdfg',	0.00,	'',	'',	'2006-11-16',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Samoa',	0,	106,	29,	1,	NULL,	'',	'gdfgdfg',	'',	'[\"ikc_registered\",\"vaccinated\"]',	5,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	2,	1,	NULL,	1,	NULL,	'2022-12-20 19:12:08',	'2022-12-20 13:42:10'),
(217,	'Quia eum ut sit sed',	'quia-eum-ut-sit-sed-Ywg7Vw',	'available_dogs',	'Ut mollitia odio eli',	500.00,	'',	'',	'2018-11-10',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Adipisicing quibusda',	1,	235,	42,	1,	NULL,	'37926',	'Eum ipsam repellendu',	'',	'[\"ikc_registered\",\"wormed\",\"vet_checked\"]',	4,	'',	'',	'3',	NULL,	NULL,	NULL,	1,	1,	5,	1,	NULL,	13,	NULL,	'2022-12-22 13:48:35',	'2022-12-22 08:24:54'),
(218,	'Lorem impedit Nam i',	'lorem-impedit-nam-i-ywnQB9',	'upcoming_litter',	'Dolorem repellendus',	0.00,	'',	'',	'2023-10-14',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Sed dolor quasi ut e',	NULL,	106,	9,	1,	NULL,	'87528',	'Totam velit soluta',	NULL,	NULL,	5,	'',	'',	NULL,	NULL,	NULL,	NULL,	0,	0,	3,	1,	NULL,	13,	NULL,	'2022-12-22 13:55:53',	'2022-12-22 08:27:27'),
(219,	'Upcoming 1',	'upcoming-1-Bp6479',	'upcoming_litter',	'Upcoming Litters',	0.00,	'',	'',	'2022-12-30',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'Indian',	NULL,	106,	25,	1,	NULL,	'141008',	'77 st no 4',	NULL,	NULL,	5,	'Up Test 1',	'Up Test 2',	'4',	NULL,	NULL,	NULL,	1,	1,	5,	1,	NULL,	1,	NULL,	'2022-12-26 12:34:06',	'2022-12-26 07:11:15'),
(220,	'gfhfghfgh',	'gfhfghfgh-b9KVP2',	'available_dogs',	'fgfgfg',	0.00,	'',	'',	'2010-04-15',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'gffghfghgf',	0,	106,	25,	1,	NULL,	'',	'5rt5656fgf',	'',	NULL,	5,	'',	'',	'4',	NULL,	NULL,	NULL,	0,	0,	4,	1,	NULL,	1,	NULL,	'2022-12-26 12:56:47',	'2022-12-26 07:31:41'),
(221,	'dfdfdf',	'dfdfdf-Gpd8Pp',	'available_dogs',	'dfdfdfdfdfdfdf',	0.00,	'',	'',	'2011-08-15',	'',	'',	NULL,	NULL,	NULL,	NULL,	'[\"\",\"\"]',	'[\"\",\"\"]',	'fddfdd',	0,	106,	9,	1,	NULL,	'',	'dfdf',	'',	NULL,	5,	'',	'',	NULL,	NULL,	NULL,	NULL,	0,	0,	3,	1,	NULL,	1,	NULL,	'2022-12-26 13:10:12',	'2022-12-26 07:46:58');

CREATE TABLE `product_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `image` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `created_by` (`created_by`),
  KEY `parent_id` (`parent_id`),
  CONSTRAINT `product_categories_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`),
  CONSTRAINT `product_categories_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `product_categories` (`id`, `parent_id`, `title`, `image`, `slug`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(103,	NULL,	'Breed',	'',	'breed-EweM5w',	1,	7,	'2022-04-19 17:48:30',	'2022-04-19 17:48:30',	'2022-07-19 07:55:04'),
(104,	NULL,	'Akita',	'',	'akita-G2R6z2',	1,	7,	NULL,	'2022-04-19 17:48:49',	'2022-08-31 06:10:11'),
(105,	NULL,	'Basenji',	NULL,	'basenji-Kp4LRp',	1,	7,	NULL,	'2022-04-19 17:49:39',	'2022-08-31 06:06:32'),
(106,	NULL,	'Bulldog',	NULL,	'bulldog-d20BXw',	1,	7,	NULL,	'2022-04-19 17:49:46',	'2022-07-19 07:54:43'),
(107,	NULL,	'Bearded Collie',	NULL,	'bearded-collie-5pvxJ9',	1,	7,	NULL,	'2022-04-19 17:49:54',	'2022-07-19 07:54:43'),
(108,	NULL,	'Cairn Terrier',	NULL,	'cairn-terrier-72rKW9',	1,	7,	NULL,	'2022-04-19 17:50:04',	'2022-07-19 07:54:43'),
(109,	NULL,	'Dalmatian',	NULL,	'dalmatian-V9ZOaw',	1,	7,	NULL,	'2022-04-19 17:50:11',	'2022-07-19 07:54:43'),
(110,	NULL,	'English Setter',	NULL,	'english-setter-ypG30p',	1,	7,	NULL,	'2022-04-19 17:50:18',	'2022-07-19 07:54:43'),
(111,	NULL,	'Pug',	'',	'pug-B2k079',	1,	7,	NULL,	'2022-08-12 15:29:53',	'2022-08-12 09:59:53'),
(112,	NULL,	'Labrador',	'',	'labrador-82j4nw',	1,	7,	NULL,	'2022-08-12 15:30:06',	'2022-08-12 10:00:06'),
(113,	NULL,	'Pommerian',	'',	'pommerian-a9BN59',	1,	7,	NULL,	'2022-08-12 15:30:13',	'2022-08-12 10:00:13'),
(114,	NULL,	'Shiba Inu',	'',	'shiba-inu-P2LVYw',	1,	7,	NULL,	'2022-08-12 15:30:24',	'2022-08-12 10:00:24'),
(115,	NULL,	'Hello',	'',	'hello-L9x0v9',	1,	7,	'2022-08-31 11:48:48',	'2022-08-31 11:47:31',	'2022-08-31 06:18:48');

CREATE TABLE `product_category_relation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_id` (`product_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `product_category_relation_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_category_relation_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `product_category_relation` (`id`, `product_id`, `category_id`) VALUES
(285,	214,	104),
(286,	215,	104),
(287,	216,	105),
(288,	211,	104),
(289,	217,	106),
(290,	218,	106),
(291,	219,	104),
(292,	220,	104),
(293,	221,	104);

CREATE TABLE `product_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `cell_number` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `zipcode` int(11) NOT NULL,
  `message` text NOT NULL,
  `form_type` enum('order','query') DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `product_forms_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `product_likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `product_likes_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_likes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `product_plan_actions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `expired_on` datetime DEFAULT NULL,
  `bumped_on` datetime DEFAULT NULL,
  `highlight_on` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `product_plan_actions_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `product_plan_actions` (`id`, `product_id`, `expired_on`, `bumped_on`, `highlight_on`, `created`, `modified`) VALUES
(3,	211,	'2023-01-20 14:11:23',	NULL,	NULL,	'2022-12-21 10:53:55',	'2022-12-21 08:41:25'),
(4,	217,	'2023-01-21 13:54:57',	NULL,	NULL,	'2022-12-22 13:55:01',	'2022-12-22 08:25:01'),
(5,	219,	'2023-01-25 12:41:22',	NULL,	NULL,	'2022-12-26 12:41:26',	'2022-12-26 07:11:26');

CREATE TABLE `product_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `product_report_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_report_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `product_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id` (`product_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `product_views_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_views_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `province` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `province_code` varchar(50) NOT NULL,
  `country_id` int(11) NOT NULL,
  `latitude` decimal(8,5) DEFAULT NULL,
  `longitude` decimal(8,5) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `province` (`id`, `name`, `province_code`, `country_id`, `latitude`, `longitude`, `status`, `created`, `modified`) VALUES
(1,	'Ulster',	'',	252,	NULL,	NULL,	1,	'2022-08-25 11:58:25',	'2022-08-25 06:28:25'),
(2,	'Ulster',	'',	106,	NULL,	NULL,	1,	'2022-08-25 11:59:27',	'2022-08-25 06:29:27'),
(3,	'Connacht',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:00:05',	'2022-08-25 06:30:05'),
(4,	'Leinster',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:00:22',	'2022-08-25 06:30:22'),
(5,	'Munster',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:01:00',	'2022-08-25 06:31:00'),
(6,	'Wales',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:01:23',	'2022-08-25 06:31:23'),
(7,	'Scotland',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:01:46',	'2022-08-25 06:31:46'),
(8,	'East',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:02:10',	'2022-08-25 06:32:10'),
(9,	'South East',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:02:24',	'2022-08-25 06:32:24'),
(10,	'North West',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:02:42',	'2022-08-25 06:32:42'),
(11,	'London',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:03:06',	'2022-08-25 06:33:06'),
(12,	'North East',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:03:39',	'2022-08-25 06:33:39'),
(13,	'East Midlands',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:04:05',	'2022-08-25 06:34:05'),
(14,	'Yorkshire and the Humber',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:04:27',	'2022-08-25 06:34:27'),
(15,	'West Midlands',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:05:49',	'2022-08-25 06:35:49'),
(16,	'South West',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:08:52',	'2022-08-25 06:38:52');

CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(1,	'company_name',	'Browse4Pets'),
(2,	'website_url',	'https://globizcloudserver.com/browsepets/public'),
(3,	'measurement_unit',	'pc'),
(4,	'currency_symbol',	'£'),
(5,	'company_address',	'Dummy Address'),
(6,	'company_gst_number',	'1888998520'),
(7,	'currency_code',	'THB'),
(8,	'admin_recaptcha',	'0'),
(9,	'admin_second_auth_factor',	''),
(10,	'recaptcha_secret',	'6LdhM1oaAAAAACK2IkHNxnjEMh5Jkoa5hl2aZb0i'),
(11,	'recaptcha_key',	'6LdhM1oaAAAAADJXL3qLn2sxBpbMTdnaHZwV8hL1'),
(12,	'sendgrid_api_key',	'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'),
(13,	'sendgrid_email',	'vermani.ritish@gmail.com'),
(14,	'pagination_method',	'scroll'),
(15,	'globiz_logo',	'data:image/png;base64,[encoded data, 24332 characters]'),
(16,	'favicon',	'/uploads/logos/16512168826736-asset-5.png'),
(17,	'from_email',	'info@example.com'),
(18,	'smtp_host',	'smtp.gmail.com'),
(19,	'smtp_encryption',	'ssl'),
(20,	'smtp_username',	'globiznotification@gmail.com'),
(21,	'smtp_email',	'globiznotification@gmail.com'),
(22,	'smtp_password',	'eyJpdiI6IlJOZS83dGtQT3crRFdlSVA4LzEwL0E9PSIsInZhbHVlIjoiM0J1ODBNalNmUmlGQStCbzNmTmh5QjZqOXFSTkkwWCtHSzNMYzQya2xaYz0iLCJtYWMiOiIzZDkyOTYyOWUzMzQ5ZmRlNGYyY2ZhMDQ4ZTMyODRjY2M4MjU4NDY2ZjIxOGMwOTkyYzU3ZDgxNjk2YmFhM2U2IiwidGFnIjoiIn0='),
(23,	'smtp_port',	'465'),
(24,	'email_method',	'smtp'),
(25,	'logo',	'/uploads/logos/16512168777618-browse4pets.png'),
(26,	'admin_notification_email',	'info@example.com'),
(27,	'date_format',	'd/m/Y'),
(28,	'time_format',	'h:iA'),
(29,	'direct_login_after_registration',	'1'),
(30,	'session_expires_in_minutes',	'1440'),
(31,	'client_recaptcha',	'0'),
(32,	'client_second_auth_factor',	''),
(33,	'client_multi_device_logins',	'1'),
(46,	'google_api_key',	'AIzaSyDT7TbxQgOhC-6baK4vOvb2SfT7b2yXOY0'),
(47,	'footer_logo',	'https://globizcloudserver.com/comunex/public/assets/frontend/images/footer-logo.png'),
(48,	'powered_by',	'Globiz Technology Inc.'),
(49,	'powered_by_link',	'https://globiztechnology.com/'),
(50,	'company_email',	'dummy12@gmail.com'),
(51,	'company_phonenumber',	'+2 (943) 672-5733'),
(52,	'facebook',	'https://www.facebook.com/'),
(53,	'twitter',	'https://twitter.com/'),
(54,	'instagram',	'https://www.instagram.com/'),
(55,	'youtube',	'https://www.youtube.com/'),
(59,	'google_client_id',	'642028846293-1d4glu2m16v36omdgj3o3844vrdh5b9l.apps.googleusercontent.com'),
(60,	'google_secret_key',	'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'),
(61,	'google_redirect_uri',	'https://globizcloudserver.com/comunex/public/google-login'),
(62,	'aboutid',	'2'),
(63,	'google_scopes',	'https://www.googleapis.com/auth/userinfo.email, https://www.googleapis.com/auth/userinfo.profile'),
(64,	'google_approvel_prompt',	'auto'),
(65,	'google_access_type',	'online'),
(66,	'facebook_app_id',	'623371488915655'),
(67,	'facebook_api_version',	'v12.0'),
(68,	'facebook_app_secret',	'5d2505d8a21213bde036e68896ccd88c'),
(69,	'facebook_scopes',	'email'),
(70,	'facebook_redirect_uri',	'https://globizcloudserver.com/comunex/public/facebook-login'),
(71,	'_token',	'aEHfSzkgkRBBLF49RKGMjn6C6OBc4Z6V259NoHtX'),
(72,	'mail',	'demo@globiztechnology.com'),
(73,	'resize_method',	'aspect_ratio'),
(74,	'stripe_key',	'sk_test_51MBefZEheo3PIBMUxTO8dYkaX3CDiFx9otZCvk367zLla1KrypMcIwRLzXT5qV5j3eF5HPpXSTxjv6jAAe0hNRGP00DfvL7fap'),
(75,	'stripe_public_key',	'pk_test_51MBefZEheo3PIBMUEgIEdS29knB3ABFopa2rrLwjHNG0dneNpYGGDQnKvgwZ5hfo5dxeLTdylkF7b2UdTotvrd4N00S1mxIrnQ'),
(76,	'stripe_live',	'0'),
(77,	'stripe_live_key',	''),
(78,	'stripe_live_public_key',	'');

CREATE TABLE `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `slider_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `slider` (`id`, `title`, `url`, `description`, `slug`, `image`, `status`, `created_by`, `deleted_at`, `created`, `modified`) VALUES
(1,	'Uniform Accessories',	'',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam maximus orci at turpis suscipit rutrum.',	'fgf-n2MDpq',	'/uploads/slider/16486421299329-vector.png',	1,	7,	NULL,	'2022-03-30 11:03:04',	'2022-04-01 05:48:46'),
(2,	'Uniform && Accessories',	'',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam maximus orci at turpis suscipit rutrum.',	'tyt-awb7pe',	'',	1,	7,	'2022-04-01 11:22:42',	'2022-03-30 11:10:27',	'2022-04-01 05:52:42'),
(3,	'Neha',	'',	'<p>gjghj</p>',	'neha-Ewerpm',	'/uploads/slider/16486420091837-vector.png',	1,	7,	'2022-03-31 10:21:26',	'2022-03-30 11:25:26',	'2022-03-31 04:51:26'),
(4,	'Uniform accesories',	'',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam maximus orci at turpis suscipit rutrum.',	'dftgfd-G2Rmp3',	'/uploads/slider/16486277778523-vector.png',	1,	7,	'2022-04-01 11:22:37',	'2022-03-30 11:26:30',	'2022-04-01 05:52:37'),
(5,	'Uniform & Accessories',	'',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam maximus orci at turpis suscipit rutrum.',	'uniform-accessories-Kp4M2m',	'',	1,	7,	'2022-04-01 11:22:31',	'2022-03-31 10:08:53',	'2022-04-01 05:52:31'),
(6,	'Test Slider',	'',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam maximus orci at turpis suscipit rutrum.',	'test-slider-d20a9n',	'',	1,	7,	'2022-04-01 11:22:24',	'2022-03-31 18:13:03',	'2022-04-01 05:52:24'),
(7,	'Uniform & Accessories',	'sda',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam maximus orci at turpis suscipit rutrum.',	'uniform-accessories-5pvK20',	'/uploads/slider/16488113605747-l-16487924079827-vector.png',	1,	7,	NULL,	'2022-04-01 11:23:32',	'2022-04-01 11:09:24'),
(8,	'tretertege',	'',	'terrrrrrrrrrrrrrrrrrrrxret wsrewswrew wserfsffse',	'tretertege-72repd',	'/uploads/slider/16488111932794-wp3173686.jpg',	1,	7,	'2022-04-01 16:37:49',	'2022-04-01 16:36:37',	'2022-04-01 11:07:49'),
(9,	'erwrewsef',	'',	'wsefswfeswew',	'erwrewsef-V9ZlpX',	'/uploads/slider/16488113947167-cc3829.jpg',	0,	7,	'2022-04-01 17:29:34',	'2022-04-01 16:39:58',	'2022-04-01 11:59:34'),
(10,	'testewsefswef',	'',	'weqwqq',	'testewsefswef-ypGm93',	'/uploads/slider/16488114138304-images-3.jpg',	0,	7,	NULL,	'2022-04-01 16:40:17',	'2022-04-01 11:12:41'),
(11,	'ewewr',	'',	'we3we3wewweww',	'ewewr-B2kbpz',	'/uploads/slider/16488143387808-wp3173686.jpg',	0,	7,	NULL,	'2022-04-01 17:29:01',	'2022-04-04 07:32:31'),
(12,	'tesergeeer',	'',	'rhfnftedr',	'tesergeeer-82jV27',	'/uploads/slider/16488867119168-images-9.jpg',	1,	7,	'2022-04-02 13:35:38',	'2022-04-02 13:35:13',	'2022-04-02 08:05:38'),
(13,	'Shirts',	'',	'yutrerweqetruiuyiyuiiiiiiiiiiiiiiiiiitwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq',	'shirts-a9By2e',	'',	1,	7,	'2022-04-04 13:18:49',	'2022-04-04 13:16:55',	'2022-04-04 07:48:49');

CREATE TABLE `states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `state_code` varchar(50) NOT NULL,
  `country_id` int(11) NOT NULL,
  `latitude` decimal(8,5) DEFAULT NULL,
  `longitude` decimal(8,5) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `states` (`id`, `name`, `state_code`, `country_id`, `latitude`, `longitude`, `status`, `created`, `modified`) VALUES
(1,	'Donegal',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:21:17',	'2022-08-25 06:51:17'),
(2,	'Tyrone',	'',	252,	NULL,	NULL,	1,	'2022-08-25 12:21:31',	'2022-08-25 06:51:31'),
(3,	'Derry',	'',	252,	NULL,	NULL,	1,	'2022-08-25 12:21:45',	'2022-08-25 06:51:45'),
(4,	'Antrim',	'',	252,	NULL,	NULL,	1,	'2022-08-25 12:21:59',	'2022-08-25 06:51:59'),
(5,	'Down',	'',	252,	NULL,	NULL,	1,	'2022-08-25 12:22:17',	'2022-08-25 06:52:17'),
(6,	'Armagh',	'',	252,	NULL,	NULL,	1,	'2022-08-25 12:22:37',	'2022-08-25 06:52:37'),
(7,	'Monaghan',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:23:18',	'2022-08-25 06:53:18'),
(8,	'Fermanagh',	'',	252,	NULL,	NULL,	1,	'2022-08-25 12:23:46',	'2022-08-25 06:53:46'),
(9,	'Cavan',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:24:17',	'2022-08-25 06:54:17'),
(10,	'Leitrim',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:24:48',	'2022-08-25 06:54:48'),
(11,	'Sligo',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:25:02',	'2022-08-25 06:55:02'),
(12,	'Mayo',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:25:17',	'2022-08-25 06:55:17'),
(13,	'Roscommon',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:25:33',	'2022-08-25 06:55:33'),
(14,	'Galway',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:25:47',	'2022-08-25 06:55:47'),
(15,	'Longford',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:26:15',	'2022-08-25 06:56:15'),
(16,	'Westmeath',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:26:31',	'2022-08-25 06:56:31'),
(17,	'Meath',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:26:45',	'2022-08-25 06:56:45'),
(18,	'Louth',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:26:58',	'2022-08-25 06:56:58'),
(19,	'Dublin',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:27:10',	'2022-08-25 06:57:10'),
(20,	'Wicklow',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:27:21',	'2022-08-25 06:57:21'),
(21,	'Kildare',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:27:35',	'2022-08-25 06:57:35'),
(22,	'Offaly',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:27:48',	'2022-08-25 06:57:48'),
(23,	'Laois',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:28:02',	'2022-08-25 06:58:02'),
(24,	'Kilkenny',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:28:15',	'2022-08-25 06:58:15'),
(25,	'Carlow',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:28:31',	'2022-08-25 06:58:31'),
(26,	'Wexford',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:28:43',	'2022-08-25 06:58:43'),
(27,	'Waterford',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:28:57',	'2022-08-25 06:58:57'),
(28,	'Tipperary',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:29:09',	'2022-08-25 06:59:09'),
(29,	'Clare',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:29:22',	'2022-08-25 06:59:22'),
(30,	'Limerick',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:29:34',	'2022-08-25 06:59:34'),
(31,	'Cork',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:29:46',	'2022-08-25 06:59:46'),
(32,	'Kerry',	'',	106,	NULL,	NULL,	1,	'2022-08-25 12:29:58',	'2022-08-25 06:59:58'),
(33,	'Gwent',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:30:15',	'2022-08-25 07:00:15'),
(34,	'South Glamorgan',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:30:29',	'2022-08-25 07:00:29'),
(35,	'West Glamorgan',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:30:41',	'2022-08-25 07:00:41'),
(36,	'Mid Glamorgan',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:30:52',	'2022-08-25 07:00:52'),
(37,	'Dyfed',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:31:07',	'2022-08-25 07:01:07'),
(38,	'Powys',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:31:20',	'2022-08-25 07:01:20'),
(39,	'Gwynedd',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:31:31',	'2022-08-25 07:01:31'),
(40,	'Clwyd',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:31:46',	'2022-08-25 07:01:46'),
(41,	'Aberdeenshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:31:59',	'2022-08-25 07:01:59'),
(42,	'Angus',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:32:09',	'2022-08-25 07:02:09'),
(43,	'Aberdeen',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:32:21',	'2022-08-25 07:02:21'),
(44,	'Argyll and Bute',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:32:33',	'2022-08-25 07:02:33'),
(45,	'Clackmannanshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:32:44',	'2022-08-25 07:02:44'),
(46,	'Dumfries and Galloway',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:33:04',	'2022-08-25 07:03:04'),
(47,	'Dundee',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:33:14',	'2022-08-25 07:03:14'),
(48,	'East Ayrshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:33:25',	'2022-08-25 07:03:25'),
(49,	'East Dunbartonshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:33:35',	'2022-08-25 07:03:35'),
(50,	'East Lothian',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:33:47',	'2022-08-25 07:03:47'),
(51,	'East Renfrewshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:33:57',	'2022-08-25 07:03:57'),
(52,	'Edinburgh',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:34:10',	'2022-08-25 07:04:10'),
(53,	'Falkirk',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:34:24',	'2022-08-25 07:04:24'),
(54,	'Fife',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:34:34',	'2022-08-25 07:04:34'),
(55,	'Glasgow',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:34:53',	'2022-08-25 07:04:53'),
(56,	'Highland',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:35:06',	'2022-08-25 07:05:06'),
(57,	'Inverclyde',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:35:17',	'2022-08-25 07:05:17'),
(58,	'Midlothian',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:35:31',	'2022-08-25 07:05:31'),
(59,	'Moray',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:35:40',	'2022-08-25 07:05:40'),
(60,	'North Ayrshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:35:58',	'2022-08-25 07:05:58'),
(61,	'North Lanarkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:36:09',	'2022-08-25 07:06:09'),
(62,	'Orkney',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:36:22',	'2022-08-25 07:06:22'),
(63,	'Perth and Kinross',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:36:34',	'2022-08-25 07:06:34'),
(64,	'Renfrewshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:36:48',	'2022-08-25 07:06:48'),
(65,	'Scottish Borders',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:36:59',	'2022-08-25 07:06:59'),
(66,	'Shetland Isles',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:37:10',	'2022-08-25 07:07:10'),
(67,	'South Ayrshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:37:22',	'2022-08-25 07:07:22'),
(68,	'South Lanarkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:37:39',	'2022-08-25 07:07:39'),
(69,	'Stirlingshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:37:51',	'2022-08-25 07:07:51'),
(70,	'West Dunbartonshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:38:03',	'2022-08-25 07:08:03'),
(71,	'West Lothian',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:38:15',	'2022-08-25 07:08:15'),
(72,	'Western Isles',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:38:30',	'2022-08-25 07:08:30'),
(73,	'Wigtonshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:38:44',	'2022-08-25 07:08:44'),
(74,	'Bedfordshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:38:54',	'2022-08-25 07:08:54'),
(75,	'Berkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:39:04',	'2022-08-25 07:09:04'),
(76,	'Bristol',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:39:14',	'2022-08-25 07:09:14'),
(77,	'Buckinghamshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:39:29',	'2022-08-25 07:09:29'),
(78,	'Cambridgeshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:39:41',	'2022-08-25 07:09:41'),
(79,	'Cheshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:39:50',	'2022-08-25 07:09:50'),
(80,	'City of London',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:40:14',	'2022-08-25 07:10:14'),
(81,	'Cornwall',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:40:25',	'2022-08-25 07:10:25'),
(82,	'Cumbria',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:40:39',	'2022-08-25 07:10:39'),
(83,	'Derbyshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:40:51',	'2022-08-25 07:10:51'),
(84,	'Devon',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:41:04',	'2022-08-25 07:11:04'),
(85,	'Dorset',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:41:13',	'2022-08-25 07:11:13'),
(86,	'Durham',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:41:31',	'2022-08-25 07:11:31'),
(87,	'East Riding of Yorkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:41:43',	'2022-08-25 07:11:43'),
(88,	'East Sussex',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:41:55',	'2022-08-25 07:11:55'),
(89,	'Essex',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:42:08',	'2022-08-25 07:12:08'),
(90,	'Gloucestershire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:42:18',	'2022-08-25 07:12:18'),
(91,	'Greater London',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:42:30',	'2022-08-25 07:12:30'),
(92,	'Greater Manchester',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:42:41',	'2022-08-25 07:12:41'),
(93,	'Hampshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:42:53',	'2022-08-25 07:12:53'),
(94,	'Herefordshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:43:04',	'2022-08-25 07:13:04'),
(95,	'Hertfordshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:43:45',	'2022-08-25 07:13:45'),
(96,	'Isle of Wight',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:43:58',	'2022-08-25 07:13:58'),
(97,	'Kent',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:44:08',	'2022-08-25 07:14:08'),
(98,	'Lancashire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:44:17',	'2022-08-25 07:14:17'),
(99,	'Leicestershire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:44:28',	'2022-08-25 07:14:28'),
(100,	'Lincolnshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:44:37',	'2022-08-25 07:14:37'),
(101,	'Merseyside',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:44:47',	'2022-08-25 07:14:47'),
(102,	'Norfolk',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:44:56',	'2022-08-25 07:14:56'),
(103,	'North Yorkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:45:08',	'2022-08-25 07:15:08'),
(104,	'Northamptonshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:45:18',	'2022-08-25 07:15:18'),
(105,	'Northumberland',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:45:28',	'2022-08-25 07:15:28'),
(106,	'Nottinghamshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:45:41',	'2022-08-25 07:15:41'),
(107,	'Oxfordshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:45:57',	'2022-08-25 07:15:57'),
(108,	'Rutland',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:46:06',	'2022-08-25 07:16:06'),
(109,	'Shropshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:46:15',	'2022-08-25 07:16:15'),
(110,	'Somerset',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:46:26',	'2022-08-25 07:16:26'),
(111,	'South Yorkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:46:39',	'2022-08-25 07:16:39'),
(112,	'Staffordshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:46:49',	'2022-08-25 07:16:49'),
(113,	'Suffolk',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:47:00',	'2022-08-25 07:17:00'),
(114,	'Surrey',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:47:09',	'2022-08-25 07:17:09'),
(115,	'Tyne and Wear',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:47:20',	'2022-08-25 07:17:20'),
(116,	'Warwickshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:47:29',	'2022-08-25 07:17:29'),
(117,	'West Midlands',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:47:54',	'2022-08-25 07:17:54'),
(118,	'West Sussex',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:48:07',	'2022-08-25 07:18:07'),
(119,	'West Yorkshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:48:18',	'2022-08-25 07:18:18'),
(120,	'Wiltshire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:48:28',	'2022-08-25 07:18:28'),
(121,	'Worcestershire',	'',	235,	NULL,	NULL,	1,	'2022-08-25 12:48:40',	'2022-08-25 07:18:40');

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `location` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `rating` int(11) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `testimonials_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `testimonials` (`id`, `name`, `designation`, `location`, `image`, `description`, `rating`, `created_by`, `status`, `deleted_at`, `created`, `modified`) VALUES
(10,	'Veet baljit',	'Lorem ipsum dolor, amet',	'',	'/uploads/testimonials/16503687531056-unsplash-wnolnjo7ts8.png',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vitae neque malesuada, vulputate mi sit amet, sollicitudin dolor. Mauris vulputate mattis mauris, eget tincidunt nisi mollis vel.Lorem ipsum dolor sit amet, consectetur adipiscing elit.',	1,	7,	1,	NULL,	'2022-04-19 17:15:55',	'2022-09-02 06:56:32'),
(11,	'Veet baljit',	'Lorem ipsum dolor, amet',	'',	'/uploads/testimonials/16503687531056-unsplash-wnolnjo7ts8.png',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vitae neque malesuada, vulputate mi sit amet, sollicitudin dolor. Mauris vulputate mattis mauris, eget tincidunt nisi mollis vel.Lorem ipsum dolor sit amet, consectetur adipiscing elit.',	1,	7,	0,	'2022-04-29 17:48:37',	'2022-04-19 17:15:55',	'2022-04-29 12:18:37'),
(12,	'Veet baljit',	'Lorem ipsum dolor, amet',	'',	'/uploads/testimonials/16503687531056-unsplash-wnolnjo7ts8.png',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vitae neque malesuada, vulputate mi sit amet, sollicitudin dolor. Mauris vulputate mattis mauris, eget tincidunt nisi mollis vel.Lorem ipsum dolor sit amet, consectetur adipiscing elit.',	1,	7,	0,	'2022-04-29 17:48:37',	'2022-04-19 17:15:55',	'2022-04-29 12:18:37'),
(13,	'Veet baljit',	'Lorem ipsum dolor, amet',	'',	'/uploads/testimonials/16503687531056-unsplash-wnolnjo7ts8.png',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vitae neque malesuada, vulputate mi sit amet, sollicitudin dolor. Mauris vulputate mattis mauris, eget tincidunt nisi mollis vel.Lorem ipsum dolor sit amet, consectetur adipiscing elit.',	1,	7,	0,	'2022-04-29 17:48:37',	'2022-04-19 17:15:55',	'2022-04-29 12:18:37'),
(14,	'Veet baljit',	'Lorem ipsum dolor, amet',	'',	'/uploads/testimonials/16503687531056-unsplash-wnolnjo7ts8.png',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vitae neque malesuada, vulputate mi sit amet, sollicitudin dolor. Mauris vulputate mattis mauris, eget tincidunt nisi mollis vel.Lorem ipsum dolor sit amet, consectetur adipiscing elit.',	1,	7,	0,	'2022-04-29 17:48:37',	'2022-04-19 17:15:55',	'2022-04-29 12:18:37'),
(15,	'Veet baljit',	'Lorem ipsum dolor, amet',	'',	'/uploads/testimonials/16503687531056-unsplash-wnolnjo7ts8.png',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vitae neque malesuada, vulputate mi sit amet, sollicitudin dolor. Mauris vulputate mattis mauris, eget tincidunt nisi mollis vel.Lorem ipsum dolor sit amet, consectetur adipiscing elit.',	1,	7,	0,	'2022-04-29 17:48:37',	'2022-04-19 17:15:55',	'2022-04-29 12:18:37'),
(16,	'Ian Schumer',	'IT Officer',	'',	'/uploads/testimonials/16512345095445-shiba.jpg',	'Amazing',	1,	7,	1,	NULL,	'2022-04-29 17:45:18',	'2022-04-29 12:15:18'),
(17,	'Ramsey',	'Business Owner',	'',	'/uploads/testimonials/1651234549844-fgb.jpg',	'Satisfied',	1,	7,	1,	NULL,	'2022-04-29 17:45:52',	'2022-04-29 12:15:52'),
(18,	'Ronda',	'Boxer',	'',	'/uploads/testimonials/16512345744788-frenchie.jpg',	'Loved it',	1,	7,	1,	NULL,	'2022-04-29 17:46:16',	'2022-04-29 12:16:16'),
(19,	'Daniel',	'Explorer',	'',	'/uploads/testimonials/16512346159081-shibainudogwithaburntorangecollarandsilvertagrestingoncarpet-min.jpg',	'So Thankful',	1,	7,	1,	NULL,	'2022-04-29 17:46:57',	'2022-05-02 12:53:50'),
(20,	'India',	'IPS',	'',	'/uploads/testimonials/16619284167509-screenshot-1.png',	'Qwerty qwerty hello',	1,	7,	1,	'2022-08-31 12:18:46',	'2022-08-31 12:16:59',	'2022-08-31 06:48:46'),
(21,	'joerge farnadvees Fake words can be an excellent way for writers to begin putting words to paper. Whether they\'re looking to overcome a bit of writer\'s block or just need a quality way to begin writing each day, having a random pseudo word generated can 1',	'IPs',	'',	'/uploads/testimonials/16621863405375-ucl-labrador7.jpg',	'In all likelihood, you ended up on this page because you were searching for cursive letters. If that happens to be the case, you\'re in luck. The Cursive Letters Generator was built specifically for those who were looking for cursive writing and all of the',	1,	7,	1,	NULL,	'2022-09-03 11:55:44',	'2022-09-03 06:49:59');

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(255) DEFAULT NULL,
  `plan_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `payout_id` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `transaction_type` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `currency_symbol` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0 COMMENT '3 = pending, 1 = success, 2 = failed',
  `created_by` int(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `payout_on` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_by` (`created_by`),
  KEY `plan_id` (`plan_id`),
  KEY `transaction_id` (`transaction_id`),
  KEY `title` (`title`),
  KEY `amount` (`amount`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_ibfk_3` FOREIGN KEY (`plan_id`) REFERENCES `memberships` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transactions_ibfk_4` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `transactions` (`id`, `transaction_id`, `plan_id`, `product_id`, `payout_id`, `user_id`, `title`, `description`, `transaction_type`, `amount`, `currency_symbol`, `currency`, `type`, `status`, `created_by`, `deleted_at`, `created`, `payout_on`, `modified`) VALUES
(9,	'ch_3MHKmSEheo3PIBMU12Fogxre',	NULL,	211,	NULL,	1,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":14,\"membership_id\":2,\"title\":\"New ad\",\"slug\":\"new-ad-n2MDpq2\",\"price\":\"40.00\",\"type\":\"available\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days\",\"status\":1,\"created\":\"2022-11-2',	'ad',	40.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-21 10:53:55',	NULL,	'2022-12-21 05:23:55'),
(10,	'ch_3MHNiiEheo3PIBMU0kcjpd9o',	NULL,	211,	NULL,	1,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":14,\"membership_id\":2,\"title\":\"New ad\",\"slug\":\"new-ad-n2MDpq2\",\"price\":\"40.00\",\"type\":\"available\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days\",\"status\":1,\"created\":\"2022-11-2',	'ad',	40.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-21 14:02:15',	NULL,	'2022-12-21 08:32:15'),
(11,	'ch_3MHNm8Eheo3PIBMU0m1Fvzoy',	NULL,	211,	NULL,	1,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":14,\"membership_id\":2,\"title\":\"New ad\",\"slug\":\"new-ad-n2MDpq2\",\"price\":\"40.00\",\"type\":\"available\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days\",\"status\":1,\"created\":\"2022-11-2',	'ad',	40.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-21 14:05:45',	NULL,	'2022-12-21 08:35:45'),
(12,	'ch_3MHNmeEheo3PIBMU0IlkTuI6',	NULL,	211,	NULL,	1,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":14,\"membership_id\":2,\"title\":\"New ad\",\"slug\":\"new-ad-n2MDpq2\",\"price\":\"40.00\",\"type\":\"available\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days\",\"status\":1,\"created\":\"2022-11-2',	'ad',	40.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-21 14:06:17',	NULL,	'2022-12-21 08:36:17'),
(13,	'ch_3MHNrbEheo3PIBMU1EqiX9yR',	NULL,	211,	NULL,	1,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":14,\"membership_id\":2,\"title\":\"New ad\",\"slug\":\"new-ad-n2MDpq2\",\"price\":\"40.00\",\"type\":\"available\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days\",\"status\":1,\"created\":\"2022-11-2',	'ad',	40.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-21 14:11:25',	NULL,	'2022-12-21 08:41:25'),
(14,	'ch_3MHk5GEheo3PIBMU1I0hBPMq',	NULL,	217,	NULL,	13,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":14,\"membership_id\":2,\"title\":\"New ad\",\"slug\":\"new-ad-n2MDpq2\",\"price\":\"40.00\",\"type\":\"available\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days\",\"status\":1,\"created\":\"2022-11-2',	'ad',	40.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-22 13:55:01',	NULL,	'2022-12-22 08:25:01'),
(15,	'ch_3MJAqFEheo3PIBMU1Y5uNFlL',	NULL,	219,	NULL,	1,	'Ad plans purchased.',	'{\"plan_features\":[{\"id\":17,\"membership_id\":2,\"title\":\"Upcoming Litter (UCL) ad\",\"slug\":\"upcoming-litter-ucl-ad-G2Rmp32\",\"price\":\"35.00\",\"type\":\"upcoming\",\"plan_type\":\"new\",\"currency\":\"\\u00a3\",\"currenct_code\":\"THB\",\"days\":30,\"description\":\"Duration 30 days',	'ad',	35.00,	'THB',	'THB',	'OUT',	1,	NULL,	NULL,	'2022-12-26 12:41:26',	NULL,	'2022-12-26 07:11:26');

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `phonenumber` varchar(255) DEFAULT NULL,
  `calling_code` varchar(10) DEFAULT NULL,
  `session_id` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `address` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `bio` longtext DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `gender` enum('male','female') DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `verified_at` datetime DEFAULT NULL,
  `facebook_id` varchar(200) DEFAULT NULL,
  `google_id` varchar(200) DEFAULT NULL,
  `google_email` varchar(200) DEFAULT NULL,
  `otp` varchar(10) DEFAULT NULL,
  `phone_verification` datetime DEFAULT NULL,
  `zipcode` varchar(10) DEFAULT NULL,
  `user_type` enum('buyer','seller','rbe','rco') DEFAULT NULL COMMENT 'buyer = Private buyer or seller, seller = Registered Seller (RS),  rbe = Registered Breeding Establishment (RBE), rco = Registered Charitable Organisation',
  `seller_id` varchar(255) DEFAULT NULL,
  `rbe_number` varchar(255) DEFAULT NULL,
  `rbe_breeding_bitches` varchar(255) DEFAULT NULL,
  `charitable_number` varchar(255) DEFAULT NULL,
  `business_name` varchar(255) DEFAULT NULL,
  `country_id` int(5) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `postal_code_id` int(11) DEFAULT NULL,
  `preferences_type` tinyint(1) NOT NULL DEFAULT 1,
  `stripe_customer_id` varchar(200) DEFAULT NULL,
  `stripe_card_id` varchar(200) DEFAULT NULL,
  `card` text DEFAULT NULL,
  `holder_name` text DEFAULT NULL,
  `card_type` text DEFAULT NULL,
  `exp_month` text DEFAULT NULL,
  `exp_year` text DEFAULT NULL,
  `stripe_account_id` varchar(200) DEFAULT NULL,
  `stripe_account_verified` tinyint(1) DEFAULT 0,
  `stripe_connect_by_customer` tinyint(1) DEFAULT 0,
  `stripe_webhook_request` varchar(255) DEFAULT NULL,
  `membership_id` int(11) DEFAULT NULL,
  `membership_title` varchar(255) DEFAULT NULL,
  `membership_date` datetime DEFAULT NULL,
  `membership_currency` varchar(255) DEFAULT NULL,
  `membership_price` varchar(255) DEFAULT NULL,
  `membership_expire` date DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `country_id` (`country_id`),
  KEY `state_id` (`state_id`),
  KEY `city_id` (`city_id`),
  KEY `postal_code_id` (`postal_code_id`),
  KEY `membership_id` (`membership_id`),
  CONSTRAINT `users_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `users_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `users_ibfk_3` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE SET NULL,
  CONSTRAINT `users_ibfk_4` FOREIGN KEY (`membership_id`) REFERENCES `memberships` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `phonenumber`, `calling_code`, `session_id`, `dob`, `address`, `image`, `bio`, `last_login`, `token`, `gender`, `email`, `password`, `status`, `verified_at`, `facebook_id`, `google_id`, `google_email`, `otp`, `phone_verification`, `zipcode`, `user_type`, `seller_id`, `rbe_number`, `rbe_breeding_bitches`, `charitable_number`, `business_name`, `country_id`, `state_id`, `city_id`, `postal_code_id`, `preferences_type`, `stripe_customer_id`, `stripe_card_id`, `card`, `holder_name`, `card_type`, `exp_month`, `exp_year`, `stripe_account_id`, `stripe_account_verified`, `stripe_connect_by_customer`, `stripe_webhook_request`, `membership_id`, `membership_title`, `membership_date`, `membership_currency`, `membership_price`, `membership_expire`, `deleted_at`, `created_by`, `created`, `modified`) VALUES
(1,	'Irfan',	'Ahmad',	NULL,	'undefined-7888769938',	NULL,	'clxBbsyUT1HFi3jCiPPJdesDb0UcpE4uDyODnsbx',	'1990-11-13',	'2233 W, Hedding St San Jose, CA',	'/uploads/user/16630433795086-70281657523604.png',	NULL,	'2022-12-27 15:34:40',	'fbUjHLGN6xqnW7QNO6sqEEFxhCA3iTHbLG83j1OAyX3BdkFfV7m4Q6jQzu8LeRzh',	'male',	'irfan.ahmad@globiztechnology.com',	'$2y$10$mIa6u4Pca.DJaT0SZzBNp.DMLMi08ilWDSULN3s633UmbOvG5gOHO',	1,	'2022-07-05 13:56:02',	NULL,	NULL,	NULL,	NULL,	'2022-07-05 15:54:51',	'141007',	'buyer',	NULL,	NULL,	NULL,	NULL,	'Dhami\'s Breeders',	252,	6,	0,	NULL,	1,	'cus_Mwy95Ez5uh3Nh2',	'card_1MD4DNEheo3PIBMU3ZFsE3Or',	'4242',	'Irfan Ahmad',	'Visa',	'5',	'2026',	NULL,	0,	0,	NULL,	2,	'Monthly Plan',	'2022-12-09 16:24:04',	'THB',	'12556.00',	'2023-01-08',	NULL,	7,	'2022-04-27 16:34:43',	'2022-12-21 05:21:16'),
(8,	'wrgsrth',	'srthsrj',	NULL,	'6895656564',	NULL,	NULL,	'0007-04-06',	'rjydtjnfjgyukfyukfy',	'',	NULL,	NULL,	NULL,	'male',	'karan@gmail.com',	'$2y$10$VeYs8474P9uOsWow3TlOwOAgBKeiPSkGPqdMZeRD/tREPAgKuH6ju',	1,	'2022-04-29 17:56:02',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-04-29 12:33:24',	7,	'2022-04-29 17:56:02',	'2022-04-29 12:26:02'),
(9,	'esrhsth',	'strhsdhd',	NULL,	'468646468',	NULL,	NULL,	'1999-04-05',	'xfjhgcnfgjt',	'',	NULL,	NULL,	NULL,	'male',	'abcd@gmail.com',	'$2y$10$/nAekWvu22IRdZjn6HkQgOxoSBtdS0XS5bvDT6ss1HCuCNyZSzTmu',	1,	'2022-04-29 17:56:27',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-04-29 12:33:24',	7,	'2022-04-29 17:56:27',	'2022-04-29 12:26:27'),
(10,	'Irfan',	'Ahmad',	NULL,	'7888769933',	'44',	NULL,	NULL,	'77 st no 4',	NULL,	NULL,	NULL,	'xlv7JeLNLDf1MNgCslxcBvI2Vl8NCUoEFN6lrJpGMPXcltsQAv4m3U8RRjF1AIhI',	NULL,	'admin@globiz.com',	'$2y$10$q2OpmNSjMc2TvKQB0jJk1.NtzLWAlzT.V235cSxPTjN21Iko1Pe42',	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'',	'',	'',	'',	'',	'Pet',	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	7,	'2022-07-02 16:20:18',	'2022-07-02 10:50:18'),
(11,	'Harman',	'Singh',	NULL,	'7894561230',	'44',	'',	NULL,	'2233 W, Hedding St San Jose, CA',	NULL,	NULL,	'2022-07-02 17:10:26',	NULL,	NULL,	'harman.globiztechnology@gmail.com',	'$2y$10$im32jFIMXfgbUgm1WJbkGO/SFel4AwpMWmHEjCGczHnina7y00cUO',	1,	'2022-07-02 17:10:26',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'',	'',	'123456',	'20',	'',	'Pet Stp',	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	7,	'2022-07-02 16:57:18',	'2022-07-02 11:27:18'),
(12,	'Joe',	'Bloggs',	'joe.bloggs.82jv27',	'8519937506',	'353',	NULL,	NULL,	'Joe Bloggs Street',	NULL,	NULL,	NULL,	'ZMDVPLRMo5v1eHxikLxF27jpmTU4MkBn',	NULL,	'tomnolan179@gmail.com',	'$2y$10$JCNF1PNtF3qk7lAgMkUAiud7gv/CzfmuqSBwfWbn40QRdIEJB2nwW',	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'',	'123456',	'',	'',	'',	'Hoozyerman',	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	7,	'2022-07-28 01:26:08',	'2022-07-27 19:56:08'),
(13,	'Karanveer Singh',	'Dhami',	'karanveer.singh.dhami.a9by2e',	'44-2154879871',	'44',	'GXb5Ac7YRbVyQMBCKL6okhJ4X8SQbJlAd465XkMn',	NULL,	'66 Woodside Court, Highland, UK',	'/uploads/user/16596163521082-oefrenchiepuppy.png',	NULL,	'2022-12-22 13:46:49',	'1ykQuRIzCoNH2DxsK9cMmm16jFmCNvw1yz1umY8WQ0yioY91E8Q8yoMbd90WGEN9',	NULL,	'karan.dhami@globiztechnology.com',	'$2y$10$YNYgkDtFuyQFVGivmzS5UeyKPch/9j8MGKfwi2Lj6N57IUqUv4jmi',	1,	'2022-07-28 10:29:41',	NULL,	NULL,	NULL,	NULL,	'2022-07-28 10:30:25',	'L6Y 2P2',	'rbe',	NULL,	'6848798464212224',	'6',	NULL,	'Dhami\'s Breeders',	106,	25,	0,	NULL,	1,	'cus_MxLhb2GWkWHexJ',	'card_1MDQzwEheo3PIBMUMqKbrDrr',	'4242',	'Irfan Ahmad',	'Visa',	'5',	'2026',	NULL,	0,	0,	NULL,	2,	'Monthly Plan',	'2022-12-10 16:43:42',	'THB',	'12556.00',	'2023-01-09',	NULL,	NULL,	'2022-07-28 10:29:17',	'2022-09-14 11:07:04'),
(14,	'dgdg',	'arfdg',	'dgdg.arfdg.p2lgpz',	'35356768',	NULL,	NULL,	NULL,	'awetrfhfd3457',	NULL,	NULL,	NULL,	'eN9hmNDSt1JCFnH2jU7OiYwXpszD8uIDZMTqzUZCL8qrS3dGlvEaG750ljqV63jM',	NULL,	'eugyweyriu@erterui.com',	'$2y$10$oYgf/KaW1lSOpAQazlYoCOI399/14RH4wmY9CPLxXdFscx9akfsVC',	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'L6Y 2P2',	'buyer',	'',	'',	'',	'',	'etet',	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	7,	'2022-08-20 11:05:56',	'2022-08-20 05:35:56'),
(15,	'Suresh',	'Khanna',	'suresh.khanna.l9xmw0',	'44-35335398841',	NULL,	'gjFAt6GwDx7951L5TftWhVhXTpBBsFOuvgp267r2',	'0000-00-00',	'LUDHIANA',	'/uploads/user/16613225764683-akita1.jpg',	NULL,	'2022-10-12 16:59:34',	'IeuQFFO1sWYGFUakVgMWoyUeV6fEeTXXbvnQCzZY5OW83E24C9wormUddWOskSb4',	'male',	'suresh.globiztechnology@gmail.com',	'$2y$10$GICeRmW6LDrKs6155tYZkOgTtiLqlNGn6GrXM9JO.4V1wFQmT8HIO',	1,	'2022-08-20 12:14:32',	NULL,	NULL,	NULL,	NULL,	'2022-08-20 12:16:21',	'R3T 2S5',	'rbe',	NULL,	'46514651613',	'4',	NULL,	'SK',	235,	41,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	7,	'2022-08-20 12:05:41',	'2022-09-12 07:59:17'),
(16,	'fdhb',	'hf',	'fdhb.hf.dpyn2d',	'353222222222',	NULL,	NULL,	NULL,	'fgfhfgh',	NULL,	NULL,	NULL,	'QTdLZ1BxIdjYgui4HYL6shdwmdQc4FiMwtGyVI3eueJgh2Nx6LwDVOYpdFQRuR1d',	NULL,	'admin@gdfgdfgfdg.com',	'$2y$10$4LUw7P4ft0dEwaG6t53/TOMb4/s.OAcJ0HsfNf1mAN/3TfwAtCdau',	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'3535345',	'seller',	'13213',	'',	'',	'',	'fhgfhgfh',	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-08-23 11:42:29',	'2022-08-23 06:12:29'),
(17,	'fd',	'wrwr',	'fd.wrwr.ywgr9q',	'353222222222',	NULL,	NULL,	NULL,	'dfsdf',	NULL,	NULL,	NULL,	'62C7A8ysGu5q8YTtOaV2DVfW2VbZSPqmURpIh4mirTOSCvauO2EAPeFd37rZxkiy',	NULL,	'admin@dsfsgsdgsdg.com',	'$2y$10$9QMsYba2mBVM5XHFQH6GpOX00moluvijci3/2rjjq4zmdpgmwPbIW',	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'21343',	'rbe',	'',	'412423',	'222',	'',	'demo business',	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-08-23 12:09:19',	'2022-08-23 06:39:19'),
(18,	'Test@123',	'Kumar@123',	'test.at.123.kumar.at.123.ywnjwj',	'',	NULL,	NULL,	'1801-01-05',	'India',	'/uploads/users/16623561578512-screenshot-1.png',	NULL,	NULL,	NULL,	'male',	'testkumar123@gmail.com',	'$2y$10$34KnR0NAqYL4N5jcJe6bYudNaim/t/41G/sk1cByHM5ho4Q7dOxMu',	0,	'2022-09-05 11:06:39',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	7,	'2022-09-05 11:06:39',	'2022-09-05 05:37:15'),
(21,	'efwg',	'wgeg',	'efwg.wgeg.gpda2a',	'353-34646457547547547',	NULL,	NULL,	NULL,	'dfbnhnnnm',	NULL,	NULL,	NULL,	'WDVfCKHrBP6kRWTvAAIVlcU0O7kSZYk2VtJDCtitTjM5eTwUsxOdHQ5PMCESybhO',	NULL,	'ghd@gc.ghrth',	'$2y$10$Z4ZGYwju.BegCj4xQbsRw.dtOrQlQ4F9SLJLQ6ZmRFqOnugomC8Oa',	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'43646',	'rbe',	'',	'weg',	'325',	'',	'436tgfb',	106,	25,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-09-12 12:14:50',	'2022-09-12 06:44:50'),
(22,	'SKKhanna',	'Ludhiana',	'skkhanna.ludhiana.xp7jwa',	'44-9888923940',	NULL,	'lwaAw6hx8hkb1lxlTgsKEuZ84fqUwPYhGeUZt1NM',	NULL,	'Ludhiana Street',	'/uploads/user/16631345573497-pug3.jpg',	NULL,	'2022-09-19 11:46:28',	'IYWuUbJdSrKzvmPMsDGUa1fgwpxzLV2INCnASALmDQxZJzqVs1xMrq0vtMan1dNp',	NULL,	'suresh.khanna894@gmail.com',	'$2y$10$GxzGxVwXYJQGEOEqcFZ7gemDQSz8SuRFB6AtZEDzAmtBQ7sasy45a',	1,	'2022-09-12 12:24:06',	NULL,	NULL,	NULL,	NULL,	'2022-09-12 12:25:40',	NULL,	'seller',	'Qwerty12345',	NULL,	NULL,	NULL,	'SKKhanna',	235,	43,	1,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-09-12 12:18:51',	'2022-09-12 07:01:00'),
(23,	'Roth',	'Kirby',	'roth.kirby.098vpe',	'353-1 (123) 6449734',	NULL,	'kM6pFzildzWKsq7T27PQRJEXSzKAqAqUyIJLAR1H',	NULL,	'Eveniet nemo volupt',	NULL,	NULL,	'2022-11-03 17:34:12',	'7Muq4EZZ8yd6jryw65EDLS9ZuTmEqKyO9atUTQlSrnBmhUenAxdu3zw33Qu1iUOk',	NULL,	'zojagesat@mailinator.com',	'$2y$10$aLBNU7z/GZnZoQeVqhAcH.b2y5FALhJPPn1UmVfNxIzNvITU9fQF6',	1,	'2022-09-12 12:24:06',	NULL,	NULL,	NULL,	'827425',	'2022-09-12 12:25:40',	'73916',	'rco',	'',	'',	'',	'334636346',	'Susan Fox',	106,	25,	0,	NULL,	1,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	0,	0,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	'2022-11-03 17:32:47',	'2022-11-03 12:02:47');

CREATE TABLE `users_matches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `last_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_message_date` datetime DEFAULT NULL,
  `last_message_id` int(11) DEFAULT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT 0,
  `last_delete_id` int(11) DEFAULT NULL,
  `is_mute` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `match_id` (`match_id`),
  KEY `product_id` (`product_id`),
  CONSTRAINT `users_matches_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `users_matches_ibfk_2` FOREIGN KEY (`match_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `users_matches_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `users_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `token` varchar(200) NOT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `device_type` enum('android','ios','web') DEFAULT NULL,
  `device_name` varchar(255) DEFAULT NULL,
  `fcm_token` text DEFAULT NULL,
  `expire_on` datetime NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `users_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users_tokens` (`id`, `user_id`, `token`, `device_id`, `device_type`, `device_name`, `fcm_token`, `expire_on`, `created`, `modified`) VALUES
(19,	11,	'PVhpqr6SfNHu7Z8kGfo2lfs72zugIZaRiyZzh5uxLHpQ5kUftJ1dPLV7QvdicoOG',	NULL,	'web',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36',	NULL,	'1970-01-01 05:30:00',	'2022-07-02 18:36:42',	'2022-07-02 13:06:42'),
(97812,	22,	'UR3sriHleroiDFWpSkyWWrsjNfcH0tZfLDxukGdQmHrg1MfaMrV7XkGJQFh8RXAW',	NULL,	'web',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36',	NULL,	'1970-01-01 05:30:00',	'2022-09-19 12:58:30',	'2022-09-19 07:28:30'),
(178258,	15,	'B41LTc3d9P2t3xTzql2KuWgxcsVDXIk9xUR5dFEWCdZAKx2pDc2PGFtW4KRHkdz8',	NULL,	'web',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36',	NULL,	'1970-01-01 05:30:00',	'2022-10-12 17:05:11',	'2022-10-12 11:35:11'),
(453325,	23,	'aXzvkqSlIX9NBXIr8KQnoy8AYk6APKxSSba0Q1DXrEXjHkYrwRKsDQYHkWDhHBUc',	NULL,	'web',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36',	NULL,	'1970-01-01 05:30:00',	'2022-11-03 17:43:20',	'2022-11-03 12:13:20'),
(515210,	13,	'ltm9PHkXWXpuXvBEzN22f4bricOWnKx82J5mxehARg2yjCAELHWZqjWDVtdoer3g',	NULL,	'web',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36',	NULL,	'1970-01-01 05:30:00',	'2022-12-22 13:55:02',	'2022-12-22 08:25:02'),
(515278,	1,	'OEDHIPwdncwU4eZXQe0RUZLijf2ikh8ds6nHY2LNPLVpuUY7HfLJboRG5yIjJE7c',	NULL,	'web',	'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36',	NULL,	'1970-01-01 05:30:00',	'2022-12-27 19:21:50',	'2022-12-27 13:51:50');

-- 2022-12-27 13:52:59
