X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=sql%2Ftc.sql;h=0829378bb9c6eee9aba64eefa8fb2d681a96c12d;hb=refs%2Fheads%2Fowenleonard%2Fdjango_db_prep;hp=ce19e36d3adc7a34635dac1c8b5ea753f4f0d80d;hpb=9cbfdccb986373952fc820285cbc027b41c44b5e;p=eq%2F.git

diff --git a/sql/tc.sql b/sql/tc.sql
index ce19e36..0829378 100644
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -161,11 +161,8 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_interview` (
 CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_leader` (
   `leader` int(16) unsigned NOT NULL auto_increment,
   `individual` int(16) unsigned NOT NULL default '0',
-  `district` int(16) unsigned default '0',
   `email` varchar(60) NOT NULL,
-  `president` tinyint(1) default '0',
-  `counselor` tinyint(1) default '0',
-  `secretary` tinyint(1) default '0',
+  `type` enum( 'P', 'C', 'S', 'D' ) NOT NULL,
   `valid` tinyint(1) default '1',
   KEY `leader` (`leader`),
   KEY `individual` (`individual`)
@@ -178,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,
@@ -230,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 ;
 
 --