Re: [ShopSuite-dev] shop and drop

[Tomasz Wegrzanowski]

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.

right


> > 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 
> NOT NULL,
> ...". So the UNIQUE implicitly creates a key and therefore a index. This is 
> more
> compact. Am I right?.

right