Sunday, February 17, 2008

Update: Round 2

Instead of being distracted, I'll try to make go of the update for tasktimer. After some minor, changes to the back-end database that I proposed last time. (I ended up DROPing and CREATE-ing the tables rather than ALTERing them). Here's what I ended up with:

create table times (taskID int,log datetime,code int,seconds int);
create table tasks (user int not null, taskID serial unique, name varchar(30) not null, description text, alarm int);
create table prefs (user int not null, friend int, taskID int, permission int);

So now all I must do is a front end.... This may be a pain.

No comments: