--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_appointment` (
`appointment` int(16) unsigned NOT NULL auto_increment,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_appointment` (
`appointment` int(16) unsigned NOT NULL auto_increment,
`family` int(16) unsigned default '0',
`individual` int(16) unsigned default '0',
`date` date NOT NULL default '0000-00-00',
`family` int(16) unsigned default '0',
`individual` int(16) unsigned default '0',
`date` date NOT NULL default '0000-00-00',
`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 ,
`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 ,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_district` (
`district` int(16) unsigned NOT NULL default '0',
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_district` (
`district` int(16) unsigned NOT NULL default '0',
`valid` tinyint(1) default NULL,
PRIMARY KEY (`district`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
`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,
`individual` int(16) unsigned default NULL,
`date` date default NULL,
`notes` text,
-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,
`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',
`counselor` tinyint(1) default '0',
`secretary` tinyint(1) default '0',
`valid` tinyint(1) default '1',
`date` date default NULL,
`notes` text,
`visited` enum('y','n','') default NULL,
`date` date default NULL,
`notes` text,
`visited` enum('y','n','') default NULL,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_district_sandbox` (
`district` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_district_sandbox` (
`district` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship_sandbox` (
`companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship_sandbox` (
`companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,