Changes between Version 1 and Version 2 of dbdevelopment

Timestamp:

01/30/26 20:46:41 (3 hours ago)

Author:

231175

Comment:

--

dbdevelopment

@@ -146 +146 @@
     SELECT COUNT(*) INTO v_active_enrollments
     FROM enrollment
-    WHERE course_version_id = OLD.id
-      AND completion_date IS NULL;
+    WHERE course_version_id = OLD.id;
     
     IF v_active_enrollments > 0 THEN
@@ -246 +245 @@
 }}}
 
-{{{
-CREATE OR REPLACE FUNCTION audit_review_changes()
-RETURNS TRIGGER AS $$
-BEGIN
-    IF TG_OP = 'INSERT' THEN
-        INSERT INTO review_audit (review_id, new_rating, new_comment, action)
-        VALUES (NEW.id, NEW.rating, NEW.comment, 'INSERT');
-    ELSIF TG_OP = 'UPDATE' THEN
-        INSERT INTO review_audit (review_id, old_rating, new_rating, old_comment, new_comment, action)
-        VALUES (NEW.id, OLD.rating, NEW.rating, OLD.comment, NEW.comment, 'UPDATE');
-    ELSIF TG_OP = 'DELETE' THEN
-        INSERT INTO review_audit (review_id, old_rating, old_comment, action)
-        VALUES (OLD.id, OLD.rating, OLD.comment, 'DELETE');
-    END IF;
-    
-    RETURN NEW;
-END;
-$$ LANGUAGE plpgsql;
-
-CREATE TRIGGER trg_audit_review
-AFTER INSERT OR UPDATE OR DELETE ON review
-FOR EACH ROW
-EXECUTE FUNCTION audit_review_changes();
-}}}
-
 ==== Погледи (Views) ====
 
@@ -293 +267 @@
 }}}
 
-==== Помошни табели (Audit) ====
-
-{{{
-CREATE TABLE review_audit (
-    id SERIAL PRIMARY KEY,
-    review_id INTEGER NOT NULL REFERENCES review(id),
-    old_rating INTEGER,
-    new_rating INTEGER,
-    old_comment TEXT,
-    new_comment TEXT,
-    changed_at TIMESTAMP DEFAULT NOW(),
-    action VARCHAR(20)
-);
-
-CREATE INDEX idx_review_audit_review ON review_audit(review_id);
-CREATE INDEX idx_review_audit_changed_at ON review_audit(changed_at);
-}}}
-
 ----