[Tickets #12498] Re: SQL Syntax error or access violation updating Horde_History DB schema
noreply at bugs.horde.org
noreply at bugs.horde.org
Tue Jan 2 12:50:44 UTC 2024
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
More information about the bugs
mailing list