Daily signup / email confirmation quotas for each proxy server

[leandrosardi]

• Setup dispatch to don't work with schedule_day field
• Setup access points to don't work with schedule_day field
• Accounts signup planner --> it should assign stealth_browser_technology_code also.
• Create proxyprovider record if not exists, when upload new accounts
• Create proxyprovider record if not exists, when upload new proxies

alter table lnuser add schedule_signup_date date null;

[leandrosardi]

Part of this fix has been pushed here: https://github.com/leandrosardi/tempora/commit/4ac4f702a4833657586e62cd45ec0d507237928a

I missed to mention this issue code in the commit.

[leandrosardi]

alter table proxyprovider add delete_time datetime null;
go

[leandrosardi]

alter table host add allowed_for_farming bit null;

[leandrosardi]

Validate the Planner is Working Fine

select x.ip, count(u.id)
from lnuser u
join proxy x on x.id=u.id_proxy 
where (
    u.schedule_signup_date = CAST(GETDATE() AS DATE) or
    u.signup_end_time > dateadd(dd,-1,getdate()) or
    u.confirm_email_end_time > dateadd(dd,-1,getdate())
)
group by x.ip
order by count(u.id) desc