From e73234a2f52b85c7c1484656eb8d9497d76f57d4 Mon Sep 17 00:00:00 2001 From: "Alan J. Pippin" 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