View Single Post
  #1  
Old 05-28-2009, 02:39 PM
Snoopdog
Sarnak
 
Join Date: Sep 2004
Posts: 31
Default 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`
Reply With Quote