`aaronic` int(16) unsigned NOT NULL auto_increment,
`name` varchar(60) default NULL,
`phone` varchar(12) default NULL,
+ `email` varchar(120) default NULL,
`valid` tinyint(1) default NULL,
PRIMARY KEY (`aaronic`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;
`elder` int(16) unsigned default '0',
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
+ `location` varchar(120) default NULL,
`uid` bigint(64) unsigned NOT NULL default '0',
PRIMARY KEY (`appointment`)
) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;
`valid` tinyint(1) default NULL,
PRIMARY KEY (`district`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-LOCK TABLES `eq_district` WRITE;
-/*!40000 ALTER TABLE `eq_district` DISABLE KEYS */;
-INSERT INTO `eq_district` (`district`, `name`, `supervisor`, `valid`) VALUES (0,'High Priests',0,0);
-/*!40000 ALTER TABLE `eq_district` ENABLE KEYS */;
-UNLOCK TABLES;
--
-- Table structure for table `eq_elder`
--
CREATE TABLE `eq_elder` (
`elder` int(16) unsigned NOT NULL auto_increment,
+ `indiv_id` int(16) unsigned NOT NULL,
`name` varchar(60) default NULL,
`phone` varchar(12) default NULL,
+ `email` varchar(120) default NULL,
+ `priesthood` enum('High Priest','Elder','Priest','Teacher','Deacon','Unordained') DEFAULT NULL,
`ppi_pri` int(10) unsigned NOT NULL default '1',
`ppi_notes` varchar(128) default NULL,
`int_pri` int(10) unsigned default '1',
PRIMARY KEY (`family`)
) ENGINE=MyISAM AUTO_INCREMENT=277 DEFAULT CHARSET=latin1;
---
--- Table structure for table `eq_interview`
---
-CREATE TABLE `eq_interview` (
- `interview` int(16) unsigned NOT NULL auto_increment,
- `interviewer` int(16) unsigned default NULL,
- `elder` int(16) unsigned default NULL,
- `aaronic` int(16) unsigned NOT NULL default '0',
- `date` date default NULL,
- `notes` text,
- PRIMARY KEY (`interview`)
-) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
-
--
-- Table structure for table `eq_parent`
--
`ppi` int(16) unsigned NOT NULL auto_increment,
`interviewer` int(16) unsigned default NULL,
`elder` int(16) unsigned default NULL,
+ `aaronic` int(16) unsigned NOT NULL default '0',
`date` date default NULL,
`notes` text,
`eqpresppi` tinyint(1) default '0',
`president` tinyint(1) default '0',
`counselor` tinyint(1) default '0',
`secretary` tinyint(1) default '0',
+ `eqpres` tinyint(1) default '0',
`valid` tinyint(1) default '1',
KEY `presidency` (`presidency`),
KEY `elder` (`elder`)