[web2py] KeyError: 'users'

[sushanth]

Hi,

How to create a primary key as name  as filed not id,right now i have 
exiting mysql schema in that string is PK and connected FK to other string 
field.i am design  a app in web2py in that  creating models using existing 
schema but  web2py is creating only id as PK default.

Can you please help on this

db=DAL('mysql://root:test1234...@localhost/new')


db.define_table('dogs',
    Field('owner_id','id'),
    Field('teamname'),primarykey=['owner_id','teamname'],
    migrate=False,
     )

db.define_table('users',
    Field('num','id'),  
    Field('name'), 
    Field('team',db.users),primarykey=['num','team'],
    migrate=False,
    )


db.users.name.requires = IS_NOT_EMPTY()
db.users.team.requires = IS_IN_DB(db, 'dogs.teamname', ' dogs_teamname')

error :

Traceback (most recent call last):
  File "/home/sushanth/Desktop/web2py/gluon/restricted.py", line 188, in 
restricted
    exec ccode in environment
  File "/home/sushanth/Desktop/web2py/applications/newone/models/db.py" 
<http://127.0.0.1:8000/admin/default/edit/newone/models/db.py>, line 13, in 
<module>
    Field('team',db.users),primarykey=['num','team'],
  File "/home/sushanth/Desktop/web2py/gluon/sql.py", line 1400, in __getattr__
    return dict.__getitem__(self,key)
KeyError: 'users'



Thanks in advance