CREATE TABLE IF NOT EXISTS `servers` (
`serverID` int(11) NOT NULL auto_increment,
`userID` varchar(50) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`build` varchar(50) NOT NULL,
`slots` varchar(50) NOT NULL,
`serverport` varchar(50) NOT NULL,
`remoteport` varchar(50) NOT NULL,
`remoteuser` varchar(50) NOT NULL,
`remotepass` varchar(50) NOT NULL,
`tcpport` varchar(50) NOT NULL,
`subdomain` varchar(50) NOT NULL,
PRIMARY KEY (`serverID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
userID = ID von tabelle cs_users
username = ftp und shell benutzer
password = ftp und shell passwort
build = aus dem auswahlfeld (1-653)
slots = slotanzahl
serverport = standart 25565 + 10 (beim n