ON DELETE | ON UPDATE | |||
---|---|---|---|---|
vcl.sql | update-vcl.sql | vcl.sql | update-vcl.sql | |
blockComputers.computerid-->computer.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
blockComputers.imageid-->image.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
blockRequest.groupid-->usergroup.id | RESTRICT | CASCADE | RESTRICT | SET NULL |
blockRequest.imageid-->image.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
blockRequest.managementnodeid-->managementnode.id | RESTRICT | CASCADE | RESTRICT | SET NULL |
blockRequest.ownerid-->user.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
blockTimes.blockRequestid-->blockRequest.id | RESTRICT | CASCADE | CASCADE | CASCADE |
blockWebDate.blockRequestid-->blockRequest.id | RESTRICT | CASCADE | CASCADE | CASCADE |
blockWebTime.blockRequestid-->blockRequest.id | RESTRICT | CASCADE | CASCADE | CASCADE |
changelog.computerid-->computer.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
changelog.logid-->log.id | RESTRICT | CASCADE | CASCADE | RESTRICT |
changelog.userid-->user.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
clickThroughs.imageid-->image.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
clickThroughs.imagerevisionid-->imagerevision.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
clickThroughs.userid-->user.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
connectlog.userid-->user.id | CASCADE | CASCADE | RESTRICT | CASCADE |
resourcemap.resourcegroupid1-->resourcegroup.id | RESTRICT | CASCADE | CASCADE | CASCADE |
resourcemap.resourcegroupid2-->resourcegroup.id | RESTRICT | CASCADE | CASCADE | CASCADE |
resourcemap.resourcetypeid1-->resourcetype.id | RESTRICT | CASCADE | CASCADE | RESTRICT |
resourcemap.resourcetypeid2-->resourcetype.id | RESTRICT | CASCADE | CASCADE | RESTRICT |
semaphore.computerid-->computer.id | CASCADE | CASCADE | CASCADE | RESTRICT |
semaphore.imageid-->image.id | CASCADE | CASCADE | CASCADE | RESTRICT |
semaphore.imagerevisionid-->imagerevision.id | CASCADE | CASCADE | CASCADE | RESTRICT |
semaphore.managementnodeid-->managementnode.id | CASCADE | CASCADE | CASCADE | RESTRICT |
shibauth.userid-->user.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
statgraphcache.affiliationid-->affiliation.id | RESTRICT | CASCADE | RESTRICT | CASCADE |
statgraphcache.provisioningid-->provisioning.id | RESTRICT | CASCADE | RESTRICT | CASCADE |
subimages.imageid-->image.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
subimages.imagemetaid-->imagemeta.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.computerid-->computer.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.hostcomputerid-->computer.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.imageid-->image.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.imagerevisionid-->imagerevision.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.logid-->log.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.managementnodeid-->managementnode.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
sublog.predictivemoduleid-->module.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |
usergroup.affiliationid-->affiliation.id | RESTRICT | CASCADE | RESTRICT | RESTRICT |