[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Backend dem.urb needs cleaner constraint
|
From: |
Karsten Hilbert |
|
Subject: |
Re: [Gnumed-devel] Backend dem.urb needs cleaner constraint |
|
Date: |
Sat, 8 Oct 2011 22:55:49 +0200 |
|
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Fri, Oct 07, 2011 at 09:15:01PM -0700, Jim Busser wrote:
> dem.state warrants to be
>
> "state_code_key" UNIQUE, btree (UPPER(code), UPPER(country))
>
>
> dem.street warrants to be
>
> "street_id_urb_key" UNIQUE, btree (id_urb, UPPER(name), UPPER(postcode))
Done.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346