Merge branch 'master' of https://github.com/adefaria/clearscm

[clearscm.git] / clearadm / lib / clearadm.sql

diff --git a/clearadm/lib/clearadm.sql b/clearadm/lib/clearadm.sql
index 8d47e36..7142ad9 100644 (file)
--- a/clearadm/lib/clearadm.sql
+++ b/clearadm/lib/clearadm.sql
@@ -174,7 +174,7 @@ create table vobstorage (
   source         decimal(10,1),
   total                  decimal(10,1),
 
   source         decimal(10,1),
   total                  decimal(10,1),
 

-  key vobtagIndex (tag),
+  key vobtagIndex (tag, region),

   primary key  (tag, region, timestamp)
   foreign key vobLink (tag, region)
     references vob (tag, region)
   primary key  (tag, region, timestamp)
   foreign key vobLink (tag, region)
     references vob (tag, region)


@@ -193,8 +193,12 @@ create table viewstorage (
   admin                decimal(10,1),
   total         decimal(10,1),
 
   admin                decimal(10,1),
   total         decimal(10,1),
 

-  key viewtagIndex (tag),
-  primary key (tag, region, timestamp)
+  key viewtagIndex (tag, region),
+  primary key (tag, region, timestamp),
+  foreign key viewLink (tag, region)
+    references view (tag, region)
+      on delete cascade
+      on update cascade

 ) engine=innodb; -- viewstorage
 
 -- loadavg: Contains a snapshot reading of a system's load average
 ) engine=innodb; -- viewstorage
 
 -- loadavg: Contains a snapshot reading of a system's load average