1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
|
CREATE TABLE `bb1_adressbuch` (
`adressbuch_id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`username` varchar(50) NOT NULL,
`vn` varchar(100) NOT NULL,
`nn` varchar(100) NOT NULL,
`str` varchar(150) NOT NULL,
`hnr` varchar(100) NOT NULL,
`plz` varchar(100) NOT NULL,
`ort` varchar(250) NOT NULL,
`tel` varchar(100) NOT NULL,
`fax` varchar(100) NOT NULL,
`email` varchar(150) NOT NULL,
`hp` varchar(100) NOT NULL,
PRIMARY KEY (`adressbuch_id`)
) TYPE=MyISAM;
|