[TYPO3-german] tt_address und Update auf TYPO3 4.2.6

[Gaspers]

Nachtrag
2: Database Analyser
Update required tables   COMPARE

ALTER TABLE tt_address ADD uid int(11) unsigned NOT NULL auto_increment;
ALTER TABLE tt_address ADD PRIMARY KEY (uid);


"Gaspers" <typo3 at gaspers.de> schrieb im Newsbeitrag 
news:mailman.1.1236719578.6951.typo3-german at lists.netfielders.de...
> Hallo,
>
> beim Update auf TYPO3 4.2.6 wird Compare für tt_address nicht ausgeführt.
> Es sind Daten in der Tabelle.
>
>
> Lösung:
> Tabelle gesichert
> Create geandert (  `uid` int(11) NOT NULL auto_increment, und   PRIMARY 
> KEY (`uid`), eingefügt)
> Create ausgeführt
> Daten zurück geschrieben
>
> Gibt es einen besseren Weg, muss leider ein paar Server Updaten.
>
> Gruß
> Bernd
>
>
> INSERT DELAYED INTO `tt_address` (`tx_cal_controller_isorganizer`, 
> `tx_cal_controller_islocation`, `tx_cal_controller_latitude`, 
> `tx_cal_controller_longitude`, `pid`, `tstamp`, `hidden`, `name`, 
> `first_name`, `middle_name`, `last_name`, `title`, `email`, `phone`, 
> `mobile`, `www`, `address`, `company`, `city`, `zip`, `region`, `country`, 
> `image`, `fax`, `deleted`, `description`, `addressgroup`, 
> `module_sys_dmail_category`, `module_sys_dmail_html`, 
> `tx_dfdirectmailsubscription_gender`) VALUES
> (0, 0, '', '', 0, 0, 0, 'Nachname', 'Vorname', '', '', '', 'E-Mail', 
> 'Telefonnummer', 'Mobilfunknummer', '', 'Straße', '', 'Ort', 'PLZ', '', 
> '', '', '', 0, '', 0, 0, 0, 0),
>
>
>
> CREATE TABLE IF NOT EXISTS `tt_address` (
>  `uid` int(11) NOT NULL auto_increment,
>  `tx_cal_controller_isorganizer` tinyint(4) NOT NULL default '0',
>  `tx_cal_controller_islocation` tinyint(4) NOT NULL default '0',
>  `tx_cal_controller_latitude` tinytext NOT NULL,
>  `tx_cal_controller_longitude` tinytext NOT NULL,
>  `pid` int(11) unsigned NOT NULL default '0',
>  `tstamp` int(11) unsigned NOT NULL default '0',
>  `hidden` tinyint(4) unsigned NOT NULL default '0',
>  `name` tinytext NOT NULL,
>  `first_name` tinytext NOT NULL,
>  `middle_name` tinytext NOT NULL,
>  `last_name` tinytext NOT NULL,
>  `title` varchar(40) NOT NULL default '',
>  `email` varchar(80) NOT NULL default '',
>  `phone` varchar(30) NOT NULL default '',
>  `mobile` varchar(30) NOT NULL default '',
>  `www` varchar(80) NOT NULL default '',
>  `address` tinytext NOT NULL,
>  `company` varchar(80) NOT NULL default '',
>  `city` varchar(80) NOT NULL default '',
>  `zip` varchar(20) NOT NULL default '',
>  `region` varchar(100) NOT NULL default '',
>  `country` varchar(100) NOT NULL default '',
>  `image` tinyblob NOT NULL,
>  `fax` varchar(30) NOT NULL default '',
>  `deleted` tinyint(3) unsigned NOT NULL default '0',
>  `description` text NOT NULL,
>  `addressgroup` int(11) NOT NULL default '0',
>  `module_sys_dmail_category` int(10) unsigned NOT NULL default '0',
>  `module_sys_dmail_html` tinyint(3) unsigned NOT NULL default '0',
>  `tx_dfdirectmailsubscription_gender` int(11) NOT NULL default '0',
>  PRIMARY KEY  (`uid`),
>  KEY `parent` (`pid`),
>  KEY `pid` (`pid`,`email`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>