Changeset 7241


Ignore:
Timestamp:
21/07/10 16:26:00 (9 years ago)
Author:
mnagni
Message:

New tables for the service

Location:
TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase
Files:
6 added
1 edited
1 moved

Legend:

Unmodified
Added
Removed
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/HarvestLog.sql

    r7239 r7241  
    11-- Table: "HarvestLog" 
    2  
    3          
    42 
    53DROP TABLE "HarvestLog"; 
    64 
    7          
    8  
    95CREATE TABLE "HarvestLog" 
    10  
    116( 
    12  
    13         "newRecs" smallint, 
    14  
    15         "delRecs" smallint, 
    16  
    17         "updateRecs" smallint, 
    18  
    19         "startHarvest" timestamp without time zone, 
    20  
    21         "stopHarvest" timestamp without time zone, 
    22  
    23         "providerID" character varying, 
    24  
    25         "reqID" integer NOT NULL, 
    26  
    27         "totRecs" integer, 
    28  
    29         CONSTRAINT "redID_key" PRIMARY KEY ("reqID") 
    30  
     7  "newRecs" smallint, 
     8  "delRecs" smallint, 
     9  "updateRecs" smallint, 
     10  "startHarvest" timestamp without time zone, 
     11  "stopHarvest" timestamp without time zone, 
     12  "providerID" character varying, 
     13  "reqID" integer NOT NULL, 
     14  "totRecs" integer, 
     15  CONSTRAINT "redID_key" PRIMARY KEY ("reqID") 
    3116) 
    32  
    3317WITH ( 
    34  
    35         OIDS=FALSE 
    36  
     18  OIDS=FALSE 
    3719); 
    38  
    39         ALTER TABLE "HarvestLog" OWNER TO badc; 
    40  
    41   
    42  
    43   
    44  
    45 -- Table: format 
    46  
    47   
    48  
    49 DROP TABLE format; 
    50  
    51   
    52  
    53 CREATE TABLE format 
    54  
    55 ( 
    56  
    57         "ID" smallint NOT NULL, 
    58  
    59         "name" character varying, 
    60  
    61         description character varying, 
    62  
    63         CONSTRAINT format_pkey PRIMARY KEY ("ID") 
    64  
    65 ) 
    66  
    67 WITH ( 
    68  
    69         OIDS=FALSE 
    70  
    71 ); 
    72  
    73         ALTER TABLE format OWNER TO badc; 
    74  
    75          
    76  
    77                  
    78  
    79 -- Table: provider 
    80  
    81          
    82  
    83 DROP TABLE provider; 
    84  
    85          
    86  
    87 CREATE TABLE provider 
    88  
    89 ( 
    90  
    91         "ID" integer NOT NULL, 
    92  
    93         "baseURL" character varying, 
    94  
    95         "set" character varying, 
    96  
    97         "formatID" smallint, 
    98  
    99         "splitBySet" boolean DEFAULT false, 
    100  
    101         CONSTRAINT frgn_key_format FOREIGN KEY ("formatID") 
    102  
    103                 REFERENCES format ("ID") MATCH SIMPLE 
    104  
    105                 ON UPDATE NO ACTION ON DELETE NO ACTION 
    106  
    107 ) 
    108  
    109 WITH ( 
    110  
    111         OIDS=FALSE 
    112  
    113 ); 
    114  
    115         ALTER TABLE provider OWNER TO badc; 
    116  
    117  
    118  
    119 -- Table: service_config 
    120  
    121  
    122  
    123 DROP TABLE service_config; 
    124  
    125  
    126  
    127 CREATE TABLE service_config 
    128  
    129 ( 
    130  
    131         param_name character varying NOT NULL, 
    132  
    133         param_value character varying, 
    134  
    135         CONSTRAINT key_srv_param_name PRIMARY KEY (param_name) 
    136  
    137 ) 
    138  
    139 WITH ( 
    140  
    141         OIDS=FALSE 
    142  
    143 ); 
    144  
    145         ALTER TABLE service_config OWNER TO badc; 
    146  
     20ALTER TABLE "HarvestLog" OWNER TO badc; 
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/create_database.sh

    r7239 r7241  
    2424echo $dbOptions 
    2525 
    26 psql -f HarvestLoggingTables.sql $dbOptions 
    2726psql -f IngestLoggingTable.sql $dbOptions 
     27psql -f HarvestLog.sql $dbOptions 
     28psql -f HarvestType.sql $dbOptions 
     29psql -f formatTable.sql $dbOptions 
     30psql -f OAIProvider.sql $dbOptions 
     31psql -f provider.sql $dbOptions 
     32psql -f service_config.sql $dbOptions 
     33 
Note: See TracChangeset for help on using the changeset viewer.