Bugfix

[simpleipd.git] / data.schema.sql

diff --git a/data.schema.sql b/data.schema.sql
index 51883e5773bf3413310696486c31b5a1fdd05e93..34eaf0de3a6583db97c3f71226bde7126ee1b43a 100644 (file)
--- a/data.schema.sql
+++ b/data.schema.sql
@@ -1,4 +1,8 @@
-
+CREATE TABLE advice(
+pid int,
+time int,
+data text
+);
 CREATE TABLE death(
 pid int,
 time int,
@@ -42,17 +46,19 @@ data text
 CREATE TABLE reports(
 pid int,
 time int,
+sample text,
 form text,
 data text
 );
 CREATE TABLE requisition(
 pid int,
 test text,
+sample text,
 time int,
 room text,
-sample text,
 form text,
-status text
+status text,
+addl text
 );
 CREATE TABLE treatment(
 pid int,
@@ -63,6 +69,7 @@ frequency text,
 start int,
 end int,
 duration text,
+administer text,
 omit boolean,
 addl text
 );