Ja sie ist exestiert noch nicht. Der Primary key wird jedoch nicht eingetragen ebenfalls wird AUTO INCREMENT nicht eingetragen.
stock CreateAccountTabelle()
{
new query[2048];
format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `"SQL_DTAG"accounts` (");
format(query, sizeof(query), "%s `ID` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,", query);
format(query, sizeof(query), "%s `Spielername` varchar(32) NOT NULL,", query);
format(query, sizeof(query), "%s `Passwort` varchar(65) NOT NULL,", query);
format(query, sizeof(query), "%s `Geschlecht` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Geburtsdatum` varchar(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Tutorial` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Level` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Geld` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `SpawnChange` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Skin` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Admin` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Perso` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `Fraktion` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `FraktionRang` int(11) NOT NULL,", query);
format(query, sizeof(query), "%s `LastIP` varchar(16) NOT NULL", query);
format(query, sizeof(query), "%s) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;", query);
mysql_pquery(handle, query);
return 1;
}
Alles anzeigen