Changeset 2112 for trunk/loreality/loreality/model/databases.py

Timestamp:

07/15/10 14:51:39 (22 months ago)

Author:

dart

Message:

LoReality?:
o AJAX work for message

File:

• trunk/loreality/loreality/model/databases.py (modified) (2 diffs)

trunk/loreality/loreality/model/databases.py

@@ -125 +125 @@
     login = sa.Column(sa.types.String, nullable=False)
     squadron_id = sa.Column(UUID(), ForeignKey('squadrons.id'))
+    loobject_id = sa.Column(UUID(), ForeignKey('loobjects.id'))
 
     messages = orm.relation("Message", backref="pilot")
@@ -139 +140 @@
         if message.unread:
             self.messages_unread += 1
+#----------------------------------------------------------------
+class LoObject(Base):
+    __tablename__ = 'loobjects'
+    id = sa.Column(UUID(), primary_key=True,default=uuid.uuid4)
+    name = sa.Column(sa.types.String, nullable=False)
+    group = sa.Column(sa.types.String, nullable=False)
+
+    latitude  = sa.Column(sa.types.Integer, nullable=False)
+    longitude = sa.Column(sa.types.Integer, nullable=False)
+    altitude  = sa.Column(sa.types.Integer, nullable=False)
+    heading   = sa.Column(sa.types.Integer, nullable=False)