Update from v2.0.2 to v3.4.0RC4

[steinm]

Hi, the outbut is:

Code:

SQL-Abfrageergebnis
Host: localhost
Datenbank: letodms3311
Erstellungszeit: 10. Dez 2012 um 18:48
Erstellt von: phpMyAdmin 3.5.3 / MySQL 5.1.49
SQL-Befehl: show create table tblDocumentContent;
Datensätze: 1

Table: tblDocumentContent
Create Table:
CREATE TABLE `tblDocumentContent` (
`document` int(11) NOT NULL DEFAULT '0',
`version` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`comment` text,
`date` int(12) DEFAULT NULL,
`createdBy` int(11) DEFAULT NULL,
`dir` varchar(255) NOT NULL DEFAULT '',
`orgFileName` varchar(150) NOT NULL DEFAULT '',
`fileType` varchar(10) NOT NULL DEFAULT '',
`mimeType` varchar(100) DEFAULT NULL,
PRIMARY KEY (`document`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Try this

alter table tblDocumentContent change version version smallint(5);
alter table tblDocumentContent drop primary key;
alter table tblDocumentContent add unique index (`document`, `version`);
alter table tblDocumentContent engine=innodb;

This should make the table upgradable for 3.4.0

Uwe