[AOLSERVER-COMMITS] havardblog README, NONE, 1.1 schema.sql, NONE, 1.1

[<jh...@us...>]

Update of /cvsroot/aolserver/havardblog
In directory sc8-pr-cvs11.sourceforge.net:/tmp/cvs-serv18580

Added Files:
	README schema.sql 
Log Message:
Initial import of Havard's Crappy Blog as seen at http://johnhavard.com/



--- NEW FILE: README ---
This blog was initially a couple of .adp scripts, but was changed
at the urging of Dossy.  To get ridiculous speeds everything is
cached, once again at the urging of Dossy.

It's still a barely usable app, but it does serve my minimal needs.
My hope is that someone will take this code and do something useful,
such as create a fully-featured blogging app for AOLserver.

I'll assume the person using this software is capable of configuring
AOLserver with database pool named 'pool1'.  I used postgresql, but 
others will likely work with the included schema. YMMV.

TODO:

RSS/Atom generator

Edit/Delete posts

Better admin section

Initial setup wizard?

--- NEW FILE: schema.sql ---
--- This was written for PostgreSQL.
CREATE DOMAIN AUTHOR_ID AS VARCHAR(16) NOT NULL;
CREATE DOMAIN EMAIL AS VARCHAR(128) NOT NULL;
CREATE DOMAIN SLUG AS VARCHAR(32) NOT NULL;
CREATE DOMAIN TAG_T AS VARCHAR(64) NOT NULL;

CREATE TABLE AUTHOR (
	ID AUTHOR_ID PRIMARY KEY,
	PERSONAL_NAME VARCHAR(64) NOT NULL,
	DISPLAY_EMAIL EMAIL,
	REAL_EMAIL EMAIL,
	PASSWORD VARCHAR(64) NOT NULL
);

CREATE TABLE ARTICLE (
	SLUG SLUG NOT NULL,
	PUBDATE DATE NOT NULL,
	UPDATED TIMESTAMP NOT NULL,
	AUTHOR AUTHOR_ID REFERENCES AUTHOR(ID) NOT NULL,
	LEAD TEXT NOT NULL,
	BODY TEXT NOT NULL,
	TITLE VARCHAR(128) NOT NULL,
	PRIMARY KEY (SLUG, PUBDATE)
);