SQL Error in newly downloaded data

nosfentora · #1 02-25-2009, 12:45 PM

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)