change supervisor field in tc_district and tc_district_sandbox to leader

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

diff --git a/sql/tc.sql b/sql/tc.sql
index d66b728d642eb8681becdb3372734873faf64659..cc8493102a31bb167b584d26d8df26662205a901 100644 (file)
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -86,6 +86,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship` (
   `companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   `mls_id` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
   `district` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
+  `type` ENUM( 'H', 'P' ) NOT NULL DEFAULT 'H' ,
   `valid` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'
 ) ENGINE = MYISAM ;
 
@@ -94,7 +95,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship` (
 --
 CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_district` (
   `district` int(16) unsigned NOT NULL default '0',
-  `supervisor` int(16) unsigned default NULL,
+  `leader` int(16) unsigned default NULL,
   `valid` tinyint(1) default NULL,
   PRIMARY KEY  (`district`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
@@ -182,7 +183,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;
 
@@ -246,7 +247,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_task` (
 --
 CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_district_sandbox` (
   `district` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
-  `supervisor` INT( 16 ) UNSIGNED NULL DEFAULT NULL
+  `leader` INT( 16 ) UNSIGNED NULL DEFAULT NULL
 ) ENGINE = MYISAM ;
 
 --