| Server IP : 170.10.162.208 / Your IP : 216.73.216.181 Web Server : LiteSpeed System : Linux altar19.supremepanel19.com 4.18.0-553.69.1.lve.el8.x86_64 #1 SMP Wed Aug 13 19:53:59 UTC 2025 x86_64 User : deltahospital ( 1806) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/deltahospital/.cagefs/tmp/ |
Upload File : |
<?php //0046a
if(!extension_loaded('ionCube Loader')){$__oc=strtolower(substr(php_uname(),0,3));$__ln='ioncube_loader_'.$__oc.'_'.substr(phpversion(),0,3).(($__oc=='win')?'.dll':'.so');if(function_exists('dl')){@dl($__ln);}if(function_exists('_il_exec')){return _il_exec();}$__ln='/ioncube/'.$__ln;$__oid=$__id=realpath(ini_get('extension_dir'));$__here=dirname(__FILE__);if(strlen($__id)>1&&$__id[1]==':'){$__id=str_replace('\\','/',substr($__id,2));$__here=str_replace('\\','/',substr($__here,2));}$__rd=str_repeat('/..',substr_count($__id,'/')).$__here.'/';$__i=strlen($__rd);while($__i--){if($__rd[$__i]=='/'){$__lp=substr($__rd,0,$__i).$__ln;if(file_exists($__oid.$__lp)){$__ln=$__lp;break;}}}if(function_exists('dl')){@dl($__ln);}}else{die('The file '.__FILE__." is corrupted.\n");}if(function_exists('_il_exec')){return _il_exec();}echo('Site error: the file <b>'.__FILE__.'</b> requires the ionCube PHP Loader '.basename($__ln).' to be installed by the website operator. If you are the website operator please use the <a href="http://www.ioncube.com/lw/">ionCube Loader Wizard</a> to assist with installation.');exit(199);
?>
HR+cPypqCCdrLudkb3kbwiJGwncl6S+i8L82lCa9+CoRGryJ5HMXq24jpfaFcnA0nFn1pB47fPwq
3xzRFtR3z2LlAS6HQr9NSMxd0t4KFvDyb8S0YbEzMydnJAuEZstbgESa2k/kh1wk5cZhbhDr1EDV
VSZ3wKB3q1mkvjfg1+i9hRx1VmPvJ2x0d8SoXh8kGcciJKnhgPpBx47svwfeIq/wSdW1T5PdVlqA
XwgmlLnldKRPuhBo1yuutF68YcWVLqlZPn1K5RgY9tXSfljby8z8Nh5LVYEiJQbxFY1G/uhggsBu
amPAomG3wr9y/OORLg5yy5eTKpe14YAujKYCPMg4ZMJ4rFwtSwbL56bBWm0kLyyDoovl8/yj7BXq
n7OfmMSk+P90wxODDUe1/TJ4Fb7DSwsXbyPNkHnqB5zNBG9HbPtlw3J5Kbuc+IsLg4LpJRrb4ToI
EQw94Jw74oyJqCGWaz2ocrdIQIrdj1QVY8cKOTB/a2LcXZv0fBOGLHYyO4qEJT+uQmHZaa0kkXH5
Q+m4tqgChr38cm47NheLNIJikIx+0DTchKFBBrnJ2Z5IKu/ZMTCCgTtj3u4XVyjArwfMa18DuSbr
eA7jGU1WVP1ILjUVKNwtO+qMpeoIxbuzjV7KuWL5gPRvjhhjKyjjYlSBwgOw0COZ73wk8A8maEK6
qiVul3CaaTY+nzrIXFYa6PD0LWg+E3qFjcaZ/Pv36C5PPwwrP9Sv4BVrapgsJpQCVY/NNlcTB4Ko
Ue9+KdbxZjI+BdYgX/T3LqbCMrVFwDsOEwMRRJ5cd0ydIshmZnx73lBr8bU+tN3zCfZ/dC+Hnz8H
Fdxl1sEgS9GG2344WjUfX2NN0tuByNXP0myVnkEKuLxM02UiGjbJUHK3KNQ1zyaP2noxp5XJO93w
ZKMu9F/ZRYgWPTC1Sbhvop2f3DcXwaBc0kBg9ADIo/rcjzQQyYoukVdIxrkC4rCi1Bg+/Kn5DXIR
lBJVm2XFFeZ7R/lKaEormRpzY9OEIkffqtfY5V4TbNT3OJ8jg1VYwrC+wNaS+CgQC/666HGNZhlL
B98xtb/kaSH5tiTnKvmPqvpMSHyC+pFyMKkyNhTjz1pIwEje7tK9JdSdnze2LrDfrtKsSniAfqS2
7zymvMiLKEdiLkuRq5DpqGJfK7jMbd1BptNzjVqaqmmB+tLd5Er5grouDrbBM7VjD02rZ6PE/dZE
cdrXaXkRTzXhXY0H2TACurQJVk4X0B0S3R9uKy+KhXvkQwsmk+UXfaXFa84DL2yD+zy4tFpB2KQW
egR+P0Zk0uU6EFQKZPN7RJ32KM2iEazJfG66YKvW/xtwgIEaXn64j3DqUouVGeD3wX6gR9wxVF+I
VtYAeTRTXPlEOwXF9mVeWJMyNbMYGk1laZLPFIsdwxHqDywIP2qmnRNz0lKAXlPurJbca6SMECtv
fnpzPWbz6iC//KpUJXC0SSzEGdJI2L09jNej5t/0UF2PsRoK9dFAU512gyJZvVFvPvlQmq8UYeoi
N5w7S2qdO3b26OfjqupONoJnuQUbDbqepv4p8tf9vFEwcHCG+hUiKckluzoJ0DsD/LBpHV185EN4
i1ZHKZy1P+7/K57QmF4ozXy9kV2PCDvUWhv53r0p0nfOtnGEpvoqpxtYjfwCxHVQ+rZJG87+XkW6
yZz1XhJuPSGwQOy+0QznLaMS8wjpP7lRqQe5kc/AQv2H7ev3QfvZBeInZHfpgH3IPVdfOKvTGkXG
k6m3enm58Nxuw8QVeagzuAtCsf0pP8MvADlSQITvL2JoN18TVBkvQYICR56Gkcif185h4RsREvO4
DVNf+aHzi7uNHNVpZktV09Io7UOVtNduB6Ph9iOGYYdLqZcavTyDQNywXjuZiQitCUjEnaEeYSfe
W0eh7oO9EwRFTtc9zJtrLDe2eYFTyfrwEi2bKGHWlfLEnckq0/choVszZFycrrWTn3Z6a/yBvPci
hbEQO0nLi+WeKdm92FIJsDQybMYXTxCG5WiC/IdHOaatStmGG2EwhApRaJjdoBcWywCztmVFzdwD
IDGtWJREeTZRS7ubT2jWuN2NJ5fBWxz1PNkTYjihtXDp3DqBViV1iWBc5XDOMItjwvrfjQ2CTn1k
QQtqLvBgxfHKtWhXc6t0rOskynav+lhLM5sJYcGBB4vNhcRXCIY6Gq1LaA08au4zWcZdNYD2XAAb
zx3S2y1MSmUrZXg3e2f+LYnCic88TUYGI4k2oOZnDn4DFWP5ngFyzDIBMBR2aFBCp04x2cfz4Ie9
ul3H8BVQHyX48qpTGPecsKP1rC/R3fhZm9rCGLXpSKfRsWl61Y5rcmhmsYkcfPZAl32k+WDovTlH
HqbOw6VBFieN/xRUzXins3HSf1tKLivMEyZFGuIz8J4Rq3AmTaSoez+IaZ4aE5WYmMxNChx7HIUO
Ao9LZsXe8hBwrkJ+81D7wg1Q6W38cjtxTE9wKGJVy5f4xCB6QvrACTPeSFUCzGsfXBi527OGdGLq
JzpeCUzEjYoKYoxihtknm4LtVwDF9OonsrpixS/UJA1h1lfe8Q0krhNAL92h72Ckx+zVfUs2TQBE
+NWi+TKrI6seQLiVeTyae/qidPit/pxh+GreKL2nVCrp2P39KOV6tDossUP9sLUH9Z4AQMS4VV5P
dUVDajFN1z3CxfFBttF/QSttwmpDWwPz/ROAHN8d7Y4KRHhRuXjH78WLDnqmHN5Fq0+u8GKgxYgx
wJWaEhBf+BVQDqoFTcKfm0G/SeaLpNHSZN/S+vuDNIOi78BgnYq/ytSWU+E9TQXaE0pxedhYVoFM
lK6GXJYecqvhdwRxxQHvZQAb46NOeRYW1Ug5pObUxPD4Mq74Vt4c5XaPPFmmYi8CUZEfsTXOhWgW
y9c4DtmugZE+v4U9zauXSdWXxg73X7z37iuOBw1g6hHSTCgmUy+dWGMvLH6yCesoOccNPbD9lmTW
VC60zsQsgC890+XVaGAthqhsEHZ4bL4mTsncao12pWCXdADTm7WdouBYP7iZt5RSLCJg6aEyhOiD
5Ws9OKzUH5UxvQh2GuVjR6CEZeCJxYBugdj2vWt96+N9Pee7Fedih40D2tDeqVpcisJyMYSoSY15
YDT+1IO68ghIZGbyINJWlCylmjMjM/ozxjDVlx0tLdqEN8Txw4RbzyAfiiv72gJt133WsDiZn+Zk
tGcC37gRH8Yna1IJG07N+nWXWk34gJDV4y0+ESSHsoQI+faJQUSUxCT3SBkbri30W4N27dIekgWs
CYraf4Oc1O9hSAr9ZJJQY8NqLxy1qQKcabsvdGL6PZJmgykfg0L22g3zMeHl62xwvYH3SmkfSgT5
4NPbVd7UDhu78XoSsLLiCf4QNvAgBN5Zq4HbddwjmpNJ8Zc4qXPGZ6eYWGs/ycTU/pyLH/XVC5TF
OlOOVx3kXunI9GHr3Rfa4t6ap6yxcuGDmmpZ7a0Xk0w2lcyEtmVHo/k/gk5YdX/yQ/QdfRtDhacC
/JTdfOOiy9DUpD8k+SKsp6Pu9WONTU55I/lEF/BpTSbOuHQuB5zP8NNivXMtnpJWpzPBO5A88gFx
j9n1L1yxD7sSrrmbmr77vmrtPy41LweYzjMbDMiIyhj4qdsY4T2s3UtNXEGq4TMNM4k7Nr4/6kPk
PqrhgOR0t7k9JpR5FzaLlXLN8g7Qi5ZptDFwPOxRYCyrZXxxGjnAJirFdJUSbqq/uBhFDbzVt01K
X3tuDgHMlNI331BIWUHW+QFhrsN/ijTHfjECHWFJ0MDmavuYe822CZxrZ989IICh5EiVnVKVYPMf
Mpvllzl59bIkKYKSSPTX8YIpWBTGdCZPWb5S2iXVC4MsQtIVDt15fKOg+1GIVlRmAi85WxuYM53b
EL8tdKhYmEdu/gHbInfdP+cZDO5R53VMmHDwrg/A4mntvUdNDsfuU/V7rmrd54cYwfJkYofAlSKE
+IeDQc3WKk2LxTm3R7tXNbYnBA1gLrafNmWu13WlaKxFi48e5Dnh5V4vHkWWLTeMUw0Ux0EaSy+c
AwOjBRMlo2hxT6ApCpIY9EZFyrsM9icQZylVlSyA4ALZTLNeIg41SKozQE6P/4z67oGUUMBSK1f6
vDWf0EoXrd7bXsbpvpx5q/6u557Lc7AN6icFeMoVjcxQwWKAAXKmeVbqqNmHnG3WjP+idDtCenqD
CqCgi8KzO4mNTquKFMGzHwECjWhgZtdSkyK/V+EKDeiD6ceYpCBqI9AEZcJ+krXcQvkYWtE/qmr+
U+2iflIL8hQjiAVwiQW1uHQqxoPsntJTtXHlWTTaiAnIBd5buIR5/akKGEVcC3R0A2FqAAtPS9YG
RpDIZRm9cA15AwzIv3TaP4GQU/KQWZihIRAHt7K6ULDpdGh3bXUfdsOuMkI4QBKIvtNhqxG/he67
5JuON34DrwczElA9FYornilgx92qSCfUpp6/cok0tQ84w8tGsHH00zwd9I+kJgJ1zVLmn6SX23zU
MPkv9C+D3ztU1hOc/gysWtQiQrIIwECFnNpE4Y1sfS8JcRvopW189IPdE+ZJgYE2S1ywh/ReJZ1y
Nlh6txCcTijcvx5/bqQvxAL7A24e5kw9nHh92PVbxvmo5Ad+zQv/D78WitvZjarTYXF9kU3xYUsv
gp/0cEPMZzlK6DTNycJIEvXVUiDTPSIl25gNR1YWJVMlXwaRnNFbQ7Vp3yWaApZ/X2Izq1150Gtf
Pf5lCPxeOI+LAiWmql8ZzkUL2e1nE4PKooruBzY6jTDtFRUtb4y8KHRBN8kKpDSGKojVss8wCH/h
AhOZv1l++Ad2Qwem5RLGIwiMfpkzsNFS5614Oa0fpyFB6yJIJ8u169DmjiJtV7C8rFFNjjeOrSgk
6fDpb2gYFRn6Uj2js1ZNY9wi+Xik0jj+1wLm71QdAi/nRl4UJQ0C/Ib6ZLCvEm25aLJjVYanaJ52
mPyah8nS/ohRjbsGT3Fy9JBrjWFso2MpRytIglqp9u7HzrC4rHcIsWFGMCzcW+XaT+ByEwblR3yo
0DlGdZuY+gWw5TqxmGsJ4etI22FwxRS2HF0vyr2sJLJ0yDfL1aiXZSltsOK3uLvBjRlkmsOuNkKX
NREQfYk3NQOp0dW/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: `humhub1173`
--
-- --------------------------------------------------------
--
-- Table structure for table `activity`
--
CREATE TABLE `activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`class` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`module` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`object_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10 ;
--
-- Dumping data for table `activity`
--
INSERT INTO `activity` VALUES
(1, 'humhub\\modules\\space\\activities\\Created', 'space', 'humhub\\modules\\space\\models\\Space', 1),
(2, 'humhub\\modules\\content\\activities\\ContentCreated', 'content', 'humhub\\modules\\post\\models\\Post', 1),
(3, 'humhub\\modules\\space\\activities\\MemberAdded', 'space', 'humhub\\modules\\space\\models\\Space', 1),
(4, 'humhub\\modules\\space\\activities\\MemberAdded', 'space', 'humhub\\modules\\space\\models\\Space', 1),
(5, 'humhub\\modules\\content\\activities\\ContentCreated', 'content', 'humhub\\modules\\post\\models\\Post', 2),
(6, 'humhub\\modules\\comment\\activities\\NewComment', 'comment', 'humhub\\modules\\comment\\models\\Comment', 1),
(7, 'humhub\\modules\\comment\\activities\\NewComment', 'comment', 'humhub\\modules\\comment\\models\\Comment', 2),
(8, 'humhub\\modules\\like\\activities\\Liked', 'like', 'humhub\\modules\\like\\models\\Like', 1),
(9, 'humhub\\modules\\like\\activities\\Liked', 'like', 'humhub\\modules\\like\\models\\Like', 2);
-- --------------------------------------------------------
--
-- Table structure for table `comment`
--
CREATE TABLE `comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` mediumtext COLLATE utf8mb4_unicode_ci,
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` int(11) NOT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_comment-created_by` (`created_by`),
KEY `idx_comment_target` (`object_id`,`object_model`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `comment`
--
INSERT INTO `comment` VALUES
(1, 'Nike – Just buy it. :wink:', 'humhub\\modules\\post\\models\\Post', 2, '[[regtime]]', 2, '[[regtime]]', 2),
(2, 'Calvin Klein – Between love and madness lies obsession.', 'humhub\\modules\\post\\models\\Post', 2, '[[regtime]]', 3, '[[regtime]]', 3);
-- --------------------------------------------------------
--
-- Table structure for table `content`
--
CREATE TABLE `content` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` int(11) NOT NULL,
`contentcontainer_id` int(11) DEFAULT NULL,
`stream_channel` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT 'default',
`stream_sort_date` datetime DEFAULT NULL,
`visibility` tinyint(3) NOT NULL DEFAULT '0',
`state` tinyint(3) NOT NULL DEFAULT '1',
`was_published` tinyint(1) NOT NULL DEFAULT '0',
`pinned` tinyint(1) NOT NULL DEFAULT '0',
`archived` tinyint(1) NOT NULL DEFAULT '0',
`hidden` tinyint(1) NOT NULL DEFAULT '0',
`locked_comments` tinyint(1) NOT NULL DEFAULT '0',
`scheduled_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_object_model` (`object_model`,`object_id`),
UNIQUE KEY `index_guid` (`guid`),
KEY `fk-contentcontainer` (`contentcontainer_id`),
KEY `fk-create-user` (`created_by`),
KEY `fk-update-user` (`updated_by`),
KEY `stream_channe` (`stream_channel`),
KEY `idx_stream_created` (`created_at`),
KEY `idx_stream_updated` (`stream_sort_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;
--
-- Dumping data for table `content`
--
INSERT INTO `content` VALUES
(1, '35ae1342-5707-4636-adc5-710be324f2aa', 'humhub\\modules\\activity\\models\\Activity', 1, 2, 'activity', '[[regtime]]', 1, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 1, '[[regtime]]', 1),
(2, 'de2c3b2e-3164-4581-8bb9-fb9b5f0fb031', 'humhub\\modules\\post\\models\\Post', 1, 2, 'default', '[[regtime]]', 1, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 1, '[[regtime]]', 1),
(3, '2754a370-0d10-4a05-babd-9964cfe744cc', 'humhub\\modules\\activity\\models\\Activity', 2, 2, 'activity', '[[regtime]]', 1, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 1, '[[regtime]]', 1),
(4, '03822896-84ae-477d-a8f9-605c3fd54d15', 'humhub\\modules\\activity\\models\\Activity', 3, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 2, '[[regtime]]', 1),
(5, 'a7e9c2e3-9b70-48f9-a592-163b28d6b6a1', 'humhub\\modules\\activity\\models\\Activity', 4, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 3, '[[regtime]]', 1),
(6, 'a8745d12-c7c9-43e2-90a1-9ab4242956d0', 'humhub\\modules\\post\\models\\Post', 2, 2, 'default', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 1, '[[regtime]]', 1),
(7, 'ab8b1ce3-0516-4ebc-89d8-ac3210d326cb', 'humhub\\modules\\activity\\models\\Activity', 5, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 1, '[[regtime]]', 1),
(8, 'e7045768-6089-4c42-90cc-b985540e9955', 'humhub\\modules\\activity\\models\\Activity', 6, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 2, '[[regtime]]', 2),
(9, '4382f900-fdb2-48a9-b9f9-f88d51db1166', 'humhub\\modules\\activity\\models\\Activity', 7, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 3, '[[regtime]]', 3),
(10, '79ce744a-c83a-4fe6-a635-dd362e6382cf', 'humhub\\modules\\activity\\models\\Activity', 8, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 3, '[[regtime]]', 3),
(11, '70ea5cfb-ba22-4c6f-9876-295621e31d36', 'humhub\\modules\\activity\\models\\Activity', 9, 2, 'activity', '[[regtime]]', 0, 1, 0, 0, 0, 0, 0, NULL, '[[regtime]]', 3, '[[regtime]]', 3);
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer`
--
CREATE TABLE `contentcontainer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
`class` char(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`pk` int(11) DEFAULT NULL,
`owner_user_id` int(11) DEFAULT NULL,
`tags_cached` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_guid` (`guid`),
UNIQUE KEY `unique_target` (`class`,`pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `contentcontainer`
--
INSERT INTO `contentcontainer` VALUES
(1, '0e924595-5407-4334-8d68-3bed72ba4af7', 'humhub\\modules\\user\\models\\User', 1, 1, 'Administration, Support, HumHub'),
(2, '8b514ad0-e6b1-490c-b59a-c9dcd2a06923', 'humhub\\modules\\space\\models\\Space', 1, 1, NULL),
(3, '3cb86e35-d937-452c-9145-119368d1114d', 'humhub\\modules\\user\\models\\User', 2, 2, 'Microsoft Office, Marketing, SEM, Digital Native'),
(4, 'e037f862-5df2-43b7-a47f-d1610f231b82', 'humhub\\modules\\user\\models\\User', 3, 3, 'Yoga, Travel, English, German, French');
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_blocked_users`
--
CREATE TABLE `contentcontainer_blocked_users` (
`contentcontainer_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`contentcontainer_id`,`user_id`),
KEY `fk-contentcontainer-blocked-users-rel-user-id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_default_permission`
--
CREATE TABLE `contentcontainer_default_permission` (
`permission_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`contentcontainer_class` char(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`group_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`module_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`permission_id`,`group_id`,`module_id`,`contentcontainer_class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_module`
--
CREATE TABLE `contentcontainer_module` (
`contentcontainer_id` int(11) NOT NULL,
`module_id` char(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`module_state` smallint(6) DEFAULT NULL,
PRIMARY KEY (`contentcontainer_id`,`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_permission`
--
CREATE TABLE `contentcontainer_permission` (
`permission_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`contentcontainer_id` int(11) NOT NULL,
`group_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`module_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`permission_id`,`group_id`,`module_id`,`contentcontainer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_setting`
--
CREATE TABLE `contentcontainer_setting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`contentcontainer_id` int(11) NOT NULL,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `settings-unique` (`module_id`,`contentcontainer_id`,`name`),
KEY `fk-contentcontainerx` (`contentcontainer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_tag`
--
CREATE TABLE `contentcontainer_tag` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`contentcontainer_class` char(60) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique-contentcontainer-tag` (`contentcontainer_class`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=13 ;
--
-- Dumping data for table `contentcontainer_tag`
--
INSERT INTO `contentcontainer_tag` VALUES
(1, 'Administration', 'humhub\\modules\\user\\models\\User'),
(7, 'Digital Native', 'humhub\\modules\\user\\models\\User'),
(10, 'English', 'humhub\\modules\\user\\models\\User'),
(12, 'French', 'humhub\\modules\\user\\models\\User'),
(11, 'German', 'humhub\\modules\\user\\models\\User'),
(3, 'HumHub', 'humhub\\modules\\user\\models\\User'),
(5, 'Marketing', 'humhub\\modules\\user\\models\\User'),
(4, 'Microsoft Office', 'humhub\\modules\\user\\models\\User'),
(6, 'SEM', 'humhub\\modules\\user\\models\\User'),
(2, 'Support', 'humhub\\modules\\user\\models\\User'),
(9, 'Travel', 'humhub\\modules\\user\\models\\User'),
(8, 'Yoga', 'humhub\\modules\\user\\models\\User');
-- --------------------------------------------------------
--
-- Table structure for table `contentcontainer_tag_relation`
--
CREATE TABLE `contentcontainer_tag_relation` (
`contentcontainer_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
PRIMARY KEY (`contentcontainer_id`,`tag_id`),
KEY `fk-contentcontainer-tag-rel-tag-id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `contentcontainer_tag_relation`
--
INSERT INTO `contentcontainer_tag_relation` VALUES
(1, 1),
(1, 2),
(1, 3),
(3, 4),
(3, 5),
(3, 6),
(3, 7),
(4, 8),
(4, 9),
(4, 10),
(4, 11),
(4, 12);
-- --------------------------------------------------------
--
-- Table structure for table `content_fulltext`
--
CREATE TABLE `content_fulltext` (
`content_id` int(11) DEFAULT NULL,
`contents` text COLLATE utf8mb4_unicode_ci,
`comments` text COLLATE utf8mb4_unicode_ci,
`files` text COLLATE utf8mb4_unicode_ci,
KEY `fk_content_fulltext` (`content_id`),
FULLTEXT KEY `ftx` (`contents`,`comments`,`files`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `content_fulltext`
--
INSERT INTO `content_fulltext` VALUES
(6, '6 \nWe''re looking for great slogans of famous brands. Maybe you can come up with some samples? \n', '\n\nNike – Just buy it. :wink:\n\n\n\nCalvin Klein – Between love and madness lies obsession.\n\n \n', ' \n');
-- --------------------------------------------------------
--
-- Table structure for table `content_tag`
--
CREATE TABLE `content_tag` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`module_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`contentcontainer_id` int(11) DEFAULT NULL,
`type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`color` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sort_order` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx-content-tag` (`module_id`,`contentcontainer_id`,`name`),
KEY `fk-content-tag-container-id` (`contentcontainer_id`),
KEY `fk-content-tag-parent-id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `content_tag_relation`
--
CREATE TABLE `content_tag_relation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content_id` int(11) NOT NULL,
`tag_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk-content-tag-rel-content-id` (`content_id`),
KEY `fk-content-tag-rel-tag-id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `file`
--
CREATE TABLE `file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` tinyint(3) NOT NULL DEFAULT '1',
`category` int(11) unsigned NOT NULL DEFAULT '0',
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`object_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`sort_order` int(11) NOT NULL DEFAULT '100',
`content_id` int(11) unsigned DEFAULT NULL,
`file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mime_type` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`size` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`metadata` varchar(4000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`show_in_stream` tinyint(1) DEFAULT '1',
`hash_sha1` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ux-file-guid` (`guid`),
KEY `fk_file-created_by` (`created_by`),
KEY `ix-file-object` (`object_model`,`object_id`,`sort_order`),
KEY `ix-file-category` (`category`,`object_model`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `file_history`
--
CREATE TABLE `file_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file_id` int(11) NOT NULL,
`size` bigint(20) NOT NULL,
`hash_sha1` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_file_history` (`file_id`),
KEY `fk_file_history_user` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `group`
--
CREATE TABLE `group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` mediumtext COLLATE utf8mb4_unicode_ci,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`ldap_dn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_admin_group` tinyint(1) NOT NULL DEFAULT '0',
`is_default_group` tinyint(1) NOT NULL DEFAULT '0',
`is_protected` tinyint(1) NOT NULL DEFAULT '0',
`show_at_registration` tinyint(1) NOT NULL DEFAULT '1',
`show_at_directory` tinyint(1) NOT NULL DEFAULT '1',
`sort_order` int(11) NOT NULL DEFAULT '100',
`notify_users` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `group`
--
INSERT INTO `group` VALUES
(1, 'Administrators', 'Default group for administrators of this HumHub Installation', '[[regtime]]', NULL, NULL, NULL, NULL, 1, 0, 0, 0, 0, 100, 0),
(2, 'Users', 'Default group for all newly registered users of the network', '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, 0, 1, 0, 1, 0, 100, 0);
-- --------------------------------------------------------
--
-- Table structure for table `group_permission`
--
CREATE TABLE `group_permission` (
`permission_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`group_id` int(11) NOT NULL,
`module_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`permission_id`,`group_id`,`module_id`),
KEY `fk_group_permission-group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `group_space`
--
CREATE TABLE `group_space` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`space_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx-group_space` (`space_id`,`group_id`),
KEY `fk-group_space-group` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `group_user`
--
CREATE TABLE `group_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`is_group_manager` tinyint(1) NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx-group_user` (`user_id`,`group_id`),
KEY `fk-group-group` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `group_user`
--
INSERT INTO `group_user` VALUES
(1, 1, 2, 0, '[[regtime]]', NULL, '[[regtime]]', NULL),
(2, 1, 1, 0, '[[regtime]]', NULL, '[[regtime]]', NULL),
(3, 2, 2, 0, '[[regtime]]', 1, '[[regtime]]', 1),
(4, 3, 2, 0, '[[regtime]]', 1, '[[regtime]]', 1);
-- --------------------------------------------------------
--
-- Table structure for table `like`
--
CREATE TABLE `like` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`target_user_id` int(11) DEFAULT NULL,
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` int(11) NOT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique-object-user` (`object_model`,`object_id`,`created_by`),
KEY `index_object` (`object_model`,`object_id`),
KEY `fk_like-created_by` (`created_by`),
KEY `fk_like-target_user_id` (`target_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `like`
--
INSERT INTO `like` VALUES
(1, NULL, 'humhub\\modules\\comment\\models\\Comment', 1, '[[regtime]]', 3, '[[regtime]]', 3),
(2, NULL, 'humhub\\modules\\post\\models\\Post', 2, '[[regtime]]', 3, '[[regtime]]', 3);
-- --------------------------------------------------------
--
-- Table structure for table `live`
--
CREATE TABLE `live` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`contentcontainer_id` int(11) DEFAULT NULL,
`visibility` int(1) DEFAULT NULL,
`serialized_data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `contentcontainer` (`contentcontainer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=20 ;
--
-- Dumping data for table `live`
--
INSERT INTO `live` VALUES
(1, 2, 1, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:1;s:9:"contentId";i:1;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"0e924595-5407-4334-8d68-3bed72ba4af7";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:1;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(2, 2, 1, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:1;s:9:"contentId";i:3;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"0e924595-5407-4334-8d68-3bed72ba4af7";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:2;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(3, 2, 1, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:1;s:9:"contentId";i:2;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"0e924595-5407-4334-8d68-3bed72ba4af7";s:11:"sourceClass";s:31:"humhub\\modules\\post\\models\\Post";s:8:"sourceId";i:1;s:6:"silent";b:0;s:13:"streamChannel";s:7:"default";s:6:"insert";b:1;}', [[timestamp]]),
(4, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:4;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"3cb86e35-d937-452c-9145-119368d1114d";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:3;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(5, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:5;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"e037f862-5df2-43b7-a47f-d1610f231b82";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:4;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(6, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:7;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"0e924595-5407-4334-8d68-3bed72ba4af7";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:5;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(7, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:6;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"0e924595-5407-4334-8d68-3bed72ba4af7";s:11:"sourceClass";s:31:"humhub\\modules\\post\\models\\Post";s:8:"sourceId";i:2;s:6:"silent";b:0;s:13:"streamChannel";s:7:"default";s:6:"insert";b:1;}', [[timestamp]]),
(8, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:8;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"3cb86e35-d937-452c-9145-119368d1114d";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:6;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(9, 1, 0, 'O:38:"humhub\\modules\\comment\\live\\NewComment":4:{s:18:"contentContainerId";i:1;s:10:"visibility";i:0;s:9:"commentId";i:1;s:9:"contentId";i:6;}', [[timestamp]]),
(10, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:9;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"e037f862-5df2-43b7-a47f-d1610f231b82";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:7;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(11, 1, 0, 'O:38:"humhub\\modules\\comment\\live\\NewComment":4:{s:18:"contentContainerId";i:1;s:10:"visibility";i:0;s:9:"commentId";i:2;s:9:"contentId";i:6;}', [[timestamp]]),
(12, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:10;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"e037f862-5df2-43b7-a47f-d1610f231b82";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:8;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(13, 2, 0, 'O:38:"humhub\\modules\\content\\live\\NewContent":11:{s:18:"contentContainerId";i:2;s:10:"visibility";i:0;s:9:"contentId";i:11;s:5:"sguid";s:36:"8b514ad0-e6b1-490c-b59a-c9dcd2a06923";s:5:"uguid";N;s:10:"originator";s:36:"e037f862-5df2-43b7-a47f-d1610f231b82";s:11:"sourceClass";s:39:"humhub\\modules\\activity\\models\\Activity";s:8:"sourceId";i:9;s:6:"silent";b:1;s:13:"streamChannel";s:8:"activity";s:6:"insert";b:1;}', [[timestamp]]),
(14, 1, 2, 'O:48:"humhub\\modules\\notification\\live\\NewNotification":6:{s:18:"contentContainerId";i:1;s:10:"visibility";i:2;s:14:"notificationId";i:1;s:17:"notificationGroup";s:81:"humhub\\modules\\comment\\notifications\\NewComment:humhub\\modules\\post\\models\\Post-2";s:4:"text";s:94:"David Roberts commented post "We''re looking for great slogans of famous brands. Maybe you...".";s:2:"ts";i:[[timestamp]];}', [[timestamp]]),
(15, 4, 2, 'O:48:"humhub\\modules\\notification\\live\\NewNotification":6:{s:18:"contentContainerId";i:4;s:10:"visibility";i:2;s:14:"notificationId";i:2;s:17:"notificationGroup";s:81:"humhub\\modules\\comment\\notifications\\NewComment:humhub\\modules\\post\\models\\Post-2";s:4:"text";s:94:"David Roberts commented post "We''re looking for great slogans of famous brands. Maybe you...".";s:2:"ts";i:[[timestamp]];}', [[timestamp]]),
(16, 1, 2, 'O:48:"humhub\\modules\\notification\\live\\NewNotification":6:{s:18:"contentContainerId";i:1;s:10:"visibility";i:2;s:14:"notificationId";i:3;s:17:"notificationGroup";s:81:"humhub\\modules\\comment\\notifications\\NewComment:humhub\\modules\\post\\models\\Post-2";s:4:"text";s:94:"Sara Schuster commented post "We''re looking for great slogans of famous brands. Maybe you...".";s:2:"ts";i:[[timestamp]];}', [[timestamp]]),
(17, 3, 2, 'O:48:"humhub\\modules\\notification\\live\\NewNotification":6:{s:18:"contentContainerId";i:3;s:10:"visibility";i:2;s:14:"notificationId";i:4;s:17:"notificationGroup";s:81:"humhub\\modules\\comment\\notifications\\NewComment:humhub\\modules\\post\\models\\Post-2";s:4:"text";s:94:"Sara Schuster commented post "We''re looking for great slogans of famous brands. Maybe you...".";s:2:"ts";i:[[timestamp]];}', [[timestamp]]),
(18, 3, 2, 'O:48:"humhub\\modules\\notification\\live\\NewNotification":6:{s:18:"contentContainerId";i:3;s:10:"visibility";i:2;s:14:"notificationId";i:5;s:17:"notificationGroup";s:81:"humhub\\modules\\like\\notifications\\NewLike:humhub\\modules\\comment\\models\\Comment-1";s:4:"text";s:57:"Sara Schuster likes comment "Nike – Just buy it. ?".";s:2:"ts";i:[[timestamp]];}', [[timestamp]]),
(19, 1, 2, 'O:48:"humhub\\modules\\notification\\live\\NewNotification":6:{s:18:"contentContainerId";i:1;s:10:"visibility";i:2;s:14:"notificationId";i:6;s:17:"notificationGroup";s:75:"humhub\\modules\\like\\notifications\\NewLike:humhub\\modules\\post\\models\\Post-2";s:4:"text";s:90:"Sara Schuster likes post "We''re looking for great slogans of famous brands. Maybe you...".";s:2:"ts";i:[[timestamp]];}', [[timestamp]]);
-- --------------------------------------------------------
--
-- Table structure for table `log`
--
CREATE TABLE `log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`level` int(11) DEFAULT NULL,
`category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`log_time` double DEFAULT NULL,
`prefix` mediumtext COLLATE utf8mb4_unicode_ci,
`message` mediumtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `idx_log_level` (`level`),
KEY `idx_log_category` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `logging`
--
CREATE TABLE `logging` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`category` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`logtime` int(11) DEFAULT NULL,
`message` mediumtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `migration`
--
CREATE TABLE `migration` (
`version` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
`apply_time` int(11) DEFAULT NULL,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `migration`
--
INSERT INTO `migration` VALUES
('m000000_000000_base', [[timestamp]]),
('m131023_164513_initial', [[timestamp]]),
('m131023_165411_initial', [[timestamp]]),
('m131023_165625_initial', [[timestamp]]),
('m131023_165755_initial', [[timestamp]]),
('m131023_165835_initial', [[timestamp]]),
('m131023_170033_initial', [[timestamp]]),
('m131023_170135_initial', [[timestamp]]),
('m131023_170159_initial', [[timestamp]]),
('m131023_170253_initial', [[timestamp]]),
('m131023_170339_initial', [[timestamp]]),
('m131203_110444_oembed', [[timestamp]]),
('m131213_165552_user_optimize', [[timestamp]]),
('m140226_111945_ldap', [[timestamp]]),
('m140303_125031_password', [[timestamp]]),
('m140304_142711_memberautoadd', [[timestamp]]),
('m140321_000917_content', [[timestamp]]),
('m140324_170617_membership', [[timestamp]]),
('m140507_150421_create_settings_table', [[timestamp]]),
('m140507_171527_create_settings_table', [[timestamp]]),
('m140512_141414_i18n_profilefields', [[timestamp]]),
('m140513_180317_createlogging', [[timestamp]]),
('m140701_000611_profile_genderfield', [[timestamp]]),
('m140701_074404_protect_default_profilefields', [[timestamp]]),
('m140702_143912_notify_notification_unify', [[timestamp]]),
('m140703_104527_profile_birthdayfield', [[timestamp]]),
('m140704_080659_installationid', [[timestamp]]),
('m140705_065525_emailing_settings', [[timestamp]]),
('m140706_135210_lastlogin', [[timestamp]]),
('m140829_122906_delete', [[timestamp]]),
('m140830_145504_following', [[timestamp]]),
('m140901_080147_indizies', [[timestamp]]),
('m140901_080432_indices', [[timestamp]]),
('m140901_112246_addState', [[timestamp]]),
('m140901_153403_addState', [[timestamp]]),
('m140901_170329_group_create_space', [[timestamp]]),
('m140902_091234_session_key_length', [[timestamp]]),
('m140907_140822_zip_field_to_text', [[timestamp]]),
('m140930_205511_fix_default', [[timestamp]]),
('m140930_205859_fix_default', [[timestamp]]),
('m140930_210142_fix_default', [[timestamp]]),
('m140930_210635_fix_default', [[timestamp]]),
('m140930_212528_fix_default', [[timestamp]]),
('m141015_173305_follow_notifications', [[timestamp]]),
('m141019_093319_mentioning', [[timestamp]]),
('m141020_162639_fix_default', [[timestamp]]),
('m141020_193920_rm_alsocreated', [[timestamp]]),
('m141020_193931_rm_alsoliked', [[timestamp]]),
('m141021_162639_oembed_setting', [[timestamp]]),
('m141022_094635_addDefaults', [[timestamp]]),
('m141106_185632_log_init', [[timestamp]]),
('m150204_103433_html5_notified', [[timestamp]]),
('m150210_190006_user_invite_lang', [[timestamp]]),
('m150302_114347_add_visibility', [[timestamp]]),
('m150322_194403_remove_type_field', [[timestamp]]),
('m150322_195619_allowedExt2Text', [[timestamp]]),
('m150429_223856_optimize', [[timestamp]]),
('m150629_220311_change', [[timestamp]]),
('m150703_012735_typelength', [[timestamp]]),
('m150703_024635_activityTypes', [[timestamp]]),
('m150703_033650_namespace', [[timestamp]]),
('m150703_130157_migrate', [[timestamp]]),
('m150704_005338_namespace', [[timestamp]]),
('m150704_005418_namespace', [[timestamp]]),
('m150704_005434_namespace', [[timestamp]]),
('m150704_005452_namespace', [[timestamp]]),
('m150704_005504_namespace', [[timestamp]]),
('m150713_054441_timezone', [[timestamp]]),
('m150714_093525_activity', [[timestamp]]),
('m150714_100355_cleanup', [[timestamp]]),
('m150831_061628_notifications', [[timestamp]]),
('m150910_223305_fix_user_follow', [[timestamp]]),
('m150924_133344_update_notification_fix', [[timestamp]]),
('m150924_154635_user_invite_add_first_lastname', [[timestamp]]),
('m150927_190830_create_contentcontainer', [[timestamp]]),
('m150928_103711_permissions', [[timestamp]]),
('m150928_134934_groups', [[timestamp]]),
('m150928_140718_setColorVariables', [[timestamp]]),
('m151010_124437_group_permissions', [[timestamp]]),
('m151010_175000_default_visibility', [[timestamp]]),
('m151013_223814_include_dashboard', [[timestamp]]),
('m151022_131128_module_fix', [[timestamp]]),
('m151106_090948_addColor', [[timestamp]]),
('m151223_171310_fix_notifications', [[timestamp]]),
('m151226_164234_authclient', [[timestamp]]),
('m160125_053702_stored_filename', [[timestamp]]),
('m160205_203840_foreign_keys', [[timestamp]]),
('m160205_203913_foreign_keys', [[timestamp]]),
('m160205_203939_foreign_keys', [[timestamp]]),
('m160205_203955_foreign_keys', [[timestamp]]),
('m160205_204000_foreign_keys', [[timestamp]]),
('m160205_204010_foreign_keys', [[timestamp]]),
('m160205_205540_foreign_keys', [[timestamp]]),
('m160216_160119_initial', [[timestamp]]),
('m160217_161220_addCanLeaveFlag', [[timestamp]]),
('m160220_013525_contentcontainer_id', [[timestamp]]),
('m160221_222312_public_permission_change', [[timestamp]]),
('m160225_180229_remove_website', [[timestamp]]),
('m160227_073020_birthday_date', [[timestamp]]),
('m160229_162959_multiusergroups', [[timestamp]]),
('m160309_141222_longerUserName', [[timestamp]]),
('m160408_100725_rename_groupadmin_to_manager', [[timestamp]]),
('m160415_180332_wall_remove', [[timestamp]]),
('m160501_220850_activity_pk_int', [[timestamp]]),
('m160507_202611_settings', [[timestamp]]),
('m160508_005740_settings_cleanup', [[timestamp]]),
('m160509_214811_spaceurl', [[timestamp]]),
('m160517_132535_group', [[timestamp]]),
('m160523_105732_profile_searchable', [[timestamp]]),
('m160714_142827_remove_space_id', [[timestamp]]),
('m161031_161947_file_directories', [[timestamp]]),
('m170110_151419_membership_notifications', [[timestamp]]),
('m170110_152425_space_follow_reset_send_notification', [[timestamp]]),
('m170111_190400_disable_web_notifications', [[timestamp]]),
('m170112_115052_settings', [[timestamp]]),
('m170118_162332_streamchannel', [[timestamp]]),
('m170119_160740_initial', [[timestamp]]),
('m170123_125622_pinned', [[timestamp]]),
('m170211_105743_show_in_stream', [[timestamp]]),
('m170224_100937_fix_default_modules', [[timestamp]]),
('m170723_133337_content_tag', [[timestamp]]),
('m170723_133338_content_tag_sort_order', [[timestamp]]),
('m170805_211208_authclient_id', [[timestamp]]),
('m170810_220543_group_sort', [[timestamp]]),
('m171015_155102_contentcontainer_module', [[timestamp]]),
('m171025_142030_queue_update', [[timestamp]]),
('m171025_200312_utf8mb4_fixes', [[timestamp]]),
('m171027_220519_exclusive_jobs', [[timestamp]]),
('m180305_084435_membership_pk', [[timestamp]]),
('m180315_112748_fix_email_length', [[timestamp]]),
('m181029_160453_collation', [[timestamp]]),
('m190211_133045_channel_length', [[timestamp]]),
('m190309_201944_rename_settings', [[timestamp]]),
('m190920_142605_fix_language_codes', [[timestamp]]),
('m200217_122108_profile_translation_fix', [[timestamp]]),
('m200218_122109_profile_translation_fix2', [[timestamp]]),
('m200323_162006_fix_visibility', [[timestamp]]),
('m200604_204445_remove_post_field', [[timestamp]]),
('m200715_171721_defaultOption', [[timestamp]]),
('m200715_184207_commentIndex', [[timestamp]]),
('m200729_080349_commentIndex_fix_order', [[timestamp]]),
('m200930_151639_add_about', [[timestamp]]),
('m201020_130431_fix_default_file_setting_value', [[timestamp]]),
('m201025_095247_spaces_of_users_group', [[timestamp]]),
('m201115_083832_add_notify_users_to_group', [[timestamp]]),
('m201130_073907_default_permissions', [[timestamp]]),
('m201130_073908_disable_legacy_richtextparser', [[timestamp]]),
('m201217_081828_fix_oembed_setting', [[timestamp]]),
('m201228_064513_default_group', [[timestamp]]),
('m210111_105355_hash', [[timestamp]]),
('m210203_122333_profilePermissions', [[timestamp]]),
('m210204_054203_fix_settings_unique_index', [[timestamp]]),
('m210211_051243_container_tag', [[timestamp]]),
('m210217_055359_protected_group', [[timestamp]]),
('m210310_103412_fix_hash', [[timestamp]]),
('m210331_115144_default_timezone', [[timestamp]]),
('m210506_060737_profile_field_directory_filter', [[timestamp]]),
('m210721_055137_content_locked_comments', [[timestamp]]),
('m210727_102150_follow_friend', [[timestamp]]),
('m210924_114847_container_blocked_users', [[timestamp]]),
('m210928_162609_stream_sort_idx', [[timestamp]]),
('m211022_152413_file_history', [[timestamp]]),
('m211124_180441_admin_group_label', [[timestamp]]),
('m220121_193617_oembed_setting_update', [[timestamp]]),
('m220207_183901_add_payload_column_to_notification_table', [[timestamp]]),
('m220302_135158_add_content_id', [[timestamp]]),
('m220606_205507_mailer_settings', [[timestamp]]),
('m220608_125539_displaysubformat', [[timestamp]]),
('m220919_104234_auth_key', [[timestamp]]),
('m221111_100450_rename_profile_url', [[timestamp]]),
('m221117_214310_rename_setting', [[timestamp]]),
('m230127_195245_content_state', [[timestamp]]),
('m230130_140944_rename_auth_invite_setting', [[timestamp]]),
('m230217_112400_content_scheduled_at', [[timestamp]]),
('m230217_175411_content_hidden', [[timestamp]]),
('m230419_102455_add_sort_order_column_to_space_table', [[timestamp]]),
('m230618_135508_file_add_sorting_column', [[timestamp]]),
('m230618_135509_file_add_category_column', [[timestamp]]),
('m230618_135510_file_add_metadata_column', [[timestamp]]),
('m230618_135511_file_add_state_column', [[timestamp]]),
('m230618_135512_file_add_guid_unique_index', [[timestamp]]),
('m231024_062218_content_was_published', [[timestamp]]),
('m240203_112155_search', [[timestamp]]),
('m240419_095931_fix_user_profile_country_code', [[timestamp]]),
('m240422_162959_new_is_untouched_settings', [[timestamp]]),
('m240423_170311_profile_checkbox_list_field', [[timestamp]]),
('m240425_144905_unique_index', [[timestamp]]),
('m240523_081438_fix_null_password', [[timestamp]]),
('m240622_082606_fix_captcha_in_registration', [[timestamp]]),
('m240715_150726_fulltext_index', [[timestamp]]),
('m240807_230603_add_permissions_to_existing_user_groups', [[timestamp]]),
('m240916_150536_extend_language', [[timestamp]]),
('m241004_093044_server_timezone', [[timestamp]]),
('m241022_084028_delete_desktop_notified', [[timestamp]]),
('m250715_070647_group_name_length', [[timestamp]]);
-- --------------------------------------------------------
--
-- Table structure for table `module_enabled`
--
CREATE TABLE `module_enabled` (
`module_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `notification`
--
CREATE TABLE `notification` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`class` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`seen` tinyint(4) DEFAULT NULL,
`source_class` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`source_pk` int(11) DEFAULT NULL,
`space_id` int(11) DEFAULT NULL,
`emailed` tinyint(4) NOT NULL DEFAULT '0',
`created_at` datetime NOT NULL,
`originator_user_id` int(11) DEFAULT NULL,
`module` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
`group_key` varchar(75) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`send_web_notifications` tinyint(1) DEFAULT '1',
`payload` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `index_user_id` (`user_id`),
KEY `index_seen` (`seen`),
KEY `index_desktop_emailed` (`emailed`),
KEY `index_groupuser` (`user_id`,`class`,`group_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `notification`
--
INSERT INTO `notification` VALUES
(1, 'humhub\\modules\\comment\\notifications\\NewComment', 1, 0, 'humhub\\modules\\comment\\models\\Comment', 1, 1, 0, '[[regtime]]', 2, 'comment', 'humhub\\modules\\post\\models\\Post-2', 1, NULL),
(2, 'humhub\\modules\\comment\\notifications\\NewComment', 3, 0, 'humhub\\modules\\comment\\models\\Comment', 1, 1, 0, '[[regtime]]', 2, 'comment', 'humhub\\modules\\post\\models\\Post-2', 1, NULL),
(3, 'humhub\\modules\\comment\\notifications\\NewComment', 1, 0, 'humhub\\modules\\comment\\models\\Comment', 2, 1, 0, '[[regtime]]', 3, 'comment', 'humhub\\modules\\post\\models\\Post-2', 1, NULL),
(4, 'humhub\\modules\\comment\\notifications\\NewComment', 2, 0, 'humhub\\modules\\comment\\models\\Comment', 2, 1, 0, '[[regtime]]', 3, 'comment', 'humhub\\modules\\post\\models\\Post-2', 1, NULL),
(5, 'humhub\\modules\\like\\notifications\\NewLike', 2, 0, 'humhub\\modules\\like\\models\\Like', 1, 1, 0, '[[regtime]]', 3, 'like', 'humhub\\modules\\comment\\models\\Comment-1', 1, NULL),
(6, 'humhub\\modules\\like\\notifications\\NewLike', 1, 0, 'humhub\\modules\\like\\models\\Like', 2, 1, 0, '[[regtime]]', 3, 'like', 'humhub\\modules\\post\\models\\Post-2', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `post`
--
CREATE TABLE `post` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` mediumtext COLLATE utf8mb4_unicode_ci,
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `post`
--
INSERT INTO `post` VALUES
(1, 'Yay! I''ve just installed HumHub :sunglasses:', NULL, '[[regtime]]', 1, '[[regtime]]', 1),
(2, 'We''re looking for great slogans of famous brands. Maybe you can come up with some samples?', NULL, '[[regtime]]', 1, '[[regtime]]', 1);
-- --------------------------------------------------------
--
-- Table structure for table `profile`
--
CREATE TABLE `profile` (
`user_id` int(11) NOT NULL,
`firstname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`street` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`zip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`birthday_hide_year` int(1) DEFAULT NULL,
`birthday` date DEFAULT NULL,
`about` text COLLATE utf8mb4_unicode_ci,
`phone_private` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_work` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`im_xmpp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_xing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_vimeo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_tiktok` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url_mastodon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `profile`
--
INSERT INTO `profile` VALUES
(1, '[[admin_fname]]', '[[admin_lname]]', 'System Administration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'David', 'Roberts', 'Late riser', NULL, '2443 Queens Lane', '24574', 'Allwood', 'Virginia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Sara', 'Schuster', 'Do-gooder', NULL, 'Schmarjestrasse 51', '17095', 'Friedland', 'Niedersachsen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `profile_field`
--
CREATE TABLE `profile_field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`profile_field_category_id` int(11) NOT NULL,
`module_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`field_type_class` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`field_type_config` mediumtext COLLATE utf8mb4_unicode_ci,
`internal_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` mediumtext COLLATE utf8mb4_unicode_ci,
`sort_order` int(11) NOT NULL DEFAULT '100',
`required` tinyint(4) DEFAULT NULL,
`show_at_registration` tinyint(4) DEFAULT NULL,
`editable` tinyint(4) NOT NULL DEFAULT '1',
`visible` tinyint(4) NOT NULL DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`ldap_attribute` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`translation_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_system` int(1) DEFAULT NULL,
`searchable` tinyint(1) DEFAULT '1',
`directory_filter` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `index_profile_field_category` (`profile_field_category_id`),
KEY `index_directory_filter` (`directory_filter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=28 ;
--
-- Dumping data for table `profile_field`
--
INSERT INTO `profile_field` VALUES
(1, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":20,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'firstname', 'First name', NULL, 100, 1, 1, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, 'givenName', NULL, 1, 1, 0),
(2, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":30,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'lastname', 'Last name', NULL, 200, 1, 1, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, 'sn', NULL, 1, 1, 0),
(3, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":50,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'title', 'Title', NULL, 300, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, 'title', NULL, 1, 1, 0),
(4, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Select', '{"type":"dropdownlist","options":"male=>Male\\nfemale=>Female\\ndiverse=>Diverse","canBeDirectoryFilter":true,"fieldTypes":[],"isVirtual":false}', 'gender', 'Gender', NULL, 300, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(5, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":150,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'street', 'Street', NULL, 400, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(6, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":10,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'zip', 'Zip', NULL, 500, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(7, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":100,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'city', 'City', NULL, 600, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(8, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\CountrySelect', '{"type":"dropdownlist","options":null,"canBeDirectoryFilter":true,"fieldTypes":[],"isVirtual":false}', 'country', 'Country', NULL, 700, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(9, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":100,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'state', 'State', NULL, 800, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(10, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Birthday', '{"type":"datetime","defaultHideAge":"0","fieldTypes":[],"isVirtual":false,"canBeDirectoryFilter":false}', 'birthday', 'Birthday', NULL, 900, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(11, 1, NULL, 'humhub\\modules\\user\\models\\fieldtype\\TextArea', '{"type":"textarea","fieldTypes":[],"isVirtual":false,"canBeDirectoryFilter":false}', 'about', 'About', NULL, 900, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(12, 2, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":100,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'phone_private', 'Phone Private', NULL, 100, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(13, 2, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":100,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'phone_work', 'Phone Work', NULL, 200, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(14, 2, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":100,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'mobile', 'Mobile', NULL, 300, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(15, 2, NULL, 'humhub\\modules\\user\\models\\fieldtype\\UserEmail', '{"type":"hidden","isVirtual":true,"fieldTypes":[],"canBeDirectoryFilter":false}', 'email_virtual', 'E-Mail', NULL, 350, 0, 0, 0, 0, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, NULL, 0, 0),
(16, 2, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":100,"validator":null,"default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'fax', 'Fax', NULL, 400, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(17, 2, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"email","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'im_xmpp', 'XMPP Jabber Address', NULL, 800, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(18, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url', 'Website URL', NULL, 100, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(19, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_facebook', 'Facebook URL', NULL, 200, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(20, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_linkedin', 'LinkedIn URL', NULL, 300, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(21, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_instagram', 'Instagram URL', NULL, 350, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(22, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_xing', 'Xing URL', NULL, 400, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(23, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_youtube', 'Youtube URL', NULL, 500, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(24, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_vimeo', 'Vimeo URL', NULL, 600, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(25, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_tiktok', 'TikTok URL', NULL, 700, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(26, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_twitter', 'Twitter URL', NULL, 800, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0),
(27, 3, NULL, 'humhub\\modules\\user\\models\\fieldtype\\Text', '{"minLength":null,"maxLength":255,"validator":"url","default":null,"regexp":null,"regexpErrorMessage":null,"canBeDirectoryFilter":true,"linkPrefix":null,"type":"text","fieldTypes":[],"isVirtual":false}', 'url_mastodon', 'Mastodon URL', NULL, 900, NULL, NULL, 1, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, NULL, 1, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `profile_field_category`
--
CREATE TABLE `profile_field_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`sort_order` int(11) NOT NULL DEFAULT '100',
`module_id` int(11) DEFAULT NULL,
`visibility` tinyint(4) NOT NULL DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`translation_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_system` int(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `profile_field_category`
--
INSERT INTO `profile_field_category` VALUES
(1, 'General', '', 100, NULL, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, 1),
(2, 'Communication', '', 200, NULL, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, 1),
(3, 'Social bookmarks', '', 300, NULL, 1, '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, 1);
-- --------------------------------------------------------
--
-- Table structure for table `queue`
--
CREATE TABLE `queue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`channel` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`job` blob NOT NULL,
`pushed_at` int(11) NOT NULL,
`ttr` int(11) NOT NULL,
`delay` int(11) NOT NULL,
`priority` int(11) unsigned NOT NULL DEFAULT '1024',
`reserved_at` int(11) DEFAULT NULL,
`attempt` int(11) DEFAULT NULL,
`done_at` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `channel` (`channel`),
KEY `reserved_at` (`reserved_at`),
KEY `priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `queue`
--
INSERT INTO `queue` VALUES
(1, 'queue', 'O:46:"humhub\\modules\\content\\jobs\\SearchRebuildIndex":0:{}', [[timestamp]], 3600, 0, 1024, NULL, NULL, NULL),
(2, 'queue', 'O:53:"humhub\\modules\\notification\\jobs\\SendBulkNotification":2:{s:12:"notification";O:51:"humhub\\modules\\content\\notifications\\ContentCreated":3:{s:11:"sourceClass";s:31:"humhub\\modules\\post\\models\\Post";s:8:"sourcePk";i:1;s:13:"originator_id";i:1;}s:5:"query";O:46:"humhub\\modules\\user\\components\\ActiveQueryUser":34:{s:27:"\0yii\\base\\Component\0_events";a:0:{}s:35:"\0yii\\base\\Component\0_eventWildcards";a:0:{}s:30:"\0yii\\base\\Component\0_behaviors";a:0:{}s:6:"select";N;s:12:"selectOption";N;s:8:"distinct";b:0;s:4:"from";N;s:7:"groupBy";N;s:4:"join";a:1:{i:0;a:3:{i:0;s:9:"LEFT JOIN";i:1;s:16:"space_membership";i:2;s:32:"space_membership.user_id=user.id";}}s:6:"having";N;s:5:"union";a:1:{i:0;a:2:{s:5:"query";O:46:"humhub\\modules\\user\\components\\ActiveQueryUser":34:{s:27:"\0yii\\base\\Component\0_events";a:0:{}s:35:"\0yii\\base\\Component\0_eventWildcards";a:0:{}s:30:"\0yii\\base\\Component\0_behaviors";a:0:{}s:6:"select";N;s:12:"selectOption";N;s:8:"distinct";b:0;s:4:"from";N;s:7:"groupBy";N;s:4:"join";N;s:6:"having";N;s:5:"union";N;s:11:"withQueries";N;s:6:"params";a:0:{}s:18:"queryCacheDuration";N;s:20:"queryCacheDependency";N;s:5:"where";a:3:{i:0;s:3:"and";i:1;a:1:{s:11:"user.status";i:1;}i:2;a:2:{i:0;s:6:"exists";i:1;O:18:"yii\\db\\ActiveQuery":33:{s:27:"\0yii\\base\\Component\0_events";a:0:{}s:35:"\0yii\\base\\Component\0_eventWildcards";a:0:{}s:30:"\0yii\\base\\Component\0_behaviors";a:0:{}s:6:"select";N;s:12:"selectOption";N;s:8:"distinct";b:0;s:4:"from";N;s:7:"groupBy";N;s:4:"join";N;s:6:"having";N;s:5:"union";N;s:11:"withQueries";N;s:6:"params";a:0:{}s:18:"queryCacheDuration";N;s:20:"queryCacheDependency";N;s:5:"where";a:4:{i:0;s:3:"and";i:1;a:2:{s:24:"user_follow.object_model";s:33:"humhub\\modules\\space\\models\\Space";s:21:"user_follow.object_id";i:1;}i:2;s:27:"user_follow.user_id=user.id";i:3;a:1:{s:30:"user_follow.send_notifications";i:1;}}s:5:"limit";N;s:6:"offset";N;s:7:"orderBy";N;s:7:"indexBy";N;s:16:"emulateExecution";b:0;s:3:"sql";N;s:2:"on";N;s:8:"joinWith";N;s:10:"modelClass";s:33:"humhub\\modules\\user\\models\\Follow";s:4:"with";N;s:7:"asArray";N;s:8:"multiple";N;s:12:"primaryModel";N;s:4:"link";N;s:3:"via";N;s:9:"inverseOf";N;s:26:"\0yii\\db\\ActiveQuery\0viaMap";N;}}}s:5:"limit";N;s:6:"offset";N;s:7:"orderBy";N;s:7:"indexBy";N;s:16:"emulateExecution";b:0;s:3:"sql";N;s:2:"on";N;s:8:"joinWith";N;s:10:"modelClass";s:31:"humhub\\modules\\user\\models\\User";s:4:"with";N;s:7:"asArray";N;s:8:"multiple";N;s:12:"primaryModel";N;s:4:"link";N;s:3:"via";N;s:9:"inverseOf";N;s:26:"\0yii\\db\\ActiveQuery\0viaMap";N;s:31:"\0*\0multiCharacterSearchVariants";a:2:{i:0;a:3:{i:0;s:1:"''";i:1;s:3:"’";i:2;s:1:"`";}i:1;a:3:{i:0;s:1:""";i:1;s:3:"”";i:2;s:3:"“";}}}s:3:"all";b:0;}}s:11:"withQueries";N;s:6:"params";a:0:{}s:18:"queryCacheDuration";N;s:20:"queryCacheDependency";N;s:5:"where";a:5:{i:0;s:3:"and";i:1;a:1:{s:11:"user.status";i:1;}i:2;a:1:{s:23:"space_membership.status";i:3;}i:3;a:1:{s:35:"space_membership.send_notifications";i:1;}i:4;a:1:{s:8:"space_id";i:1;}}s:5:"limit";N;s:6:"offset";N;s:7:"orderBy";a:1:{s:16:"profile.lastname";i:4;}s:7:"indexBy";N;s:16:"emulateExecution";b:0;s:3:"sql";N;s:2:"on";N;s:8:"joinWith";a:1:{i:0;a:3:{i:0;a:1:{i:0;s:7:"profile";}i:1;b:1;i:2;s:9:"LEFT JOIN";}}s:10:"modelClass";s:31:"humhub\\modules\\user\\models\\User";s:4:"with";N;s:7:"asArray";N;s:8:"multiple";N;s:12:"primaryModel";N;s:4:"link";N;s:3:"via";N;s:9:"inverseOf";N;s:26:"\0yii\\db\\ActiveQuery\0viaMap";N;s:31:"\0*\0multiCharacterSearchVariants";a:2:{i:0;a:3:{i:0;s:1:"''";i:1;s:3:"’";i:2;s:1:"`";}i:1;a:3:{i:0;s:1:""";i:1;s:3:"”";i:2;s:3:"“";}}}}', [[timestamp]], 3600, 0, 1024, NULL, NULL, NULL),
(3, 'queue', 'O:48:"humhub\\modules\\content\\jobs\\SearchUpdateDocument":1:{s:9:"contentId";i:2;}', [[timestamp]], 3600, 0, 1024, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `queue_exclusive`
--
CREATE TABLE `queue_exclusive` (
`id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`job_message_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`job_status` smallint(6) DEFAULT '2',
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `queue_exclusive`
--
INSERT INTO `queue_exclusive` VALUES
('content-search.rebuild-index', '1', 2, '[[regtime]]'),
('content-search.update.2', '3', 2, '[[regtime]]'),
('content-search.update.6', '6', 2, '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `setting`
--
CREATE TABLE `setting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` mediumtext COLLATE utf8mb4_unicode_ci,
`module_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique-setting` (`name`,`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=71 ;
--
-- Dumping data for table `setting`
--
INSERT INTO `setting` VALUES
(1, 'oembedProviders', '{"Facebook Video":{"pattern":"/facebook\\\\.com\\\\/(.*)(video)/","endpoint":"https://graph.facebook.com/v12.0/oembed_video?url=%url%&access_token="},"Facebook Post":{"pattern":"/facebook\\\\.com\\\\/(.*)(post|activity|photo|permalink|media|question|note)/","endpoint":"https://graph.facebook.com/v12.0/oembed_post?url=%url%&access_token="},"Facebook Page":{"pattern":"/^(https\\\\:\\\\/\\\\/)*(www\\\\.)*facebook\\\\.com\\\\/((?!video|post|activity|photo|permalink|media|question|note).)*$/","endpoint":"https://graph.facebook.com/v12.0/oembed_post?url=%url%&access_token="},"Instagram":{"pattern":"/instagram\\\\.com/","endpoint":"https://graph.facebook.com/v12.0/instagram_oembed?url=%url%&access_token="},"Twitter":{"pattern":"/twitter\\\\.com/","endpoint":"https://publish.twitter.com/oembed?url=%url%&maxwidth=450"},"YouTube":{"pattern":"/youtube\\\\.com|youtu.be/","endpoint":"https://www.youtube.com/oembed?scheme=https&url=%url%&format=json&maxwidth=450"},"Soundcloud":{"pattern":"/soundcloud\\\\.com/","endpoint":"https://soundcloud.com/oembed?url=%url%&format=json&maxwidth=450"},"Vimeo":{"pattern":"/vimeo\\\\.com/","endpoint":"https://vimeo.com/api/oembed.json?scheme=https&url=%url%&format=json&maxwidth=450"},"SlideShare":{"pattern":"/slideshare\\\\.net/","endpoint":"https://www.slideshare.net/api/oembed/2?url=%url%&format=json&maxwidth=450"},"Reddit":{"pattern":"/reddit\\\\.com/","endpoint":"https://www.reddit.com/oembed?format=json&url=%url%"}}', 'base'),
(2, 'defaultVisibility', '1', 'space'),
(3, 'defaultJoinPolicy', '1', 'space'),
(4, 'includeCommunityModules', '1', 'marketplace'),
(5, 'richtextCompatMode', '0', 'content'),
(6, 'auth.showRegistrationUserGroup', '1', 'user'),
(7, 'displayNameSubFormat', 'title', 'base'),
(8, 'serverTimeZone', 'America/New_York', 'base'),
(9, 'themeParents', '[]', 'base'),
(10, 'theme.var.HumHub.default', '#e7e7e7', 'base'),
(11, 'theme.var.HumHub.primary', '#435f6f', 'base'),
(12, 'theme.var.HumHub.info', '#21A1B3', 'base'),
(13, 'theme.var.HumHub.success', '#97d271', 'base'),
(14, 'theme.var.HumHub.warning', '#FFC107', 'base'),
(15, 'theme.var.HumHub.danger', '#FC4A64', 'base'),
(16, 'theme.var.HumHub.link', '#21A1B3', 'base'),
(17, 'theme.var.HumHub.isFluid', 'false', 'base'),
(18, 'theme.var.HumHub.text-color-main', '#555', 'base'),
(19, 'theme.var.HumHub.text-color-default', '#4b4b4b', 'base'),
(20, 'theme.var.HumHub.text-color-secondary', '#7a7a7a', 'base'),
(21, 'theme.var.HumHub.text-color-highlight', '#000', 'base'),
(22, 'theme.var.HumHub.text-color-soft', '#555555', 'base'),
(23, 'theme.var.HumHub.text-color-soft2', '#aeaeae', 'base'),
(24, 'theme.var.HumHub.text-color-soft3', '#bac2c7', 'base'),
(25, 'theme.var.HumHub.text-color-contrast', '#fff', 'base'),
(26, 'theme.var.HumHub.background-color-main', '#fff', 'base'),
(27, 'theme.var.HumHub.background-color-secondary', '#f9f9f9', 'base'),
(28, 'theme.var.HumHub.background-color-page', '#ededed', 'base'),
(29, 'theme.var.HumHub.background-color-highlight', 'fade(@info, 20%)', 'base'),
(30, 'theme.var.HumHub.background-color-highlight-soft', 'lighten(desaturate(spin(@info, 6), 16), 55)', 'base'),
(31, 'theme.var.HumHub.background3', '#d7d7d7', 'base'),
(32, 'theme.var.HumHub.background4', '#b2b2b2', 'base'),
(33, 'theme.var.HumHub.background-color-success', '#f7fbf4', 'base'),
(34, 'theme.var.HumHub.text-color-success', '#84be5e', 'base'),
(35, 'theme.var.HumHub.border-color-success', '#97d271', 'base'),
(36, 'theme.var.HumHub.background-color-warning', '#fffbf7', 'base'),
(37, 'theme.var.HumHub.text-color-warning', '#e9b168', 'base'),
(38, 'theme.var.HumHub.border-color-warning', '#fdd198', 'base'),
(39, 'theme.var.HumHub.background-color-danger', '#fff6f6', 'base'),
(40, 'theme.var.HumHub.text-color-danger', '#ff8989', 'base'),
(41, 'theme.var.HumHub.border-color-danger', '#ff8989', 'base'),
(42, 'theme.var.HumHub.mail-font-family', '''Open Sans'', Arial, Tahoma, Helvetica, sans-serif', 'base'),
(43, 'name', '[[site_name]]', 'base'),
(44, 'baseUrl', '[[softurl]]', 'base'),
(45, 'paginationSize', '10', 'base'),
(46, 'displayNameFormat', '{profile.firstname} {profile.lastname}', 'base'),
(47, 'horImageScrollOnMobile', '1', 'base'),
(48, 'cronLastDailyRun', '[[timestamp]]', 'base'),
(49, 'auth.needApproval', '0', 'user'),
(50, 'auth.anonymousRegistration', '1', 'user'),
(51, 'auth.internalUsersCanInviteByEmail', '1', 'user'),
(52, 'auth.internalUsersCanInviteByLink', '1', 'user'),
(53, 'mailer.transportType', 'php', 'base'),
(54, 'mailer.systemEmailAddress', 'social@example.com', 'base'),
(55, 'mailer.systemEmailName', '[[site_name]]', 'base'),
(56, 'mailSummaryInterval', '2', 'activity'),
(57, 'maxFileSize', '8388608', 'file'),
(58, 'excludeMediaFilesPreview', '1', 'file'),
(59, 'cacheClass', 'yii\\caching\\FileCache', 'base'),
(60, 'cacheExpireTime', '3600', 'base'),
(61, 'installationId', '[[installationId]]', 'admin'),
(62, 'spaceOrder', '0', 'space'),
(63, 'enable', '1', 'tour'),
(64, 'cronLastRun', '[[timestamp]]', 'base'),
(65, 'defaultLanguage', '[[language]]', 'base'),
(66, 'useCase', 'other', 'base'),
(67, 'group.adminGroupId', '1', 'user'),
(68, 'sampleData', '1', 'installer'),
(69, 'secret', '[[secret]]', 'base'),
(70, 'defaultTimeZone', 'America/New_York', 'base');
-- --------------------------------------------------------
--
-- Table structure for table `space`
--
CREATE TABLE `space` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` mediumtext COLLATE utf8mb4_unicode_ci,
`about` text COLLATE utf8mb4_unicode_ci,
`join_policy` tinyint(4) DEFAULT NULL,
`visibility` tinyint(4) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`sort_order` int(11) NOT NULL DEFAULT '100',
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`ldap_dn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auto_add_new_members` int(4) DEFAULT NULL,
`contentcontainer_id` int(11) DEFAULT NULL,
`default_content_visibility` tinyint(1) DEFAULT NULL,
`color` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`members_can_leave` int(11) DEFAULT '1',
`url` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `url-unique` (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `space`
--
INSERT INTO `space` VALUES
(1, '8b514ad0-e6b1-490c-b59a-c9dcd2a06923', 'Welcome Space', 'Your first sample space to discover the platform.', NULL, 2, 2, 1, 100, '[[regtime]]', 1, '[[regtime]]', 1, NULL, 1, 2, NULL, '#6fdbe8', 1, 'welcome-space');
-- --------------------------------------------------------
--
-- Table structure for table `space_membership`
--
CREATE TABLE `space_membership` (
`space_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`originator_user_id` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(4) DEFAULT NULL,
`request_message` mediumtext COLLATE utf8mb4_unicode_ci,
`last_visit` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`group_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'member',
`show_at_dashboard` tinyint(1) DEFAULT '1',
`can_cancel_membership` int(11) DEFAULT '1',
`send_notifications` tinyint(1) DEFAULT '0',
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
KEY `index_status` (`status`),
KEY `fk_space_membership-space_id` (`space_id`),
KEY `fk_space_membership-user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `space_membership`
--
INSERT INTO `space_membership` VALUES
(1, 1, NULL, 3, NULL, NULL, '[[regtime]]', 1, '[[regtime]]', 1, 'admin', 1, 1, 0, 1),
(1, 2, NULL, 3, NULL, NULL, '[[regtime]]', 1, '[[regtime]]', 1, 'member', 1, 1, 0, 2),
(1, 3, NULL, 3, NULL, NULL, '[[regtime]]', 1, '[[regtime]]', 1, 'member', 1, 1, 0, 3);
-- --------------------------------------------------------
--
-- Table structure for table `url_oembed`
--
CREATE TABLE `url_oembed` (
`url` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
`preview` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`guid` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint(4) DEFAULT NULL,
`username` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` char(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_mode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`language` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`visibility` int(1) DEFAULT '1',
`time_zone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`contentcontainer_id` int(11) DEFAULT NULL,
`authclient_id` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_key` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_email` (`email`),
UNIQUE KEY `unique_username` (`username`),
UNIQUE KEY `unique_guid` (`guid`),
UNIQUE KEY `unique_authclient_id` (`authclient_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `user`
--
INSERT INTO `user` VALUES
(1, '0e924595-5407-4334-8d68-3bed72ba4af7', 1, '[[admin_username]]', '[[admin_email]]', 'local', '', '[[regtime]]', NULL, '[[regtime]]', NULL, NULL, 1, NULL, 1, NULL, '[[auth_key]]'),
(2, '3cb86e35-d937-452c-9145-119368d1114d', 1, 'david1986', 'david.roberts@example.com', 'local', '', '[[regtime]]', 1, '[[regtime]]', 1, NULL, 1, NULL, 3, NULL, NULL),
(3, 'e037f862-5df2-43b7-a47f-d1610f231b82', 1, 'sara1989', 'sara.schuster@example.com', 'local', '', '[[regtime]]', 1, '[[regtime]]', 1, NULL, 1, NULL, 4, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `user_auth`
--
CREATE TABLE `user_auth` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`source_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user_follow`
--
CREATE TABLE `user_follow` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`send_notifications` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`),
KEY `index_user` (`user_id`),
KEY `index_object` (`object_model`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `user_follow`
--
INSERT INTO `user_follow` VALUES
(1, 'humhub\\modules\\post\\models\\Post', 1, 1, 1),
(2, 'humhub\\modules\\post\\models\\Post', 2, 1, 1),
(3, 'humhub\\modules\\post\\models\\Post', 2, 2, 1),
(4, 'humhub\\modules\\post\\models\\Post', 2, 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `user_friendship`
--
CREATE TABLE `user_friendship` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`friend_user_id` int(11) NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx-friends` (`user_id`,`friend_user_id`),
KEY `fk-friend` (`friend_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user_http_session`
--
CREATE TABLE `user_http_session` (
`id` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`expire` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`data` longblob,
PRIMARY KEY (`id`),
KEY `fk_user_http_session-user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_invite`
--
CREATE TABLE `user_invite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_originator_id` int(11) DEFAULT NULL,
`space_invite_id` int(11) DEFAULT NULL,
`email` char(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`source` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
`language` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_email` (`email`),
UNIQUE KEY `unique_token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user_mentioning`
--
CREATE TABLE `user_mentioning` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`object_model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`object_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `i_user` (`user_id`),
KEY `i_object` (`object_model`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user_password`
--
CREATE TABLE `user_password` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) DEFAULT NULL,
`algorithm` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password` mediumtext COLLATE utf8mb4_unicode_ci,
`salt` mediumtext COLLATE utf8mb4_unicode_ci,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `user_password`
--
INSERT INTO `user_password` VALUES
(1, 1, 'bcrypt', '[[admin_pass]]', '[[salt]]', '[[regtime]]');
--
-- Constraints for dumped tables
--
--
-- Constraints for table `comment`
--
ALTER TABLE `comment`
ADD CONSTRAINT `fk_comment-created_by` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `content`
--
ALTER TABLE `content`
ADD CONSTRAINT `fk-contentcontainer` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `fk-create-user` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE SET NULL,
ADD CONSTRAINT `fk-update-user` FOREIGN KEY (`updated_by`) REFERENCES `user` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `contentcontainer_blocked_users`
--
ALTER TABLE `contentcontainer_blocked_users`
ADD CONSTRAINT `fk-contentcontainer-blocked-users-rel-contentcontainer-id` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-contentcontainer-blocked-users-rel-user-id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `contentcontainer_module`
--
ALTER TABLE `contentcontainer_module`
ADD CONSTRAINT `fk_contentcontainer` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `contentcontainer_setting`
--
ALTER TABLE `contentcontainer_setting`
ADD CONSTRAINT `fk-contentcontainerx` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `contentcontainer_tag_relation`
--
ALTER TABLE `contentcontainer_tag_relation`
ADD CONSTRAINT `fk-contentcontainer-tag-rel-contentcontainer-id` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-contentcontainer-tag-rel-tag-id` FOREIGN KEY (`tag_id`) REFERENCES `contentcontainer_tag` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `content_fulltext`
--
ALTER TABLE `content_fulltext`
ADD CONSTRAINT `fk_content_fulltext` FOREIGN KEY (`content_id`) REFERENCES `content` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `content_tag`
--
ALTER TABLE `content_tag`
ADD CONSTRAINT `fk-content-tag-container-id` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-content-tag-parent-id` FOREIGN KEY (`parent_id`) REFERENCES `content_tag` (`id`) ON DELETE SET NULL;
--
-- Constraints for table `content_tag_relation`
--
ALTER TABLE `content_tag_relation`
ADD CONSTRAINT `fk-content-tag-rel-content-id` FOREIGN KEY (`content_id`) REFERENCES `content` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-content-tag-rel-tag-id` FOREIGN KEY (`tag_id`) REFERENCES `content_tag` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `file`
--
ALTER TABLE `file`
ADD CONSTRAINT `fk_file-created_by` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `file_history`
--
ALTER TABLE `file_history`
ADD CONSTRAINT `fk_file_history` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `fk_file_history_user` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
--
-- Constraints for table `group_permission`
--
ALTER TABLE `group_permission`
ADD CONSTRAINT `fk_group_permission-group_id` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `group_space`
--
ALTER TABLE `group_space`
ADD CONSTRAINT `fk-group_space-group` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-group_space-space` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `group_user`
--
ALTER TABLE `group_user`
ADD CONSTRAINT `fk-group-group` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-user-group` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `like`
--
ALTER TABLE `like`
ADD CONSTRAINT `fk_like-created_by` FOREIGN KEY (`created_by`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `fk_like-target_user_id` FOREIGN KEY (`target_user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `live`
--
ALTER TABLE `live`
ADD CONSTRAINT `contentcontainer` FOREIGN KEY (`contentcontainer_id`) REFERENCES `contentcontainer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `notification`
--
ALTER TABLE `notification`
ADD CONSTRAINT `fk_notification-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `profile`
--
ALTER TABLE `profile`
ADD CONSTRAINT `fk_profile-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `profile_field`
--
ALTER TABLE `profile_field`
ADD CONSTRAINT `fk_profile_field-profile_field_category_id` FOREIGN KEY (`profile_field_category_id`) REFERENCES `profile_field_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `space_membership`
--
ALTER TABLE `space_membership`
ADD CONSTRAINT `fk_space_membership-space_id` FOREIGN KEY (`space_id`) REFERENCES `space` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `fk_space_membership-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `user_auth`
--
ALTER TABLE `user_auth`
ADD CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `user_follow`
--
ALTER TABLE `user_follow`
ADD CONSTRAINT `fk_user_follow-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `user_friendship`
--
ALTER TABLE `user_friendship`
ADD CONSTRAINT `fk-friend` FOREIGN KEY (`friend_user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `fk-user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `user_http_session`
--
ALTER TABLE `user_http_session`
ADD CONSTRAINT `fk_user_http_session-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `user_mentioning`
--
ALTER TABLE `user_mentioning`
ADD CONSTRAINT `fk_user_mentioning-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `user_password`
--
ALTER TABLE `user_password`
ADD CONSTRAINT `fk_user_password-user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;
<softedit xmlns="http://www.softaculous.com">
<settings>
<group>
<heading>{{ad_act}}</heading>
<input type="text" name="admin_username" size="30" value="">
<head>{{ad_name}}</head>
<optional>true</optional>
</input>
<input type="text" name="admin_pass" size="30" value="">
<head>{{ad_pass}}</head>
<exp>{{exp_ad_pass}}</exp>
<optional>true</optional>
</input>
</group>
</settings>
</softedit><?php //004fb
if(!extension_loaded('ionCube Loader')){$__oc=strtolower(substr(php_uname(),0,3));$__ln='ioncube_loader_'.$__oc.'_'.substr(phpversion(),0,3).(($__oc=='win')?'.dll':'.so');if(function_exists('dl')){@dl($__ln);}if(function_exists('_il_exec')){return _il_exec();}$__ln='/ioncube/'.$__ln;$__oid=$__id=realpath(ini_get('extension_dir'));$__here=dirname(__FILE__);if(strlen($__id)>1&&$__id[1]==':'){$__id=str_replace('\\','/',substr($__id,2));$__here=str_replace('\\','/',substr($__here,2));}$__rd=str_repeat('/..',substr_count($__id,'/')).$__here.'/';$__i=strlen($__rd);while($__i--){if($__rd[$__i]=='/'){$__lp=substr($__rd,0,$__i).$__ln;if(file_exists($__oid.$__lp)){$__ln=$__lp;break;}}}if(function_exists('dl')){@dl($__ln);}}else{die('The file '.__FILE__." is corrupted.\n");}if(function_exists('_il_exec')){return _il_exec();}echo("Site error: the ".(php_sapi_name()=='cli'?'ionCube':'<a href="http://www.ioncube.com">ionCube</a>')." PHP Loader needs to be installed. This is a widely used PHP extension for running ionCube protected PHP code, website security and malware blocking.\n\nPlease visit ".(php_sapi_name()=='cli'?'get-loader.ioncube.com':'<a href="http://get-loader.ioncube.com">get-loader.ioncube.com</a>')." for install assistance.\n\n");exit(199);
?>
HR+cPtVQlQKgZGQACn4eXkTAO87UP/1LqRwYTOkum5x4PFajiN87XgyXXV6Cea7mavwVp31he4O8
r5WI5DTT3yAwaFGAO/QYxa9m6uF3XTq6CjK3KvT/AEBL/kITyzD6s1XUyAEcl36qbtwQVmPRkGda
8byfaYM6s3smj8xiTqEOVzguoUkzyqrwL9w1saZp6rsHUHAg0h8WUz+3+XbfeHiaR/4QzWNc7a8j
J8vpAwYsT4nF0Du97HNZ37XdBEm1iNeJL7V3EJkgyKadvl5J8Gue0jHMvOfdBcXOSTXo80FmFeau
pYmdKg8xHpGlVSs0snDpiUAgx6weRIIiIFyVhGAfQloIh+MI/lb9eAx+6nNlCrWec1N3+50/x0Q7
tKEnfpvn2Ma6BoOrAEhjYnV6YIdPPIHAYmHn25g7H0LDQ1m9TswxpNYeestACh94o7LwcCE2ujYp
kkfGacGGtnJ8PfLB++0onmOWoCa88UNfrWj/GxHaQy2IQPlwe6J5+gwDUNJJmK0G1OsoNjs5urXU
e2NinQNyVYmfe/XYBp+bmsa0zz5vLXA+8MFKqac2dUuBa2sYuaOCMuLVCud6PNNLNDh2isx69Izs
lfdEo4BfJWdw6QnmYqantXHa3XvuddfepUE9c2pTKMlmMB7faGni193qIj2eADf9Ow649vsp8031
4WxaoeMf3htiUGdxLCwzS6+MQb3t0ejJ165KD3OBxm9CnqL3ocet5BCiqri6aEk5ASiZ4dzn0Ycf
c22y2wUs1E4cwwRbbnwLdnC6RW0alQ8GoMxwN92MKhGIZ60RYQo29ceVkZ/qW+7imu3rUOCAMKCI
crY/Kac5s8prAsOL/h+NNi+nzXQrrAZ8CUzVTxLMS7qFpJW1sq5oyJHP+B5eluIoONL9avfRCeXi
ZG4S1Ku4fIgia6CQ2PFg9PJZDkR5f6ecKKeXnyMDLwyqLOo0qs9SSghKLb+Zgi/O1UiVZO8F2tWM
Yl84crj523gWiQUhe11iEdFzFxNBpHbxGhjPGlBohHIndN+i8aUOC1JWzcCdyKqCbnV1+CiTZWli
8vo4icXmscSAh1EFJUAm100szzjpx/vTkg0ZOqTFtyuPPfSlX3YFy2fTwFQ/ZpcJVSMrsggsG7Sz
8NNCeDhGgKfYcz3jiPtE2PJzcbzVYzoWCP+wTER9Cm+6N0e2O5ltQzWnLaIZR4rW8W4d1HdtRgSG
SRlqTuUiGufgHeZMx3VsU1ePyefZqtqr7aRv1ON3lLdh8tvrCcLcHnEmlsL3vHriBpJmjRdAyvJn
P44Qx889vGYwWMDYh4ScXEo1w/955sSPuOeN6vqRcXgzZ1hizXPB6OOYHLUE6qKa/EvlniOIrLko
LHP3LmrBfZYjN/RKAZRXFRyv6mFES1uSkKw9ipw3vGXgQErIPrQvJLT9K4jFzjs955dDbmREvco/
RSZvd+x4rA3pCQE2CxeJiagKaCK5kW0ffU8fJT9VuoFtZ24fTAwjOSTyk5f8egj9KqmYzULWjBEN
mbyuWvXqXxXce6Sp2QYpGUjPt1SXkmJfJj0YqyovH04BKxRbzbB0ifl8OuTqUGwbttFA+bV7DrNY
2gha1mZgP+Xq6oWT77o08LGG6frxLLBcqNqdi9RFtvEu0B48eOB8xavIxJwMB38CEmuUOA27VieG
8NY8IajKe9D89SP3fr/FC8Hq8m9DhmjEBZliuplUjmQMiD9i+TflD3/xg68HOYB4GB6qO0EwHpYT
e3fIcLBBmrRiI+2//dS4s+39Q4liluIIYyhsIiqVjOKfLuHNusqv0+Dz9r5lY/Dvi0CuMSWJ+Aww
vEvFwqmh+7F5uFnW6V1Y4Gnd176cU76WIrtB+QOBvINnBY1b39h9hVImH92M6m8HA38w45IFwdLy
nhDyz+iHYgfZYoZfxB+EA0JDLarMdZ5goP/ZDnt7DQjyagZ03kN6xY07H/1/uu+YYFIdZyGb7m+K
4zp3yDppaK6dAIrm65edo9M4kt+Qfx0MC2e4LVMe3PPN5CaxtccXlx3cI3CCwwMb2YtmKfO5Exxy
8jVeOhRDVDAHjaREoOBFkqFL2WRqdV4AN5B13Bp0Y397f+uTyeKga665YBOjt9WiuwHX9bLvJavg
5plddIJVuXk7dHcyP0+mVJOf8XR1lTnTHTRl//0kEuHVVakNf6ghdRs/Y974bUNZwn+JSo/4h/2u
p7QlKiUiJHzRZsmrDB4iLESHx0vGsKVeOtmRIuMh2lnZi69j/MjLZiVnMhAKnPe2caXeyW89arhS
/mbzuU6G+EyECPfiLzlpwtxgcqGu6g0afQ1Ej247XVgj3qDIf/fC/wVTPRgrAAN+c1n+9SQbxip1
WdK392gO0OmWqSa8ydqr7R8KP1xDCEf5XCU+/kaDINmT/yj1UyCoh/GvtIY8TuOBjindWTATnCBd
zg2e2fF6UrzbTTbo0p/qN+3GmSdauu1Squ6Kq3ERZgpl2+EayhUaeeP+d3/jupFqxc2SYmBhYJcB
bbn9t6DjXxS6+ZvLvMuApQjDgHjRjSKMjJHMsV5iw6L7xo9mTJC/1PwZnLMRrIrjKzluj20PKQnP
9BrLeDwj5gFcT4ckrCIv0WlB80ztPH5q+QCXOxQJe/GnwuZv9MdPI0T/nTDhLmqGsE+ONB08zsMG
9jeQjzT8oTPF6y8lg2My4BZikrE7J/Py4SRHVzWX718TWjmcm5f0Byz1ejcSKSzLsaOO0chwNvdP
5amvTml/qV4DAl83KMEn9aKMsd4TTHLfSFkVpY37E+nT2Y7LOHSgMKpyqmZvqVQYcx4PYloIDA7E
PgVziZV82ZrXasRnPqX8pJtQp0dIsGRrKnb9bCYHkXU9GovbR+E3BhvOR9HRMQxvuyywrfS74sBd
EkUdHzqIu49UchtluaM5d7q3tIBB4hF5xmRg4gdlGosfMARqTpzc+5mi+N/bhIxlv6Utmtemc7D8
BQeDrDmGE0GHwZ6Q5Scc3oJHHWewx5Vsj/uQ82tbhYb+z885Uq3FgiGI6gnbeVOMhzhavlADdM6E
n4sVo7cH2kVSdk+lL44aqSUopId/n3aJIzixPkNwmDiPG6Ob8ic5FfLgUSRQ7wwh23q6GB9zaaAu
aFokYIBarMwMaKy+T7jLbB10zTRAIhUqQShPFsPKOwubtFbfBPH0gCFwqABZRRmThGl9lIIohqCj
N5cXXKz+EO6j7vQEaMxj5FtNbG/uGrY0uW483uQ7+uhKWHk18sUFu0cHvqxvX2tiNsYb92AdNp6D
6vtktIdLw17QGgNF5J2lUN/DPEQcLtrkQMMj9PzEJUEeY0vPqyYkbRppvmdaV8zsIi/nJ/2tHfaz
kcvBw9oF/0kxnz/EfP8AdYgEI7awOlUlrm9WvaOaf4YlRDauNY1bWCc6WjgODO0GAwPSw8IdMlMa
6B9n6rEPZ84VZ5yR/pU4TqcYLlx/fuR6OOikR3UWrvP3moPCa5RdACXPn/1FgEeNVUA6/o1oS9vm
eWA1zhP2t9IoNEPAmv1PxmLEbImHUQ75sA/EH6ccIN6uNRY+/R0GWDbAf/UMwoTH6ZjtYIwa/pwn
Od7a9bYlrQr9LuDuEFYsVMvkWH5XZCx0WU0DLxo4aOMvIuEYtJ5VSWO74H6m4pwDgVgBjueV7IoL
RugcxlzhY/MZQ+rNCbVoiw/JdBXEi0Trmn0pujFiwOzqf8qSZ/xiR5JHyot8capLaQby2jBB9xiH
WLhd50WqucnWOzfFWl+WLtrypnIjWIxg3jJatUi/f0MOo7dTfqq+GrZ/yv+CthOw03PvQvWZv2+o
k3j7mukQ4qPMlnOn1Ffqzyt7tcGudksjVdXGj6/aGRZJ0AtTTdmqnzthwh0h1JJse5RKlNN1NO4I
gd+gnhqdjItOEgZraBl9HeYMo6KYOKPgmB73Dn6AsgYASQhmsgbCINso5hyVP1zfjktiCohGC6WM
eU/tpCb2ip15oT1GU7ClT6JmCJFycErS9u33jIpHH0oJLp39E1ib58f3CY3fidw3tRwBJS79Zada
AOzglqoJI8ekSgMKQLUAXvBZ4PG1R2Me9MPohOPFfC1xPSREf/1xdQBnv4/0vxh4dXyDSJ1qOTDU
ePt7M2GQsZbtkfBR6oOlr7uH2RSDV4iX97B+QcxZBUNBOHSad7cnbK7IGy3s0Of1vn27Jvk1GDX5
f5N7ahC5ERMdIpMuJTvV5TLb9YR5NZ9e4ZvU+XLsMCE33Vcy4GeGn6Clpb/aVNsEQyr0wrc7ZYwJ
4Y1Vt0SzOkV4MIQRwV5CQFutAVdy9JLR6q5jv4M+m8TrgoHtT1hJ7ReFN7DiDr9dq1oWecHmMftG
5vvBtv4zM9sDZ3TmUrtPh6uT69sBY+55W1Vj0K5zbO086Wn/mxgYkdQRtARVbsckt/PE0dkhXDR0
tYzxz7QTeuEjqeF6nP03WBsubpVcocnSYyn6xnQBWOCoWgoHFjLv4PHa4oSkCMTh4yAiRRB09nyQ
8T8d452H9553/OrEc8SW/83Z8dWEUIGY0pz4GmNA6JjfNJlAlUYEAdPcXgRxve/x7AQE4ANMVUTP
Vm/2SyyBPT7VTqHZq+w+Qa3PE7BIrHxlwqnf06O3JY6Y22S1mHZadUbI/YulWw6iZ22KDxjXO4ob
p/gqz75j4kc6AUEI2ZfMYNFOGIbZWYBiM8Kbt7LcbjChPlTBsF8xAVe3wrH0cDGZV2/Zplyoyeb5
tjSrcEzH6gKiOSIlgwPfW4oWuz7yU+goqVJGgHhfPdeADfZ41cvkfm9FeE61NlRqPCMdID1wP5Tw
Fj/rt52cB7F4jdgt+JUmCJVg1TasJ3Koc1VjYvBTWi+kJ1QrsIDXltlu0WCHYw77KhMmUPEU3Y/A
829ku1dF1Fic9p89TJ9ip7oLu1NCWJI2vQVvLMfSkKBlPXntfLpo+tba1CqLg3vSu3qqS0hd4VCM
TaQUZJP6kfNIlL6R8Q0UvWxRHNCi2VIYexA5gN8n72Exfytx0v7ovp/bWWjYhEJn7pg9kiNF56w5
TdUqgGSfX29NYr3a+q7FwfXwDUm/S/7TP7yjquwjQxD4kM2QCIqkVO6qo8QBWFwplHj99PF9ON7z
ESER9TNfN/msDtm4+QsgWdKE3UVStn05fXTBBK54cmRcUNV3k7ZNBiQIWkjd1MvNRI5vaoh0Hjs/
76LGD5Yx4A8vt08+t6MTBb//ooxXTwu8KZrCBxZDWbnapi0pYdux1nRjdN+WSByMWux9WTSkA3X6
GAdLL7p/85yYHXI7CVZ5xta0WSOYirkZKjgVQUnXz29m36q7BiGfiw2wYhz4Zc847rQxw+kyoZWM
KlqAdz4ciLtJWjg4ryRy9LXFu2rwVkCjwznAiHMWIpufV+Rw2NwAe/DnEhZBL12DRcxc3588nA+C
Wnr5ccXdaW3PxAgtKbFEg2uxjopFYOUixbgbCS+hafuK+KRT9SCeHPwTfzJE92SkgOPvB25P8NCY
g3bCsB+DVfCaiQr9QtTbTbO5fSy0I7qQpDrdpY8AoOwUyzINJobVLddVa0g9SWd1RCjjkEG8nuWn
Giw0Vx5//HNBnSCt6Num+yD1DGwcSsv8b8fYUlgoM39bCGNz5F/MFqiMjpKtnUj69jGEWyjm0/kh
63bc/cK/wfwzJhlO3W8VLjCmY9qtiOmRxKeC9bnTu2rzngaVQR1fpMuYEBgl231v0yylW7HQaZbh
vx+y5uEEKfV/Hog3bvNFJigdl30aATHNy4cBqcyLwE3qZg1ZqxHZ5dLTidK7pL+9hBYgLnKHm8m9
sN2Bp8hpS3KWWrt8+vZmCBLSkguSOj4EibrhBYizrXiOWuKpI6TF7Z64JId/2mHsubYSLjMSjuIU
5g9C664f0Ox6UiQ1f2YExc3w8H7P4us5dLQBkLitzXsKw1LRlVzb5pb6W+57Kxo1FnJLA0Fys7UY
nbiFMttRL5ODDrYPCw9bi6CIi6MjpCgswS4WxzymymPlwSX/7d+btscBEDvv9oE8zDGRJFg6Voy1
kHXKGcm+CCcLva6QkHxyupOkURvlR79YNJrE82Qu5IGkVCDkOpevS2jtanL1fU4ZZSJ3mfcyi1vZ
YUPjHLvq1eH28vhMLQOQo6r4k2chU4FeVkjtOW0Vfq7Ex9c4jMC2+3J1Sz0OjYSqMtq9mU5HA2Hb
XQFbWT7MlXU8gLtHdQuCt7TqE+PGSbryg1XHke2d5rUsFtQRKJqGpJEvYVEJJE4KUdjnFanlRw/6
6hO1YXX8LWdyG7PX5QeX+1SC+rjm4erg78nEchuuUMHyc42Wsm3BUCmlaGCC1GNb9wFOgOwp7BO=