pagalbos mysql

[phimberis]

Pajungiau serverį ir loguose metą šitą:

[20:50:29] [plugins/mysql] error #1064 while executing query "CREATE TABLE IF NOT EXISTS `profiliai` (`ID` int(11) NOT NULL AUTO_INCREMENT,`Vardas` varchar(24) NOT NULL,`Slaptazodis` char(65) NOT NULL,`SALT` char(11) NOT NULL,`XP` mediumint(7), `Pinigai` mediumint(7) NOT NULL DEFAULT '0', `PosX` float(7) NOT NULL DEFAULT '0.0', `PosY` float(7) NOT NULL DEFAULT '0.0', `PosZ` float(7) NOT NULL DEFAULT '0.0' PRIMARY KEY (`ID`) UNIQUE KEY `Vardas` (`Vardas`))": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(`ID`) UNIQUE KEY `Vardas` (`Vardas`))' at line 1

	mysql_tquery(Database, "CREATE TABLE IF NOT EXISTS `profiliai` (`ID` int(11) NOT NULL AUTO_INCREMENT,`Vardas` varchar(24) NOT NULL,`Slaptazodis` char(65) NOT NULL,`SALT` char(11) NOT NULL,`XP` mediumint(7), `Pinigai` mediumint(7) NOT NULL DEFAULT '0', `PosX` float(7) NOT NULL DEFAULT '0.0', `PosY` float(7) NOT NULL DEFAULT '0.0', `PosZ` float(7) NOT NULL DEFAULT '0.0' PRIMARY KEY (`ID`) UNIQUE KEY `Vardas` (`Vardas`))");

 

[» Stacey.]

@mariusqw

[mariusqw]

CREATE TABLE IF NOT EXISTS `profiliai` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Vardas` varchar(24) NOT NULL,
  `Slaptazodis` char(65) NOT NULL,
  `SALT` char(11) NOT NULL,
  `XP` mediumint(7),
  `Pinigai` mediumint(7) NOT NULL DEFAULT '0',
  `PosX` float(7) NOT NULL DEFAULT '0.0',
  `PosY` float(7) NOT NULL DEFAULT '0.0',
  `PosZ` float(7) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`ID`)
)

 

[phimberis]

24 minutes prieš, mariusqw parašė:

CREATE TABLE IF NOT EXISTS `profiliai` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Vardas` varchar(24) NOT NULL,
  `Slaptazodis` char(65) NOT NULL,
  `SALT` char(11) NOT NULL,
  `XP` mediumint(7),
  `Pinigai` mediumint(7) NOT NULL DEFAULT '0',
  `PosX` float(7) NOT NULL DEFAULT '0.0',
  `PosY` float(7) NOT NULL DEFAULT '0.0',
  `PosZ` float(7) NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`ID`)
)

 

ta pati problema