| 1 | -- =====================================================================
|
|---|
| 2 | -- NUTRITIONEER | 00 - RESET QUERY
|
|---|
| 3 | -- =====================================================================
|
|---|
| 4 |
|
|---|
| 5 | DROP TABLE IF EXISTS intake_planner_save_to_list_post CASCADE;
|
|---|
| 6 | DROP TABLE IF EXISTS grocery_list_single_add_ingredient CASCADE;
|
|---|
| 7 | DROP TABLE IF EXISTS grocery_list_bulk_add_ingredient CASCADE;
|
|---|
| 8 | DROP TABLE IF EXISTS recipe_contains_restriction CASCADE;
|
|---|
| 9 | DROP TABLE IF EXISTS ingredient_contains_nutrient CASCADE;
|
|---|
| 10 | DROP TABLE IF EXISTS recipe_contains_ingredient CASCADE;
|
|---|
| 11 | DROP TABLE IF EXISTS biometrics CASCADE;
|
|---|
| 12 | DROP TABLE IF EXISTS intake_planner CASCADE;
|
|---|
| 13 | DROP TABLE IF EXISTS grocery_list CASCADE;
|
|---|
| 14 | DROP TABLE IF EXISTS comment CASCADE;
|
|---|
| 15 | DROP TABLE IF EXISTS post CASCADE;
|
|---|
| 16 | DROP TABLE IF EXISTS recipe CASCADE;
|
|---|
| 17 | DROP TABLE IF EXISTS restriction CASCADE;
|
|---|
| 18 | DROP TABLE IF EXISTS nutrient CASCADE;
|
|---|
| 19 | DROP TABLE IF EXISTS ingredient CASCADE;
|
|---|
| 20 | DROP TABLE IF EXISTS "user" CASCADE;
|
|---|
| 21 |
|
|---|
| 22 | DROP TYPE IF EXISTS post_status CASCADE;
|
|---|
| 23 | DROP TYPE IF EXISTS restriction_type CASCADE;
|
|---|
| 24 | DROP TYPE IF EXISTS nutrient_type CASCADE;
|
|---|
| 25 | DROP TYPE IF EXISTS nutrient_unit CASCADE;
|
|---|
| 26 | DROP TYPE IF EXISTS ingredient_type CASCADE;
|
|---|
| 27 | DROP TYPE IF EXISTS user_role CASCADE;
|
|---|
