/*UPDATEREVISION*/
INSERT INTO site (`setting`, `value`, `updateddate` ) VALUES ('dbversion', '$Rev: 2800 $', now()) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), updateddate=now();

/*PATCHHERE*/
ALTER TABLE  `spotnabsources` ADD  `lastbroadcast` DATETIME NULL AFTER  `lastupdate` ;
ALTER TABLE  `spotnabsources` ADD  `dateadded` DATETIME NULL AFTER  `lastbroadcast` ;
ALTER TABLE spotnabsources ADD CONSTRAINT spotnabsources_ix1 UNIQUE (username, useremail, usenetgroup);

INSERT INTO `site` (`ID` , `setting` , `value` , `updateddate` )
	VALUES ( NULL ,  'spotnabdiscover',  '0', NOW( ));
INSERT INTO `site` (`ID` , `setting` , `value` , `updateddate` )
	VALUES ( NULL ,  'spotnabbroadcast',  '0', NOW( ));
