[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ShopSuite-dev] shop and drop

From: Tomasz Wegrzanowski
Subject: Re: [ShopSuite-dev] shop and drop
Date: Thu, 23 Aug 2001 03:26:39 +0200
User-agent: Mutt/1.3.20i

On Thu, Aug 23, 2001 at 02:13:55AM +0100, Davi Leal wrote:
> Yes, you are right. So, must drop.psql be added to scripts/ ? What do you 
> think?. I
> think so now, as the script is a development tool.


> > It is already UNIQUE due to CREATE UNIQUE INDEX on it.
> Yes, it is. However, I thought removing the "CREATE UNIQUE INDEX ... 
> (shortdsc);"
> line and instead using "CREATE TABLE products (   shortdsc char(11) UNIQUE 
> ...". So the UNIQUE implicitly creates a key and therefore a index. This is 
> more
> compact. Am I right?.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]