[Tickets #12498] Re: SQL Syntax error or access violation updating Horde_History DB schema

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: https://bugs.horde.org/ticket/12498
------------------------------------------------------------------------------
  Ticket           | 12498
  Aktualisiert Von | unihb at uni-bremen.de
  Zusammenfassung  | SQL Syntax error or access violation updating
                   | Horde_History DB schema
  Warteschlange    | Horde Framework Packages
  Version          | Git master
  Typ              | Bug
  Status           | Resolved
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


unihb at uni-bremen.de (2024-01-02 12:50) hat geschrieben:

>> Is my database structure ok?
>> Can someone give me the right sql command to fix the upgrade?

Moin!
I use this:

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_histories` (
   `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `object_uid` varchar(255) NOT NULL,
   `history_action` varchar(32) NOT NULL,
   `history_ts` bigint(20) NOT NULL,
   `history_desc` text DEFAULT NULL,
   `history_who` varchar(255) DEFAULT NULL,
   `history_extra` text DEFAULT NULL,
   `history_modseq` int(11) NOT NULL DEFAULT 0,
   PRIMARY KEY (`history_id`),
   KEY `history_action_idx` (`history_action`),
   KEY `history_ts_idx` (`history_ts`),
   KEY `history_uid_idx` (`object_uid`),
   KEY `index_horde_histories_on_history_modseq` (`history_modseq`),
   KEY `index_horde_histories_on_object_uid` (`object_uid`),
   KEY `history_modseq_idx` (`history_modseq`)
) ENGINE=MyISAM AUTO_INCREMENT=14715533 DEFAULT CHARSET=utf8mb3  
COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

:-)
Arnold