lib/admissionrules/conditionaladmission/sql/uninstall.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

--
-- Remove conditional admissions.
--
DROP TABLE `conditionaladmissions`;

--
-- Delete associated StudipConditions and their fields.
--
DELETE FROM `conditionfields`
WHERE `condition_id` IN (
    SELECT `condition_id` FROM `admission_condition`
);

DELETE FROM `conditions`
WHERE `condition_id` IN (
    SELECT `condition_id` FROM `admission_condition`
);

DROP TABLE `admission_condition`;

--
-- Delete courseset assignments.
--
DELETE FROM `courseset_rule` WHERE `type`='ConditionalAdmission';