lib/admissionrules/preferentialadmission/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

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

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

DROP TABLE `prefadmission_condition`;

--
-- Remove favored admissions.
--
DROP TABLE `prefadmissions`;

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