Web diary 0.3.5

Web Diary is a Web-based multi-user CGI diary applet.
Web Diary is a Web-based multi-user CGI diary applet. It includes scripts for allowing users to make entries publicly viewable, easy administration, and user preference editing.

There are two changes to the database structure in this release and is very simple:

1. There is a new table (see diary.tbls), categories, and two pieces of information that needs to go in there. Nothing too complicated.
2. There needs to be one column added to, and one column removed from entries. You can accomplish this via something like:

alter table entries add entFCat int not null default 1
update entries set entFCat=2 where entFIsPublic=1
alter table entries drop entFIsPublic

Though, as usual, you might be wise to make a backup, though this is what I did, and didn't have a problem with it. What this does, in order, is 1) creates the new column, 2) preserves the public entries.
3) gets rid of the old column.

Other than that, I don't recall any signigicant changes that were made in
thi version that will affect the database.

last updated on:
June 23rd, 2006, 3:05 GMT
license type:
GPL (GNU General Public License) 
developed by:
Dave DeMaagd
ROOT \ Office \ News/Diary
Web diary
Download Button

In a hurry? Add it to your Download Basket!

user rating 16



Rate it!

Add your review!