X-Git-Url: http://git.veekun.com/zzz-floof.git/blobdiff_plain/e080215f07b8153ef01d6c840a4ba3a4bfc2d770..224a257ade788e1a87aab78032dc3cdc9677cc06:/floof/model/users.py

diff --git a/floof/model/users.py b/floof/model/users.py
new file mode 100644
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")