[horde] Mnemo table crashed

[josef radinger]

On Thu, 2022-06-09 at 19:48 +0300, Jānis wrote:
> Hi!
> 
> Due to some unfortunate event I have my mnemo_memos file crashed
> and,  
> it seems, I have to re-create the mnemo tables.
> 
> Where can I find table schemes for MySQL? Tried to find them in the  
> package, but... Any other method?
> 
> Janis
> 

that is the schema from my live-installation:
DROP TABLE IF EXISTS `mnemo_memos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_memos` (
  `memo_owner` varchar(255) NOT NULL,
  `memo_id` varchar(32) NOT NULL,
  `memo_uid` varchar(255) NOT NULL,
  `memo_desc` varchar(255) NOT NULL,
  `memo_body` text,
  `memo_private` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`memo_owner`,`memo_id`),
  KEY `index_mnemo_memos_on_memo_owner` (`memo_owner`),
  KEY `index_mnemo_memos_on_memo_uid` (`memo_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

maybe you want to look into:
https://github.com/horde/mnemo/tree/master/migration

hope that helps

yours