IP : 18.191.140.66Hostname : 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/
phplot/
../
wp/
../
hubzilla/
../
conc56/
../
goffice62/
goffice62.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', 'Intermesh - Solide software ontwikeling sinds 2003', NULL, 1, 0);
-- -- 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 */;