1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
|
CREATE TABLE `mitglieder` (
`id` int(100) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`passwort` varchar(55) NOT NULL,
`email` varchar(150) NOT NULL,
`bild` varchar(10) NOT NULL,
`benutzertext` text NOT NULL,
`tag` varchar(2) NOT NULL,
`monat` varchar(2) NOT NULL,
`jahr` varchar(4) NOT NULL,
`msn` varchar(150) NOT NULL,
`icq` varchar(100) NOT NULL,
`homepage` varchar(255) NOT NULL,
`refresh` int(100) NOT NULL,
`register` int(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `login` (
`id` int(255) unsigned NOT NULL auto_increment,
`name` varchar(150) NOT NULL,
`ip` varchar(100) NOT NULL,
`timestamp` int(100) NOT NULL,
`erfolgreich` varchar(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ; |