 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `pconfig` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `uid` int(11) NOT NULL DEFAULT '0',
-  `cat` varbinary(255) NOT NULL DEFAULT '',
-  `k` varbinary(255) NOT NULL DEFAULT '',
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'User id',
+  `cat` varbinary(50) NOT NULL DEFAULT '',
+  `k` varbinary(100) NOT NULL DEFAULT '',
   `v` mediumtext,
   PRIMARY KEY (`id`),
   UNIQUE KEY `uid_cat_k` (`uid`,`cat`,`k`)
-) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4;
+) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='personal (per user) configuration storage';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --


LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` VALUES (1,'758d682b1559b10e589ca69032940355','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355',6,6,5,'wall',1,0,1,'urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/avatar/6.jpg',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/avatar/6.jpg','','Hi, my name is friendica5, I am new here!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','',NULL,'lang=english;0.26171428571429:italian;0.20561904761905:swahili;0.19666666666667','http://friendica.local/display/758d682b1559b10e589ca69032940355','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,1,0,1,0,'dfrn','f6e9f0ecd605b649f4bb2f9025ef7132','Hi, my name is friendica5, I am new here!',1),(2,'758d682b1559b10e589ca69032940355','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355',0,19,5,'remote',0,0,2,'urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/avatar/6.jpg',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/avatar/6.jpg','','Hi, my name is friendica5, I am new here!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.26171428571429:italian;0.20561904761905:swahili;0.19666666666667','http://friendica.local/display/758d682b1559b10e589ca69032940355','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','f6e9f0ecd605b649f4bb2f9025ef7132','Hi, my name is friendica5, I am new here!',1),(3,'758d682b1559b10e589ca69032940355','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355',2,14,5,'remote',0,0,3,'urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:08',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/profile/6.jpg',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/profile/6.jpg','','Hi, my name is friendica5, I am new here!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.26171428571429:italian;0.20561904761905:swahili;0.19666666666667','http://friendica.local/display/758d682b1559b10e589ca69032940355','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','f6e9f0ecd605b649f4bb2f9025ef7132','Hi, my name is friendica5, I am new here!',1),(4,'758d682b1559b10e589ca69032940355','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355',5,18,5,'remote',0,0,4,'urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','','urn:X-dfrn:friendica.local:6:758d682b1559b10e589ca69032940355','2017-09-07 09:16:08','2017-09-07 09:16:08','2017-09-07 09:16:09','2017-09-07 09:16:09','2017-09-07 09:16:09',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/profile/6.jpg',19,'friendica5','http://friendica.local/profile/friendica5','http://friendica.local/photo/profile/6.jpg','','Hi, my name is friendica5, I am new here!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.26171428571429:italian;0.20561904761905:swahili;0.19666666666667','http://friendica.local/display/758d682b1559b10e589ca69032940355','',0,'','','','','','','','','','',0,0,0,1,0,0,0,1,0,0,0,1,0,'dfrn','f6e9f0ecd605b649f4bb2f9025ef7132','Hi, my name is friendica5, I am new here!',1),(5,'758d682b1359b10e79d3f8f310513025','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025',3,3,2,'wall',1,0,5,'urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','2017-09-07 09:16:41','2017-09-07 09:16:41','2017-09-07 09:16:41','2017-09-07 09:16:41','2017-09-07 09:16:41',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/avatar/3.jpg',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/avatar/3.jpg','','Hello, I\'m friendica2! How are you?','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','',NULL,'lang=italian;0.16459770114943:english;0.16:hawaiian;0.13287356321839','http://friendica.local/display/758d682b1359b10e79d3f8f310513025','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,1,0,1,0,'dfrn','cb3a2ad36c8910dac777062647b0e739','Hello, I\'m friendica2! How are you?',1),(6,'758d682b1359b10e79d3f8f310513025','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025',0,20,2,'remote',0,0,6,'urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','2017-09-07 09:16:41','2017-09-07 09:16:41','2017-09-07 09:16:42','2017-09-07 09:16:41','2017-09-07 09:16:42',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/avatar/3.jpg',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/avatar/3.jpg','','Hello, I\'m friendica2! How are you?','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=italian;0.16459770114943:english;0.16:hawaiian;0.13287356321839','http://friendica.local/display/758d682b1359b10e79d3f8f310513025','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','cb3a2ad36c8910dac777062647b0e739','Hello, I\'m friendica2! How are you?',1),(7,'758d682b1359b10e79d3f8f310513025','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025',2,8,2,'remote',0,0,7,'urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','2017-09-07 09:16:41','2017-09-07 09:16:41','2017-09-07 09:16:42','2017-09-07 09:16:42','2017-09-07 09:16:42',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/profile/3.jpg',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/profile/3.jpg','','Hello, I\'m friendica2! How are you?','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=italian;0.16459770114943:english;0.16:hawaiian;0.13287356321839','http://friendica.local/display/758d682b1359b10e79d3f8f310513025','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','cb3a2ad36c8910dac777062647b0e739','Hello, I\'m friendica2! How are you?',1),(8,'758d682b1359b10e79d3f8f310513025','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025',4,15,2,'remote',0,0,8,'urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','','urn:X-dfrn:friendica.local:3:758d682b1359b10e79d3f8f310513025','2017-09-07 09:16:41','2017-09-07 09:16:41','2017-09-07 09:16:42','2017-09-07 09:16:42','2017-09-07 09:16:42',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/profile/3.jpg',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/profile/3.jpg','','Hello, I\'m friendica2! How are you?','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=italian;0.16459770114943:english;0.16:hawaiian;0.13287356321839','http://friendica.local/display/758d682b1359b10e79d3f8f310513025','',0,'','','','','','','','','','',0,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','cb3a2ad36c8910dac777062647b0e739','Hello, I\'m friendica2! How are you?',1),(9,'758d682b1859b10ebd6abab685903735','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735',2,2,1,'wall',1,0,9,'urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','2017-09-07 09:17:49','2017-09-07 09:17:49','2017-09-07 09:18:24','2017-09-07 09:17:49','2017-09-07 09:18:24',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-5.jpg?ts=1504775575',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-5.jpg?ts=1504775575','','Hey, group2, this post is only visible to you!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','',NULL,'lang=english;0.32923076923077:czech;0.1965811965812:slovak;0.19179487179487','http://friendica.local/display/758d682b1859b10ebd6abab685903735','',0,'','','','','','','','<8>','','',1,0,0,1,0,0,0,0,0,1,0,0,0,'dfrn','d5d5408ee800a3c1a3b3d4b2826935f2','Hey, group2, this post is only visible to you!',0),(10,'758d682b1859b10ebd6abab685903735','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735',4,9,1,'remote',0,0,10,'urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','2017-09-07 09:17:49','2017-09-07 09:17:49','2017-09-07 09:18:24','2017-09-07 09:17:49','2017-09-07 09:18:24',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575','','Hey, group2, this post is only visible to you!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.32923076923077:czech;0.1965811965812:slovak;0.19179487179487','http://friendica.local/display/758d682b1859b10ebd6abab685903735','',0,'','','','','','','','','','',1,0,0,1,0,0,0,0,0,0,0,0,0,'dfrn','d5d5408ee800a3c1a3b3d4b2826935f2','Hey, group2, this post is only visible to you!',0),(11,'758d682b1859b10ebd6abab685903735','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735',6,13,1,'remote',0,0,11,'urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','2017-09-07 09:17:49','2017-09-07 09:17:49','2017-09-07 09:18:25','2017-09-07 09:17:49','2017-09-07 09:18:25',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575','','Hey, group2, this post is only visible to you!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.32923076923077:czech;0.1965811965812:slovak;0.19179487179487','http://friendica.local/display/758d682b1859b10ebd6abab685903735','',0,'','','','','','','','','','',1,0,0,1,0,0,0,1,0,0,0,0,0,'dfrn','d5d5408ee800a3c1a3b3d4b2826935f2','Hey, group2, this post is only visible to you!',0),(12,'758d682b1059b10ee096f38798595234','urn:X-dfrn:friendica.local:4:758d682b1059b10ee096f38798595234',4,4,3,'remote-comment',0,6,10,'urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24',22,'friendica3','http://friendica.local/profile/friendica3','http://friendica.local/photo/avatar/4.jpg',22,'friendica3','http://friendica.local/profile/friendica3','http://friendica.local/photo/avatar/4.jpg','','Cool!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/comment','','',NULL,'lang=welsh;0.30333333333333:romanian;0.24583333333333:portuguese;0.24583333333333','http://friendica.local/display/758d682b1059b10ee096f38798595234','',0,'','','','','','','','','','',1,0,0,1,0,0,0,0,0,1,0,1,0,'dfrn','481164a1e08e1182a8c3476458754cfe','Cool!',0),(13,'758d682b1059b10ee096f38798595234','urn:X-dfrn:friendica.local:4:758d682b1059b10ee096f38798595234',2,10,3,'remote-comment',1,6,9,'urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24',22,'friendica3','http://friendica.local/profile/friendica3','http://friendica.local/photo/profile/4.jpg',22,'friendica3','http://friendica.local/profile/friendica3','http://friendica.local/photo/profile/4.jpg','','Cool!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/comment','','','','lang=welsh;0.30333333333333:romanian;0.24583333333333:portuguese;0.24583333333333','http://friendica.local/display/758d682b1059b10ee096f38798595234','',0,'','','','','','','','<8>','','',1,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','481164a1e08e1182a8c3476458754cfe','Cool!',0),(14,'758d682b1059b10ee096f38798595234','urn:X-dfrn:friendica.local:4:758d682b1059b10ee096f38798595234',6,13,3,'remote',0,6,11,'urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','','urn:X-dfrn:friendica.local:2:758d682b1859b10ebd6abab685903735','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:24','2017-09-07 09:18:25','2017-09-07 09:18:25',22,'friendica3','http://friendica.local/profile/friendica3','http://friendica.local/photo/01ff45af20fe4c6fb230e6fc773f3ef8-4.jpg?ts=1504775904',22,'friendica3','http://friendica.local/profile/friendica3','http://friendica.local/photo/01ff45af20fe4c6fb230e6fc773f3ef8-4.jpg?ts=1504775904','','Cool!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/comment','','','','lang=welsh;0.30333333333333:romanian;0.24583333333333:portuguese;0.24583333333333','http://friendica.local/display/758d682b1059b10ee096f38798595234','',0,'','','','','','','','','','',1,0,0,1,0,0,0,1,0,0,0,1,0,'dfrn','481164a1e08e1182a8c3476458754cfe','Cool!',0),(15,'758d682b1459b10f0be17c3206121357','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357',2,2,1,'wall',1,0,15,'urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','2017-09-07 09:19:07','2017-09-07 09:19:07','2017-09-07 09:19:28','2017-09-07 09:19:07','2017-09-07 09:19:28',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-5.jpg?ts=1504775575',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-5.jpg?ts=1504775575','','And this post goes to group1 only!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','',NULL,'lang=english;0.43118279569892:pidgin;0.29258064516129:lithuanian;0.21688172043011','http://friendica.local/display/758d682b1459b10f0be17c3206121357','',0,'','','','','','','','<7>','','',1,0,0,1,0,0,0,0,0,1,0,0,0,'dfrn','55a23b185f917e31a5b959328b696300','And this post goes to group1 only!',0),(16,'758d682b1459b10f0be17c3206121357','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357',3,7,1,'remote',0,0,16,'urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','2017-09-07 09:19:07','2017-09-07 09:19:07','2017-09-07 09:19:28','2017-09-07 09:19:08','2017-09-07 09:19:28',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575','','And this post goes to group1 only!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.43118279569892:pidgin;0.29258064516129:lithuanian;0.21688172043011','http://friendica.local/display/758d682b1459b10f0be17c3206121357','',0,'','','','','','','','','','',1,0,0,1,0,0,0,0,0,0,0,0,0,'dfrn','55a23b185f917e31a5b959328b696300','And this post goes to group1 only!',0),(17,'758d682b1459b10f0be17c3206121357','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357',5,11,1,'remote',0,0,17,'urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','2017-09-07 09:19:07','2017-09-07 09:19:07','2017-09-07 09:19:28','2017-09-07 09:19:08','2017-09-07 09:19:28',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575',21,'friendica1','http://friendica.local/profile/friendica1','http://friendica.local/photo/4b7db531ad1920a7cb8fb76aed46ddd9-4.jpg?ts=1504775575','','And this post goes to group1 only!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/note','','','','lang=english;0.43118279569892:pidgin;0.29258064516129:lithuanian;0.21688172043011','http://friendica.local/display/758d682b1459b10f0be17c3206121357','',0,'','','','','','','','','','',1,0,0,1,0,0,0,1,0,0,0,0,0,'dfrn','55a23b185f917e31a5b959328b696300','And this post goes to group1 only!',0),(18,'758d682b2059b10f204f9c2684001373','urn:X-dfrn:friendica.local:3:758d682b2059b10f204f9c2684001373',3,3,2,'remote-comment',0,6,16,'urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/avatar/3.jpg',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/avatar/3.jpg','','Yay!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/comment','','',NULL,'lang=tagalog;0.41777777777778:somali;0.35111111111111:swahili;0.32777777777778','http://friendica.local/display/758d682b2059b10f204f9c2684001373','',0,'','','','','','','','','','',1,0,0,1,0,0,0,0,0,1,0,1,0,'dfrn','0e54fc6a9dba79c2bc03ac08f3bf4a27','Yay!',0),(19,'758d682b2059b10f204f9c2684001373','urn:X-dfrn:friendica.local:3:758d682b2059b10f204f9c2684001373',2,8,2,'remote-comment',1,6,15,'urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/profile/3.jpg',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/profile/3.jpg','','Yay!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/comment','','','','lang=tagalog;0.41777777777778:somali;0.35111111111111:swahili;0.32777777777778','http://friendica.local/display/758d682b2059b10f204f9c2684001373','',0,'','','','','','','','<7>','','',1,0,0,1,0,0,0,0,0,0,0,1,0,'dfrn','0e54fc6a9dba79c2bc03ac08f3bf4a27','Yay!',0),(20,'758d682b2059b10f204f9c2684001373','urn:X-dfrn:friendica.local:3:758d682b2059b10f204f9c2684001373',5,11,2,'remote',0,6,17,'urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','','urn:X-dfrn:friendica.local:2:758d682b1459b10f0be17c3206121357','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28','2017-09-07 09:19:28',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/5b0e9c6920adcf8efafaf3743d0e0c6c-4.jpg?ts=1504775802',20,'friendica2','http://friendica.local/profile/friendica2','http://friendica.local/photo/5b0e9c6920adcf8efafaf3743d0e0c6c-4.jpg?ts=1504775802','','Yay!','','http://activitystrea.ms/schema/1.0/post','http://activitystrea.ms/schema/1.0/comment','','','','lang=tagalog;0.41777777777778:somali;0.35111111111111:swahili;0.32777777777778','http://friendica.local/display/758d682b2059b10f204f9c2684001373','',0,'','','','','','','','','','',1,0,0,1,0,0,0,1,0,0,0,1,0,'dfrn','0e54fc6a9dba79c2bc03ac08f3bf4a27','Yay!',0);
/*!40000 ALTER TABLE `item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item_id`
--

DROP TABLE IF EXISTS `item_id`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item_id` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iid` int(11) NOT NULL DEFAULT '0',
  `uid` int(11) NOT NULL DEFAULT '0',
  `sid` varchar(255) NOT NULL DEFAULT '',
  `service` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `sid` (`sid`(191)),
  KEY `service` (`service`(32)),
  KEY `iid` (`iid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item_id`
--

LOCK TABLES `item_id` WRITE;
/*!40000 ALTER TABLE `item_id` DISABLE KEYS */;
/*!40000 ALTER TABLE `item_id` ENABLE KEYS */;
UNLOCK TABLES;

--

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `intro` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'sequential ID',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'User id',
  `fid` int(10) unsigned NOT NULL DEFAULT '0',
  `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
  `knowyou` tinyint(1) NOT NULL DEFAULT '0',
  `duplex` tinyint(1) NOT NULL DEFAULT '0',
  `note` text,
