Re: [ShopSuite-dev] shop and drop

[Tomasz Wegrzanowski]

On Wed, Aug 22, 2001 at 03:32:24PM +0100, Davi Leal wrote:
> > Here are two scripts: shop.psql and drop.psql
> >
> > drop.psql drops all shopDB tables from db, so newer version can be
> > added (that's mostly for debug)
> 
> We have scripts/clean.psql (DELETE). Must the drop.psql (DROP) be added to the
> scripts/ directory?. I do not think so. At least not now. What do you think?.

clean.psql doesn't remove tables, drop.sql does.

Compare:
$ psql shopdb <drop.sql
$ psql shopdb <shop.sql # new version

With:
$ dropdb shopdb
$ createdb shopdb
$ su
# su postgres
$ psql shopdb <rational.sql
$ ^D
# ^D
$ psql shopdb shop.sql # new version

> Agreed. And ... What about using 'UNIQUE' too into the products.shortdsc 
> field?.
> See the diff of attached shop.psql.

It is already UNIQUE due to CREATE UNIQUE INDEX on it.