diff options
Diffstat (limited to 'db/migrations.rkt')
| -rw-r--r-- | db/migrations.rkt | 20 |
1 files changed, 1 insertions, 19 deletions
diff --git a/db/migrations.rkt b/db/migrations.rkt index a0d7b9e..71296f7 100644 --- a/db/migrations.rkt +++ b/db/migrations.rkt @@ -62,36 +62,25 @@ #:if-not-exists nutrient_value_sets #:columns [id integer #:not-null] [nutrient_measurement_id integer] - [nutrient_target_id integer] [crop_requirement_id integer] [fertilizer_product_id integer] #:constraints (primary-key id) (foreign-key nutrient_measurement_id #:references (nutrient_measurements id) #:on-delete #:cascade) - (foreign-key nutrient_target_id #:references (nutrient_targets id) #:on-delete #:cascade) (foreign-key crop_requirement_id #:references (crop_requirements id) #:on-delete #:cascade) (foreign-key fertilizer_product_id #:references (fertilizer_products id) #:on-delete #:cascade) (unique nutrient_measurement_id) - (unique nutrient_target_id) (unique crop_requirement_id) (unique fertilizer_product_id) (check (or (and (is-not-null nutrient_measurement_id) - (is-null nutrient_target_id) (is-null crop_requirement_id) (is-null fertilizer_product_id)) (and (is-null nutrient_measurement_id) - (is-not-null nutrient_target_id) (is-null crop_requirement_id) (is-null fertilizer_product_id)) (and (is-null nutrient_measurement_id) - (is-null nutrient_target_id) (is-not-null crop_requirement_id) - (is-null fertilizer_product_id)) - (and (is-null nutrient_measurement_id) - (is-null nutrient_target_id) - (is-null crop_requirement_id) - (is-not-null fertilizer_product_id))))) + (is-null fertilizer_product_id))))) "CREATE INDEX IF NOT EXISTS idx_nvs_meas ON nutrient_value_sets(nutrient_measurement_id)" - "CREATE INDEX IF NOT EXISTS idx_nvs_targ ON nutrient_value_sets(nutrient_target_id)" "CREATE INDEX IF NOT EXISTS idx_nvs_crop ON nutrient_value_sets(crop_requirement_id)" "CREATE INDEX IF NOT EXISTS idx_nvs_prod ON nutrient_value_sets(fertilizer_product_id)")) @@ -115,13 +104,6 @@ #:constraints (primary-key id) (unique measurement_date)))) -(define-migration "create table nutrient_targets" - (list (create-table #:if-not-exists nutrient_targets - #:columns [id integer #:not-null] - ;; ISO8601 date - [target_date text #:not-null] - #:constraints (primary-key id) - (unique target_date)))) ;;;;;;;; ;; CROPS |