Big update of Clearadm

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

diff --git a/clearadm/lib/clearadm.sql b/clearadm/lib/clearadm.sql
index f365201..e722015 100644 (file)
--- 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,