Mercurial > kallithea
changeset 61:1b6d7662d6e2
Updated database model, with FK and Booleans
| author | Marcin Kuzminski <marcin@python-blog.com> |
|---|---|
| date | Sat, 10 Apr 2010 16:29:25 +0200 |
| parents | eb0268a89187 |
| children | 4df4c0eac619 |
| files | pylons_app/model/db.py |
| diffstat | 1 files changed, 6 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/pylons_app/model/db.py Sat Apr 10 16:28:52 2010 +0200 +++ b/pylons_app/model/db.py Sat Apr 10 16:29:25 2010 +0200 @@ -12,13 +12,15 @@ user_id = Column("user_id", SLInteger(), nullable=False, unique=True, default=None, primary_key=1) username = Column("username", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) password = Column("password", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) - active = Column("active", SLInteger(), nullable=True, unique=None, default=None) - admin = Column("admin", SLInteger(), nullable=True, unique=None, default=None) - + active = Column("active", SLBoolean(), nullable=True, unique=None, default=None) + admin = Column("admin", SLBoolean(), nullable=True, unique=None, default=None) + action_log = relation('UserLogs') + class UserLogs(Base): __tablename__ = 'user_logs' __table_args__ = {'useexisting':True} id = Column("id", SLInteger(), nullable=False, unique=True, default=None, primary_key=1) - user_id = Column("user_id", SLInteger(), nullable=True, unique=None, default=None) + user_id = Column("user_id", SLInteger(), ForeignKey(u'users.user_id'), nullable=True, unique=None, default=None) last_action = Column("last_action", SLText(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) last_action_date = Column("last_action_date", SLDateTime(timezone=False), nullable=True, unique=None, default=None) + user = relation('Users')