Hi,
just testing on this table:
| Kód: |
CREATE TABLE `mitarbeiter` (
`pkey` int(11) NOT NULL auto_increment,
`acode` varchar(10) NOT NULL default '',
`acode_ok` char(1) NOT NULL default '0',
`qnummer` varchar(10) NOT NULL default '',
`status` enum('mitarbeiter','rentner') NOT NULL default 'mitarbeiter',
`email` varchar(255) NOT NULL default '',
`kurzzeichen` varchar(10) NOT NULL default '',
`anrede` enum('1','2') default NULL,
`name` varchar(255) NOT NULL default '',
`vorname` varchar(255) NOT NULL default '',
`geboren_am` date default NULL,
`standort` varchar(255) NOT NULL default '',
`kennwort` varchar(255) NOT NULL default '',
`strasse` varchar(255) NOT NULL default '',
`nr` varchar(10) NOT NULL default '',
`plz` varchar(10) NOT NULL default '',
`ort` varchar(255) NOT NULL default '',
`telefon` varchar(20) default NULL,
`mobiltelefon` varchar(20) default NULL,
`ergebnis_info_email` enum('0','1') NOT NULL default '0',
`ergebnis_info_sms` enum('0','1') NOT NULL default '0',
`show_in_highscore` enum('0','1') NOT NULL default '0',
`tstamp` timestamp(14) NOT NULL,
PRIMARY KEY (`pkey`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `acode` (`acode`),
UNIQUE KEY `qnummer` (`qnummer`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=7 ;
|
give me this content file:
| Kód: |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Mitarbeiter</title>
<style type="text/css">
table { border: #004d9c 1px solid; border-collapse: collapse; border-spacing: 0px; width: 100%; }
th { border: #004d9c 1px solid; padding: 4px; background: #add8e6; }
td { border: #004d9c 1px solid; padding: 3px; }
hr { border: 0px solid; padding: 0px; margin: 0px; border-top-width: 1px; height: 1px; }
</style>
</head>
<body>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Mitarbeiter</title>
<style type="text/css">
table { border: #004d9c 1px solid; border-collapse: collapse; border-spacing: 0px; width: 100%; }
th { border: #004d9c 1px solid; padding: 4px; background: #add8e6; }
td { border: #004d9c 1px solid; padding: 3px; }
hr { border: 0px solid; padding: 0px; margin: 0px; border-top-width: 1px; height: 1px; }
</style>
</head>
<body></body>
</html> |
Anyone seen this yet?
Cheers
Mike
|