Adding more OS to select from dropdown list while entering

[David Miller]

On 4/8/03 10:52 PM +0530, Me And You wrote:

> Thanks so much friend,
>
> Finally I could find the solution :)
>
> I modified the field "op_sys" under the table "bugs".
>
> The the field "op_sys" is of type
>
> ENUM('All','Windows 3.1','Windows 95','Windows 98','Windows ME','Windows
>2000','Windows NT','Mac System 7','Mac System 7.5','Mac System 7.6.1','Mac
>System 8.0','Mac System 8.5','Mac System 8.6','Mac System
>9.0','Linux','BSDI','FreeBSD','NetBSD','OpenBSD','AIX','BeOS','HP-UX','IRIX','Neutrino','OpenVMS','OS/2','OSF/1','Solaris','SunOS','other')
>
> You can run the command (to add 'Windows XP','Windows XP Home' and
>'Windows XP Pro')
>
> mysql> ALTER TABLE bugs MODIFY op_sys enum('All','Windows 3.1','Windows
>95','Windows 98','Windows ME','Windows 2000','Windows XP','Windows XP
>Home','Windows XP Pro','Windows NT','Mac System 7','Mac System 7.5','Mac
>System 7.6.1','Mac System 8.0','Mac System 8.5','Mac System 8.6','Mac
>System
>9.0','Linux','BSDI','FreeBSD','NetBSD','OpenBSD','AIX','BeOS','HP-UX','IRIX','Neutrino','OpenVMS','OS/2','OSF/1','Solaris','SunOS','other');
>
> Hope this experience of mine will be helpful for all of us.
>
> Thanks to all for you for quick attempts to help me.

Uhhh, why not just change the list in the localconfig file and run
checksetup.pl again?  It'll change the schema for you.
-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/