X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=sql%2Ftc.sql;h=d66b728d642eb8681becdb3372734873faf64659;hb=40bab501e1ba7d982bead980469dcd975d141130;hp=3d287e52ee948d1f5eadd9b1d033772ae669abde;hpb=39346e4dae3d877b8aceec8ed6b3dadd2be42d0c;p=eq%2F.git

diff --git a/sql/tc.sql b/sql/tc.sql
index 3d287e5..d66b728 100644
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -149,7 +149,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_interview` (
   `individual` int(16) unsigned default NULL,
   `date` date default NULL,
   `notes` text,
-  `interview_type` enum('hti','ppi') NOT NULL DEFAULT 'hti',
+  `type` enum('H','P') NOT NULL DEFAULT 'H',
   PRIMARY KEY  (`interview`)
 ) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=latin1;
 
@@ -263,6 +263,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companion_sandbox` (
 --
 CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship_sandbox` (
   `companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+  `tc_companionship` INT( 16 ) UNSIGNED NOT NULL ,
   `district` INT( 16 ) UNSIGNED NULL DEFAULT NULL
 ) ENGINE = MYISAM ;