Setup: http://wp040.webpack.hosteurope.de/phpMyAdmin/
dbu1022769
fuB0gar7
db1022769-php
kRam8l
Salt $1$fAr71ooc$
$1$fAr71ooc$Zdt20iK7t7yZxPEYooqgL0
'siarp','clique','uni','familie','beethoven','pottenstein','musical','israel','service'
1  	Tilman Walther  	tilman  	$1$fAr71ooc$Zdt20iK7t7yZxPEYooqgL0  	siarp


CREATE TABLE `users` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 35 ) NOT NULL ,
`login` VARCHAR( 35 ) NOT NULL ,
`c_passwort` VARCHAR( 35 ) NOT NULL ,
`gruppen` SET( 'admin', 'clique', 'uni', 'familie', 'beethoven', 'pottenstein', 'musical', 'israel', 'service' ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`name` ,
`login`
)
) TYPE = MYISAM ;

CREATE TABLE `securepages` (
`id` INT NOT NULL AUTO_INCREMENT ,
`pfad` VARCHAR( 255 ) NOT NULL ,
`gruppen` SET( 'admin', 'clique', 'uni', 'familie', 'beethoven', 'pottenstein', 'musical', 'israel', 'service' ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`pfad`
)
) TYPE = MYISAM ;

---------------------------------


INSERT INTO users (name, login, c_passwort) VALUES ('Tilman Walther', 'tilman', '$1$fAr71ooc$Zdt20iK7t7yZxPEYooqgL0')




-----------------------------
Adressen:
CREATE TABLE `adressen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `Vorname` varchar(40) collate latin1_bin default NULL,
  `Nachname` varchar(40) collate latin1_bin default NULL,
  `Anschrift` varchar(40) collate latin1_bin default NULL,
  `PLZ` int(11) default '0',
  `Ort` varchar(40) collate latin1_bin default NULL,
  `Tel. privat` varchar(40) collate latin1_bin default NULL,
  `Tel. geschftlich` varchar(40) collate latin1_bin default NULL,
  `Tel. mobil` varchar(40) collate latin1_bin default NULL,
  `E-Mail privat` varchar(40) collate latin1_bin default NULL,
  `E-Mail geschftlich` varchar(40) collate latin1_bin default NULL,
  `Geburtstag` date default '0000-00-00',
  `Gruppe` enum('Familie','Uni','Bettinas Familie','rzte','Bettinas Bekannte','Bekannte','Beethoven') collate latin1_bin default NULL,
  `Bemerkung` varchar(255) collate latin1_bin default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=1 ;
