log when tasks are tested, and show testing date and completion date (when applicable...

[contractor-progress.git] / tasks.sql

diff --git a/tasks.sql b/tasks.sql
index 4306c57..788771c 100644 (file)
--- a/tasks.sql
+++ b/tasks.sql
@@ -3,6 +3,7 @@ create table tasks (
     id int unique auto_increment,
     client_id int not null default 0,
     finished_at varchar(20) not null default "",
     id int unique auto_increment,
     client_id int not null default 0,
     finished_at varchar(20) not null default "",

+    tested_at varchar(20) not null default "",

     price varchar(20) not null default "",
     ord int not null default 0,
     title varchar(200) not null default "",
     price varchar(20) not null default "",
     ord int not null default 0,
     title varchar(200) not null default "",