| Server IP : 103.119.228.120 / Your IP : 3.128.201.207 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/pods/ |
Upload File : |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `people`
--
-- --------------------------------------------------------
--
-- Table structure for table `activity`
--
CREATE TABLE `activity` (
`userId` bigint(12) DEFAULT NULL,
`targetUserId` bigint(12) DEFAULT NULL,
`targetContentId` bigint(12) DEFAULT NULL,
`targetContentType` varchar(25) DEFAULT NULL,
`resultContentId` bigint(12) DEFAULT NULL,
`resultContentType` varchar(25) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`targetMessage` varchar(255) DEFAULT NULL,
`userMessage` varchar(255) DEFAULT NULL,
`gid` varchar(25) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
UNIQUE KEY `id` (`id`),
UNIQUE KEY `gidx` (`gid`),
KEY `uid` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=65 ;
--
-- Dumping data for table `activity`
--
-- --------------------------------------------------------
--
-- Table structure for table `alerts`
--
CREATE TABLE `alerts` (
`id` bigint(12) NOT NULL AUTO_INCREMENT,
`userId` bigint(12) DEFAULT NULL,
`targetUserId` bigint(12) DEFAULT NULL,
`targetContentId` bigint(12) DEFAULT NULL,
`targetContentType` varchar(25) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`status` enum('new','read') DEFAULT 'new',
PRIMARY KEY (`id`),
KEY `uid` (`targetUserId`),
KEY `targetidx` (`targetContentId`,`targetContentType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;
--
-- Dumping data for table `alerts`
--
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`contentId` bigint(12) DEFAULT NULL,
`profileId` bigint(12) DEFAULT NULL,
`userId` bigint(12) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`comment` text,
`type` varchar(12) DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `doc_idx` (`contentId`),
KEY `pid` (`profileId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ;
--
-- Dumping data for table `comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `content`
--
CREATE TABLE `content` (
`userId` bigint(12) DEFAULT NULL,
`createdBy` bigint(12) DEFAULT NULL,
`parentId` bigint(12) DEFAULT NULL,
`groupId` bigint(12) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`changeDate` datetime DEFAULT NULL,
`body` text,
`headline` text,
`link` varchar(1024) DEFAULT NULL,
`type` varchar(12) DEFAULT NULL,
`privacy` enum('public','friends_only','group_only','owner_only') DEFAULT 'public',
`status` enum('new','approved','featured','hidden') DEFAULT 'new',
`flagDate` datetime DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
`commentCount` bigint(12) DEFAULT '0',
`yes_votes` int(11) DEFAULT '0',
`no_votes` int(11) DEFAULT '0',
`stub` text,
`editDate` datetime DEFAULT NULL,
`commentDate` datetime DEFAULT NULL,
`hidden` int(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `datesort` (`date`),
KEY `uidx` (`userId`),
KEY `datex` (`date`),
KEY `gidx` (`groupId`),
FULLTEXT KEY `idx_full` (`headline`,`link`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=123 ;
--
-- Dumping data for table `content`
--
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`file_name` varchar(60) DEFAULT NULL,
`original_name` varchar(60) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`extension` varchar(6) DEFAULT NULL,
`mime_type` varchar(32) DEFAULT NULL,
`userId` bigint(12) DEFAULT NULL,
`contentId` bigint(12) DEFAULT NULL,
`groupId` bigint(12) DEFAULT NULL,
`changeDate` datetime DEFAULT NULL,
`date` datetime DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `didx` (`contentId`),
KEY `uidx` (`userId`),
KEY `gid` (`groupId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
--
-- Dumping data for table `files`
--
-- --------------------------------------------------------
--
-- Table structure for table `flags`
--
CREATE TABLE `flags` (
`type` enum('content','user','group','comment','file') DEFAULT NULL,
`itemId` bigint(12) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`value` text,
`userId` bigint(12) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `lookup` (`type`,`itemId`,`name`,`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=77 ;
--
-- Dumping data for table `flags`
--
-- --------------------------------------------------------
--
-- Table structure for table `groupMember`
--
CREATE TABLE `groupMember` (
`userId` bigint(12) DEFAULT NULL,
`groupId` bigint(12) DEFAULT NULL,
`type` enum('invitee','owner','manager','member') DEFAULT NULL,
`date` datetime DEFAULT NULL,
UNIQUE KEY `nodupes` (`userId`,`groupId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `groupMember`
--
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
CREATE TABLE `groups` (
`groupname` varchar(255) DEFAULT NULL,
`description` text,
`stub` varchar(40) DEFAULT NULL,
`type` enum('public','private') DEFAULT NULL,
`userId` bigint(12) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`changeDate` datetime DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `invites`
--
CREATE TABLE `invites` (
`userId` bigint(12) DEFAULT NULL,
`groupId` bigint(12) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`date` datetime DEFAULT NULL,
`code` varchar(200) DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `invites`
--
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
CREATE TABLE `messages` (
`id` bigint(12) NOT NULL AUTO_INCREMENT,
`userId` bigint(12) NOT NULL,
`targetUserId` bigint(12) DEFAULT NULL,
`fromId` bigint(12) NOT NULL,
`message` text,
`date` datetime DEFAULT NULL,
`status` enum('new','read','flagged','spam') DEFAULT 'new',
PRIMARY KEY (`id`),
KEY `user_and_friend` (`userId`,`targetUserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;
--
-- Dumping data for table `messages`
--
-- --------------------------------------------------------
--
-- Table structure for table `meta`
--
CREATE TABLE `meta` (
`type` enum('group','content','user','comment','file') NOT NULL,
`itemId` bigint(12) NOT NULL,
`name` varchar(100) NOT NULL,
`value` text NOT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
UNIQUE KEY `u` (`type`,`itemId`,`name`),
KEY `lookup` (`type`,`itemId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
--
-- Dumping data for table `meta`
--
INSERT INTO `meta` VALUES('user', 5, 'adminUser', '1', 49);
-- --------------------------------------------------------
--
-- Table structure for table `tagRef`
--
CREATE TABLE `tagRef` (
`tagId` bigint(12) DEFAULT NULL,
`itemId` bigint(12) DEFAULT NULL,
`type` enum('content','user','group','comment','file') DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `lookup` (`type`,`itemId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tagRef`
--
-- --------------------------------------------------------
--
-- Table structure for table `tags`
--
CREATE TABLE `tags` (
`value` varchar(100) DEFAULT NULL,
`weight` bigint(12) DEFAULT '0',
`date` datetime DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tags`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`nick` varchar(255) DEFAULT NULL,
`fullname` varchar(255) DEFAULT NULL,
`stub` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`id` bigint(12) NOT NULL AUTO_INCREMENT,
`password` varchar(100) DEFAULT NULL,
`memberSince` datetime DEFAULT NULL,
`date` datetime DEFAULT NULL,
`homepage` varchar(255) DEFAULT NULL,
`lastVisit` datetime DEFAULT NULL,
`verificationKey` varchar(200) DEFAULT NULL,
`authSecret` varchar(32) DEFAULT NULL,
`passwordResetCode` varchar(32) DEFAULT NULL,
`invitedBy` bigint(12) DEFAULT NULL,
`birthday` date DEFAULT NULL,
`zipcode` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES('[[admin_username]]', NULL, '[[admin_username]]', '[[admin_email]]', 5, NULL, '[[regtime]]', NULL, NULL, '[[regtime]]', NULL, '[[admin_pass]]', NULL, NULL, NULL, NULL);