projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
adding msi so you don't have to build to use MLSFileTrimmer.exe
[eq/.git]
/
sql
/
eq.sql
diff --git
a/sql/eq.sql
b/sql/eq.sql
index 7d0add889529ac0c16c668e73d87136a7152a3d1..81065417c5b810683057a5747c28e9aad0db9570 100644
(file)
--- 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,
`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;
`valid` tinyint(1) default NULL,
PRIMARY KEY (`aaronic`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;
@@
-45,6
+46,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',
`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;
`uid` bigint(64) unsigned NOT NULL default '0',
PRIMARY KEY (`appointment`)
) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;
@@
-132,8
+134,11
@@
CREATE TABLE `eq_district` (
--
CREATE TABLE `eq_elder` (
`elder` int(16) unsigned NOT NULL auto_increment,
--
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,
`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',
`ppi_pri` int(10) unsigned NOT NULL default '1',
`ppi_notes` varchar(128) default NULL,
`int_pri` int(10) unsigned default '1',