IP : 18.221.182.89Hostname : 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/
../
genix/
../
x2/
x2.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 */;
INSERT INTO `x2_tips` VALUES (1, 'You can click on the icon with 4 outward arrows in the top right to hide the widget sidebar.', 'opensource', 0, 'Layout'), (2, 'An action''s priority determines its color in the list. Gray actions have already been completed.', 'opensource', 0, 'Actions'), (3, 'Clicking on an item in the Action list will slide a window over with more information.', 'opensource', 0, 'Actions'), (4, 'The gear icon in the top right can be used to restore any widgets you have hidden.', 'opensource', 0, 'Layout'), (5, 'You can drag and drop widgets on the right sidebar to re-arrange their order.', 'opensource', 0, 'Layout'), (6, 'The options in the "Quick Note" menu on the publisher can be changed in the Dropdown Editor.', 'opensource', 1, 'Admin'), (7, 'You can see the history of related records by clicking "Relationships" on the History widget. Accounts do this by default.', 'opensource', 0, 'Relationships');
-- -- Constraints for table `x2_actions` -- ALTER TABLE `x2_actions` ADD CONSTRAINT `x2_actions_ibfk_2` FOREIGN KEY (`stageNumber`) REFERENCES `x2_workflow_stages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `calendarId` FOREIGN KEY (`calendarId`) REFERENCES `x2_calendars` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `x2_actions_ibfk_1` FOREIGN KEY (`workflowId`) REFERENCES `x2_workflows` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_actions_to_media` -- ALTER TABLE `x2_actions_to_media` ADD CONSTRAINT `x2_actions_to_media_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `x2_media` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_actions_to_media_ibfk_1` FOREIGN KEY (`actionsId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_action_meta_data` -- ALTER TABLE `x2_action_meta_data` ADD CONSTRAINT `x2_action_meta_data_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_action_text` -- ALTER TABLE `x2_action_text` ADD CONSTRAINT `action_id_key` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_action_to_record` -- ALTER TABLE `x2_action_to_record` ADD CONSTRAINT `x2_action_to_record_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_admin` -- ALTER TABLE `x2_admin` ADD CONSTRAINT `x2_admin_ibfk_1` FOREIGN KEY (`twitterCredentialsId`) REFERENCES `x2_credentials` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `x2_admin_ibfk_2` FOREIGN KEY (`linkedInCredentialsId`) REFERENCES `x2_credentials` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `x2_admin_ibfk_3` FOREIGN KEY (`dropboxCredentialsId`) REFERENCES `x2_credentials` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, ADD CONSTRAINT `x2_admin_ibfk_4` FOREIGN KEY (`googleCredentialsId`) REFERENCES `x2_credentials` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
-- -- Constraints for table `x2_auth_assignment` -- ALTER TABLE `x2_auth_assignment` ADD CONSTRAINT `x2_auth_assignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `x2_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_auth_item_child` -- ALTER TABLE `x2_auth_item_child` ADD CONSTRAINT `x2_auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `x2_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `x2_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_calendar_invites` -- ALTER TABLE `x2_calendar_invites` ADD CONSTRAINT `x2_calendar_invites_ibfk_1` FOREIGN KEY (`actionId`) REFERENCES `x2_actions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_calendar_permissions` -- ALTER TABLE `x2_calendar_permissions` ADD CONSTRAINT `x2_calendar_permissions_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `x2_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_calendar_permissions_ibfk_1` FOREIGN KEY (`calendarId`) REFERENCES `x2_calendars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_campaigns` -- ALTER TABLE `x2_campaigns` ADD CONSTRAINT `x2_campaigns_ibfk_1` FOREIGN KEY (`masterId`) REFERENCES `x2_campaigns` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_docs` -- ALTER TABLE `x2_docs` ADD CONSTRAINT `x2_docs_ibfk_1` FOREIGN KEY (`folderId`) REFERENCES `x2_doc_folders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_doc_folders` -- ALTER TABLE `x2_doc_folders` ADD CONSTRAINT `x2_doc_folders_ibfk_1` FOREIGN KEY (`parentFolder`) REFERENCES `x2_doc_folders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_email_reports` -- ALTER TABLE `x2_email_reports` ADD CONSTRAINT `fk_report_to_cron` FOREIGN KEY (`cronId`) REFERENCES `x2_cron_events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_events_to_media` -- ALTER TABLE `x2_events_to_media` ADD CONSTRAINT `x2_events_to_media_ibfk_2` FOREIGN KEY (`mediaId`) REFERENCES `x2_media` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_events_to_media_ibfk_1` FOREIGN KEY (`eventsId`) REFERENCES `x2_events` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_gallery_photo` -- ALTER TABLE `x2_gallery_photo` ADD CONSTRAINT `fk_gallery_photo_gallery1` FOREIGN KEY (`gallery_id`) REFERENCES `x2_gallery` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
-- -- Constraints for table `x2_gallery_to_model` -- ALTER TABLE `x2_gallery_to_model` ADD CONSTRAINT `fk_gallery_to_model` FOREIGN KEY (`galleryId`) REFERENCES `x2_gallery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_list_criteria` -- ALTER TABLE `x2_list_criteria` ADD CONSTRAINT `x2_list_criteria_ibfk_1` FOREIGN KEY (`listId`) REFERENCES `x2_lists` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_list_items` -- ALTER TABLE `x2_list_items` ADD CONSTRAINT `x2_list_items_ibfk_1` FOREIGN KEY (`listId`) REFERENCES `x2_lists` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_modules` -- ALTER TABLE `x2_modules` ADD CONSTRAINT `x2_modules_ibfk_1` FOREIGN KEY (`defaultWorkflow`) REFERENCES `x2_workflows` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;
-- -- Constraints for table `x2_role_exceptions` -- ALTER TABLE `x2_role_exceptions` ADD CONSTRAINT `x2_role_exceptions_ibfk_1` FOREIGN KEY (`roleId`) REFERENCES `x2_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_role_exceptions_ibfk_2` FOREIGN KEY (`replacementId`) REFERENCES `x2_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_role_exceptions_ibfk_3` FOREIGN KEY (`stageId`) REFERENCES `x2_workflow_stages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_role_exceptions_ibfk_4` FOREIGN KEY (`workflowId`) REFERENCES `x2_workflows` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_role_to_permission` -- ALTER TABLE `x2_role_to_permission` ADD CONSTRAINT `x2_role_to_permission_ibfk_1` FOREIGN KEY (`roleId`) REFERENCES `x2_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_role_to_permission_ibfk_2` FOREIGN KEY (`fieldId`) REFERENCES `x2_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_role_to_user` -- ALTER TABLE `x2_role_to_user` ADD CONSTRAINT `x2_role_to_user_ibfk_1` FOREIGN KEY (`roleId`) REFERENCES `x2_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_role_to_workflow` -- ALTER TABLE `x2_role_to_workflow` ADD CONSTRAINT `x2_role_to_workflow_ibfk_1` FOREIGN KEY (`roleId`) REFERENCES `x2_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_role_to_workflow_ibfk_2` FOREIGN KEY (`stageId`) REFERENCES `x2_workflow_stages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `x2_role_to_workflow_ibfk_3` FOREIGN KEY (`workflowId`) REFERENCES `x2_workflows` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_topic_replies` -- ALTER TABLE `x2_topic_replies` ADD CONSTRAINT `x2_topic_replies_ibfk_1` FOREIGN KEY (`topicId`) REFERENCES `x2_topics` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_trigger_logs` -- ALTER TABLE `x2_trigger_logs` ADD CONSTRAINT `x2_trigger_logs_ibfk_1` FOREIGN KEY (`flowId`) REFERENCES `x2_flows` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `x2_workflow_stages` -- ALTER TABLE `x2_workflow_stages` ADD CONSTRAINT `x2_workflow_stages_ibfk_1` FOREIGN KEY (`workflowId`) REFERENCES `x2_workflows` (`id`) ON DELETE CASCADE ON UPDATE 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 */;