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/
./
sitepad/
../
koken/
../
backdrop/
../
goffice67/
goffice67.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 */;
-- -- Table structure for table `bookmarks_bookmark` --
CREATE TABLE `bookmarks_bookmark` ( `id` int(11) NOT NULL AUTO_INCREMENT, `categoryId` int(11) NOT NULL, `createdBy` int(11) DEFAULT NULL, `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `logo` binary(40) DEFAULT NULL, `openExtern` tinyint(1) NOT NULL DEFAULT '1', `behaveAsModule` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `createdBy` (`createdBy`), KEY `categoryId` (`categoryId`), KEY `core_blob_bookmark_logo_idx` (`logo`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
-- -- Dumping data for table `bookmarks_bookmark` --
INSERT INTO `bookmarks_bookmark` VALUES (1, 1, 1, 'Group-Office', 'https://www.group-office.com', 'Group-Office is an enterprise CRM and groupware tool. Collaborate, Share projects, calendars, files and e-mail online with co-workers and clients. Easy to use and fully customizable.', 'f384ee1dd8a66f36a425dce7b08992d7a6a68c36', 1, 0), (2, 1, 1, 'Intermesh', 'https://www.intermesh.nl', NULL, NULL, 1, 0);
-- -- Constraints for table `core_spreadsheet_export` -- ALTER TABLE `core_spreadsheet_export` ADD CONSTRAINT `core_spreadsheet_export_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `core_user` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `core_spreadsheet_export_ibfk_2` FOREIGN KEY (`entityTypeId`) REFERENCES `core_entity` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `core_user` -- ALTER TABLE `core_user` ADD CONSTRAINT `fk_user_avatar_id` FOREIGN KEY (`avatarId`) REFERENCES `core_blob` (`id`) ON UPDATE NO ACTION;
-- -- Constraints for table `core_user_custom_fields` -- ALTER TABLE `core_user_custom_fields` ADD CONSTRAINT `core_user_custom_fields_ibfk_1` FOREIGN KEY (`id`) REFERENCES `core_user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `core_user_default_group` -- ALTER TABLE `core_user_default_group` ADD CONSTRAINT `core_user_default_group_ibfk_1` FOREIGN KEY (`groupId`) REFERENCES `core_group` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `core_user_group` -- ALTER TABLE `core_user_group` ADD CONSTRAINT `core_user_group_ibfk_1` FOREIGN KEY (`groupId`) REFERENCES `core_group` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `core_user_group_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `core_user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `em_contacts_last_mail_times` -- ALTER TABLE `em_contacts_last_mail_times` ADD CONSTRAINT `em_contacts_last_mail_times_addressbook_addressbook_id_fk` FOREIGN KEY (`contact_id`) REFERENCES `addressbook_contact` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `em_contacts_last_mail_times_core_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `core_user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `fs_bookmarks` -- ALTER TABLE `fs_bookmarks` ADD CONSTRAINT `fs_bookmarks_core_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `core_user` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fs_bookmarks_fs_folders_folder_id_fk` FOREIGN KEY (`folder_id`) REFERENCES `fs_folders` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `fs_files_custom_fields` -- ALTER TABLE `fs_files_custom_fields` ADD CONSTRAINT `fs_files_custom_fields_ibfk_1` FOREIGN KEY (`id`) REFERENCES `fs_files` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `fs_folders_custom_fields` -- ALTER TABLE `fs_folders_custom_fields` ADD CONSTRAINT `fs_folders_custom_fields_ibfk_1` FOREIGN KEY (`id`) REFERENCES `fs_folders` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `go_state` -- ALTER TABLE `go_state` ADD CONSTRAINT `go_state_core_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `core_user` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `go_templates` -- ALTER TABLE `go_templates` ADD CONSTRAINT `fk_go_templates_go_template_group` FOREIGN KEY (`group_id`) REFERENCES `go_template_group` (`id`) ON DELETE SET NULL;
-- -- Constraints for table `history_log_entry` -- ALTER TABLE `history_log_entry` ADD CONSTRAINT `fk_log_entry_core_acl1` FOREIGN KEY (`aclId`) REFERENCES `core_acl` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION;
-- -- Constraints for table `notes_note` -- ALTER TABLE `notes_note` ADD CONSTRAINT `notes_note_ibfk_1` FOREIGN KEY (`noteBookId`) REFERENCES `notes_note_book` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `notes_note_ibfk_2` FOREIGN KEY (`createdBy`) REFERENCES `core_user` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION, ADD CONSTRAINT `notes_note_ibfk_3` FOREIGN KEY (`modifiedBy`) REFERENCES `core_user` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION;
-- -- Constraints for table `notes_note_book` -- ALTER TABLE `notes_note_book` ADD CONSTRAINT `notes_note_book_ibfk_1` FOREIGN KEY (`aclId`) REFERENCES `core_acl` (`id`), ADD CONSTRAINT `notes_note_book_ibfk_2` FOREIGN KEY (`createdBy`) REFERENCES `core_user` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION;
-- -- Constraints for table `notes_note_custom_fields` -- ALTER TABLE `notes_note_custom_fields` ADD CONSTRAINT `notes_note_custom_fields_ibfk_1` FOREIGN KEY (`id`) REFERENCES `notes_note` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `tasks_tasklist_group` -- ALTER TABLE `tasks_tasklist_group` ADD CONSTRAINT `fk_tasks_column_tasks_tasklist1` FOREIGN KEY (`tasklistId`) REFERENCES `tasks_tasklist` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tasks_tasklist_user` -- ALTER TABLE `tasks_tasklist_user` ADD CONSTRAINT `fk_tasks_tasklist_user_tasks_tasklist1` FOREIGN KEY (`tasklistId`) REFERENCES `tasks_tasklist` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tasks_task_category` -- ALTER TABLE `tasks_task_category` ADD CONSTRAINT `tasks_task_category_ibfk_1` FOREIGN KEY (`taskId`) REFERENCES `tasks_task` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `tasks_task_category_ibfk_2` FOREIGN KEY (`categoryId`) REFERENCES `tasks_category` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `tasks_task_custom_fields` -- ALTER TABLE `tasks_task_custom_fields` ADD CONSTRAINT `fk_tasks_task_custom_field1` FOREIGN KEY (`id`) REFERENCES `tasks_task` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `tasks_task_user` -- ALTER TABLE `tasks_task_user` ADD CONSTRAINT `fk_tasks_task_user_tasks_task1` FOREIGN KEY (`taskId`) REFERENCES `tasks_task` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
-- -- Constraints for table `tasks_user_settings` -- ALTER TABLE `tasks_user_settings` ADD CONSTRAINT `tasks_user_settings_core_user_id_fk` FOREIGN KEY (`userId`) REFERENCES `core_user` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `tasks_user_settings_tasks_tasklist_id_fk` FOREIGN KEY (`defaultTasklistId`) REFERENCES `tasks_tasklist` (`id`) ON DELETE SET NULL;
/*!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 */;