BEGIN
set @now = UNIX_TIMESTAMP();
if new.addtime is null or new.addtime = 0 then
    set new.addtime = @now;
end if;
END