Changes between Version 1 and Version 2 of DatabaseProgramming

Timestamp:

06/03/26 02:45:05 (13 days ago)

Author:

231071

Comment:

--

DatabaseProgramming

@@ -3 +3 @@
 == Тригери
 
-=== trg_validate_ballot
+=== 1. trg_validate_ballot
 
 **Тип:** `BEFORE INSERT` на табела `ballot`
@@ -91 +91 @@
 ----
 
-=== trg_after_insert_ballot_live_count
+=== 2. trg_after_insert_ballot_live_count
 
 **Тип:** `AFTER INSERT` на табела `ballot`
@@ -145 +145 @@
 ----
 
-=== trg_before_insert_voter_age
+=== 3. trg_before_insert_voter_age
 
 **Тип:** `BEFORE INSERT` на табела `voter`
@@ -192 +192 @@
 ----
 
-=== trg_after_voter_change_sync_stats
+=== 4. trg_after_voter_change_sync_stats
 
 **Тип:** `AFTER INSERT OR DELETE` на табела `voter`
@@ -227 +227 @@
 ----
 
-=== trg_prevent_duplicate_voter_checkin
+=== 5. trg_prevent_duplicate_voter_checkin
 
 **Тип:** `BEFORE INSERT` на табела `voter_election`
@@ -309 +309 @@
 == Функции
 
-=== fn_calculate_dhondt
+=== 6. fn_calculate_dhondt
 
 **Сигнатура:** `fn_calculate_dhondt(p_election_id bigint, p_district_id bigint)`
@@ -438 +438 @@
 ----
 
-=== fn_get_candidate_list_for_entity
+=== 7. fn_get_candidate_list_for_entity
 
 **Сигнатура:** `fn_get_candidate_list_for_entity(p_entity_id bigint, p_election_id bigint)`
@@ -523 +523 @@
 ----
 
-=== fn_station_anomaly_score
+=== 8. fn_station_anomaly_score
 
 **Сигнатура:** `fn_station_anomaly_score(p_station_id bigint, p_election_id bigint)`
@@ -666 +666 @@
 == Процедури
 
-=== sp_close_election
+=== 9. sp_close_election
 
 **Сигнатура:** `sp_close_election(IN p_election_id bigint)`
@@ -745 +745 @@
 ----
 
-=== sp_open_election
+=== 10. sp_open_election
 
 **Сигнатура:** `sp_open_election(IN p_election_id bigint)`
@@ -799 +799 @@
 ----
 
-=== sp_register_newly_eligible_voters
+=== 11. sp_register_newly_eligible_voters
 
 **Сигнатура:** `sp_register_newly_eligible_voters()`