Web Diary is a Web-based multi-user CGI diary applet.
Version: 0.3.5Web 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.
Operating System: Linux
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.