School-database/clear.sql at main · MaksymTur/School-database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
drop table if exists excuses cascade;

drop table if exists bell_schedule_history cascade;

drop table if exists groups_history cascade;

drop table if exists employees_history cascade;

drop table if exists posts cascade;

drop table if exists type_weights_history cascade;

drop table if exists marks cascade;

drop table if exists mark_types cascade;

drop table if exists holidays cascade;

drop table if exists salary_history cascade;

drop table if exists class_history cascade;

drop table if exists class_teacher_history cascade;

drop table if exists skips cascade;

drop table if exists pupils cascade;

drop table if exists groups_to_events cascade;

drop table if exists events cascade;

drop table if exists themes cascade;

drop table if exists quarters cascade;

drop table if exists groups_to_schedule cascade;

drop table if exists groups cascade;

drop table if exists schedule_history cascade;

drop type if exists week_day cascade;

drop table if exists rooms cascade;

drop table if exists employees cascade;

drop table if exists subject_to_class_certificate cascade;

drop table if exists subjects cascade;

drop table if exists classes cascade;

drop function if exists get_week_day(date) cascade;

drop function if exists has_post(integer, integer, timestamp) cascade;

drop function if exists add_post(integer, integer) cascade;

drop function if exists delete_post(integer, integer) cascade;

drop function if exists study_start(integer) cascade;

drop function if exists work_start(integer) cascade;

drop function if exists bell_begin_time(date, integer) cascade;

drop function if exists bell_end_time(date, integer) cascade;

drop function if exists bell_begin_time(integer) cascade;

drop function if exists bell_end_time(integer) cascade;

drop function if exists was_at_lecture(integer, integer) cascade;

drop function if exists is_studying(integer, timestamp) cascade;

drop function if exists get_class(integer, timestamp) cascade;

drop function if exists is_working(integer, timestamp) cascade;

drop function if exists get_bells_schedule(date) cascade;

drop function if exists get_parity(date) cascade;

drop function if exists get_schedule(date) cascade;

drop function if exists add_bell(integer, time, time, timestamp) cascade;

drop function if exists get_schedule(week_day, boolean, date) cascade;

drop function if exists add_to_schedule(integer, integer, integer, week_day, boolean, timestamp) cascade;

drop function if exists get_pupils_from_group(integer, timestamp) cascade;

drop function if exists get_groups_from_event(integer) cascade;

drop function if exists get_groups_of_pupil(integer, timestamp) cascade;

drop function if exists delete_from_group(integer, integer, timestamp) cascade;

drop function if exists get_mark_from_theme(integer, integer) cascade;

drop function if exists get_group_class(integer) cascade;

drop function if exists get_subject_of_theme(integer) cascade;

drop function if exists get_subject_of_schedule(integer) cascade;

drop function if exists get_mandatory(integer) cascade;

drop function if exists is_in_certificate(integer, integer) cascade;

drop function if exists get_theme_of_event(integer) cascade;

drop function if exists get_quarter_begin(integer) cascade;

drop function if exists get_quarter_end(integer) cascade;

drop function if exists get_quarter_year(integer) cascade;

drop function if exists get_quarter_order(integer) cascade;

drop function if exists get_now_quarter(date) cascade;

drop function if exists get_now_holiday(date) cascade;

drop function if exists get_quarter_of_theme(integer) cascade;

drop function if exists get_themes_in_quarter(integer, integer) cascade;

drop function if exists get_mark_in_quarter(integer, integer, integer) cascade;

drop function if exists get_quarters_in_year(integer) cascade;

drop function if exists get_mark_in_year(integer, integer, integer) cascade;

drop function if exists get_certificate_for_class(integer) cascade;

drop function if exists get_schedule_for_class(integer, date) cascade;

drop function if exists get_skip_date(integer) cascade;

drop function if exists is_real_skip(integer) cascade;

drop function if exists get_events_of_subject(integer) cascade;

drop function if exists get_all_skips(integer, integer) cascade;

drop function if exists bell_schedule_history_insert_trigger() cascade;

drop function if exists groups_mandatory_check_f(integer, integer) cascade;

drop function if exists groups_history_insert_trigger() cascade;

drop function if exists schedule_history_insert_trigger() cascade;

drop function if exists quarters_insert_trigger() cascade;

drop function if exists holidays_insert_trigger() cascade;

drop function if exists class_history_insert_delete_from_groups_trigger() cascade;

drop function if exists skips_insert_trigger() cascade;

drop function if exists groups_to_events_same_subject_check_f(integer, integer) cascade;

drop function if exists groups_to_events_same_class_check_f(integer, integer) cascade;

drop function if exists groups_to_events_delete_trigger() cascade;

drop function if exists groups_to_schedule_same_subject_check_f(integer, integer) cascade;

drop function if exists groups_to_schedule_same_class_check_f(integer, integer) cascade;