Bugfix

[simpleipd.git] / data.schema.sql

diff --git a/data.schema.sql b/data.schema.sql
index 579ec1883916aae36153a15bac3124ef89cd2f07..34eaf0de3a6583db97c3f71226bde7126ee1b43a 100644 (file)
--- a/data.schema.sql
+++ b/data.schema.sql
@@ -1,3 +1,8 @@
+CREATE TABLE advice(
+pid int,
+time int,
+data text
+);
 CREATE TABLE death(
 pid int,
 time int,
@@ -52,7 +57,8 @@ sample text,
 time int,
 room 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
 );