@stifan Thanks for the response. You are right on the request_tenant field, and I should had explained it better.
When you use tenants, you kind of partition the database so only the users of that tenant can see the info/data of that tenant, but all the information of all the tenants are in the same database. So we cannot make a field (another different from request_tenant) unique because the database does not see the tenant "separation". On Wednesday, June 25, 2014 4:20:38 PM UTC-5, 黄祥 wrote: > > please try (not tested) > db._common_fields.append(Field('request_tenant', > default = request.env.http_host, writable = False, unique = True) ) > > ref: > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer > > best regards, > stifan > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.