converged president,counselor,secretary fields in tc_leader into one type field

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

diff --git a/sql/tc.sql b/sql/tc.sql
index 3d287e52ee948d1f5eadd9b1d033772ae669abde..2d1c631740c32637f3baddb6f5ddccf0ba4cbce5 100644 (file)
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -28,7 +28,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_activity` (
 --
 CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_appointment` (
   `appointment` int(16) unsigned NOT NULL auto_increment,
-  `presidency` int(16) unsigned NOT NULL default '0',
+  `leader` int(16) unsigned NOT NULL default '0',
   `family` int(16) unsigned default '0',
   `individual` int(16) unsigned default '0',
   `date` date NOT NULL default '0000-00-00',
@@ -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;
@@ -149,24 +150,22 @@ 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;
 
 
 --
--- Table structure for table `tc_presidency`
+-- Table structure for table `tc_leader`
 --
-CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_presidency` (
-  `presidency` int(16) unsigned NOT NULL auto_increment,
+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 `presidency` (`presidency`),
+  KEY `leader` (`leader`),
   KEY `individual` (`individual`)
 ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
 
@@ -182,7 +181,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 +245,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 ;
 
 --
@@ -263,6 +262,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 ;