kacaii.dev / senac-brigade-server
wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo
gleam
fork atom
senac-brigade-server / priv / sql / drop.sql
at main 26 lines 1.2 kB view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- VIEWS ----------------------------------------------------------------------- 2drop view if exists vw_count_active_occurrences; 3drop view if exists vw_count_recent_occurrences; 4drop view if exists vw_count_total_occurrences; 5drop view if exists vw_count_active_brigades; 6 7-- TRIGGERS -------------------------------------------------------------------- 8drop trigger if exists tgr_default_notification_preferences 9on user_account; 10drop function if exists public.set_default_notification_preferences; 11 12-- pgt-ignore-start lint/safety/banDropTable: We are resetting the Database 13drop table if exists public.occurrence_brigade; 14drop table if exists public.brigade_membership; 15drop table if exists public.occurrence; 16drop table if exists public.brigade; 17drop table if exists public.user_notification_preference; 18drop table if exists public.user_account; 19-- pgt-ignore-end lint/safety/banDropTable 20 21-- TYPES ----------------------------------------------------------------------- 22drop type if exists public.notification_type_enum; 23drop type if exists public.occurrence_category_enum; 24drop type if exists public.occurrence_subcategory_enum; 25drop type if exists public.user_role_enum; 26drop type if exists public.occurrence_priority_enum;