-------------------------------------------------------------------
BugId: 1
Title: Persons are not deleted when deleting a conference.
+Status: Fixed.
-------------------------------------------------------------------
BugId: 2
Title: SQL injections possible.
+Status:
-------------------------------------------------------------------
execQueryWithParameter(db, "DELETE FROM EVENT_ROOM WHERE xid_conference = :xid_conference", params);
execQueryWithParameter(db, "DELETE FROM EVENT_PERSON WHERE xid_conference = :xid_conference", params);
execQueryWithParameter(db, "DELETE FROM EVENT WHERE xid_conference = :xid_conference", params);
+ execQueryWithParameter(db, "DELETE FROM ROOM WHERE xid_conference = :xid_conference", params);
+ execQueryWithParameter(db, "DELETE FROM PERSON WHERE xid_conference = :xid_conference", params);
+ execQueryWithParameter(db, "DELETE FROM TRACK WHERE xid_conference = :xid_conference", params);
execQueryWithParameter(db, "DELETE FROM CONFERENCE WHERE id = :xid_conference", params);
- execQuery(db, "DELETE FROM ROOM WHERE NOT EXISTS(SELECT * FROM EVENT_ROOM WHERE xid_room = ROOM.id)");
- execQuery(db, "DELETE FROM PERSON WHERE NOT EXISTS(SELECT * FROM EVENT_PERSON WHERE xid_person = PERSON.id)");
commitTransaction();
}