Small typo in SVN
I was running the updated sql from the instancing branch and noticed a semicolon missing, I guess I cannot change it so someone else will have to. It is missing in the file instance_branch_table_changes.sql I imagine it happened during a copy/paste. I imagine it is no big deal if you do each line one at a time, but trying to do them sequentially it will fail.
CREATE TABLE `adventure_details` (
`id` int(10) unsigned NOT NULL auto_increment,
`adventure_id` smallint(5) unsigned NOT NULL,
`instance_id` int(11) NOT NULL default '-1',
`count` smallint(5) unsigned NOT NULL default '0',
`status` tinyint(3) unsigned NOT NULL default '0',
`time_created` int(10) unsigned NOT NULL default '0',
`time_zoned` int(10) unsigned NOT NULL default '0',
`time_completed` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Also on line
ALTER TABLE `doors` ADD `is_ldon_door` TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER `dest_heading`
|