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},)