projects
/
clearscm.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added a few more things to clean
[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