X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=clearadm%2Flib%2Fclearadm.sql;h=7142ad9b80442a6d81d770069c0aae924942d9ff;hb=360bd6c4a68de2625d6d09b117bf7b6cffd6cb78;hp=8d47e3607d38e81aa4478ce3b3a4c3530de1fc57;hpb=a70e80a6af6e31d56b120348bc8bc23cdd6543f5;p=clearscm.git

diff --git a/clearadm/lib/clearadm.sql b/clearadm/lib/clearadm.sql
index 8d47e36..7142ad9 100644
--- 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),
 
-  key vobtagIndex (tag),
+  key vobtagIndex (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),
 
-  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