All pastes #656065 Raw Edit

Stuff

public text v1 · immutable
#656065 ·published 2007-08-13 20:30 UTC
rendered paste body
mysql -u root -p ascent < /home/angel/clean_db.sql

ERROR 1064 (42000) at line 4577: 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 'in
LL,
  `Entry` int(10) unsigned NOT NULL default '0',
  `Map` int(10) unsigned' at line 6


DROP TABLE IF EXISTS `gameobject_spawns`;
CREATE TABLE `gameobject_spawns` (
  `ID` int(30) unsigned NOT NULL,
  `Entry` int(10) unsigned NOT NULL default '0',
  `Map` int(10) unsigned NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `Facing` float NOT NULL default '0',
  `o1` float NOT NULL default '0',
  `o2` float NOT NULL default '0',
  `o3` float NOT NULL default '0',
  `o4` float NOT NULL default '0',
  `State` int(10) unsigned NOT NULL default '0',
  `Flags` int(10) unsigned NOT NULL default '0',
  `Faction` int(10) unsigned NOT NULL default '0',
  `Scale` float NOT NULL default '0',
  `state_npc_link` int(30) NOT NULL,
  UNIQUE KEY `ID` (`ID`),
  KEY `Map` (`Map`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs;