X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Feq.sql;h=468bd1e40413f86192638335c4c951d7d1c95376;hb=5b890635d41024cad8348023e9fccae419ddaaca;hp=36499530303845e7f18b1807600a8f7d68a0cab9;hpb=82963f2191eff35b295440782e4309ea3632cf55;p=eq%2F.git

diff --git a/sql/eq.sql b/sql/eq.sql
index 3649953..468bd1e 100644
--- a/sql/eq.sql
+++ b/sql/eq.sql
@@ -45,6 +45,7 @@ CREATE TABLE `eq_appointment` (
   `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;
@@ -126,19 +127,16 @@ CREATE TABLE `eq_district` (
   `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,
   `ppi_pri` int(10) unsigned NOT NULL default '1',
   `ppi_notes` varchar(128) default NULL,
   `int_pri` int(10) unsigned default '1',
@@ -164,19 +162,6 @@ CREATE TABLE `eq_family` (
   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`
 --
@@ -208,6 +193,7 @@ CREATE TABLE `eq_ppi` (
   `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',
@@ -227,6 +213,7 @@ CREATE TABLE `eq_presidency` (
   `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`)