From 89465782871025993e054babe907771c009cc75b Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Mon, 28 Nov 2005 20:33:11 +0000
Subject: [PATCH] added outcome and disposition to issues, removed from
 clinical notes

---
 contrib/forms/clinical_notes/new.php              | 48 ++++++++-----
 contrib/forms/clinical_notes/report.php           |  8 ++-
 contrib/forms/clinical_notes/table.sql            |  6 +-
 contrib/forms/clinical_notes/view.php             | 48 ++++++++-----
 interface/forms/newpatient/new.php                |  2 +-
 interface/forms/newpatient/view.php               |  2 +-
 interface/patient_file/problem_encounter.php      |  2 +-
 interface/patient_file/summary/add_edit_issue.php | 88 +++++++++++++++++------
 interface/patient_file/summary/stats_full.php     |  2 +-
 sql/2_8_0-to-2_8_1_upgrade.sql                    |  7 ++
 sql/database.sql                                  | 32 +++++----
 11 files changed, 168 insertions(+), 77 deletions(-)

diff --git a/contrib/forms/clinical_notes/new.php b/contrib/forms/clinical_notes/new.php
index bdaa2a013..db6cdbb1c 100644
--- a/contrib/forms/clinical_notes/new.php
+++ b/contrib/forms/clinical_notes/new.php
@@ -77,10 +77,10 @@ if ($_POST['bn_save']) {
    "history = '"          . $_POST['form_history']     . "', " .
    "examination = '"      . $_POST['form_examination'] . "', " .
    "plan = '"             . $_POST['form_plan']        . "', " .
-   "followup_required = " . cbvalue('fu_required')     . ", "  .
-   "followup_timing = '$fu_timing'"                    . ", "  .
-   "outcome = "           . rbvalue('outcome')         . ", "  .
-   "destination = "       . rbvalue('destination')     . " "   .
+   "followup_required = " . rbvalue('fu_required')     . ", "  .
+   "followup_timing = '$fu_timing'"                    . " "   .
+// "outcome = "           . rbvalue('outcome')         . ", "  .
+// "destination = "       . rbvalue('destination')     . " "   .
    "WHERE id = '$formid'";
   sqlStatement($query);
  }
@@ -89,16 +89,16 @@ if ($_POST['bn_save']) {
  //
  else {
   $query = "INSERT INTO form_clinical_notes ( " .
-   "history, examination, plan, followup_required, followup_timing, " .
-   "outcome, destination " .
+   "history, examination, plan, followup_required, followup_timing " .
+// ",outcome, destination " .
    ") VALUES ( " .
    "'" . $_POST['form_history']     . "', " .
    "'" . $_POST['form_examination'] . "', " .
    "'" . $_POST['form_plan']        . "', " .
-   cbvalue('fu_required')           . ", "  .
-   "'$fu_timing'"                   . ", "  .
-   rbvalue('outcome')               . ", "  .
-   rbvalue('destination')           . " "   .
+   rbvalue('fu_required')           . ", "  .
+   "'$fu_timing'"                   . " "   .
+// rbvalue('outcome')               . ", "  .
+// rbvalue('destination')           . " "   .
    ")";
   $newid = sqlInsert($query);
   addForm($encounter, "Clinical Notes", $newid, "clinical_notes", $pid, $userauthorized);
@@ -162,7 +162,7 @@ if ($formid) {
    <table width='100%'>
     <tr>
      <td width='5%' nowrap>
-      <? echo cbinput('fu_required', 'followup_required') ?>Required on:&nbsp;
+      <? echo rbinput('fu_required', '1', 'Required in:', 'followup_required') ?>
      </td>
      <td nowrap>
       <input type='text' name='fu_timing' size='10' style='width:100%'
@@ -170,10 +170,22 @@ if ($formid) {
        value='<? echo addslashes($row['followup_timing']) ?>' />
      </td>
     </tr>
+    <tr>
+     <td colspan='2' nowrap>
+      <? echo rbinput('fu_required', '2', 'Pending investigation', 'followup_required') ?>
+     </td>
+    </tr>
+    <tr>
+     <td colspan='2' nowrap>
+      <? echo rbinput('fu_required', '0', 'None required', 'followup_required') ?>
+     </td>
+    </tr>
    </table>
   </td>
  </tr>
 
+ <!--
+
  <tr bgcolor='#dddddd'>
   <td colspan='2' align='center'><b>Final Discharge</b></td>
  </tr>
@@ -183,10 +195,10 @@ if ($formid) {
   <td nowrap>
    <table width='100%'>
     <tr>
-     <? echo rbcell('outcome', '1', 'Resolved'  , 'outcome') ?>
-     <? echo rbcell('outcome', '2', 'Improved'  , 'outcome') ?>
-     <? echo rbcell('outcome', '3', 'Status Quo', 'outcome') ?>
-     <? echo rbcell('outcome', '4', 'Worse'     , 'outcome') ?>
+     <? // echo rbcell('outcome', '1', 'Resolved'  , 'outcome') ?>
+     <? // echo rbcell('outcome', '2', 'Improved'  , 'outcome') ?>
+     <? // echo rbcell('outcome', '3', 'Status Quo', 'outcome') ?>
+     <? // echo rbcell('outcome', '4', 'Worse'     , 'outcome') ?>
     </tr>
    </table>
   </td>
@@ -197,8 +209,8 @@ if ($formid) {
   <td nowrap>
    <table width='100%'>
     <tr>
-     <? echo rbcell('destination', '1', 'GP'                 , 'destination') ?>
-     <? echo rbcell('destination', '2', 'Hospital Specialist', 'destination') ?>
+     <? // echo rbcell('destination', '1', 'GP'                 , 'destination') ?>
+     <? // echo rbcell('destination', '2', 'Hospital Specialist', 'destination') ?>
      <td width='25%'>&nbsp;</td>
      <td width='25%'>&nbsp;</td>
     </tr>
@@ -206,6 +218,8 @@ if ($formid) {
   </td>
  </tr>
 
+ -->
+
 </table>
 
 <p>
diff --git a/contrib/forms/clinical_notes/report.php b/contrib/forms/clinical_notes/report.php
index 3b0db3bbd..a139aea39 100644
--- a/contrib/forms/clinical_notes/report.php
+++ b/contrib/forms/clinical_notes/report.php
@@ -25,8 +25,13 @@ function clinical_notes_report($pid, $encounter, $cols, $id) {
    }
 
    if ($key == 'followup_required') {
-    $value = 'Yes';
+    switch ($value) {
+     case '1': $value = 'Yes'; break;
+     case '2': $value = 'Pending investigation'; break;
+    }
    }
+
+   /****
    else if ($key == 'outcome') {
     switch ($value) {
      case '1': $value = 'Resolved'  ; break;
@@ -41,6 +46,7 @@ function clinical_notes_report($pid, $encounter, $cols, $id) {
      case '2': $value = 'Hospital Specialist'; break;
     }
    }
+   ****/
 
    $key=ucwords(str_replace("_"," ",$key));
    print "<td valign='top'><span class='bold'>$key: </span><span class='text'>$value &nbsp;</span></td>\n";
diff --git a/contrib/forms/clinical_notes/table.sql b/contrib/forms/clinical_notes/table.sql
index f823b8b86..175849fb6 100644
--- a/contrib/forms/clinical_notes/table.sql
+++ b/contrib/forms/clinical_notes/table.sql
@@ -6,14 +6,14 @@ CREATE TABLE IF NOT EXISTS form_clinical_notes (
  examination       text         NOT NULL DEFAULT '',
  plan              text         NOT NULL DEFAULT '',
 
- followup_required tinyint(1)   NOT NULL DEFAULT 0,  -- checkbox
+ followup_required int(11)      NOT NULL DEFAULT 0,  -- radio
  followup_timing   varchar(255) NOT NULL DEFAULT '',
 
  -- resolved, improved, status quo, worse:
- outcome           int(11)      NOT NULL DEFAULT 0,  -- radio
+ -- outcome           int(11)      NOT NULL DEFAULT 0,  -- radio
 
  -- gp, hospital specialist:
- destination       int(11)      NOT NULL DEFAULT 0,  -- radio
+ -- destination       int(11)      NOT NULL DEFAULT 0,  -- radio
 
  PRIMARY KEY (id)
 ) TYPE=MyISAM;
diff --git a/contrib/forms/clinical_notes/view.php b/contrib/forms/clinical_notes/view.php
index bdaa2a013..db6cdbb1c 100644
--- a/contrib/forms/clinical_notes/view.php
+++ b/contrib/forms/clinical_notes/view.php
@@ -77,10 +77,10 @@ if ($_POST['bn_save']) {
    "history = '"          . $_POST['form_history']     . "', " .
    "examination = '"      . $_POST['form_examination'] . "', " .
    "plan = '"             . $_POST['form_plan']        . "', " .
-   "followup_required = " . cbvalue('fu_required')     . ", "  .
-   "followup_timing = '$fu_timing'"                    . ", "  .
-   "outcome = "           . rbvalue('outcome')         . ", "  .
-   "destination = "       . rbvalue('destination')     . " "   .
+   "followup_required = " . rbvalue('fu_required')     . ", "  .
+   "followup_timing = '$fu_timing'"                    . " "   .
+// "outcome = "           . rbvalue('outcome')         . ", "  .
+// "destination = "       . rbvalue('destination')     . " "   .
    "WHERE id = '$formid'";
   sqlStatement($query);
  }
@@ -89,16 +89,16 @@ if ($_POST['bn_save']) {
  //
  else {
   $query = "INSERT INTO form_clinical_notes ( " .
-   "history, examination, plan, followup_required, followup_timing, " .
-   "outcome, destination " .
+   "history, examination, plan, followup_required, followup_timing " .
+// ",outcome, destination " .
    ") VALUES ( " .
    "'" . $_POST['form_history']     . "', " .
    "'" . $_POST['form_examination'] . "', " .
    "'" . $_POST['form_plan']        . "', " .
-   cbvalue('fu_required')           . ", "  .
-   "'$fu_timing'"                   . ", "  .
-   rbvalue('outcome')               . ", "  .
-   rbvalue('destination')           . " "   .
+   rbvalue('fu_required')           . ", "  .
+   "'$fu_timing'"                   . " "   .
+// rbvalue('outcome')               . ", "  .
+// rbvalue('destination')           . " "   .
    ")";
   $newid = sqlInsert($query);
   addForm($encounter, "Clinical Notes", $newid, "clinical_notes", $pid, $userauthorized);
@@ -162,7 +162,7 @@ if ($formid) {
    <table width='100%'>
     <tr>
      <td width='5%' nowrap>
-      <? echo cbinput('fu_required', 'followup_required') ?>Required on:&nbsp;
+      <? echo rbinput('fu_required', '1', 'Required in:', 'followup_required') ?>
      </td>
      <td nowrap>
       <input type='text' name='fu_timing' size='10' style='width:100%'
@@ -170,10 +170,22 @@ if ($formid) {
        value='<? echo addslashes($row['followup_timing']) ?>' />
      </td>
     </tr>
+    <tr>
+     <td colspan='2' nowrap>
+      <? echo rbinput('fu_required', '2', 'Pending investigation', 'followup_required') ?>
+     </td>
+    </tr>
+    <tr>
+     <td colspan='2' nowrap>
+      <? echo rbinput('fu_required', '0', 'None required', 'followup_required') ?>
+     </td>
+    </tr>
    </table>
   </td>
  </tr>
 
+ <!--
+
  <tr bgcolor='#dddddd'>
   <td colspan='2' align='center'><b>Final Discharge</b></td>
  </tr>
@@ -183,10 +195,10 @@ if ($formid) {
   <td nowrap>
    <table width='100%'>
     <tr>
-     <? echo rbcell('outcome', '1', 'Resolved'  , 'outcome') ?>
-     <? echo rbcell('outcome', '2', 'Improved'  , 'outcome') ?>
-     <? echo rbcell('outcome', '3', 'Status Quo', 'outcome') ?>
-     <? echo rbcell('outcome', '4', 'Worse'     , 'outcome') ?>
+     <? // echo rbcell('outcome', '1', 'Resolved'  , 'outcome') ?>
+     <? // echo rbcell('outcome', '2', 'Improved'  , 'outcome') ?>
+     <? // echo rbcell('outcome', '3', 'Status Quo', 'outcome') ?>
+     <? // echo rbcell('outcome', '4', 'Worse'     , 'outcome') ?>
     </tr>
    </table>
   </td>
@@ -197,8 +209,8 @@ if ($formid) {
   <td nowrap>
    <table width='100%'>
     <tr>
-     <? echo rbcell('destination', '1', 'GP'                 , 'destination') ?>
-     <? echo rbcell('destination', '2', 'Hospital Specialist', 'destination') ?>
+     <? // echo rbcell('destination', '1', 'GP'                 , 'destination') ?>
+     <? // echo rbcell('destination', '2', 'Hospital Specialist', 'destination') ?>
      <td width='25%'>&nbsp;</td>
      <td width='25%'>&nbsp;</td>
     </tr>
@@ -206,6 +218,8 @@ if ($formid) {
   </td>
  </tr>
 
+ -->
+
 </table>
 
 <p>
diff --git a/interface/forms/newpatient/new.php b/interface/forms/newpatient/new.php
index 56c784728..9a7028f1d 100644
--- a/interface/forms/newpatient/new.php
+++ b/interface/forms/newpatient/new.php
@@ -49,7 +49,7 @@
 
  // Process click on issue title.
  function newissue() {
-  dlgopen('../../patient_file/summary/add_edit_issue.php', '_blank', 500, 450);
+  dlgopen('../../patient_file/summary/add_edit_issue.php', '_blank', 600, 475);
   return false;
  }
 
diff --git a/interface/forms/newpatient/view.php b/interface/forms/newpatient/view.php
index 0dae27061..7688e00d9 100644
--- a/interface/forms/newpatient/view.php
+++ b/interface/forms/newpatient/view.php
@@ -52,7 +52,7 @@
 
  // Process click on issue title.
  function newissue() {
-  dlgopen('../../patient_file/summary/add_edit_issue.php', '_blank', 500, 450);
+  dlgopen('../../patient_file/summary/add_edit_issue.php', '_blank', 600, 475);
   return false;
  }
 
diff --git a/interface/patient_file/problem_encounter.php b/interface/patient_file/problem_encounter.php
index e6ebce921..92e648cb1 100644
--- a/interface/patient_file/problem_encounter.php
+++ b/interface/patient_file/problem_encounter.php
@@ -108,7 +108,7 @@ function refreshIssue(issue, title) {
 function newIssue() {
  var f = document.forms[0];
  var tmp = (keyid && f.form_key[1].checked) ? ('?enclink=' + keyid) : '';
- dlgopen('summary/add_edit_issue.php' + tmp, '_blank', 500, 450);
+ dlgopen('summary/add_edit_issue.php' + tmp, '_blank', 600, 475);
 }
 
 // New Encounter button is clicked.
diff --git a/interface/patient_file/summary/add_edit_issue.php b/interface/patient_file/summary/add_edit_issue.php
index 6d9d6b212..12953ad03 100644
--- a/interface/patient_file/summary/add_edit_issue.php
+++ b/interface/patient_file/summary/add_edit_issue.php
@@ -1,4 +1,4 @@
-<?
+<?php
  // Copyright (C) 2005 Rod Roark <rod@sunsetsystems.com>
  //
  // This program is free software; you can redistribute it and/or
@@ -36,6 +36,20 @@
   return "NULL";
  }
 
+ function rbinput($name, $value, $desc, $colname) {
+  global $irow;
+  $ret  = "<input type='radio' name='$name' value='$value'";
+  if ($irow[$colname] == $value) $ret .= " checked";
+  $ret .= " />$desc";
+  return $ret;
+ }
+
+ function rbvalue($rbname) {
+  $tmp = $_POST[$rbname];
+  if (! $tmp) $tmp = '0';
+  return "'$tmp'";
+ }
+
 ?>
 <html>
 <head>
@@ -56,7 +70,7 @@ td { font-size:10pt; }
  var mypcc = '<? echo $GLOBALS['phone_country_code'] ?>';
 
  var aopts = new Array();
-<?
+<?php
  // "Clickoptions" is a feature by Mark Leeds that provides for one-click
  // access to preselected lists of issues in each category.  Here we get
  // the issue titles from the user-customizable file and write JavaScript
@@ -115,7 +129,7 @@ td { font-size:10pt; }
 </head>
 
 <body <?echo $top_bg_line;?>>
-<?
+<?php
  // If we are saving, then save and close the window.
  //
  if ($_POST['form_save']) {
@@ -131,20 +145,24 @@ td { font-size:10pt; }
 
   if ($issue) {
    sqlStatement("UPDATE lists SET " .
-    "type = '" . $text_type . "', " .
-    "title = '" . $_POST['form_title'] . "', " .
-    "comments = '" . $_POST['form_comments'] . "', " .
-    "begdate = " . QuotedOrNull($form_begin) . ", " .
-    "enddate = " . QuotedOrNull($form_end) . ", " .
-    "diagnosis = '" . $_POST['form_diagnosis'] . "', " .
-    "occurrence = '" . $_POST['form_occur'] . "', " .
-    "referredby = '" . $_POST['form_referredby'] . "', " .
-    "extrainfo = '" . $_POST['form_missed'] . "' " .
+    "type = '"        . $text_type                  . "', " .
+    "title = '"       . $_POST['form_title']        . "', " .
+    "comments = '"    . $_POST['form_comments']     . "', " .
+    "begdate = "      . QuotedOrNull($form_begin)   . ", "  .
+    "enddate = "      . QuotedOrNull($form_end)     . ", "  .
+    "diagnosis = '"   . $_POST['form_diagnosis']    . "', " .
+    "occurrence = '"  . $_POST['form_occur']        . "', " .
+    "referredby = '"  . $_POST['form_referredby']   . "', " .
+    "extrainfo = '"   . $_POST['form_missed']       . "', " .
+    "outcome = "      . rbvalue('form_outcome')     . ", "  .
+//  "destination = "  . rbvalue('form_destination') . " "   . // radio button version
+    "destination = '" . $_POST'form_destination']   . "' "  .
     "WHERE id = '$issue'");
   } else {
    $issue = sqlInsert("INSERT INTO lists ( " .
     "date, pid, type, title, activity, comments, begdate, enddate, " .
-    "diagnosis, occurrence, referredby, extrainfo, user, groupname " .
+    "diagnosis, occurrence, referredby, extrainfo, user, groupname, " .
+    "outcome, destination " .
     ") VALUES ( " .
     "NOW(), " .
     "'$pid', " .
@@ -159,7 +177,11 @@ td { font-size:10pt; }
     "'" . $_POST['form_referredby']  . "', " .
     "'" . $_POST['form_missed']      . "', " .
     "'" . $$_SESSION['authUser']     . "', " .
-    "'" . $$_SESSION['authProvider'] . "' )");
+    "'" . $$_SESSION['authProvider'] . "', " .
+   rbvalue('form_outcome')           . ", "  .
+// rbvalue('form_destination')       . " "   . // radio button version
+    "'" . $_POST['form_destination'] . "' "  .
+   ")");
   }
 
   $tmp_title = $ISSUE_TYPES[$text_type][2] . ": $form_begin " .
@@ -211,7 +233,7 @@ td { font-size:10pt; }
  <tr>
   <td valign='top' width='1%' nowrap><b>Type:</b></td>
   <td>
-<?
+<?php
  $index = 0;
  foreach ($ISSUE_TYPES as $value) {
   echo "   <input type='radio' name='form_type' value='$index' onclick='newtype($index)'";
@@ -262,7 +284,7 @@ td { font-size:10pt; }
   <td>
    <select name='form_diagnosis' title='Diagnosis must be coded into a linked encounter'>
     <option value="">Unknown or N/A</option>
-<?
+<?php
  while ($brow = sqlFetchArray($bres)) {
   echo "   <option value='" . $brow['code'] . "'";
   if ($brow['code'] == $irow['diagnosis']) echo " selected";
@@ -277,7 +299,7 @@ td { font-size:10pt; }
   <td valign='top' nowrap><b>Occurrence:</b></td>
   <td>
    <select name='form_occur'>
-<?
+<?php
  foreach ($arroccur as $key => $value) {
   echo "   <option value='$key'";
   if ($key == $irow['occurrence']) echo " selected";
@@ -288,7 +310,7 @@ td { font-size:10pt; }
   </td>
  </tr>
 
-<? if ($GLOBALS['athletic_team']) { ?>
+<?php if ($GLOBALS['athletic_team']) { ?>
  <tr>
   <td valign='top' nowrap><b>Missed:</b></td>
   <td>
@@ -297,7 +319,7 @@ td { font-size:10pt; }
    &nbsp;games/events
   </td>
  </tr>
-<? } else { ?>
+<?php } else { ?>
  <tr>
   <td valign='top' nowrap><b>Referred by:</b></td>
   <td>
@@ -305,7 +327,7 @@ td { font-size:10pt; }
     style='width:100%' title='Referring physician and practice' />
   </td>
  </tr>
-<? } ?>
+<?php } ?>
 
  <tr>
   <td valign='top' nowrap><b>Comments:</b></td>
@@ -314,6 +336,32 @@ td { font-size:10pt; }
   </td>
  </tr>
 
+ <tr>
+  <td valign='top' nowrap><b>Outcome:</b></td>
+  <td>
+   <? echo rbinput('form_outcome', '1', 'Resolved'        , 'outcome') ?>&nbsp;
+   <? echo rbinput('form_outcome', '2', 'Improved'        , 'outcome') ?>&nbsp;
+   <? echo rbinput('form_outcome', '3', 'Status quo'      , 'outcome') ?>&nbsp;
+   <? echo rbinput('form_outcome', '4', 'Worse'           , 'outcome') ?>&nbsp;
+   <? echo rbinput('form_outcome', '5', 'Pending followup', 'outcome') ?>
+  </td>
+ </tr>
+
+ <tr>
+  <td valign='top' nowrap><b>Destination:</b></td>
+  <td>
+<?php if (true) { ?>
+   <input type='text' size='40' name='form_destination' value='<? echo $irow['destination'] ?>'
+    style='width:100%' title='GP, Secondary care specialist, etc.' />
+<?php } else { // leave this here for now, please -- Rod ?>
+   <? echo rbinput('form_destination', '1', 'GP'                 , 'destination') ?>&nbsp;
+   <? echo rbinput('form_destination', '2', 'Secondary care spec', 'destination') ?>&nbsp;
+   <? echo rbinput('form_destination', '3', 'GP via physio'      , 'destination') ?>&nbsp;
+   <? echo rbinput('form_destination', '4', 'GP via podiatry'    , 'destination') ?>
+<?php } ?>
+  </td>
+ </tr>
+
 </table>
 
 <p>
diff --git a/interface/patient_file/summary/stats_full.php b/interface/patient_file/summary/stats_full.php
index c57ea2c61..a699b48f6 100644
--- a/interface/patient_file/summary/stats_full.php
+++ b/interface/patient_file/summary/stats_full.php
@@ -55,7 +55,7 @@ function refreshIssue(issue, title) {
 
 // Process click on issue title.
 function dopclick(id) {
- dlgopen('add_edit_issue.php?issue=' + id, '_blank', 500, 450);
+ dlgopen('add_edit_issue.php?issue=' + id, '_blank', 600, 475);
 }
 
 // Process click on number of encounters.
diff --git a/sql/2_8_0-to-2_8_1_upgrade.sql b/sql/2_8_0-to-2_8_1_upgrade.sql
index 50f80dba3..a3788797c 100644
--- a/sql/2_8_0-to-2_8_1_upgrade.sql
+++ b/sql/2_8_0-to-2_8_1_upgrade.sql
@@ -55,3 +55,10 @@ CREATE TABLE IF NOT EXISTS `lang_languages` (
 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (1, 'en', 'English');
 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (2, 'se', 'Swedish');
 INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (3, 'es', 'Spanish');
+
+ALTER TABLE lists
+  ADD outcome     int(11) NOT NULL DEFAULT 0,
+  ADD destination varchar(255) DEFAULT NULL;
+
+ALTER TABLE form_clinical_notes
+  MODIFY followup_required int(11) NOT NULL DEFAULT 0;
diff --git a/sql/database.sql b/sql/database.sql
index fb2b112d4..6ea39c3c8 100644
--- a/sql/database.sql
+++ b/sql/database.sql
@@ -26947,21 +26947,23 @@ CREATE TABLE `integration_mapping` (
 
 DROP TABLE IF EXISTS `lists`;
 CREATE TABLE `lists` (
-  `id`       bigint(20)    NOT NULL auto_increment,
-  `date`     datetime      default NULL,
-  `type`     varchar(255)  default NULL,
-  `title`    varchar(255)  default NULL,
-  begdate    date          DEFAULT NULL,
-  enddate    date          DEFAULT NULL,
-  occurrence int(11)       DEFAULT 0,
-  referredby varchar(255)  DEFAULT NULL,
-  extrainfo  varchar(255)  DEFAULT NULL,
-  diagnosis  varchar(255)  NOT NULL DEFAULT '',
-  `activity` tinyint(4)    default NULL,
-  `comments` longtext      ,
-  `pid` bigint(20)         default NULL,
-  `user` varchar(255)      default NULL,
-  `groupname` varchar(255) default NULL,
+  `id`          bigint(20)    NOT NULL auto_increment,
+  `date`        datetime      DEFAULT NULL,
+  `type`        varchar(255)  DEFAULT NULL,
+  `title`       varchar(255)  DEFAULT NULL,
+  begdate       date          DEFAULT NULL,
+  enddate       date          DEFAULT NULL,
+  occurrence    int(11)       DEFAULT 0,
+  referredby    varchar(255)  DEFAULT NULL,
+  extrainfo     varchar(255)  DEFAULT NULL,
+  diagnosis     varchar(255)  NOT NULL DEFAULT '',
+  `activity`    tinyint(4)    DEFAULT NULL,
+  `comments`    longtext      ,
+  `pid`         bigint(20)    DEFAULT NULL,
+  `user`        varchar(255)  DEFAULT NULL,
+  `groupname`   varchar(255)  DEFAULT NULL,
+  `outcome`     int(11)       NOT NULL DEFAULT 0,
+  `destination` varchar(255)  DEFAULT NULL,
   PRIMARY KEY  (`id`)
 ) ;
 
-- 
2.11.4.GIT