Bugfix

[simpleipd.git] / data.schema.sql

diff --git a/data.schema.sql b/data.schema.sql
index 9875979b51171fe14d44097d9cde876f3e74ed0a..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,