gistfile1.py

from google.appengine.ext import db



class User(db.Model):
    account = db.StringProperty()
    password = db.StringProperty()
    name = db.StringProperty()
    created = db.DateTimeProperty(auto_now=True)

class URL(db.Model):
    user = db.ReferenceProperty()
    website = db.StringProperty()
    created = db.DateTimeProperty(auto_now=True)
    votes = db.IntegerProperty()
    
class Vote(db.Model):
    user = db.ReferenceProperty(User) #See if voted on this site yet
    url = db.ReferenceProperty(URL) #To apply vote to right URL
    upvote = db.IntegerProperty()
    created = db.DateTimeProperty(auto_now=True)