X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=sql%2Ftc.sql;h=2fedef164a486579352634ad614571b9cc0fbf92;hb=0b1efe21447094e08a99d68704dc8947b40e989a;hp=687cf7118ae58920ad92e80df375eb67ac781cf5;hpb=991af26c24553af2262b6eca3cd7c5c390a41c2a;p=eq%2F.git

diff --git a/sql/tc.sql b/sql/tc.sql
index 687cf71..2fedef1 100644
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -74,6 +74,7 @@ CREATE TABLE `tc_calling` (
   `organization` varchar(30) default NULL,
   `position` varchar(30) default NULL,
   `sustained` varchar(30) default NULL,
+  KEY `name` (`name`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 --
@@ -124,9 +125,6 @@ CREATE TABLE `tc_individual` (
 --
 CREATE TABLE `tc_family` (
   `family` int(16) unsigned NOT NULL auto_increment,
-  `hofh_id` int(16) unsigned NOT NULL default '0',
-  `name` varchar(30) NOT NULL default '',
-  `name_id` varchar(30) NOT NULL default '',
   `individual` int(16) unsigned default '0',
   `companionship` int(16) unsigned default NULL,
   `scheduling_priority` int(16) unsigned default NULL,
@@ -153,7 +151,7 @@ CREATE TABLE `tc_interview` (
   `date` date default NULL,
   `notes` text,
   `interview_type` enum('hti','ppi') NOT NULL DEFAULT 'hti',
-  PRIMARY KEY  (`ppi`)
+  PRIMARY KEY  (`interview`)
 ) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=latin1;