| 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 : /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_ena