Database Schema

Database schema
entry
A blog entry. This can be associated with a location (latitude and longitude), and may be edited over time.
aside
An aside is a short bit of markdown describing the entry. It can be NULL.
contents
Contents (markdown).
ctime
Creation time.
flags
1 if currently being edited (and thus not to be shown).
id
Unique identifier.
lang
IETF language tag (as in RFC 2616, 3.10).
latitude
Latitude (decimal degrees) of post. Both latitude and longitude are required for location.
longitude
Longitude (decimal degrees) of post. Both latitude and longitude are required for location.
mtime
Last updated.
title
Title (text).
userid
Posting user.
sess
Browser session. This is the usual setup.
cookie
Unique cookie generated for session.
ctime
Creation time in database.
id
Unique identifier.
userid
User attached to session.
user
A blogger. This is just an e-mail identified individual. Nothing complicated.
cloudkey
If applicable, a public key for cloud (media) updates.
cloudname
The name of the cloud account for media storage, if applicable.
cloudpath
If applicable, the path on the cloud server for media storage.
cloudsecret
If applicable, a secret key for cloud (media) content.
email
E-mail address (and login identifier).
flags
Bitmask of flags. If containing 0x01, the user can administer other users. If containing 0x02, the user is disabled and can't login.
hash
Hash representation of password.
id
Unique identifier.
lang
Default IETF language tag (as in RFC 2616, 3.10).
A link to their homepage, if applicable.
name
Free-form username.