- 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 on Netmag, EventPrefMag & MagPrefPriority tables need to be updated.

-----------------------------------------------------------------------------
--> Allan implemented the changes in Trimag & Jiggle.
Currently, no amplitudes are associated with Mlr magnitudes; the ones associated
with the Ml are used. Group suggests that the observables should be stored in the
database as well.
-----------------------------------------------------------------------------


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

==> Request approved.
The following tables will be added to the AP schema:

- PDL_PRODUCT Table:

FIELD    TYPE    DEFINITION
-----------------------------------------------------------------------------
evid     NUMBER  Event Identifier
prodtype VARCHAR Product Type: origin, phase-data, moment-tensor,
                 focal-mechanism, nearby-cities, shakemap
dest     VARCHAR Destination: Recent_event_PDL, ComCat_PDL, dev-ComCat_PDL,
                 dev-Recent_event_PDL
source   VARCHAR Source: System that submitted the information
time     DATE    Time of Action
action   VARCHAR PDL action (called "status" in PDL docs): 
                 U (update) or D (delete)
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
lddate   DATE    Load date
-----------------------------------------------------------------------------
Primary Key: (evid, prodtype, action, dest, time, source)

- 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
lddate   DATE    Load date
-----------------------------------------------------------------------------
Primary Key: (dbsetid, tname)