Hmm may be we can add an "index=True" option? Even better have something like: db.add_index('table', 'name_index_as', ['field1','field2'], unique=True)
It'll add an index with multiple fields, unique=True is obviously optional. However, this may be to much work, and may be focusing ont he actual web part rather than the ORM is more important. :P On May 19, 7:04 am, benqktc <zxzwin...@gmail.com> wrote: > adding 'unique=True' to SQLField causes web2py to implicitly create > unique index on that column, that works for me. > > but what if i just want an index not an unique index. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---