- Request #149 (E. Yu): Add a new netmag.magtype of r
-----------------------

Add a new magtype = r, as a valid magnitude type. This magnitude is based on
the Ml magnitude but it has been adjusted to be closer to the Mw calculation.
The SCSN would like to apply this adjustment to Mls >=3, and would like to
distinguish them from the original Ml calculation by magtype.  

-----------------------------------------------------------------------------
==> Request approved.
    This magnitude is a linear adjustment to Ml and will be labeled 'Mlr' (reduced).
    Caltech will implement the software changes.
    Jiggle & Trimag need to be updated. Possibly Ampgen, TMTS & Alarming.
    Constraints in Netmag, EventPrefMag & MagPrefPriority tables need to be updated.
-----------------------------------------------------------------------------


- Request #150 (S. Zuzlewski): PDL product submission information
------------------------------

Here is a preliminary set of tables designed to store PDL product submission information.

- PDL_PRODUCT Table:

FIELD    TYPE    DEFINITION
-----------------------------------------------------------------------------
evid     NUMBER  Event Identifier
prodtype VARCHAR Product Type: Origin, Phase-data, Moment-tensor,
                 Focal-mech, Nearby-cities, Shakemap
dest     VARCHAR Destination: Recent_event_PDL, ComCat_PDL, dev-ComCat_PDL
stime    DATE    Submission Time
dbsetid  NUMBER  Database Id's of main elements of the product: orid & magid
                 for Origin, Shakemap & Phase-data products; mecid for 
                 Moment-tensor & Focal-mech products; orid for Nearby-cities 
                 product.
                 Foreign key to PDL_IDS.dbsetid
dtime    DATE    Deletion Time
-----------------------------------------------------------------------------
Primary Key: (evid, prodtype, dest, stime)

- PDL_IDS Table:

FIELD    TYPE    DEFINITION
-----------------------------------------------------------------------------
dbsetid  NUMBER  DB Set of Id's Identifier
tname    VARCHAR Table name: origin, netmag, mec
id       NUMBER  Identifier Value
-----------------------------------------------------------------------------
Primary Key: (dbsetid, tname)

- Concerns:
1.- How to include PDL hub tracking.
2.- How are deletions recorded in table (could submit deletion without submitting product).

-----------------------------------------------------------------------------
==> Tables should be replicated.
    Need to add the following fields:
         TIME   Action time
         ACTION Update, Delete, Submit
         SOURCE Which system submitted it.
-----------------------------------------------------------------------------