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@xxxxxxxxxx, GPG: 0xA5A04C3B
http://dimitris.glezos.com/
"He who gives up functionality for ease of use
loses both and deserves neither." (Anonymous)
--
