--
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',
--
--- 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;
`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,
`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 ;
--