changed note field in tc_accomplishment to notes

[eq/.git] / sql / tc.sql

diff --git a/sql/tc.sql b/sql/tc.sql
index 9aaff5ea88d60bab34c31e3f5ceb3462edeaf34c..0829378bb9c6eee9aba64eefa8fb2d681a96c12d 100644 (file)
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -175,8 +175,6 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_visit` (
   `visit` int(16) unsigned NOT NULL auto_increment,
   `family` int(16) unsigned default NULL,
   `companionship` int(16) unsigned default NULL,
-  `companion1` int(16) unsigned default NULL,
-  `companion2` int(16) unsigned default NULL,
   `date` date default NULL,
   `notes` text,
   `visited` enum('y','n','') default NULL,
@@ -227,7 +225,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_accomplishment` (
   `individual` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
   `date` DATE NULL DEFAULT NULL ,
   `task` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
-  `note` VARCHAR( 128 ) NOT NULL
+  `notes` VARCHAR( 128 ) NOT NULL
 ) ENGINE = MYISAM ;
 
 --