Outlook-Konnektor für Adressen

[itari]

Das gleiche Skript wie bei den Outlook-Terminen, jetzt nur auf Adressen angewandt. Die Datenbank sieht so aus:

CREATE TABLE IF NOT EXISTS `adresse` (
  `Adresse_ID` int(11) NOT NULL auto_increment,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `MD5` varchar(32) collate latin1_general_ci default NULL,
  `Birthday` varchar(20) collate latin1_general_ci default NULL,
  `Body` varchar(3200) collate latin1_general_ci default NULL,
  `BusinessAddress` varchar(255) collate latin1_general_ci default NULL,
  `BusinessTelephoneNumber` varchar(20) collate latin1_general_ci default NULL,
  `Categories` varchar(255) collate latin1_general_ci default NULL,
  `CompanyName` varchar(50) collate latin1_general_ci default NULL,
  `CustomerID` varchar(20) collate latin1_general_ci default NULL,
  `Email1Address` varchar(50) collate latin1_general_ci default NULL,
  `Email2Address` varchar(50) collate latin1_general_ci default NULL,
  `Email3Address` varchar(50) collate latin1_general_ci default NULL,
  `FirstName` varchar(20) collate latin1_general_ci default NULL,
  `FullName` varchar(50) collate latin1_general_ci default NULL,
  `HomeAddress` varchar(255) collate latin1_general_ci default NULL,
  `HomeTelephoneNumber` varchar(20) collate latin1_general_ci default NULL,
  `LastName` varchar(30) collate latin1_general_ci default NULL,
  `MobileTelephoneNumber` varchar(20) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`Adresse_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

Das Skript wird genauso installiert und benutzt wie bei den Terminen.