View Single Post
  #1  
Old 02-25-2009, 12:45 PM
nosfentora
Discordant
 
Join Date: Oct 2004
Location: In a house
Posts: 377
Default SQL Error in newly downloaded data

Just pulled the db from the svn and am getting an error on load_player.sql - specifically in 'rule_values.sql'

the code is
Code:
SET FOREIGN_KEY_CHECKS=0;           
CREATE TABLE `rule_values` (      
  `ruleset_id` tinyint(3) unsigned NOT NULL default '0',      
  `rule_name` varchar(64) NOT NULL default '',      
  `rule_value` varchar('1'0) NOT NULL default '',      
  PRIMARY KEY  (`ruleset_id`,`rule_name`),      
  KEY `ruleset_id` (`ruleset_id`)      
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
what should
Code:
`rule_value` varchar('1'0) NOT NULL default '',
be?

Also - what is the correct order to install a fresh db?
peqdb_1129RevXXX.sql
load_player.sql
load_bots.sql
?
(it's been a while since i've started from scratch)
Reply With Quote