GIF89a=( õ' 7IAXKgNgYvYx\%wh…hŽth%ˆs%—x¨}9®Œ©€&©‰%¶†(¹–.¹5·œD¹&Çš)ÇŸ5ǘ;Í£*È¡&Õ²)ׯ7×µ<Ñ»4ï°3ø‘HÖ§KͯT÷¨Yÿšqÿ»qÿÔFØ !ù ' !ÿ NETSCAPE2.0 , =( þÀ“pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§gª«ªE¯°¨¬ª±²Œ¹º¹E¾­”´ÂB¶¯ §Åȸ»ÑD¾¿Á•ÄÅ®° ÝH¾ÒLÀÆDÙ«D¶BÝïðÀ¾DÑÑÔTÌÍíH òGö¨A RÎڐ |¥ ٭&ºìE8œ¹kGÔAÞpx­a¶­ã R2XB®åE8I€Õ6Xî:vT)äžþÀq¦è³¥ì仕F~%xñ  4#ZÔ‰O|-4Bs‘X:= QÉ œš lºÒyXJŠGȦ|s hÏíK–3l7·B|¥$'7Jީܪ‰‡àá”Dæn=Pƒ ¤Òëí‰`䌨ljóá¯Éüv>á–Á¼5 ½.69ûϸd«­ºÀûnlv©‹ªîf{¬ÜãPbŸ  l5‘Ž¯pß ´ ˜3aÅùäI«O’ý·‘áÞ‡˜¾Æ‚ÙÏiÇÿ‹Àƒ #öó)pâš Þ½ ‘Ý{ó)vmÞü%D~ 6f s}ŃƒDØW Eþ`‡þ À…L8xá†ç˜{)x`X/> Ì}mø‚–RØ‘*|`D=‚Ø_ ^ð5 !_…'aä“OÚ—7âcð`D”Cx`ÝÂ¥ä‹éY¹—F¼¤¥Š?¡Õ™ n@`} lď’ÄÉ@4>ñd œ à‘vÒxNÃ×™@žd=ˆgsžG±æ ´²æud &p8Qñ)ˆ«lXD©øÜéAžHìySun jª×k*D¤LH] †¦§C™Jä–´Xb~ʪwStŽ6K,°£qÁœ:9ت:¨þªl¨@¡`‚ûÚ ».Û¬¯t‹ÆSÉ[:°=Š‹„‘Nåû”Ìî{¿ÂA ‡Rà›ÀÙ6úë°Ÿð0Ä_ ½;ÃϱîÉì^ÇÛÇ#Ëë¼ôº!±Ä˜íUîÅÇ;0L1óÁµö«p% AÀºU̬ݵ¼á%霼€‡¯Á~`ÏG¯»À× ­²± =4ªnpð3¾¤³¯­ü¾¦îuÙuµÙ®|%2ÊIÿür¦#0·ÔJ``8È@S@5ê¢ ö×Þ^`8EÜ]ý.뜃Âç 7 ú ȉÞj œ½Dç zý¸iþœÑÙûÄë!ˆÞÀl§Ïw‹*DçI€nEX¯¬¼ &A¬Go¼QföõFç°¯;é¦÷îŽêJ°îúôF5¡ÌQ|îúöXªæ»TÁÏyñêï]ê² o óÎC=öõ›ÒÓPB@ D×½œä(>èCÂxŽ`±«Ÿ–JЀ»Û á¤±p+eE0`ëŽ`A Ú/NE€Ø†À9‚@¤à H½7”à‡%B‰`Àl*ƒó‘–‡8 2ñ%¸ —€:Ù1Á‰E¸àux%nP1ð!‘ðC)¾P81lÑɸF#ˆ€{´âé°ÈB„0>±û °b¡Š´±O‚3È–Ù()yRpbµ¨E.Z‘D8ÊH@% òŒx+%Ù˜Æcü »¸˜fõ¬b·d`Fê™8èXH"ÉÈ-±|1Ô6iI, 2““¬$+](A*jÐ QTÂo‰.ÛU슬Œã„Ž`¯SN¡–¶Äåyše¯ª’­¬‚´b¦Éož œ)åyâ@Ì®3 ÎtT̉°&Ø+žLÀf"Ø-|žçÔ>‡Ðv¦Ðžì\‚ Q1)Ž@Žh#aP72”ˆ™¨$‚ !ù " , =( …7IAXG]KgNgYvYxR"k\%w]'}hŽth%ˆg+ˆs%—r.—m3šx3˜x¨}9®€&©€+¨‡7§‰%¶†(¹–.¹œD¹&ǘ;Í•&ײ)×»4ïÌ6ò§KÍ þ@‘pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§g «¬ E ±± ¨­¶°ººE Á´”·®C¬²§Ç¶Œ»ÓDÃÕƷ¯Ê±H½ºM×ÁGÚ¬D¶BËÁ½î½DÓôTÏÛßîG»ôõC×CÌ l&âž:'òtU³6ɹ#·Ø)€'Ü.6±&ëÍÈ» K(8p0N?!æ2"ÛˆNIJX>R¼ÐO‚M '¡¨2¸*Ÿþ>#n↠å@‚<[:¡Iïf’ ¤TÚ˘CdbÜÙ“[«ŽEú5MBo¤×@€`@„€Êt W-3 ¶Ÿ¡BíêäjIÝ…Eò9[T…$íêﯧ„…•s»Óȳ¹€ÅÚdc®UUρ#±Ùïldj?´í¼²`\ŽÁðÞu|3'ÖŒ]ë6 ¶S#²‡˜FKLÈ *N E´‘áäŠ$˜›eÄYD„ºq«.è촁ƒs \-ÔjA 9²õ÷å- üúM[Âx(ís÷ì®x€|í¡Ù’p¦‚ ŽkÛTÇDpE@WÜ ²Ç]kŠ1¨ þ€·Yb ÓÁ‰l°*n0 ç™—žzBdОu¾7ĉBl€â‰-ºx~|UåU‰  h*Hœ|e"#"?vpÄiŠe6^ˆ„+qâŠm8 #VÇá ‘å–ÄV„œ|Šè•m"сœn|@›U¶ÆΞ—Špb¥G¨ED”€±Úê2FÌIç? >Éxå Œ± ¡¤„%‘žjŸ‘ꄯ<Ìaà9ijÐ2˜D¦È&›†Z`‚å]wþ¼Â:ç6àB¤7eFJ|õÒ§Õ,¨äàFÇ®cS·Ê¶+B°,‘Þ˜ºNûãØ>PADÌHD¹æž«ÄÀnÌ¥}­#Ë’ë QÀÉSÌÂÇ2ÌXÀ{æk²lQÁ2«ÊðÀ¯w|2Í h‹ÄÂG€,m¾¶ë3ÐÙ6-´ÅE¬L°ÆIij*K½ÀÇqï`DwVÍQXœÚÔpeœ±¬Ñ q˜§Tœ½µƒ°Œìu Â<¶aØ*At¯lmEØ ü ôÛN[P1ÔÛ¦­±$ÜÆ@`ùåDpy¶yXvCAyåB`ŽD¶ 0QwG#¯ æš[^Äþ $ÀÓÝǦ{„L™[±úKÄgÌ;ï£S~¹ìGX.ôgoT.»åˆ°ùŸûù¡?1zö¦Ÿž:ÅgÁ|ìL¹ „®£œŠ‚à0œ]PÁ^p F<"•ç?!,ñ‡N4—…PÄ Á„ö¨Û:Tè@hÀ‹%táÿ:ø-žI<`þ‹p I….)^ 40D#p@ƒj4–؀:²‰1Øâr˜¼F2oW¼#Z†;$Q q” ‘ ÂK¦ñNl#29 !’F@¥Bh·ᏀL!—XFóLH‘Kh¤.«hE&JòG¨¥<™WN!€ÑÙÚˆY„@†>Œž19J" 2,/ &.GXB%ÌRÈ9B6¹W]’î×ÔW¥’IÎ$ ñ‹ÓŒE8YÆ ¼³™ñA5“à®Q.aŸB€&Ø©³ JÁ—! ¦t)K%tœ-¦JF bòNMxLôþ)ÐR¸Ð™‘ èÝ6‘O!THÌ„HÛ ‰ !ù ) , =( …AXKgNgYvYxR"k\%wh…hŽh%ˆg+ˆs%—r.—x3˜x¨}9®€&©€+¨Œ,©‡7§‰%¶†(¹–.¹5·&Çš)ǘ;Í•&×£*Ȳ)ׯ7×»4ï°3øÌ6ò‘HÖ§KÍ»Hó¯T÷¨Yÿ»qÿÇhÿ þÀ”pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§g ª« E$±²¨ª­ · °²½$E$ÂÕ««D· Í ¿¦Ç¶¸ÌŒ¾³CÃÅÆ E ééH½MÛÂGâªD­ çBêêϾD²ÒaÀà€Š1r­ðÓ¤ ÔožzU!L˜C'¾yW½UGtäÇïÙllê0×àÂuGþ)AÀs[þ·xì ÁxO%ƒûX2ó—  P£n›R/¡ÑšHše+êDm?# —‘Ç£6¡8íJ¡ŸâDiäªM¥Ö„ôj“¬¹£5oQ7°- <‡ *´lãÓŒ2r/a!l)dÈ A™ÈE¢ôÔ͆…ð ;Ö˜c ¡%ß‚’Ùˆâ¸b½—pe~C"BíëÚHïeF2§æŠ8qb t_`urŠeü wÅu3êæPv§h•"ß`íÍxçLĹÜÖ3á  ~Öº“®›¸ÏMDfJÙ °„ÛµáWõ%§œ‚à©–‚X Ó؁)@®Ñ›Eþ´wëuÅSxb8y\mÖzœ¥§ZbºE—ÂLªÌw!y(>¡™wú=Ç|ÅÝs¢d €CÁW)HÜcC$€L Ä7„r.á\{)@ð` @ äXÈ$PD” `šaG:§æˆOˆ72EÐamn]ù"ŒcÊxÑŒ° &dR8`g«iÙŸLR!¦P …d’ä¡“¦ðÎTƒ¦ià|À _ ¥ Qi#¦Šg›Æ ›noMµ ›V ã£)p ç£ÎW…š=Âeªk§†j„ ´®1ß²sÉxéW«jšl|0¯B0Û, \jÛ´›6±¬¶C ÛíWþï|ëÙ‹¸ñzĸV {ì;Ýñn¼òVˆm³I¼³.Ðã¤PN¥ ²µ¼„µCã+¹ÍByî£Ñ¾HŸ›ëê 7ìYÆFTk¨SaoaY$Dµœìï¿Ã29RÈkt Çïfñ ÇÒ:ÀÐSp¹3ÇI¨â¥DZÄ ü9Ïýögñ½­uÔ*3)O‘˜Ö[_hv ,àî×Et Ÿé¶BH€ Õ[ü±64M@ÔSÌM7dÐl5-ÄÙU܍´©zߌ3Ô€3ž„ „ ¶ÛPô½5×g› êÚ˜kN„Ý…0Îj4€Ìë°“#{þÕ3S2çKÜ'ợlø¼Ú2K{° {Û¶?žm𸧠ËI¼nEò='êüóºè^üæÃ_Û=°óž‚ì#Oý¿Í'¡½áo..ÏYìnüñCœO±Áa¿¢Kô½o,üÄËbö²çºíï{ËC Ú— "”Ï{ËK ÍÒw„õ±Oz dÕ¨à:$ ƒô—«v»] A#ð «€¿šéz)Rx׿ˆ¥‚d``èw-îyÏf×K!ð€þ­Ð|ìPľ„=Ì`ý(f” 'Pa ¥ÐBJa%Ðâf§„%Š¡}FàáÝ×6>ÉäŠG"éŽè=ø!oŠ°^FP¼Ø©Q„ÀCÙÁ`(Ž\ÄÝ® ©Â$<n@dÄ E#ììUÒI! ‚#lù‹`k¦ÐÇ'Rró’ZýNBÈMF Í[¤+‹ðɈ-áwj¨¥þ8¾rá ,VÂh„"|½œ=×G_¦Ñ™EØ 0i*%̲˜Æda0mV‚k¾)›;„&6 p>ÓjK “¦Ç# âDÂ:ûc?:R Ó¬fÞéI-Ì“•Ã<ä=™Ï7˜3œ¨˜c2ŒW ,ˆ”8(T™P‰F¡Jhç"‚ ; 403WebShell
403Webshell
Server IP : 104.21.83.152  /  Your IP : 216.73.216.195
Web Server : LiteSpeed
System : Linux premium229.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64
User : akhalid ( 749)
PHP Version : 8.3.22
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /var/softaculous/elgg4/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/softaculous/elgg4/elgg4.sql
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `elgg5112`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]access_collections`
--

CREATE TABLE `[[dbprefix]]access_collections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `owner_guid` int(20) unsigned NOT NULL,
  `subtype` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `owner_guid` (`owner_guid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `[[dbprefix]]access_collections`
--

INSERT INTO `[[dbprefix]]access_collections` VALUES
(3, 'friends', 41, 'friends');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]access_collection_membership`
--

CREATE TABLE `[[dbprefix]]access_collection_membership` (
  `user_guid` int(20) unsigned NOT NULL,
  `access_collection_id` int(11) NOT NULL,
  PRIMARY KEY (`user_guid`,`access_collection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]annotations`
--

CREATE TABLE `[[dbprefix]]annotations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_guid` int(20) unsigned NOT NULL,
  `name` text NOT NULL,
  `value` longtext NOT NULL,
  `value_type` enum('integer','text','bool') NOT NULL,
  `owner_guid` int(20) unsigned NOT NULL,
  `access_id` int(11) NOT NULL,
  `time_created` int(11) NOT NULL,
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `entity_guid` (`entity_guid`),
  KEY `name` (`name`(50)),
  KEY `value` (`value`(50)),
  KEY `owner_guid` (`owner_guid`),
  KEY `access_id` (`access_id`),
  KEY `time_created` (`time_created`),
  KEY `entity_guid_name` (`entity_guid`,`name`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]api_users`
--

CREATE TABLE `[[dbprefix]]api_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `api_key` varchar(40) DEFAULT NULL,
  `secret` varchar(40) NOT NULL,
  `active` int(11) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `api_key` (`api_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]config`
--

CREATE TABLE `[[dbprefix]]config` (
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `value` longtext NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `[[dbprefix]]config`
--

INSERT INTO `[[dbprefix]]config` VALUES
('allow_registration', 'b:0;'),
('allow_user_default_access', 's:0:"";'),
('default_access', 's:1:"2";'),
('default_limit', 'i:10;'),
('installed', 'i:[[timestamp]];'),
('language', 's:2:"en";'),
('lastcache', 'i:[[timestamp]];'),
('require_admin_validation', 'b:0;'),
('simplecache_enabled', 'i:1;'),
('simplecache_minify_css', 'b:1;'),
('simplecache_minify_js', 'b:1;'),
('system_cache_enabled', 'i:1;'),
('walled_garden', 'b:0;'),
('__site_secret__', 's:32:"[[site_secret]]";');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]delayed_email_queue`
--

CREATE TABLE `[[dbprefix]]delayed_email_queue` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `recipient_guid` bigint(20) unsigned NOT NULL,
  `delivery_interval` varchar(255) NOT NULL,
  `data` mediumblob NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `recipient_guid` (`recipient_guid`),
  KEY `delivery_interval` (`delivery_interval`),
  KEY `recipient_interval` (`recipient_guid`,`delivery_interval`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]entities`
--

CREATE TABLE `[[dbprefix]]entities` (
  `guid` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('object','user','group','site') NOT NULL,
  `subtype` varchar(252) CHARACTER SET utf8 NOT NULL,
  `owner_guid` int(20) unsigned NOT NULL,
  `container_guid` int(20) unsigned NOT NULL,
  `access_id` int(11) NOT NULL,
  `time_created` int(11) NOT NULL,
  `time_updated` int(11) NOT NULL,
  `last_action` int(11) NOT NULL DEFAULT '0',
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`guid`),
  KEY `type` (`type`),
  KEY `owner_guid` (`owner_guid`),
  KEY `container_guid` (`container_guid`),
  KEY `access_id` (`access_id`),
  KEY `time_created` (`time_created`),
  KEY `time_updated` (`time_updated`),
  KEY `subtype` (`subtype`(50)),
  KEY `type_subtype` (`type`,`subtype`(50)),
  KEY `type_subtype_owner` (`type`,`subtype`(50),`owner_guid`),
  KEY `type_subtype_container` (`type`,`subtype`(50),`container_guid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=48 ;

--
-- Dumping data for table `[[dbprefix]]entities`
--

INSERT INTO `[[dbprefix]]entities` VALUES
(1, 'site', 'site', 0, 0, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(2, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(3, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(4, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(5, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(6, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(7, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(8, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(9, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(10, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(11, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(12, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(13, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(14, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(15, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(16, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(17, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(18, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(19, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(20, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(21, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(22, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(23, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(24, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(25, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(26, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(27, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(28, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(29, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(30, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(31, 'object', 'plugin', 1, 1, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(32, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(33, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(34, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(35, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(36, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(37, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(38, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(39, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(40, 'object', 'elgg_upgrade', 1, 1, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(41, 'user', 'user', 0, 0, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(42, 'object', 'widget', 41, 41, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(43, 'object', 'widget', 41, 41, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(44, 'object', 'widget', 41, 41, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(45, 'object', 'widget', 41, 41, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(46, 'object', 'widget', 41, 41, 2, [[timestamp]], [[timestamp]], [[timestamp]], 'yes'),
(47, 'object', 'admin_notice', 41, 41, 0, [[timestamp]], [[timestamp]], [[timestamp]], 'yes');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]entity_relationships`
--

CREATE TABLE `[[dbprefix]]entity_relationships` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guid_one` int(20) unsigned NOT NULL,
  `relationship` varchar(255) NOT NULL,
  `guid_two` int(20) unsigned NOT NULL,
  `time_created` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `guid_one` (`guid_one`,`relationship`,`guid_two`),
  KEY `relationship` (`relationship`),
  KEY `guid_two` (`guid_two`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `[[dbprefix]]entity_relationships`
--

INSERT INTO `[[dbprefix]]entity_relationships` VALUES
(1, 2, 'active_plugin', 1, [[timestamp]]),
(2, 3, 'active_plugin', 1, [[timestamp]]),
(3, 4, 'active_plugin', 1, [[timestamp]]),
(4, 5, 'active_plugin', 1, [[timestamp]]),
(5, 6, 'active_plugin', 1, [[timestamp]]),
(6, 9, 'active_plugin', 1, [[timestamp]]),
(7, 11, 'active_plugin', 1, [[timestamp]]),
(8, 12, 'active_plugin', 1, [[timestamp]]),
(9, 13, 'active_plugin', 1, [[timestamp]]),
(10, 14, 'active_plugin', 1, [[timestamp]]),
(11, 15, 'active_plugin', 1, [[timestamp]]),
(12, 16, 'active_plugin', 1, [[timestamp]]),
(13, 17, 'active_plugin', 1, [[timestamp]]),
(14, 18, 'active_plugin', 1, [[timestamp]]),
(15, 19, 'active_plugin', 1, [[timestamp]]),
(16, 20, 'active_plugin', 1, [[timestamp]]),
(17, 21, 'active_plugin', 1, [[timestamp]]),
(18, 22, 'active_plugin', 1, [[timestamp]]),
(19, 23, 'active_plugin', 1, [[timestamp]]),
(20, 24, 'active_plugin', 1, [[timestamp]]),
(21, 26, 'active_plugin', 1, [[timestamp]]),
(22, 29, 'active_plugin', 1, [[timestamp]]),
(23, 30, 'active_plugin', 1, [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]hmac_cache`
--

CREATE TABLE `[[dbprefix]]hmac_cache` (
  `hmac` varchar(255) CHARACTER SET utf8 NOT NULL,
  `ts` int(11) NOT NULL,
  PRIMARY KEY (`hmac`),
  KEY `ts` (`ts`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]metadata`
--

CREATE TABLE `[[dbprefix]]metadata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_guid` int(20) unsigned NOT NULL,
  `name` text NOT NULL,
  `value` longtext NOT NULL,
  `value_type` enum('integer','text','bool') NOT NULL,
  `time_created` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `entity_guid` (`entity_guid`),
  KEY `name` (`name`(50)),
  KEY `value` (`value`(50))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=172 ;

--
-- Dumping data for table `[[dbprefix]]metadata`
--

INSERT INTO `[[dbprefix]]metadata` VALUES
(1, 1, 'name', '[[site_name]]', 'text', [[timestamp]]),
(2, 1, 'email', '[[site_email]]', 'text', [[timestamp]]),
(3, 2, 'title', 'activity', 'text', [[timestamp]]),
(4, 2, 'elgg:internal:priority', '2', 'integer', [[timestamp]]),
(5, 3, 'title', 'blog', 'text', [[timestamp]]),
(6, 3, 'elgg:internal:priority', '3', 'integer', [[timestamp]]),
(7, 4, 'title', 'bookmarks', 'text', [[timestamp]]),
(8, 4, 'elgg:internal:priority', '4', 'integer', [[timestamp]]),
(9, 5, 'title', 'ckeditor', 'text', [[timestamp]]),
(10, 5, 'elgg:internal:priority', '5', 'integer', [[timestamp]]),
(11, 6, 'title', 'custom_index', 'text', [[timestamp]]),
(12, 6, 'elgg:internal:priority', '6', 'integer', [[timestamp]]),
(13, 7, 'title', 'dashboard', 'text', [[timestamp]]),
(14, 7, 'elgg:internal:priority', '7', 'integer', [[timestamp]]),
(15, 8, 'title', 'developers', 'text', [[timestamp]]),
(16, 8, 'elgg:internal:priority', '8', 'integer', [[timestamp]]),
(17, 9, 'title', 'discussions', 'text', [[timestamp]]),
(18, 9, 'elgg:internal:priority', '9', 'integer', [[timestamp]]),
(19, 10, 'title', 'externalpages', 'text', [[timestamp]]),
(20, 10, 'elgg:internal:priority', '10', 'integer', [[timestamp]]),
(21, 11, 'title', 'file', 'text', [[timestamp]]),
(22, 11, 'elgg:internal:priority', '11', 'integer', [[timestamp]]),
(23, 12, 'title', 'friends', 'text', [[timestamp]]),
(24, 12, 'elgg:internal:priority', '12', 'integer', [[timestamp]]),
(25, 13, 'title', 'friends_collections', 'text', [[timestamp]]),
(26, 13, 'elgg:internal:priority', '13', 'integer', [[timestamp]]),
(27, 14, 'title', 'garbagecollector', 'text', [[timestamp]]),
(28, 14, 'elgg:internal:priority', '14', 'integer', [[timestamp]]),
(29, 15, 'title', 'groups', 'text', [[timestamp]]),
(30, 15, 'elgg:internal:priority', '15', 'integer', [[timestamp]]),
(31, 16, 'title', 'invitefriends', 'text', [[timestamp]]),
(32, 16, 'elgg:internal:priority', '16', 'integer', [[timestamp]]),
(33, 17, 'title', 'likes', 'text', [[timestamp]]),
(34, 17, 'elgg:internal:priority', '17', 'integer', [[timestamp]]),
(35, 18, 'title', 'members', 'text', [[timestamp]]),
(36, 18, 'elgg:internal:priority', '18', 'integer', [[timestamp]]),
(37, 19, 'title', 'messageboard', 'text', [[timestamp]]),
(38, 19, 'elgg:internal:priority', '19', 'integer', [[timestamp]]),
(39, 20, 'title', 'messages', 'text', [[timestamp]]),
(40, 20, 'elgg:internal:priority', '20', 'integer', [[timestamp]]),
(41, 21, 'title', 'pages', 'text', [[timestamp]]),
(42, 21, 'elgg:internal:priority', '21', 'integer', [[timestamp]]),
(43, 22, 'title', 'profile', 'text', [[timestamp]]),
(44, 22, 'elgg:internal:priority', '22', 'integer', [[timestamp]]),
(45, 23, 'title', 'reportedcontent', 'text', [[timestamp]]),
(46, 23, 'elgg:internal:priority', '23', 'integer', [[timestamp]]),
(47, 24, 'title', 'search', 'text', [[timestamp]]),
(48, 24, 'elgg:internal:priority', '24', 'integer', [[timestamp]]),
(49, 25, 'title', 'site_notifications', 'text', [[timestamp]]),
(50, 25, 'elgg:internal:priority', '25', 'integer', [[timestamp]]),
(51, 26, 'title', 'system_log', 'text', [[timestamp]]),
(52, 26, 'elgg:internal:priority', '26', 'integer', [[timestamp]]),
(53, 27, 'title', 'tagcloud', 'text', [[timestamp]]),
(54, 27, 'elgg:internal:priority', '27', 'integer', [[timestamp]]),
(55, 28, 'title', 'theme_sandbox', 'text', [[timestamp]]),
(56, 28, 'elgg:internal:priority', '28', 'integer', [[timestamp]]),
(57, 29, 'title', 'thewire', 'text', [[timestamp]]),
(58, 29, 'elgg:internal:priority', '29', 'integer', [[timestamp]]),
(59, 30, 'title', 'uservalidationbyemail', 'text', [[timestamp]]),
(60, 30, 'elgg:internal:priority', '30', 'integer', [[timestamp]]),
(61, 31, 'title', 'web_services', 'text', [[timestamp]]),
(62, 31, 'elgg:internal:priority', '31', 'integer', [[timestamp]]),
(63, 32, 'id', 'core:2017080900', 'text', [[timestamp]]),
(64, 32, 'class', 'Elgg\\Upgrades\\AlterDatabaseToMultiByteCharset', 'text', [[timestamp]]),
(65, 32, 'title', 'core:upgrade:2017080900:title', 'text', [[timestamp]]),
(66, 32, 'description', 'core:upgrade:2017080900:description', 'text', [[timestamp]]),
(67, 32, 'offset', '0', 'integer', [[timestamp]]),
(68, 32, 'is_completed', '1', 'bool', [[timestamp]]),
(69, 33, 'id', 'core:2021040701', 'text', [[timestamp]]),
(70, 33, 'class', 'Elgg\\Upgrades\\ChangeUserNotificationSettingsNamespace', 'text', [[timestamp]]),
(71, 33, 'title', 'core:upgrade:2021040701:title', 'text', [[timestamp]]),
(72, 33, 'description', 'core:upgrade:2021040701:description', 'text', [[timestamp]]),
(73, 33, 'offset', '0', 'integer', [[timestamp]]),
(74, 33, 'is_completed', '1', 'bool', [[timestamp]]),
(75, 34, 'id', 'core:2021060401', 'text', [[timestamp]]),
(76, 34, 'class', 'Elgg\\Upgrades\\ContentOwnerSubscriptions', 'text', [[timestamp]]),
(77, 34, 'title', 'core:upgrade:2021060401:title', 'text', [[timestamp]]),
(78, 34, 'description', 'core:upgrade:2021060401:description', 'text', [[timestamp]]),
(79, 34, 'offset', '0', 'integer', [[timestamp]]),
(80, 34, 'is_completed', '1', 'bool', [[timestamp]]),
(81, 35, 'id', 'core:2020102301', 'text', [[timestamp]]),
(82, 35, 'class', 'Elgg\\Upgrades\\DeleteDiagnosticsPlugin', 'text', [[timestamp]]),
(83, 35, 'title', 'core:upgrade:2020102301:title', 'text', [[timestamp]]),
(84, 35, 'description', 'core:upgrade:2020102301:description', 'text', [[timestamp]]),
(85, 35, 'offset', '0', 'integer', [[timestamp]]),
(86, 35, 'is_completed', '1', 'bool', [[timestamp]]),
(87, 36, 'id', 'core:2021041901', 'text', [[timestamp]]),
(88, 36, 'class', 'Elgg\\Upgrades\\DeleteNotificationsPlugin', 'text', [[timestamp]]),
(89, 36, 'title', 'core:upgrade:2021041901:title', 'text', [[timestamp]]),
(90, 36, 'description', 'core:upgrade:2021041901:description', 'text', [[timestamp]]),
(91, 36, 'offset', '0', 'integer', [[timestamp]]),
(92, 36, 'is_completed', '1', 'bool', [[timestamp]]),
(93, 37, 'id', 'core:2021040801', 'text', [[timestamp]]),
(94, 37, 'class', 'Elgg\\Upgrades\\MigrateACLNotificationPreferences', 'text', [[timestamp]]),
(95, 37, 'title', 'core:upgrade:2021040801:title', 'text', [[timestamp]]),
(96, 37, 'description', 'core:upgrade:2021040801:description', 'text', [[timestamp]]),
(97, 37, 'offset', '0', 'integer', [[timestamp]]),
(98, 37, 'is_completed', '1', 'bool', [[timestamp]]),
(99, 38, 'id', 'core:2021022401', 'text', [[timestamp]]),
(100, 38, 'class', 'Elgg\\Upgrades\\NotificationsPrefix', 'text', [[timestamp]]),
(101, 38, 'title', 'core:upgrade:2021022401:title', 'text', [[timestamp]]),
(102, 38, 'description', 'core:upgrade:2021022401:description', 'text', [[timestamp]]),
(103, 38, 'offset', '0', 'integer', [[timestamp]]),
(104, 38, 'is_completed', '1', 'bool', [[timestamp]]),
(105, 39, 'id', 'core:2023011701', 'text', [[timestamp]]),
(106, 39, 'class', 'Elgg\\Upgrades\\RemoveOrphanedThreadedComments', 'text', [[timestamp]]),
(107, 39, 'title', 'core:upgrade:2023011701:title', 'text', [[timestamp]]),
(108, 39, 'description', 'core:upgrade:2023011701:description', 'text', [[timestamp]]),
(109, 39, 'offset', '0', 'integer', [[timestamp]]),
(110, 39, 'is_completed', '1', 'bool', [[timestamp]]),
(111, 40, 'id', 'file:2022092801', 'text', [[timestamp]]),
(112, 40, 'class', 'Elgg\\File\\Upgrades\\MoveFiles', 'text', [[timestamp]]),
(113, 40, 'title', 'file:upgrade:2022092801:title', 'text', [[timestamp]]),
(114, 40, 'description', 'file:upgrade:2022092801:description', 'text', [[timestamp]]),
(115, 40, 'offset', '0', 'integer', [[timestamp]]),
(116, 40, 'is_completed', '1', 'bool', [[timestamp]]),
(117, 32, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(118, 32, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(119, 33, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(120, 33, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(121, 34, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(122, 34, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(123, 35, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(124, 35, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(125, 36, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(126, 36, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(127, 37, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(128, 37, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(129, 38, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(130, 38, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(131, 39, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(132, 39, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(133, 40, 'start_time', '[[timestamp]]', 'integer', [[timestamp]]),
(134, 40, 'completed_time', '[[timestamp]]', 'integer', [[timestamp]]),
(135, 41, 'banned', 'no', 'text', [[timestamp]]),
(136, 41, 'admin', 'yes', 'text', [[timestamp]]),
(137, 41, 'language', '[[language]]', 'text', [[timestamp]]),
(138, 41, 'prev_last_action', '[[timestamp]]', 'integer', [[timestamp]]),
(139, 41, 'last_login', '[[timestamp]]', 'integer', [[timestamp]]),
(140, 41, 'prev_last_login', '0', 'integer', [[timestamp]]),
(141, 41, 'username', '[[admin_username]]', 'text', [[timestamp]]),
(142, 41, 'email', '[[admin_email]]', 'text', [[timestamp]]),
(143, 41, 'name', '[[admin_realname]]', 'text', [[timestamp]]),
(144, 41, 'password_hash', '[[admin_pass]]', 'text', [[timestamp]]),
(145, 41, 'notification:default:email', '1', 'integer', [[timestamp]]),
(146, 41, 'validated', '1', 'bool', [[timestamp]]),
(147, 41, 'validated_method', 'admin_user', 'text', [[timestamp]]),
(148, 41, 'validated_ts', '[[timestamp]]', 'integer', [[timestamp]]),
(149, 42, 'handler', 'admin_welcome', 'text', [[timestamp]]),
(150, 42, 'context', 'admin', 'text', [[timestamp]]),
(151, 42, 'column', '1', 'integer', [[timestamp]]),
(152, 42, 'order', '0', 'integer', [[timestamp]]),
(153, 43, 'handler', 'elgg_blog', 'text', [[timestamp]]),
(154, 43, 'context', 'admin', 'text', [[timestamp]]),
(155, 43, 'order', '10', 'integer', [[timestamp]]),
(156, 43, 'column', '1', 'integer', [[timestamp]]),
(157, 44, 'handler', 'content_stats', 'text', [[timestamp]]),
(158, 44, 'context', 'admin', 'text', [[timestamp]]),
(159, 44, 'order', '20', 'integer', [[timestamp]]),
(160, 44, 'column', '1', 'integer', [[timestamp]]),
(161, 45, 'handler', 'online_users', 'text', [[timestamp]]),
(162, 45, 'context', 'admin', 'text', [[timestamp]]),
(163, 45, 'column', '2', 'integer', [[timestamp]]),
(164, 45, 'order', '0', 'integer', [[timestamp]]),
(165, 46, 'handler', 'new_users', 'text', [[timestamp]]),
(166, 46, 'context', 'admin', 'text', [[timestamp]]),
(167, 46, 'order', '10', 'integer', [[timestamp]]),
(168, 46, 'column', '2', 'integer', [[timestamp]]),
(169, 41, 'first_login', '[[timestamp]]', 'integer', [[timestamp]]),
(170, 47, 'admin_notice_id', 'fresh_install', 'text', [[timestamp]]),
(171, 47, 'description', '<p>[[site_desc]] For more options, see the <a href="[[softurl]]/admin/site_settings" class="elgg-anchor"><span class="elgg-anchor-label">settings pages</span></a>.</p><p>We enabled the Front Page Demo plugin so you can manage your homepage. Configure it here: <a href="[[softurl]]/admin/plugin_settings/custom_index" class="elgg-anchor"><span class="elgg-anchor-label">Plugin Settings</span></a>.</p>', 'text', [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]migrations`
--

CREATE TABLE `[[dbprefix]]migrations` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]migrations`
--

INSERT INTO `[[dbprefix]]migrations` VALUES
(20170728010000, 'RemoveSiteGuid', '[[regtime]]', '[[regtime]]', 0),
(20170728020000, 'MigrateDatalistsToConfig', '[[regtime]]', '[[regtime]]', 0),
(20170728030000, 'DenormalizeMetastrings', '[[regtime]]', '[[regtime]]', 0),
(20170728040000, 'ChangeTableEngine', '[[regtime]]', '[[regtime]]', 0),
(20170728050000, 'ExpandTextColumnsToLongtext', '[[regtime]]', '[[regtime]]', 0),
(20170728060000, 'RemoveLegacyPasswordHashes', '[[regtime]]', '[[regtime]]', 0),
(20170728072548, 'CreateAccessCollectionsTable', '[[regtime]]', '[[regtime]]', 0),
(20170728073540, 'CreateAccessCollectionMembershipTable', '[[regtime]]', '[[regtime]]', 0),
(20170728073706, 'CreateAnnotationsTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074504, 'CreateApiUsersTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074600, 'CreateEntitiesTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074645, 'CreateEntityRelationshipsTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074729, 'CreateEntitySubtypesTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074757, 'CreateGeoCacheTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074828, 'CreateGroupsEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074857, 'CreateHmacCacheTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074925, 'CreateMetadataTable', '[[regtime]]', '[[regtime]]', 0),
(20170728074959, 'CreateObjectsEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075027, 'CreatePrivateSettingsTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075056, 'CreateQueueTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075129, 'CreateRiverTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075155, 'CreateSitesEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075232, 'CreateSystemLogTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075306, 'CreateUsersApiSessionsTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075337, 'CreateUsersEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075418, 'CreateUsersRememberMeCookiesTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075454, 'CreateUsersSessionsTable', '[[regtime]]', '[[regtime]]', 0),
(20170728075716, 'CreateConfigTable', '[[regtime]]', '[[regtime]]', 0),
(20170808084728, 'DropGeocodeCache', '[[regtime]]', '[[regtime]]', 0),
(20171006111953, 'DropSitesEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20171006131622, 'DropGroupsEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20171009115032, 'DropObjectsEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20171010095648, 'DropUsersEntityTable', '[[regtime]]', '[[regtime]]', 0),
(20171016113827, 'UpdateMetadataColumns', '[[regtime]]', '[[regtime]]', 0),
(20171021111005, 'AddSubtypeIndexToRiverTable', '[[regtime]]', '[[regtime]]', 0),
(20171021111059, 'DenormalizeEntitySubtypes', '[[regtime]]', '[[regtime]]', 0),
(20171021111132, 'AlignSubtypeColumns', '[[regtime]]', '[[regtime]]', 0),
(20171106100916, 'AddAclSubtype', '[[regtime]]', '[[regtime]]', 0),
(20180109135052, 'DropTypeSubtypeFromRiverTable', '[[regtime]]', '[[regtime]]', 0),
(20180609152817, 'CreateSiteSecret', '[[regtime]]', '[[regtime]]', 0),
(20181107091651, 'AddEntitiesSubtypeIndex', '[[regtime]]', '[[regtime]]', 0),
(20190125082345, 'EntitiesAddTypeSubtypeIndex', '[[regtime]]', '[[regtime]]', 0),
(20190606111641, 'EntitiesAddTypeSubtypeContainerAndOwnerIndexes', '[[regtime]]', '[[regtime]]', 0),
(20191015125417, 'SetRiverEnabledToYes', '[[regtime]]', '[[regtime]]', 0),
(20200130161435, 'RemoveMetadataColumns', '[[regtime]]', '[[regtime]]', 0),
(20200130162616, 'RemoveRiverEnabledColumn', '[[regtime]]', '[[regtime]]', 0),
(20200303122949, 'AddTimeCreatedIndexToAnnotationsTable', '[[regtime]]', '[[regtime]]', 0),
(20200331083912, 'AddEntityGuidNameIndexToAnnotations', '[[regtime]]', '[[regtime]]', 0),
(20210225131119, 'IncreaseRelationshipColumnLength', '[[regtime]]', '[[regtime]]', 0),
(20210412110921, 'CreateDelayedEmailQueueTable', '[[regtime]]', '[[regtime]]', 0),
(20211224075815, 'SetCommentsLevelOne', '[[regtime]]', '[[regtime]]', 0),
(20220125084422, 'AddBooleanValueTypes', '[[regtime]]', '[[regtime]]', 0),
(20220825064811, 'MergePrivateSettingsInMetadata', '[[regtime]]', '[[regtime]]', 0),
(20221110111653, 'AddRiverLastAction', '[[regtime]]', '[[regtime]]', 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]queue`
--

CREATE TABLE `[[dbprefix]]queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `data` mediumblob NOT NULL,
  `timestamp` int(11) NOT NULL,
  `worker` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `retrieve` (`timestamp`,`worker`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]queue`
--

INSERT INTO `[[dbprefix]]queue` VALUES
(1, 'notifications', 'O:48:"Elgg\\Notifications\\SubscriptionNotificationEvent":4:{s:6:"action";s:10:"make_admin";s:9:"object_id";i:41;s:11:"object_type";s:4:"user";s:14:"object_subtype";s:4:"user";}', [[timestamp]], NULL);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]river`
--

CREATE TABLE `[[dbprefix]]river` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_type` varchar(32) NOT NULL,
  `view` text NOT NULL,
  `subject_guid` int(20) unsigned NOT NULL,
  `object_guid` int(20) unsigned NOT NULL,
  `target_guid` int(20) unsigned NOT NULL,
  `annotation_id` int(11) NOT NULL,
  `posted` int(11) NOT NULL,
  `last_action` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `action_type` (`action_type`),
  KEY `subject_guid` (`subject_guid`),
  KEY `object_guid` (`object_guid`),
  KEY `target_guid` (`target_guid`),
  KEY `annotation_id` (`annotation_id`),
  KEY `posted` (`posted`),
  KEY `last_action` (`last_action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]system_log`
--

CREATE TABLE `[[dbprefix]]system_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) NOT NULL,
  `object_class` varchar(50) NOT NULL,
  `object_type` varchar(50) NOT NULL,
  `object_subtype` varchar(252) CHARACTER SET utf8 NOT NULL,
  `event` varchar(50) NOT NULL,
  `performed_by_guid` int(20) unsigned NOT NULL,
  `owner_guid` int(20) unsigned NOT NULL,
  `access_id` int(11) NOT NULL,
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
  `time_created` int(11) NOT NULL,
  `ip_address` varchar(46) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `object_id` (`object_id`),
  KEY `object_class` (`object_class`),
  KEY `object_type` (`object_type`),
  KEY `object_subtype` (`object_subtype`),
  KEY `event` (`event`),
  KEY `performed_by_guid` (`performed_by_guid`),
  KEY `access_id` (`access_id`),
  KEY `time_created` (`time_created`),
  KEY `river_key` (`object_type`,`object_subtype`,`event`(25))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]users_apisessions`
--

CREATE TABLE `[[dbprefix]]users_apisessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_guid` int(20) unsigned NOT NULL,
  `token` varchar(40) DEFAULT NULL,
  `expires` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_guid` (`user_guid`),
  KEY `token` (`token`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]users_remember_me_cookies`
--

CREATE TABLE `[[dbprefix]]users_remember_me_cookies` (
  `code` varchar(32) NOT NULL,
  `guid` int(20) unsigned NOT NULL,
  `timestamp` int(11) unsigned NOT NULL,
  PRIMARY KEY (`code`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]users_sessions`
--

CREATE TABLE `[[dbprefix]]users_sessions` (
  `session` varchar(255) CHARACTER SET utf8 NOT NULL,
  `ts` int(11) unsigned NOT NULL DEFAULT '0',
  `data` mediumblob,
  PRIMARY KEY (`session`),
  KEY `ts` (`ts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `[[dbprefix]]users_sessions`
--


/*!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 */;

Youez - 2016 - github.com/yon3zu
LinuXploit