IP : 3.147.127.96Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
loaded7/
../
symfony3/
../
wp55/
../
wp65/
../
krayin/
krayin.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Dumping data for table `[[dbprefix]]workflows` --
INSERT INTO `[[dbprefix]]workflows` VALUES (1, 'Emails to participants after activity creation', 'Emails to participants after activity creation', 'activities', 'activity.create.after', 'and', '[{"value": ["call", "meeting", "lunch"], "operator": "{}", "attribute": "type", "attribute_type": "multiselect"}]', '[{"id": "send_email_to_participants", "value": "1"}]', '[[regtime]]', '[[regtime]]'), (2, 'Emails to participants after activity updation', 'Emails to participants after activity updation', 'activities', 'activity.update.after', 'and', '[{"value": ["call", "meeting", "lunch"], "operator": "{}", "attribute": "type", "attribute_type": "multiselect"}]', '[{"id": "send_email_to_participants", "value": "2"}]', '[[regtime]]', '[[regtime]]');
-- -- Constraints for dumped tables --
-- -- Constraints for table `[[dbprefix]]activities` -- ALTER TABLE `[[dbprefix]]activities` ADD CONSTRAINT `[[dbprefix]]activities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]activity_files` -- ALTER TABLE `[[dbprefix]]activity_files` ADD CONSTRAINT `[[dbprefix]]activity_files_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `[[dbprefix]]activities` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]activity_participants` -- ALTER TABLE `[[dbprefix]]activity_participants` ADD CONSTRAINT `[[dbprefix]]activity_participants_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `[[dbprefix]]activities` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]activity_participants_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `[[dbprefix]]persons` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]activity_participants_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]attribute_options` -- ALTER TABLE `[[dbprefix]]attribute_options` ADD CONSTRAINT `[[dbprefix]]attribute_options_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `[[dbprefix]]attributes` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]attribute_values` -- ALTER TABLE `[[dbprefix]]attribute_values` ADD CONSTRAINT `[[dbprefix]]attribute_values_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `[[dbprefix]]attributes` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]country_states` -- ALTER TABLE `[[dbprefix]]country_states` ADD CONSTRAINT `[[dbprefix]]country_states_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `[[dbprefix]]countries` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]emails` -- ALTER TABLE `[[dbprefix]]emails` ADD CONSTRAINT `[[dbprefix]]emails_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]emails_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]emails_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `[[dbprefix]]persons` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]email_attachments` -- ALTER TABLE `[[dbprefix]]email_attachments` ADD CONSTRAINT `[[dbprefix]]email_attachments_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]email_tags` -- ALTER TABLE `[[dbprefix]]email_tags` ADD CONSTRAINT `[[dbprefix]]email_tags_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `[[dbprefix]]emails` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]email_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]leads` -- ALTER TABLE `[[dbprefix]]leads` ADD CONSTRAINT `[[dbprefix]]leads_lead_pipeline_id_foreign` FOREIGN KEY (`lead_pipeline_id`) REFERENCES `[[dbprefix]]lead_pipelines` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]leads_lead_pipeline_stage_id_foreign` FOREIGN KEY (`lead_pipeline_stage_id`) REFERENCES `[[dbprefix]]lead_pipeline_stages` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `[[dbprefix]]leads_lead_source_id_foreign` FOREIGN KEY (`lead_source_id`) REFERENCES `[[dbprefix]]lead_sources` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]leads_lead_type_id_foreign` FOREIGN KEY (`lead_type_id`) REFERENCES `[[dbprefix]]lead_types` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]leads_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `[[dbprefix]]persons` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]leads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]lead_activities` -- ALTER TABLE `[[dbprefix]]lead_activities` ADD CONSTRAINT `[[dbprefix]]lead_activities_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `[[dbprefix]]activities` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]lead_activities_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]lead_pipeline_stages` -- ALTER TABLE `[[dbprefix]]lead_pipeline_stages` ADD CONSTRAINT `[[dbprefix]]lead_pipeline_stages_lead_pipeline_id_foreign` FOREIGN KEY (`lead_pipeline_id`) REFERENCES `[[dbprefix]]lead_pipelines` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]lead_products` -- ALTER TABLE `[[dbprefix]]lead_products` ADD CONSTRAINT `[[dbprefix]]lead_products_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]lead_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]products` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]lead_quotes` -- ALTER TABLE `[[dbprefix]]lead_quotes` ADD CONSTRAINT `[[dbprefix]]lead_quotes_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]lead_quotes_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `[[dbprefix]]quotes` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]lead_tags` -- ALTER TABLE `[[dbprefix]]lead_tags` ADD CONSTRAINT `[[dbprefix]]lead_tags_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `[[dbprefix]]leads` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]lead_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]organizations` -- ALTER TABLE `[[dbprefix]]organizations` ADD CONSTRAINT `[[dbprefix]]organizations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]persons` -- ALTER TABLE `[[dbprefix]]persons` ADD CONSTRAINT `[[dbprefix]]persons_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `[[dbprefix]]organizations` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]persons_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `[[dbprefix]]person_activities` -- ALTER TABLE `[[dbprefix]]person_activities` ADD CONSTRAINT `[[dbprefix]]person_activities_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `[[dbprefix]]activities` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]person_activities_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `[[dbprefix]]persons` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]person_tags` -- ALTER TABLE `[[dbprefix]]person_tags` ADD CONSTRAINT `[[dbprefix]]person_tags_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `[[dbprefix]]persons` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]person_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]product_activities` -- ALTER TABLE `[[dbprefix]]product_activities` ADD CONSTRAINT `[[dbprefix]]product_activities_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `[[dbprefix]]activities` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]product_activities_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]products` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]product_inventories` -- ALTER TABLE `[[dbprefix]]product_inventories` ADD CONSTRAINT `[[dbprefix]]product_inventories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]product_inventories_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `[[dbprefix]]warehouses` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]product_inventories_warehouse_location_id_foreign` FOREIGN KEY (`warehouse_location_id`) REFERENCES `[[dbprefix]]warehouse_locations` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]product_tags` -- ALTER TABLE `[[dbprefix]]product_tags` ADD CONSTRAINT `[[dbprefix]]product_tags_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `[[dbprefix]]products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]product_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]quotes` -- ALTER TABLE `[[dbprefix]]quotes` ADD CONSTRAINT `[[dbprefix]]quotes_person_id_foreign` FOREIGN KEY (`person_id`) REFERENCES `[[dbprefix]]persons` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]quotes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]quote_items` -- ALTER TABLE `[[dbprefix]]quote_items` ADD CONSTRAINT `[[dbprefix]]quote_items_quote_id_foreign` FOREIGN KEY (`quote_id`) REFERENCES `[[dbprefix]]quotes` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]tags` -- ALTER TABLE `[[dbprefix]]tags` ADD CONSTRAINT `[[dbprefix]]tags_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]users` -- ALTER TABLE `[[dbprefix]]users` ADD CONSTRAINT `[[dbprefix]]users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `[[dbprefix]]roles` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]user_groups` -- ALTER TABLE `[[dbprefix]]user_groups` ADD CONSTRAINT `[[dbprefix]]user_groups_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]user_groups_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]warehouse_activities` -- ALTER TABLE `[[dbprefix]]warehouse_activities` ADD CONSTRAINT `[[dbprefix]]warehouse_activities_activity_id_foreign` FOREIGN KEY (`activity_id`) REFERENCES `[[dbprefix]]activities` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]warehouse_activities_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `[[dbprefix]]warehouses` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]warehouse_locations` -- ALTER TABLE `[[dbprefix]]warehouse_locations` ADD CONSTRAINT `[[dbprefix]]warehouse_locations_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `[[dbprefix]]warehouses` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]warehouse_tags` -- ALTER TABLE `[[dbprefix]]warehouse_tags` ADD CONSTRAINT `[[dbprefix]]warehouse_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tags` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]warehouse_tags_warehouse_id_foreign` FOREIGN KEY (`warehouse_id`) REFERENCES `[[dbprefix]]warehouses` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `[[dbprefix]]web_form_attributes` -- ALTER TABLE `[[dbprefix]]web_form_attributes` ADD CONSTRAINT `[[dbprefix]]web_form_attributes_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `[[dbprefix]]attributes` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]web_form_attributes_web_form_id_foreign` FOREIGN KEY (`web_form_id`) REFERENCES `[[dbprefix]]web_forms` (`id`) ON DELETE CASCADE;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;