g4RLq9Rb

1CREATE TABLE IF NOT EXISTS `perso` (
2 `id` int(12) NOT NULL AUTO_INCREMENT,
3 `pid` varchar(50) NOT NULL DEFAULT '',
4 `persoCop` text NOT NULL,
5 `persoMed` text NOT NULL,
6 `persoCiv` text NOT NULL,
7 `persoEast` text NOT NULL,
8 `Erstellungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
9 `Aenderungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10 PRIMARY KEY (`id`,`pid`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1;