X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;f=sql%2Feq.sql;fp=sql%2Feq.sql;h=81065417c5b810683057a5747c28e9aad0db9570;hb=3922955bdc5c67d0ad7485288016754aa981b280;hp=468bd1e40413f86192638335c4c951d7d1c95376;hpb=8720abcdfd49bddf12b95383e558525efd8fed72;p=eq%2F.git

diff --git a/sql/eq.sql b/sql/eq.sql
index 468bd1e..8106541 100644
--- a/sql/eq.sql
+++ b/sql/eq.sql
@@ -18,6 +18,7 @@ CREATE TABLE `eq_aaronic` (
   `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;
@@ -137,6 +138,7 @@ CREATE TABLE `eq_elder` (
   `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',