def __init__(self, profiles_table, traits_table):
     profile_col = PkName('profile')
     profile_col.set_fk(profiles_table)
     trait_col = PkName('trait')
     trait_col.set_fk(traits_table)
     ord_col = Num('ord')
     Table.__init__(self, 'profile_trait', [profile_col, trait_col, ord_col])

 def __init__(self):
     taskid = PkNum('taskid')
     taskid.set_auto_increment('task_ident')
     name = Name('name')
     desc = Text('description')
     cols = [taskid, name, desc]
     Table.__init__(self, 'tasks', cols)

 def __init__(self):
     idcol = PkName('name')
     keyid = Name('keyid')
     keyid.constraint.unique = True
     data = Text('data')
     columns = [idcol, keyid, data]
     Table.__init__(self, 'archive_keys', columns)

 def __init__(self, machines_table):
     machine_col = PkName('machine')
     machine_col.set_fk(machines_table)
     family_col = PkName('family')
     family_col.set_fk('families')
     columns = [machine_col, family_col]
     Table.__init__(self, 'machine_family', columns)

 def __init__(self):
     entityid = PkNum('entityid')
     fieldname = PkBigname('fieldname')
     # value defaults to text type, it needs to be coerced into
     # it's supported type
     value = Text('value')
     cols = [entityid, fieldname, value]
     Table.__init__(self, 'entity_extfields', cols)

 def __init__(self):
     idcol = AutoId('workid')
     type_ = Name('type')
     title = Bigname('title')
     url = Bigname('url')
     desc = Text('description')
     cols= [idcol, type_, title, url, desc]
     Table.__init__(self, 'all_works', cols)

 def __init__(self, idcol, idtable, name):
     id_ = PkNum(idcol)
     id_.set_fk(idtable)
     tagname = PkName('tag')
     tagname.set_fk('tagnames')
     tagval = Text('value')
     cols = [id_, tagname, tagval]
     Table.__init__(self, name, cols)

 def __init__(self):
     gamenum = PkNum('gamenum')
     title = Bigname('title')
     desc = Text('desc')
     # we are going to store a dictionary in
     # smallinfo for a little while
     smallinfo = Text('smallinfo')
     cols = [gamenum, title, desc, smallinfo]
     Table.__init__(self, 'abandonia_games', cols)

 def __init__(self, fs_table, mounts_table):
     fs_col = PkName('filesystem')
     fs_col.set_fk(fs_table)
     mnt_name_col = PkName('mnt_name')
     mnt_name_col.set_fk(mounts_table)
     ord_col = Num('ord')
     partition_column = Num('partition')
     columns = [fs_col, mnt_name_col, ord_col, partition_column]
     Table.__init__(self, 'filesystem_mounts', columns)

 def __init__(self):
     gmcol = PkName('game')
     gncol = Name('genre')
     fncol = Bigname('fullname')
     dbpth = Bigname('dosboxpath')
     launch = Bigname('launchcmd')
     desc  = Text('desc')
     cols = [gmcol, gncol, fncol, dbpth, launch, desc]
     Table.__init__(self, 'games', cols)