nosfentora
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
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
`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)
the code is
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
`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)