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

Re: UDD: proposed schema changes.

On 21/09/08 at 20:37 +0200, Kurt Roeckx wrote:
> Hi,
> I'd like to make some minor changes the current udd schema:
> - Make severity an enum instead of text:
>   CREATE TYPE bugs_severity AS ENUM ('fixed', 'wishlist', 'minor', 'normal', 'important', 'serious', 'grave', 'critical');
>   This would allow to make queries using something like
>   severity >= 'serious', and get what you expect, instead of a string
>   compare.
> - Add an affects_experimental in bugs and archived_bugs
> - Rename affects_sarchived_table to affects_stable and
>   affects_unsarchived_table to affects_unstable in
>   archived_bugs.
> Does anybody have any probems with those?

No, please go ahead.
| Lucas Nussbaum
| lucas@lucas-nussbaum.net   http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr             GPG: 1024D/023B3F4F |

Reply to: