Mercurial > kallithea
diff rhodecode/model/db.py @ 956:83d35d716a02 beta
started working on issue #56
author | Marcin Kuzminski <marcin@python-works.com> |
---|---|
date | Tue, 25 Jan 2011 18:59:20 +0100 |
parents | 2f83756f3041 |
children | 7d1483f3170b |
line wrap: on
line diff
--- a/rhodecode/model/db.py Mon Jan 24 22:41:40 2011 +0100 +++ b/rhodecode/model/db.py Tue Jan 25 18:59:20 2011 +0100 @@ -153,6 +153,29 @@ user = relation('User') repository = relation('Repository') + +class UsersGroup(Base, BaseModel): + __tablename__ = 'users_groups' + __table_args__ = {'useexisting':True} + + user_group_id = Column("users_groups_id", Integer(), nullable=False, unique=True, default=None, primary_key=True) + user_group_name = Column("user_group_name", String(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None) + + + members = relation('UsersGroupMember') + + +class UsersGroupMember(Base, BaseModel): + __tablename__ = 'users_groups_members' + __table_args__ = {'useexisting':True} + + user_groups_members_id = Column("user_groups_members_id", Integer(), nullable=False, unique=True, default=None, primary_key=True) + user_group_id = Column("user_group_id", Integer(), ForeignKey('users_groups.users_groups_id'), nullable=False, unique=None, default=None) + user_id = Column("user_id", Integer(), ForeignKey('users.user_id'), nullable=False, unique=None, default=None) + + user = relation('User') + users_group = relation('UsersGroup') + class Repository(Base, BaseModel): __tablename__ = 'repositories' __table_args__ = (UniqueConstraint('repo_name'), {'useexisting':True},)