--
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',
PRIMARY KEY (`assignment`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
---
--- Dumping data for table `tc_assignment`
---
-LOCK TABLES `tc_assignment` WRITE;
-/*!40000 ALTER TABLE `tc_assignment` DISABLE KEYS */;
-INSERT INTO `tc_assignment` (`assignment`, `name`, `abbreviation`) VALUES (1,'Enrichment Night Babysitting','RS'),(2,'Building Lockup','LU'),(3,'Building Cleaning Coordinator','CC'),(4,'Missionary Splits','MS'),(5,'Stake Farm','SF'),(6,'Loveland Kitchen','LK'),(7,'Moves','MV'),(8,'Temple Kitchen & Laundary','TKL'),(9,'Temple Sealings','TS'),(10,'Temple Initatories','TI');
-/*!40000 ALTER TABLE `tc_assignment` ENABLE KEYS */;
-UNLOCK TABLES;
-
--
-- Table structure for table `tc_attendance`
--
`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 ;
--
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;
`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,
`counselor` tinyint(1) default '0',
`secretary` tinyint(1) default '0',
`valid` tinyint(1) default '1',
- KEY `presidency` (`presidency`),
+ KEY `leader` (`leader`),
KEY `individual` (`individual`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
`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;
-- Table structure for table `tc_district_sandbox`
--
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
+ `district` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ `leader` INT( 16 ) UNSIGNED NULL DEFAULT NULL
) ENGINE = MYISAM ;
--
-- Table structure for table `tc_companion_sandbox`
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companion_sandbox` (
-`companion` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`individual` INT( 16 ) UNSIGNED NOT NULL ,
-`companionship` INT( 16 ) UNSIGNED NOT NULL
+ `companion` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `individual` INT( 16 ) UNSIGNED NOT NULL ,
+ `companionship` INT( 16 ) UNSIGNED NOT NULL
) ENGINE = MYISAM ;
--
--
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 ;
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_family_sandbox` (
`family` int(16) unsigned NOT NULL auto_increment,
`tc_family` int(16) unsigned default '0',
+ `individual` INT( 16 ) UNSIGNED NOT NULL ,
`companionship` int(16) unsigned default NULL,
PRIMARY KEY (`family`)
) ENGINE = MyISAM ;