<html><div style='background-color:'><DIV>
<P>Hey David ,</P>
<P>I liked u'r suggestion.</P>
<P>Why don't you let me know the file details to do it :)</P>
<P>Thanks,</P>
<P>Jai <BR><BR></P></DIV>
<DIV></DIV>
<DIV></DIV>>From: David Miller <JUSTDAVE@SYNDICOMM.COM>
<DIV></DIV>>Reply-To: developers@bugzilla.org
<DIV></DIV>>To: developers@bugzilla.org
<DIV></DIV>>Subject: Re: Adding more OS to select from dropdown list while entering
<DIV></DIV>>Date: Tue, 8 Apr 2003 14:38:47 -0400
<DIV></DIV>>
<DIV></DIV>>On 4/8/03 10:52 PM +0530, Me And You wrote:
<DIV></DIV>>
<DIV></DIV>> > Thanks so much friend,
<DIV></DIV>> >
<DIV></DIV>> > Finally I could find the solution :)
<DIV></DIV>> >
<DIV></DIV>> > I modified the field "op_sys" under the table "bugs".
<DIV></DIV>> >
<DIV></DIV>> > The the field "op_sys" is of type
<DIV></DIV>> >
<DIV></DIV>> > ENUM('All','Windows 3.1','Windows 95','Windows 98','Windows ME','Windows
<DIV></DIV>> >2000','Windows NT','Mac System 7','Mac System 7.5','Mac System 7.6.1','Mac
<DIV></DIV>> >System 8.0','Mac System 8.5','Mac System 8.6','Mac System
<DIV></DIV>> >9.0','Linux','BSDI','FreeBSD','NetBSD','OpenBSD','AIX','BeOS','HP-UX','IRIX','Neutrino','OpenVMS','OS/2','OSF/1','Solaris','SunOS','other')
<DIV></DIV>> >
<DIV></DIV>> > You can run the command (to add 'Windows XP','Windows XP Home' and
<DIV></DIV>> >'Windows XP Pro')
<DIV></DIV>> >
<DIV></DIV>> > mysql> ALTER TABLE bugs MODIFY op_sys enum('All','Windows 3.1','Windows
<DIV></DIV>> >95','Windows 98','Windows ME','Windows 2000','Windows XP','Windows XP
<DIV></DIV>> >Home','Windows XP Pro','Windows NT','Mac System 7','Mac System 7.5','Mac
<DIV></DIV>> >System 7.6.1','Mac System 8.0','Mac System 8.5','Mac System 8.6','Mac
<DIV></DIV>> >System
<DIV></DIV>> >9.0','Linux','BSDI','FreeBSD','NetBSD','OpenBSD','AIX','BeOS','HP-UX','IRIX','Neutrino','OpenVMS','OS/2','OSF/1','Solaris','SunOS','other');
<DIV></DIV>> >
<DIV></DIV>> > Hope this experience of mine will be helpful for all of us.
<DIV></DIV>> >
<DIV></DIV>> > Thanks to all for you for quick attempts to help me.
<DIV></DIV>>
<DIV></DIV>>Uhhh, why not just change the list in the localconfig file and run
<DIV></DIV>>checksetup.pl again? It'll change the schema for you.
<DIV></DIV>>--
<DIV></DIV>>Dave Miller Project Leader, Bugzilla Bug Tracking System
<DIV></DIV>>http://www.justdave.net/ http://www.bugzilla.org/
<DIV></DIV>>----
<DIV></DIV>>To view or change your list settings, click here:
<DIV></DIV>><HTTP: mj_wwwusr?user="mh12am4077@hotmail.com" cgi-bin bugzilla.org>
<DIV></DIV></div><br clear=all><hr>Mobile, masti, magic! Cool ringtones & logos. <a href="http://g.msn.com/8HMIENIN/2737">Get noticed</a> </html>