/opt/mysql/libexec/mysqld, Version: 5.1.28-rcyes-log (yes). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument 080923 12:50:14 1 Connect root@localhost on 1 Query select @@version_comment limit 1 1 Query /*!40000 DROP DATABASE IF EXISTS `CRM1_1`*/ 1 Query CREATE DATABASE /*!32312 IF NOT EXISTS*/ `CRM1_1` /*!40100 DEFAULT CHARACTER SET latin1 */ 1 Query SELECT DATABASE() 1 Init DB CRM1_1 1 Query SET @saved_cs_client = @@character_set_client 1 Query SET character_set_client = utf8 1 Query CREATE TABLE `CRM_KONFIGURATION` ( `DEFAULT_LAND` char(3) NOT NULL default 'A' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 Query SET character_set_client = @saved_cs_client 1 Query /*!40000 ALTER TABLE `CRM_KONFIGURATION` DISABLE KEYS */ 1 Query INSERT INTO `CRM_KONFIGURATION` (`DEFAULT_LAND`) VALUES ('A') 1 Query /*!40000 ALTER TABLE `CRM_KONFIGURATION` ENABLE KEYS */ 1 Query SET @saved_cs_client = @@character_set_client 1 Query SET character_set_client = utf8 1 Query CREATE TABLE `KUNDE` ( `AUTOID` int(9) NOT NULL auto_increment, `KUNDENID` varchar(31) NOT NULL default '0', `FIRMENNAME` varchar(255) default NULL, `ANREDE` varchar(63) default NULL, `TITEL` varchar(63) default NULL, `VORNAME` varchar(255) default NULL, `NAME` varchar(255) default NULL, `STRASSE` varchar(255) default NULL, `LAND` varchar(127) default NULL, `PLZ` varchar(5) default NULL, `ORT` varchar(255) default NULL, `TELEFON` varchar(127) default NULL, `FAX` varchar(127) default NULL, `EMAIL` varchar(127) NOT NULL default '', `F_NO_HTMLMAIL` enum('0','1') NOT NULL default '0', `F_KEIN_EMAIL` enum('0','1') NOT NULL default '0', `URL_HOMEPAGE` varchar(255) default 'http://', `CRM_CODES` text, `DATUM_ERFASSUNG` date NOT NULL default '0000-00-00', `DATUM_AENDERUNG` date NOT NULL default '0000-00-00', PRIMARY KEY (`AUTOID`), KEY `i_kundenid` (`KUNDENID`), FULLTEXT KEY `fti_firmenname` (`FIRMENNAME`), FULLTEXT KEY `fti_name` (`VORNAME`,`NAME`) ) ENGINE=MyISAM AUTO_INCREMENT=45887 DEFAULT CHARSET=latin1 COMMENT='KUNDENID = zsar8new.PERSONENID' 1 Query SET character_set_client = @saved_cs_client 1 Query /*!40000 ALTER TABLE `KUNDE` DISABLE KEYS */ 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 080923 12:50:15 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ..... 080923 12:50:16 1 Query INSERT INTO `KUNDE` (`AUTOID`, `KUNDENID`, `FIRMENNAME`, `ANREDE`, `TITEL`, `VORNAME`, `NAME`, `STRASSE`, `LAND`, `PLZ`, `ORT`, `TELEFON`, `FAX`, ....._ 1 Query /*!40000 ALTER TABLE `KUNDE` ENABLE KEYS */