USE `astrad`;

ALTER TABLE location2 MODIFY  useragent varchar(20) default 'Unknown';
ALTER TABLE registration MODIFY  useragent varchar(20) default 'Unknown';
UPDATE location2 SET useragent = 'Unknown' WHERE useragent IS NULL;