diff options
Diffstat (limited to 'data/dozmod-upgrade.sql')
| -rw-r--r-- | data/dozmod-upgrade.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/data/dozmod-upgrade.sql b/data/dozmod-upgrade.sql index f235926..190436e 100644 --- a/data/dozmod-upgrade.sql +++ b/data/dozmod-upgrade.sql @@ -81,7 +81,7 @@ DELETE pm -- Migrate image permissions
INSERT IGNORE INTO sat.imagepermission(imagebaseid, userid, canlink, candownload, canedit, canadmin)
SELECT pm.GUID_imageID, pm.userID, pm.link_allowed, pm.image_read, pm.image_write, pm.image_admin
- FROM bwLehrpool.pm_VLData_image AS pm;
+ FROM bwLehrpool.pm_VLData_image AS pm WHERE pm.userID IN (SELECT userid FROM sat.user);
-- Delete lectures which link to a non existing image
DELETE lec
|