IP : 13.59.4.70Hostname : 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/
drupal9/
../
vision/
../
elgg/
../
uikit/
../
pier/
pier.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 `[[dbprefix]]file_repo_attributes` --
CREATE TABLE `[[dbprefix]]file_repo_attributes` ( `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `attribute` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`,`attribute`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- -- Table structure for table `[[dbprefix]]projects` --
CREATE TABLE `[[dbprefix]]projects` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `priority` int(3) unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `show_description_in_overview` tinyint(1) unsigned NOT NULL DEFAULT '0', `logo_file` varchar(44) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `completed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `completed_by_id` int(11) DEFAULT NULL, `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by_id` int(10) unsigned DEFAULT NULL, `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_by_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `completed_on` (`completed_on`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]projects` --
INSERT INTO `[[dbprefix]]projects` VALUES (1, 'Welcome', 0, 0, 'This is the very first project', 1, NULL, '0000-00-00 00:00:00', NULL, '[[regtime]]', NULL, '[[regtime]]', NULL);
-- -- Dumping data for table `[[dbprefix]]project_tasks` --
INSERT INTO `[[dbprefix]]project_tasks` VALUES (1, 1, 'Step 1: Activate the plugins\r\nThink about the things you need in your projects, like links, files, tickets, wiki, etc.\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 0, '[[regtime]]', 0, 1), (2, 1, 'Step 2: Update your company info\r\nSet your company details such as phone and fax number, address, email, homepage, etc.\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 0, '[[regtime]]', 0, 2), (3, 1, 'Step 3: Add team members\r\nYou can create user accounts for all members of your team (an unlimited number). Every member will get a username and password which they can use to access the system\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 0, '[[regtime]]', 0, 3), (4, 1, 'Step 4: Add client companies and their members\r\nNow it''s time to define client companies (unlimited). When you''re done you can add their members or leave that for their team leaders. Client members are similar to your company members except that they have limited access to content and functions (you can set what they can do per project and per member)\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 0, '[[regtime]]', 0, 4), (5, 1, 'Step 5: Start a project\r\nDefining a new project is really easy: set a name and description (optional) and click submit. After that you can set permissions for your team members and clients.\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 1, '[[regtime]]', 1, 5), (6, 1, 'Step 6: Mark the Welcome project finished\r\n', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 0, '[[regtime]]', 0, 6);
-- -- Table structure for table `[[dbprefix]]project_task_lists` --
CREATE TABLE `[[dbprefix]]project_task_lists` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `milestone_id` int(10) unsigned NOT NULL DEFAULT '0', `project_id` int(10) unsigned DEFAULT NULL, `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, `priority` int(3) unsigned NOT NULL DEFAULT '0', `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `due_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `score` int(3) unsigned NOT NULL DEFAULT '0', `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0', `completed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `completed_by_id` int(10) unsigned DEFAULT NULL, `created_on` datetime DEFAULT NULL, `created_by_id` int(10) unsigned NOT NULL DEFAULT '0', `updated_on` datetime DEFAULT NULL, `updated_by_id` int(10) unsigned NOT NULL DEFAULT '0', `order` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `milestone_id` (`milestone_id`), KEY `project_id` (`project_id`), KEY `completed_on` (`completed_on`), KEY `created_on` (`created_on`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]project_task_lists` --
INSERT INTO `[[dbprefix]]project_task_lists` VALUES (1, 1, 1, 'To-Do List', 1, 'Welcome to your new account. You can get started in a minute following these easy steps.', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 1, '0000-00-00 00:00:00', 0, '[[regtime]]', 0, '[[regtime]]', 0, 0);
-- -- Table structure for table `[[dbprefix]]user_im_values` --
CREATE TABLE `[[dbprefix]]user_im_values` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0', `im_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `value` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`im_type_id`), KEY `is_default` (`is_default`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!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 */;