Added OpenID registration and login.

[zzz-floof.git] / floof / model / users.py

diff --git a/floof/model/users.py b/floof/model/users.py
new file mode 100644 (file)
index 0000000..f51282c
--- /dev/null
+++ b/floof/model/users.py
@@ -0,0 +1,19 @@
+from sqlalchemy import Column, ForeignKey
+from sqlalchemy.orm import relation
+from sqlalchemy.types import Integer, Unicode
+
+from floof.model import meta
+
+__all__ = ['User', 'IdentityURL']
+
+class User(meta.TableBase):
+    __tablename__ = 'users'
+    id = Column(Integer, primary_key=True)
+    name = Column(Unicode(length=20), nullable=False)
+
+class IdentityURL(meta.TableBase):
+    __tablename__ = 'identity_urls'
+    url = Column(Unicode(length=255), primary_key=True)
+    user_id = Column(Integer, ForeignKey('users.id'))
+
+IdentityURL.user = relation(User, lazy=False, backref="identity_urls")