DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: http://bugs.horde.org/ticket/12498
------------------------------------------------------------------------------
Ticket | 12498
Updated By | samuel.wolf at wolf-maschinenbau.de
Summary | SQL Syntax error or access violation updating
| Horde_History DB schema
Queue | Horde Framework Packages
Version | Git master
Type | Bug
State | Feedback
Priority | 2. Medium
Milestone |
Patch |
Owners |
------------------------------------------------------------------------------
samuel.wolf at wolf-maschinenbau.de (2013-07-26 15:36) wrote:
Is my database structure ok?
Can someone give me the right sql command to fix the upgrade?
--
-- Tabellenstruktur für Tabelle `horde_histories`
--
CREATE TABLE IF NOT EXISTS `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` int(11) NOT NULL,
`history_desc` longtext,
`history_who` varchar(255) DEFAULT NULL,
`history_extra` longtext,
`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_and_object_uid`
(`history_modseq`,`object_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=74754 ;