Alkali notes 2004-05-23 22:50 Posts table: post posted-by (user.id) ID title (human-readable) short title (clipped human-readable) posted-at (timestamp) last-edit (timestamp) head (doctype through "") -- bad idea Comments table: id comment posted-at (timestamp) last-edit (timestamp) parent-comment (comment.id | null) parent-post (post.id) posted-by (user.id) Users table: id login hash long name type enum(philosopher-king, guardian, citizen) URI bio Posting: User must be a philospher-king. post defaults to '' ID is YYYY/MM/DD/(n) user.id is user title defaults to '' short title defaults to '' posted-at is the timestamp last-edit is the same head XXX Deleting a post User must be a philosopher-king. All comments where in-reply-to is the post are moved to heaven.