From: Nirmalya L. <nir...@ya...> - 2009-01-29 01:26:06
|
Ravi, thanks for your query..I was out for a family tour...that is why I was not able to reply the query. You have asked for why I use varchar instead of int. As we know int variable can hold only integer value, but varchar can hold int as well as other non numeric value. "menu_id" is an unique field, So to increase the range of unique value I use varchar instead of int. Have you test the total menu system? If you need any help, you can ask me. --- নির্মাল্য লাহিড়ী [Nirmalya Lahiri] +৯১-৯৪৩৩১১৩৫৩৬ [+91-9433113536] --- On Wed, 1/21/09, Ravi Jaya <rav...@gm...> wrote: > From: Ravi Jaya <rav...@gm...> > Subject: Re: [sahana-maindev] Updated SMS module from Sahana project [by Nirmalaya] > To: mi...@op..., "Sahana developers' list" <sah...@li...> > Date: Wednesday, January 21, 2009, 7:25 PM > On Wed, Jan 21, 2009 at 7:18 AM, Mifan Careem > <mi...@op...> wrote: > > > AJ, > > > > Would be good if these are handled as patches on the > patch/feature > > tracker? Good work from Nirmalya though... > > > > Hi Arjun, > I am raising an issue, Please do check, why the following > field menu_id is > kept as a varchar rather than int. > > CREATE TABLE msg_menu_structure ( > menu_id varchar(6) NOT NULL UNIQUE KEY, > > > cheers > > RJ > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword_______________________________________________ > Sahana-maindev mailing list > Sah...@li... > https://lists.sourceforge.net/lists/listinfo/sahana-maindev |