Changes between Version 19 and Version 20 of ippToPsps_Database

Timestamp:

Apr 4, 2012, 4:05:01 PM (14 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Database

@@ -31 +31 @@
 
 The config table contains all available configurations of 'loading campaigns'. Generally this means a row for 3pi, a row for MDF, SAS etc. All {{{ippToPsps}}} programs require the name of a config as their first argument when run from the command line, but changes can be made to config while programs are running and they will update accordingly.
+
+|| '''Field'''             || '''Type'''          || '''Null''' || '''Key''' || '''Default value'''       || '''Description''' ||
+|| timestamp         || timestamp     || NO   ||     || CURRENT_TIMESTAMP   ||       ||
+|| name              || varchar(30)   || NO   || PRI || NULL                ||       ||
+|| datastore_product || varchar(30)   || YES  ||     || NULL                ||       ||
+|| datastore_type    || varchar(30)   || YES  ||     || IPP_PSPS            ||       ||
+|| datastore_publish || tinyint(1)    || YES  ||     || 0                   ||       ||
+|| dvo_label         || varchar(100)  || YES  ||     || NULL                ||       ||
+|| dvo_location      || varchar(1000) || YES  ||     || NULL                ||       ||
+|| min_ra            || double        || YES  ||     || 0                   ||       ||
+|| max_ra            || double        || YES  ||     || 360                 ||       ||
+|| min_dec           || double        || YES  ||     || -30                 ||       ||
+|| max_dec           || double        || YES  ||     || 90                  ||       ||
+|| box_size          || double        || YES  ||     || 4                   ||       ||
+|| base_path         || varchar(1000) || YES  ||     || NULL                ||       ||
+|| data_release      || smallint(6)   || YES  ||     || 0                   ||       ||
+|| delete_local      || tinyint(1)    || YES  ||     || 0                   ||       ||
+|| delete_datastore  || tinyint(1)    || YES  ||     || 1                   ||       ||
+|| delete_dxlayer    || tinyint(1)    || YES  ||     || 1                   ||       ||
+|| epoch             || timestamp     || NO   ||     || 0000-00-00 00:00:00 ||       ||
+|| survey            || varchar(10)   || YES  ||     || NULL                ||       ||
+|| psps_survey       || varchar(10)   || YES  ||     || NULL                ||       ||
+|| queue_P2          || tinyint(1)    || YES  ||     || 1                   ||       ||
+|| queue_ST          || tinyint(1)    || YES  ||     || 0                   ||       ||
+|| queue_OB          || tinyint(1)    || YES  ||     || 0                   ||       ||
+|| active            || tinyint(1)    || YES  ||     || 1                   ||  defines whether this config is in active use or not ||
+
+
+
 == The {{{clients}}} table ==