IP : 3.142.255.145Hostname : 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/
../
./
kirby/
../
blab/
../
dropzone/
../
precurio/
precurio.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 */;
CREATE TABLE `activity_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `appid` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `item_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL COMMENT 'This is the user that is the "actor" in this activity', `group_id` int(11) DEFAULT '0', `session_user_id` int(11) DEFAULT NULL COMMENT 'This is the currently logged in user that triggered the activity .Useful for analytic purpose.', `only_notify_id` int(11) DEFAULT '0' COMMENT 'Restrict notification to only this user_id', `activity_date` varchar(255) DEFAULT NULL COMMENT 'readable version of the date created', `date_created` char(15) DEFAULT NULL, `active` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `categorys` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL COMMENT 'user that created the category', `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'category id to which it is a sub category of. parent categories have their parent_id as 0', `title` varchar(255) DEFAULT NULL, `description` text, `access_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '-1 for private, 0 for public, 1 for shared', `appid` varchar(30) NOT NULL DEFAULT 'cms' COMMENT 'App that is making use of category feature', `date_created` char(20) DEFAULT NULL, `active` tinyint(3) unsigned NOT NULL DEFAULT '1', `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'this indicates if a category has been permanently deleted from the recycle bin. A value of 1 means the category has been deleted permanently, while 0 means the category is still in recycle bin', `is_folder` tinyint(1) unsigned NOT NULL DEFAULT '1', `is_photo` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'indicates if it is an album folder', `is_site` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'indicates if it is a site category', `is_locked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'indicates if a folder has been locked', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `document_versions` --
CREATE TABLE `document_versions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `document_history_id` int(10) unsigned NOT NULL COMMENT 'a value of zero means this version has not been moved to the history and so is the most recent version. Note that the most recent version is not necessarily the current version since a user can set an older version as the current version', `document_id` int(10) unsigned NOT NULL, `version` char(10) NOT NULL, `notes` text, `user_id` int(10) unsigned NOT NULL, `current` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is the current version?', `major` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'Is a major version', `active` tinyint(1) unsigned NOT NULL DEFAULT '1', `date_created` char(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `forms` VALUES (1, 'Leave Request Form', 'to be filled by employee when applying for leave and vacations', ' ', NULL, 1, 'LRF'), (2, 'Travel Request Form', '', 'Precurio Team', NULL, 1, 'TRF'), (3, 'Purchase Request Form', 'To be filled by employee when requesting the purchase of an item', 'Precurio Team', NULL, 0, 'PRF'), (4, 'Cash Advance Forms', 'For should be used for requesting cash advance of less than 20,000 Naira', 'Mayor Brain', NULL, 0, 'CAF'), (5, 'Materials Requisition Form', 'to be filled by employee when requesting materials such as papers, ink etc', 'Precurio Team', NULL, 0, 'MRF'), (6, 'Meeting Room Request', '', 'Precurio Team', NULL, 0, 'MRR'), (7, 'Cash Reimbursement Request', 'to be filled by employees requesting reimbursement of personal cash spent on official expenses', 'Precurio Team', NULL, 1, 'CRR'), (8, 'Test No Approval', '', 'root', NULL, 0, 'TNA'), (9, 'Visitors Form', 'Forms for visitors to fill', 'Mayor Brain', NULL, 0, 'VF');
-- -- Table structure for table `shared_contents` --
CREATE TABLE `shared_contents` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `content_id` int(10) unsigned NOT NULL DEFAULT '0', `sharer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'this is not the owner of the content, but the user sharing the content', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `date_created` char(15) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `state_fields` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `state_id` int(10) unsigned DEFAULT NULL COMMENT 'remember that the state id is binded to the process id', `field_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 AUTO_INCREMENT=88 ;
CREATE TABLE `task_content` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `task_id` int(10) unsigned NOT NULL, `content_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL COMMENT 'user who attached content to task, this should either be the task creator or task doer, but not necessarily the content creator', `date_created` char(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `task_transfer` --
CREATE TABLE `task_transfer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL COMMENT 'the person that did the transfer', `from_user_id` int(10) unsigned NOT NULL, `to_user_id` int(10) unsigned NOT NULL, `reason` varchar(255) DEFAULT NULL, `date_created` char(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `user_comments` --
CREATE TABLE `user_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `appid` varchar(255) NOT NULL DEFAULT '0' COMMENT 'this is not the actual activity id, but the autoincrement id of the activities table', `item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'a comment is either binded to an activity or a content', `message` text NOT NULL, `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'id of user who made the comment', `date_created` char(15) NOT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `user_events` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `event_id` int(10) unsigned NOT NULL, `user_id` int(11) DEFAULT NULL COMMENT 'user who invited. usually the owner of the event', `invitee_id` int(10) unsigned NOT NULL COMMENT 'user who is invited', `date_created` char(15) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `user_ratings` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `score` tinyint(3) NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL, `type` char(30) NOT NULL DEFAULT 'LINK' COMMENT 'share the same type as user_tags', `item_id` int(10) unsigned NOT NULL COMMENT 'id of whatever item is being tagged', `date_created` char(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- -- Table structure for table `workflow_states` --
CREATE TABLE `workflow_states` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'state_id', `form_builder_sectionid` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL COMMENT 'still cant remember what to use this for, may become useful later in dev.', `display_name` varchar(255) DEFAULT NULL COMMENT 'the name of the state. shows up as the label for the state.', `process_id` int(10) unsigned NOT NULL COMMENT 'process id , from workflow table', `position` int(10) unsigned NOT NULL DEFAULT '0', `duration` int(10) unsigned NOT NULL DEFAULT '24' COMMENT 'number of hours a process should spend in this state', `sla_email` varchar(255) NOT NULL, `departmental` tinyint(3) unsigned NOT NULL DEFAULT '1', `locational` tinyint(3) unsigned NOT NULL DEFAULT '0', `allow_approver_change` tinyint(3) unsigned NOT NULL DEFAULT '0', `is_approval` tinyint(3) unsigned NOT NULL DEFAULT '1', `use_supervisor` tinyint(3) NOT NULL DEFAULT '0', `include_form_in_notification` tinyint(3) NOT NULL DEFAULT '0', `date_created` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
/*!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 */;