science-ation/db/db.update.136.sql

ALTER TABLE `fairs` CHANGE `type` `type` ENUM( 'feeder', 'sfiab', 'ysc' ) NOT NULL ;

UPDATE fairs SET `type`='ysc' WHERE `type`='';

DELETE FROM config WHERE var='ysf_region_id';
DELETE FROM config WHERE var='ysf_region_password';
- Rename YSF to YSC - Add the help websites we lost somewhere for STO and YSC - Copy the $config ysf login data into the fairs data 2009-09-19 06:12:48 +00:00			ALTER TABLE `fairs` CHANGE `type` `type` ENUM( 'feeder', 'sfiab', 'ysc' ) NOT NULL ;

			UPDATE fairs SET `type`='ysc' WHERE `type`='';

- For the first time probably ever, DELETE a config variable :O - Rename the user/pass for fair type=ysc so it's more familiar (asks for YSC ID and pass) - Convert cwsfregister to use the fair entry data. 2009-09-19 06:53:49 +00:00			`DELETE FROM config WHERE var='ysf_region_id';`
			`DELETE FROM config WHERE var='ysf_region_password';`