Project

General

Profile

« Previous | Next » 

Revision 1085

vegbien.sql: locationevent: Added unique constraint for subplots based on subplot location

View differences:

vegbien.my.sql
3012 3012

  
3013 3013

  
3014 3014
--
3015
-- Name: locationevent_keys_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3016
--
3017

  
3018
ALTER TABLE locationevent
3019
    ADD CONSTRAINT locationevent_keys_parent_location UNIQUE (parent_id, location_id);
3020

  
3021

  
3022
--
3015 3023
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3016 3024
--
3017 3025

  

Also available in: Unified diff