-
Notifications
You must be signed in to change notification settings - Fork 0
/
drop_views.sql
49 lines (49 loc) · 2.29 KB
/
drop_views.sql
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
DROP VIEW IF EXISTS mab_target_view;
DROP VIEW IF EXISTS mab_epitope_view;
DROP VIEW IF EXISTS mab_synonym;
DROP VIEW IF EXISTS single_mab_view;
DROP VIEW IF EXISTS rx_single_mab_view;
DROP VIEW IF EXISTS rx_combo_mab_view;
DROP VIEW IF EXISTS rx_mab_view;
DROP VIEW IF EXISTS dms_single_mab_view;
DROP VIEW IF EXISTS dms_combo_mab_view;
DROP VIEW IF EXISTS dms_mab_view;
DROP VIEW IF EXISTS rx_dms_single_mab_view;
DROP VIEW IF EXISTS rx_dms_combo_mab_view;
DROP VIEW IF EXISTS rx_dms_mab_view;
DROP VIEW IF EXISTS isolate_mutations_with_ref_view;
DROP VIEW IF EXISTS isolate_mutations_spike_view;
DROP VIEW IF EXISTS isolate_mutations_spike_no_614g_683g_view;
DROP VIEW IF EXISTS _isolate_mutations_spike_del_view;
DROP VIEW IF EXISTS _isolate_mutations_spike_del_group_view;
DROP VIEW IF EXISTS _isolate_mutations_spike_consecu_del_view;
DROP VIEW IF EXISTS _isolate_mutations_spike_merged_del_view;
DROP VIEW IF EXISTS _isolate_mutations_spike_normal_view;
DROP VIEW IF EXISTS isolate_mutations_single_s_mut_view;
DROP VIEW IF EXISTS _isolate_mutations_combo_s_mut_view;
DROP VIEW IF EXISTS isolate_mutations_combo_s_mut_view;
DROP VIEW IF EXISTS isolate_wildtype_view;
DROP VIEW IF EXISTS isolate_non_wildtype_view;
DROP VIEW IF EXISTS isolate_variant_view;
DROP VIEW IF EXISTS _isolate_mutations_spike_raw_mut_view;
DROP VIEW IF EXISTS rx_conv_plasma_wt_infect_view;
DROP VIEW IF EXISTS rx_conv_plasma_infect_var_view;
DROP VIEW IF EXISTS rx_vacc_plasma_infect_var_view;
DROP VIEW IF EXISTS rx_vacc_plasma_full_dosage_view;
DROP VIEW IF EXISTS susc_results_view;
DROP VIEW IF EXISTS susc_results_50_view;
DROP VIEW IF EXISTS susc_results_wt_view;
DROP VIEW IF EXISTS susc_results_50_wt_view;
DROP VIEW IF EXISTS susc_results_cp_50_wt_view;
DROP VIEW IF EXISTS susc_results_mab_50_wt_view;
DROP VIEW IF EXISTS susc_results_vp_50_wt_view;
DROP VIEW IF EXISTS susc_results_aggr_view;
DROP VIEW IF EXISTS susc_results_aggr_50_view;
DROP VIEW IF EXISTS susc_results_aggr_wt_view;
DROP VIEW IF EXISTS susc_results_aggr_50_wt_view;
DROP VIEW IF EXISTS susc_results_indiv_view;
DROP VIEW IF EXISTS susc_results_indiv_50_view;
DROP VIEW IF EXISTS susc_results_indiv_wt_view;
DROP VIEW IF EXISTS susc_results_indiv_50_wt_view;
DROP VIEW IF EXISTS _isolate_mutations_variant_raw_s_mut_view;
DROP VIEW IF EXISTS isolate_mutations_variant_raw_s_mut_view;