RAVEN READINESS TODO

NOTE: SAAS stuff will be a later on thing, these changes are just enough to be able to sell it and support the license key infrastructure
no need to do anything fancy with UI, just the bare minimum for now as I will be building a nice vuetify UI down the road after release

CHANGES

Put trials in their own tables not in regular customers
"TrialRequest"
    id integer PRIMARY key
    dbid text
    company name text
    contact name text
    notes (for us) text
    email address text
    email validated bool
    requested timestamp
    processed timestamp
    status enum 0=notset, 1=approved, 2=rejected
    rejectreason text
    generated key text
    key retrieved timestamp

Add "trial" table mirroring purchase table but with trial stuff in it
CREATE TABLE trial (id INTEGER PRIMARY KEY, trialrequest_id integer not null, productCode text, FOREIGN KEY (trialrequest_id) REFERENCES trialrequest(id) ON DELETE CASCADE)

Add minimal ui for this under main top menu beside customers "Trials"
    going to make a full ui later with vuetify so just do the bare minimum nothing more
    display a list of active trials 
    optionaly way to view old trials?

Rename SITE to DATABASE in the UI (keep as site in code)
SITE UI AND TABLE
    Remove UI AND DB: SERVER BITS, SERVER OS, DB TYPE (old dbtype) 
    Remove DB: trial bool, (Purchases present indicate status of customer, trial is assumed)
    ADD LEGACY_V7 as a bool, set all to true (V8 is the default going forward and assumed to be true)
    ADD DBID as text (and ui)





API
Add email verification route with code (called by RAVEN)
    emails us when it's verified as a notification that a trial is ready to send





