X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=clearadm%2Flib%2Fclearadm.sql;fp=clearadm%2Flib%2Fclearadm.sql;h=e72201522ab441e809fe762889bb26caa03d0991;hb=0c802537ec02d6cfea4c41b3138535c09a319489;hp=f3652018bc829bf455c157ac3d27db19e932430a;hpb=bdb1e0c845a6921e22d52fbff3404d5c1dfae520;p=clearscm.git

diff --git a/clearadm/lib/clearadm.sql b/clearadm/lib/clearadm.sql
index f365201..e722015 100644
--- a/clearadm/lib/clearadm.sql
+++ b/clearadm/lib/clearadm.sql
@@ -157,6 +157,38 @@ create table fs (
       on update cascade
 ) engine=innodb; -- fs
 
+-- vobstorage: Contains a snapshot of a vob's storage pools at a given date
+-- and time
+create table vobstorage (
+  tag		varchar(255) not null,
+  region        varchar(255) not null,
+  timestamp	datetime     not null,
+  admin		decimal(10,1),
+  db		decimal(10,1),
+  cleartext	decimal(10,1),
+  derivedobj	decimal(10,1),
+  source	decimal(10,1),
+  total		decimal(10,1),
+
+  key vobtagIndex (tag),
+  primary key  (tag, region, timestamp)
+) engine=innodb; -- vobstorage
+
+-- viewstorage: Contains a snapshot of a view's storage pools at a given date
+-- and time
+create table viewstorage (
+  tag		varchar(255) not null,
+  region        varchar(255) not null,
+  timestamp	datetime     not null,
+  private	decimal(10,1),
+  db		decimal(10,1),
+  admin		decimal(10,1),
+  total         decimal(10,1),
+
+  key viewtagIndex (tag),
+  primary key (tag, region, timestamp)
+) engine=innodb; -- viewstorage
+
 -- loadavg: Contains a snapshot reading of a system's load average
 create table loadavg (
   system        varchar(255)    not null,