Package DB Schema v3

[Dimitris Glezos]

O/H Karel Zak έγραψε:
> On Mon, Dec 04, 2006 at 09:59:11PM -0800, Toshio Kuratomi wrote:
>>   pendingURLTemplate text null,
>>   summary text null,
>>   description text null,
>>   unique (name, version),
>>   check (status = 'development' or status = 'active' or status = 'maintanence'
>>     or status = 'EOL' or status = 'rejected')
>> );
> 
>  From my point of view the status column is odd. I think you should
>  use an abbreviation or one char only.
> 
>  status     text not null default 'D'
>             check ( status IN ('D','A','M','E','R') )

It would be best to keep open the possibility that these (and other similar)
flags might change in the future, happen to have conflicting first letters etc.

-d


-- 
Dimitris Glezos
Jabber ID: glezos at jabber.org, GPG: 0xA5A04C3B
http://dimitris.glezos.com/


"He who gives up functionality for ease of use
loses both and deserves neither." (Anonymous)
--