06.12.2011, 22:26
Ich will das Useraward für meine seite installieren aber ich bekomm error bei einen befehl was ich in die DB importieren soll.
DROP TABLE IF EXISTS ws_V59_user_award_list;
DROP TABLE IF EXISTS ws_V59_user_awards;
CREATE TABLE ws_V59_user_award_list (
uawardID int(11) auto_increment,
name varchar(255),
info text,
image varchar(255),
PRIMARY KEY(uawardID)
);
CREATE TABLE ws_V59_user_awards (
uwID int(11) auto_increment,
userID int(11),
awardID int(11),
PRIMARY KEY(uwID)
);
Fehler beim Ausführen des SQL : SQL DROP TABLE IF EXISTS ws_V59_user_award_list; DROP TABLE IF EXISTS ws_V59_user_awards; CREATE TABLE ws_V59_user_award_list ( uawardID int(11) auto_increment, name varchar(255), info text, image varchar(255), PRIMARY KEY(uawardID) ); CREATE TABLE ws_V59_user_awards ( uwID int(11) auto_increment, userID int(11), awardID int(11), PRIMARY KEY(uwID) ); schlug fehl: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS ws_V59_user_awards; CREATE TABLE ws_V59_user_award_list ( u' at line 1
was daran falsch??
DROP TABLE IF EXISTS ws_V59_user_award_list;
DROP TABLE IF EXISTS ws_V59_user_awards;
CREATE TABLE ws_V59_user_award_list (
uawardID int(11) auto_increment,
name varchar(255),
info text,
image varchar(255),
PRIMARY KEY(uawardID)
);
CREATE TABLE ws_V59_user_awards (
uwID int(11) auto_increment,
userID int(11),
awardID int(11),
PRIMARY KEY(uwID)
);
Fehler beim Ausführen des SQL : SQL DROP TABLE IF EXISTS ws_V59_user_award_list; DROP TABLE IF EXISTS ws_V59_user_awards; CREATE TABLE ws_V59_user_award_list ( uawardID int(11) auto_increment, name varchar(255), info text, image varchar(255), PRIMARY KEY(uawardID) ); CREATE TABLE ws_V59_user_awards ( uwID int(11) auto_increment, userID int(11), awardID int(11), PRIMARY KEY(uwID) ); schlug fehl: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS ws_V59_user_awards; CREATE TABLE ws_V59_user_award_list ( u' at line 1
was daran falsch??