|
From: <jh...@us...> - 2008-09-15 20:06:13
|
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) ); |