EQEmulator Forums - SQL Error in newly downloaded data

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - SQL Error in newly downloaded data (https://www.eqemulator.org/forums/showthread.php?t=27564)

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)

Code:

`rule_value` varchar('1'0) NOT NULL default '',

should be

Code:

`rule_value` varchar('10') NOT NULL default '',

And I believe its source load_player.sql, then load_bots.sql, then the peq.sql