From e73234a2f52b85c7c1484656eb8d9497d76f57d4 Mon Sep 17 00:00:00 2001
From: "Alan J. Pippin" <ajp@server.pippins.net>
Date: Tue, 13 May 2008 08:38:46 -0600
Subject: [PATCH] Added new fields to sql db create script

---
 sql/eq.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/sql/eq.sql b/sql/eq.sql
index 7d0add8..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;
@@ -132,8 +133,10 @@ CREATE TABLE `eq_district` (
 --
 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',
-- 
2.34.1