hello everybody! I created a table of contacts that requires the first name+last name to be unique the table:
db.define_table("Contacts", Field("FirstName", "string", length=45, notnull=True), Field("LastName", "string", length=45, notnull=True), Field("Title", "string", length=45, default=None), Field("Department", "string", length=45, default=None), Field("Address", "string", length=255, default=None), Field("Phone", "string", length=45, default=None), Field("Fax", "string", length=45, default=None), Field("Email", "string", length=45, default=None), Field("Comments", "text", default=None), migrate=True) how do I instruct the DAL to create unique constraint on FirstName +LastName when in creates the table in the database? I have lots of tables that have unique constrain on 2-3 fields, so I prefer not to do this manually..... any help will be appreciated!