Changes between Version 2 and Version 3 of Software/Productionalisation/MuaSchema


Ignore:
Timestamp:
04/24/13 16:46:08 (7 years ago)
Author:
smartp@…
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Software/Productionalisation/MuaSchema

    v2 v3  
    11= MUA Schema = 
    22 
    3 {{{ 
     3 
     4    create table AggregatedEvent ( 
     5        persistantId int8 not null, 
     6        eventtime timestamp, 
     7        serviceHost varchar(400), 
     8        resourceHost varchar(255), 
     9        serviceId varchar(255), 
     10        resourceId varchar(255), 
     11        eventId int4 not null, 
     12        eventType varchar(255), 
     13        resourceIdCategory int4, 
     14        entityId varchar(255), 
     15        serviceName varchar(255), 
     16        organisationName varchar(255), 
     17        periodStart timestamp, 
     18        periodEnd timestamp, 
     19        primary key (persistantId) 
     20    ); 
     21 
    422    create table AuthenticationEvent ( 
    523        persistantId int8 not null, 
     
    4260        sessionId varchar(255), 
    4361        current_hashCode int4, 
     62        primary key (persistantId) 
     63    ); 
     64 
     65    create table JuspAggregatedEvent ( 
     66        persistantId int8 not null, 
     67        eventtime timestamp, 
     68        serviceHost varchar(400), 
     69        resourceHost varchar(255), 
     70        serviceId varchar(255), 
     71        resourceId varchar(255), 
     72        eventId int4 not null, 
     73        eventType varchar(255), 
     74        resourceIdCategory int4, 
     75        entityId varchar(255), 
     76        serviceName varchar(255), 
     77        organisationName varchar(255), 
     78        periodStart timestamp, 
     79        periodEnd timestamp, 
     80        jr1Downloads int4, 
     81        jr1aDownloads int4, 
     82        plId varchar(255), 
     83        totalDownloads int4, 
    4484        primary key (persistantId) 
    4585    ); 
     
    118158    ); 
    119159 
     160    create table WugenEvent ( 
     161        persistantId int8 not null, 
     162        eventtime timestamp, 
     163        serviceHost varchar(400), 
     164        resourceHost varchar(255), 
     165        serviceId varchar(255), 
     166        resourceId varchar(255), 
     167        eventId int4 not null, 
     168        eventType varchar(255), 
     169        resourceIdCategory int4, 
     170        entityId varchar(255), 
     171        serviceName varchar(255), 
     172        organisationName varchar(255), 
     173        target varchar(255), 
     174        quality int4, 
     175        wayflessUrl varchar(255), 
     176        primary key (persistantId) 
     177    ); 
     178 
    120179    create table event ( 
    121180        persistantId int8 not null, 
     
    154213    ); 
    155214 
     215    create index AggregatedEventeventid_i on AggregatedEvent (eventId); 
     216 
     217    create index AggregatedEventorgname_i on AggregatedEvent (organisationName); 
     218 
     219    create index AggregatedEventserviceid_i on AggregatedEvent (serviceId); 
     220 
     221    create index AggregatedEventservicename_i on AggregatedEvent (serviceName); 
     222 
     223    create index AggregatedEventrequesthost_i on AggregatedEvent (serviceHost); 
     224 
     225    create index AggregatedEvententityid_i on AggregatedEvent (entityId); 
     226 
     227    create index AggregatedEventdt_i on AggregatedEvent (eventtime); 
     228 
    156229    create index AuthenticationEventeventid_i on AuthenticationEvent (eventId); 
    157230 
     
    196269    create index hashcode_i on EzproxyAuthenticationEvent (current_hashCode); 
    197270 
     271    create index JuspAggregatedEventAggregatedEventeventid_i on JuspAggregatedEvent (eventId); 
     272 
     273    create index JuspAggregatedEventAggregatedEventorgname_i on JuspAggregatedEvent (organisationName); 
     274 
     275    create index JuspAggregatedEventAggregatedEventserviceid_i on JuspAggregatedEvent (serviceId); 
     276 
     277    create index JuspAggregatedEventAggregatedEventservicename_i on JuspAggregatedEvent (serviceName); 
     278 
     279    create index JuspAggregatedEventAggregatedEventrequesthost_i on JuspAggregatedEvent (serviceHost); 
     280 
     281    create index JuspAggregatedEventAggregatedEvententityid_i on JuspAggregatedEvent (entityId); 
     282 
     283    create index JuspAggregatedEventAggregatedEventdt_i on JuspAggregatedEvent (eventtime); 
     284 
    198285    create index RadiusAuthenticationEventAuthenticationEventeventid_i on RadiusAuthenticationEvent (eventId); 
    199286 
     
    236323    create index ShibbolethIdpAuthenticationEventschool_i on ShibbolethIdpAuthenticationEvent (school); 
    237324 
    238     create index hashcode_i_shib on ShibbolethIdpAuthenticationEvent (current_hashCode); 
     325    create index hashcode_i on ShibbolethIdpAuthenticationEvent (current_hashCode); 
    239326 
    240327    create index ShibbolethSpAuthenticationEventAuthenticationEventeventid_i on ShibbolethSpAuthenticationEvent (eventId); 
     
    257344 
    258345    create index ShibbolethSpAuthenticationEventschool_i on ShibbolethSpAuthenticationEvent (school); 
     346 
     347    create index WugenEventeventid_i on WugenEvent (eventId); 
     348 
     349    create index WugenEventorgname_i on WugenEvent (organisationName); 
     350 
     351    create index WugenEventserviceid_i on WugenEvent (serviceId); 
     352 
     353    create index WugenEventservicename_i on WugenEvent (serviceName); 
     354 
     355    create index WugenEventrequesthost_i on WugenEvent (serviceHost); 
     356 
     357    create index WugenEvententityid_i on WugenEvent (entityId); 
     358 
     359    create index WugenEventdt_i on WugenEvent (eventtime); 
    259360 
    260361    create index eventid_i on event (eventId); 
     
    290391 
    291392    insert into hibernate_unique_key values ( 0 ); 
    292 }}}