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)
);
|
