catalog varchar(64), t_schema varchar(64),
   t_name varchar(64), geometry_column varchar(64), t_srid int

begin
  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end

catalog varchar(64), t_schema varchar(64),
   t_name varchar(64), geometry_column varchar(64)

begin
  set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end

IN `course_id` INT, IN `attendance_date` DATE, IN `attendance_data` TEXT

BEGIN
    -- هذا إجراء مبسط، يمكن تطويره لمعالجة بيانات الحضور
    -- attendance_data يمكن أن يكون JSON أو نص مفصول
    INSERT INTO attendance (student_id, course_id, attendance_date, status, recorded_by)
    SELECT student_id, course_id, attendance_date, 'حاضر', 1
    FROM course_registrations 
    WHERE course_id = course_id AND status = 'معتمد';
END

IN `student_id` INT

BEGIN
    DECLARE new_gpa DECIMAL(4,2);
    
    SET new_gpa = CalculateStudentGPA(student_id);
    
    UPDATE students 
    SET gpa = new_gpa,
        total_credits = (
            SELECT SUM(c.credits) 
            FROM course_registrations cr 
            JOIN courses c ON cr.course_id = c.id 
            WHERE cr.student_id = student_id AND cr.status = 'معتمد'
        )
    WHERE id = student_id;
END

`student_id` INT

decimal(4,2)

BEGIN
    DECLARE total_points DECIMAL(10,2);
    DECLARE total_credits INT;
    DECLARE gpa DECIMAL(4,2);
    
    SELECT SUM(g.grade_point * c.credits), SUM(c.credits)
    INTO total_points, total_credits
    FROM grades g
    JOIN courses c ON g.course_id = c.id
    WHERE g.student_id = student_id AND g.status = 'معتمد';
    
    IF total_credits > 0 THEN
        SET gpa = total_points / total_credits;
    ELSE
        SET gpa = 0.00;
    END IF;
    
    RETURN gpa;
END