| Server IP : 103.119.228.120 / Your IP : 3.133.117.113 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/softaculous/webcollab/ |
Upload File : |
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 */;
--
-- Database: `webcollab352`
--
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE `config` (
`email_admin` varchar(200) DEFAULT NULL,
`reply_to` varchar(200) DEFAULT NULL,
`email_from` varchar(200) DEFAULT NULL,
`globalaccess` varchar(50) DEFAULT NULL,
`groupaccess` varchar(50) DEFAULT NULL,
`config_owner` varchar(50) DEFAULT NULL,
`usergroup` varchar(50) DEFAULT NULL,
`project_order` varchar(200) DEFAULT NULL,
`task_order` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `config`
--
INSERT INTO `config` VALUES
(NULL, NULL, NULL, 'checked="checked"', '', NULL, NULL, 'ORDER BY task_name', 'ORDER BY task_name');
-- --------------------------------------------------------
--
-- Table structure for table `contacts`
--
CREATE TABLE `contacts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`firstname` varchar(100) NOT NULL,
`lastname` varchar(100) NOT NULL,
`company` varchar(100) DEFAULT NULL,
`tel_home` varchar(100) DEFAULT NULL,
`gsm` varchar(100) DEFAULT NULL,
`fax` varchar(100) DEFAULT NULL,
`tel_business` varchar(100) DEFAULT NULL,
`address` varchar(100) DEFAULT NULL,
`postal` varchar(100) DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`notes` text,
`email` varchar(100) DEFAULT NULL,
`added_by` int(10) unsigned NOT NULL,
`date_mod` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` int(10) unsigned NOT NULL,
`taskid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `contacts_tasks`
--
CREATE TABLE `contacts_tasks` (
`contact_id` int(11) DEFAULT NULL,
`task_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fileid` int(10) unsigned NOT NULL DEFAULT '0',
`hashid` varchar(200) DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`file_size` bigint(20) NOT NULL DEFAULT '0',
`file_description` text,
`uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`uploader` int(10) unsigned NOT NULL,
`mime` varchar(200) DEFAULT NULL,
`taskid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `taskid` (`taskid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `forum`
--
CREATE TABLE `forum` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent` int(10) unsigned NOT NULL,
`taskid` int(10) unsigned NOT NULL,
`posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`edited` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`forum_text` text,
`userid` int(10) unsigned NOT NULL,
`usergroupid` int(10) unsigned NOT NULL,
`sequence` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `taskid` (`taskid`),
KEY `edited` (`edited`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `logins`
--
CREATE TABLE `logins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`session_key` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
`lastaccess` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`token` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `session_key` (`session_key`(10),`user_id`),
KEY `lastaccess` (`lastaccess`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `logins`
--
-- --------------------------------------------------------
--
-- Table structure for table `login_attempt`
--
CREATE TABLE `login_attempt` (
`login_name` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
`last_attempt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `maillist`
--
CREATE TABLE `maillist` (
`email` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `seen`
--
CREATE TABLE `seen` (
`taskid` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
`seen_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
KEY `taskid` (`taskid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `site_name`
--
CREATE TABLE `site_name` (
`manager_name` varchar(100) DEFAULT NULL,
`abbr_manager_name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `site_name`
--
INSERT INTO `site_name` VALUES
('[[site_name]]', 'WebCollab');
-- --------------------------------------------------------
--
-- Table structure for table `taskgroups`
--
CREATE TABLE `taskgroups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_name` varchar(100) NOT NULL,
`group_description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `group_name` (`group_name`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tasks`
--
CREATE TABLE `tasks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent` int(10) unsigned NOT NULL,
`task_name` varchar(255) NOT NULL,
`task_text` text,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`edited` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`task_owner` int(10) unsigned NOT NULL DEFAULT '0',
`creator` int(10) unsigned NOT NULL,
`finished_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`projectid` int(10) unsigned NOT NULL DEFAULT '0',
`deadline` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`priority` tinyint(4) NOT NULL DEFAULT '2',
`task_status` varchar(20) NOT NULL DEFAULT 'created',
`taskgroupid` int(10) unsigned NOT NULL,
`lastforumpost` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`usergroupid` int(10) unsigned NOT NULL,
`globalaccess` varchar(5) NOT NULL DEFAULT 't',
`groupaccess` varchar(5) NOT NULL DEFAULT 'f',
`lastfileupload` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`completed` tinyint(4) NOT NULL DEFAULT '0',
`completion_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`archive` tinyint(4) NOT NULL DEFAULT '0',
`sequence` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `task_owner` (`task_owner`),
KEY `parent` (`parent`),
KEY `task_name` (`task_name`(10)),
KEY `projectid` (`projectid`),
KEY `taskgroupid` (`taskgroupid`),
KEY `deadline` (`deadline`),
KEY `task_status` (`task_status`,`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tokens`
--
CREATE TABLE `tokens` (
`token` varchar(100) DEFAULT NULL,
`user_action` varchar(100) DEFAULT NULL,
`userid` int(10) unsigned NOT NULL,
`lastaccess` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `usergroups`
--
CREATE TABLE `usergroups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_name` varchar(100) NOT NULL,
`group_description` varchar(255) DEFAULT NULL,
`private` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `group_name` (`group_name`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `usergroups_users`
--
CREATE TABLE `usergroups_users` (
`usergroupid` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
KEY `userid` (`userid`,`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(200) NOT NULL,
`fullname` varchar(200) NOT NULL,
`user_password` varchar(255) NOT NULL,
`email` varchar(200) NOT NULL,
`user_admin` varchar(5) NOT NULL DEFAULT 'f',
`private` tinyint(4) NOT NULL DEFAULT '0',
`guest` tinyint(4) NOT NULL DEFAULT '0',
`deleted` varchar(5) NOT NULL DEFAULT 'f',
`locale` varchar(10) NOT NULL DEFAULT 'en',
PRIMARY KEY (`id`),
KEY `fullname` (`fullname`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES
(1, '[[admin_username]]', '[[admin_realname]]', '[[admin_pass]]', '[[admin_email]]', 't', 0, 0, 'f', 'en');
/*!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 */;