X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Ftc.sql;h=f5520dbaeee32d909b912eedfff10087a4e6e741;hb=10d31609e9f447202816d2721333e0d83f5c4f0a;hp=7b23e0817b6b1e0d813ebf9b1664eefd402088b8;hpb=c55bb22273cd071e0b871736eab0324076ecaa67;p=eq%2F.git

diff --git a/sql/tc.sql b/sql/tc.sql
index 7b23e08..f5520db 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;
 
@@ -182,7 +182,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_visit` (
   `date` date default NULL,
   `notes` text,
   `visited` enum('y','n','') default NULL,
-  `visit_type` enum('presidency','hometeaching') not null default 'hometeaching',
+  `type` enum('P','H') not null default 'H',
   PRIMARY KEY  (`visit`)
 ) ENGINE=MyISAM AUTO_INCREMENT=9513 DEFAULT CHARSET=latin1;