


CREATE TABLE IF NOT EXISTS `karteikarte` (
	`id` 							int(11) 		NOT NULL AUTO_INCREMENT,
	`anrede` 						varchar(32) 	DEFAULT NULL,
	`firma` 						varchar(64) 	DEFAULT NULL,
	`vorname` 						varchar(64) 	DEFAULT NULL,
	`nachname` 						varchar(64) 	DEFAULT NULL,
	`email` 						varchar(32) 	DEFAULT NULL,
	`telefon` 						varchar(32) 	DEFAULT NULL,
	`sonstiges` 					LONGTEXT 		DEFAULT NULL,
	`preis` 						DECIMAL(8,2) 	DEFAULT NULL,
	`geboren` 						DATE			DEFAULT NULL,
	`zeitstempel` 					TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`)	
	)
	ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='Test Karteikarte';
	
	