* This is a batch dump file for MySQL. In the event of a complete database wipeout * all the information contained herein can be automatically reinserted into the * database with one command. * * Simply copy this file into a directory on the server. From the shell command line type: * * mysql -h host -u user -p dbname < thisfile.txt * * * You will then be prompted for your password, and then the entire contents of this * file will be executed. * This backup was generated on: Friday September 10 2010, 09:48:04 * Note: This backup format has not been tested; however, it should be easy to manually * modify this file to correct mistakes. * The Address Book 1.04e * DROP TABLE IF EXISTS additionaldata; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS contact; DROP TABLE IF EXISTS email; DROP TABLE IF EXISTS grouplist; DROP TABLE IF EXISTS groups; DROP TABLE IF EXISTS messaging; DROP TABLE IF EXISTS options; DROP TABLE IF EXISTS otherphone; DROP TABLE IF EXISTS websites; DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS scratchpad; CREATE TABLE additionaldata (id INT(11) NOT NULL DEFAULT '0', type VARCHAR(20) DEFAULT NULL, value TEXT) TYPE=MyISAM; CREATE TABLE address (refid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, id INT(11) NOT NULL DEFAULT '0', type VARCHAR(20) NOT NULL DEFAULT '', line1 VARCHAR(100) DEFAULT NULL, line2 VARCHAR(100) DEFAULT NULL, city VARCHAR(50) DEFAULT NULL, state VARCHAR(10) DEFAULT NULL, zip VARCHAR(20) DEFAULT NULL, country VARCHAR(3) DEFAULT NULL, phone1 VARCHAR(20) DEFAULT NULL, phone2 VARCHAR(20) DEFAULT NULL ) TYPE=MyISAM; CREATE TABLE contact (id INT(11) NOT NULL AUTO_INCREMENT, firstname VARCHAR(40) NOT NULL DEFAULT '', lastname VARCHAR(80) NOT NULL DEFAULT '', middlename VARCHAR(40) DEFAULT NULL, primaryAddress INT(11) DEFAULT NULL, birthday DATE DEFAULT NULL, nickname VARCHAR(40) DEFAULT NULL, pictureURL VARCHAR(255) DEFAULT NULL, notes TEXT, lastUpdate DATETIME DEFAULT NULL, hidden INT(1) DEFAULT '0' NOT NULL, whoAdded VARCHAR(15), PRIMARY KEY (id)) TYPE=MyISAM; CREATE TABLE email (id INT(11) NOT NULL DEFAULT '0', email VARCHAR(100) DEFAULT NULL, type VARCHAR(20) DEFAULT NULL) TYPE=MyISAM; CREATE TABLE grouplist (groupid INT(11) NOT NULL DEFAULT '0', groupname VARCHAR(60) DEFAULT NULL, PRIMARY KEY (groupid)) TYPE=MyISAM; CREATE TABLE groups (id INT(11) NOT NULL DEFAULT '0', groupid TINYINT(4) NOT NULL DEFAULT '0') TYPE=MyISAM; CREATE TABLE messaging (id INT(11) NOT NULL DEFAULT '0', handle VARCHAR(30) DEFAULT NULL, type VARCHAR(20) DEFAULT NULL) TYPE=MyISAM; CREATE TABLE options (bdayInterval INT(3) DEFAULT '21' NOT NULL, bdayDisplay INT(1) DEFAULT '1' NOT NULL, displayAsPopup INT(1) DEFAULT '0' NOT NULL, useMailScript INT(1) DEFAULT '1' NOT NULL, picAlwaysDisplay INT(1) DEFAULT '0' NOT NULL, picWidth INT(1) DEFAULT '140' NOT NULL, picHeight INT(1) DEFAULT '140' NOT NULL, picDupeMode INT(1) DEFAULT '1' NOT NULL, picAllowUpload INT(1) DEFAULT '1' NOT NULL, modifyTime VARCHAR(3) DEFAULT '0' NOT NULL, msgLogin TEXT NULL, msgWelcome VARCHAR(255) NULL, countryDefault CHAR(3) DEFAULT '0' NULL, allowUserReg INT(1) DEFAULT '0' NOT NULL, eMailAdmin int(1) NOT NULL default '0', requireLogin INT(1) DEFAULT '1' NOT NULL, language VARCHAR(25) NOT NULL, defaultLetter char(2) default NULL, limitEntries smallint(3) NOT NULL default '0') TYPE=MyISAM; CREATE TABLE otherphone (id INT(11) NOT NULL DEFAULT '0', phone VARCHAR(20) DEFAULT NULL, type VARCHAR(20) DEFAULT NULL) TYPE=MyISAM; CREATE TABLE websites (id INT(11) NOT NULL DEFAULT '0', webpageURL VARCHAR(255) DEFAULT NULL, webpageName VARCHAR(255) DEFAULT NULL) TYPE=MyISAM; CREATE TABLE users (id INT(2) NOT NULL AUTO_INCREMENT, username VARCHAR(15) NOT NULL, usertype ENUM('admin','user','guest') NOT NULL DEFAULT 'user', password VARCHAR(32) NOT NULL DEFAULT '', email VARCHAR(50) NOT NULL, confirm_hash VARCHAR(50) NOT NULL, is_confirmed TINYINT(1) DEFAULT '0' NOT NULL, bdayInterval int(3) default NULL, bdayDisplay int(1) default NULL, displayAsPopup int(1) default NULL, useMailScript int(1) default NULL, language varchar(25) default NULL, defaultLetter char(2) default NULL, limitEntries smallint(3) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY username (username)) TYPE=MyISAM; CREATE TABLE scratchpad (notes TEXT NOT NULL) TYPE=MyISAM; INSERT INTO additionaldata VALUES(21,"Spouse","Ronda"); INSERT INTO additionaldata VALUES(21,"Spouse_Birthday","December 7"); INSERT INTO additionaldata VALUES(21,"Anniversary","November 24"); INSERT INTO address VALUES(1,1,"","Box 7805","","Kampala","","","ug","","Field: East Africa"); INSERT INTO address VALUES(2,2,"","c/o World Baptist Fellowship","","Arlington","TX","76094-0459","us","","Field: Mexico"); INSERT INTO address VALUES(4,3,"","1 Tobin Way","","S. A. 5108","TX","76094-0459","us","","Field: Mexico"); INSERT INTO address VALUES(5,4,"","P.O. Box 532786","","Grand Prarie","TX","75053-2786","us","","Field: US Evangalism"); INSERT INTO address VALUES(6,5,"","P.O. Box 0623","","Mindanao","","","ph","","Field: Philippines"); INSERT INTO address VALUES(7,6,"","c/o B.B.F.I.","","Springfield","MO","65801-0191","us","","Filed: Zambia"); INSERT INTO address VALUES(8,7,"","c/o W.B.F. Mission Agency","","Arlington","TX","76094-0459","us","","Field: Brazil"); INSERT INTO address VALUES(9,8,"","P.O. Box 2554","","Phnom Penh 3","","","kh","","Field: Cambodia"); INSERT INTO address VALUES(10,9,"","P. O. Box 33","","Cavite City","","","ph","","Field: Philippines"); INSERT INTO address VALUES(11,10,"","Casilla 09-04-598P","","Guayaquil","","","ec","","Field: Ecuador"); INSERT INTO address VALUES(12,11,"","c/o Maranatha Baptist Mission","","Natchez","MO",39121,"us","","Field: Israel"); INSERT INTO address VALUES(13,12,"","P. O. Box 135","","Kokopo","","ENBP 611","pg","","Field: PNG"); INSERT INTO address VALUES(14,13,"","P.O. Box 6641","","Ft. Worth","TX",76115,"us","","Field: Radio, US"); INSERT INTO address VALUES(15,14,"","Dorilaiou 10","","Nea Smirni 171-23","","","gr","","Field: Greece"); INSERT INTO address VALUES(16,15,"","Rua Antonio Maria","","2795-785 Queijas","","","pt","","Field: Portugal"); INSERT INTO address VALUES(17,16,"","US Baptist Rescue Mission","1900 May Street","Ft. Worth","TX",76110,"us","","Field: US"); INSERT INTO address VALUES(18,17,"","P.O. Box 3704","","Eldoret","","","ke","","Field: East Africa"); INSERT INTO address VALUES(19,18,"","Yayoi 2 chome 103-3 Kurate machi","","Fukuoka ken 807-1315","","","jp","","Field: Japan"); INSERT INTO address VALUES(20,19,"","C.P. 3788","","Bahia","","","br","","Field: Brazil"); INSERT INTO address VALUES(21,20,"","Cd. Mante Tamps.","","89000 Mexico","","","mx","","Field: Mexico"); INSERT INTO address VALUES(22,21,"","P.O. Box 40400","","Upper Hutt 6415","","","nz","","Field: New Zealand"); INSERT INTO address VALUES(23,22,"","Caixa Postal 365","","69011-970 - Manaus","Amazonas","","br","","Field: Brazil"); INSERT INTO address VALUES(24,23,"","Caixa Postal 14","","67030-970 Ananindeua","Para\\\'","","br","","Field: Brazil"); INSERT INTO address VALUES(25,24,"","2200 Woodland Oaks Drive","","Arlington","TX",76093,"us","","Field: Brazil"); INSERT INTO address VALUES(26,25,"","Minnetonka Youth Camp","","Clayton","OK",74536,"us","","Field: US"); INSERT INTO address VALUES(27,26,"","Casilla 17-11-4789","","Quito","","","ec","","Field: Ecuador"); INSERT INTO address VALUES(28,27,"","1920 Johnson","","Mission","TX",78572,"mx","",""); INSERT INTO address VALUES(29,28,"","A.A. 023","","Santa Maria","","","co","","Field: Colombia"); INSERT INTO address VALUES(30,29,"","P.O. Box 1678","","Millers Creek","NC",28651,"us","","Field: US"); INSERT INTO address VALUES(31,30,"","O.P. 1","","2000 Ploiesti","","","ro","","Field: Romania"); INSERT INTO address VALUES(32,31,"","Gapaardstraat 34","","8000 Brugge","","","be","","Field: Belgium"); INSERT INTO address VALUES(33,32,"","P.O. Box 11","","Seong Nam City","Kyung gi Do","461-600","kr","","Field: Korea"); INSERT INTO address VALUES(34,33,"","P.O. Box 276","","Kosciusko","MS",39090,"us","","Field: US"); INSERT INTO address VALUES(35,34,"","500 West Sunset Drive","","Rittman","OH",44270,"us","","Field: US Evangalism"); INSERT INTO address VALUES(36,35,"","c/o Baptist Bible Fellowship","","Springfield","MO",65801,"ru","","Field: Russia"); INSERT INTO address VALUES(37,36,"","P.O. Box 1483","","St. Michaels","AZ",86511,"us","","Field: US (Navajo In"); INSERT INTO address VALUES(38,37,"","Apartado 26","","Tamps.","","","mx","","Field: Mexico"); INSERT INTO address VALUES(39,38,"","P.O. Box 1751","","Ladysmith","","KZN 3370","za","","Field: Africa"); INSERT INTO address VALUES(40,39,"","c/o International Baptist Mission","","Dallas","TX",75217,"be","","Field: Belgium"); INSERT INTO address VALUES(41,40,"","Le Verney du Pont","73660 St. Remy de Mne.","","","","fr","","Field: France"); INSERT INTO address VALUES(42,41,"","c/o I.A.B.M.","","Forest","VA",24551,"us","","Field: Australia"); INSERT INTO address VALUES(43,42,"","Casilla 4789","","Quito","","","ec","","Field: Ecuador"); INSERT INTO address VALUES(44,43,"","P.O. Box 3704","","Eldoret","","","ke","","Field: Africa"); INSERT INTO address VALUES(45,44,"","World Baptist Fellowship","","Arlington","TX",76094,"us","","Field: US, WBF"); INSERT INTO address VALUES(46,45,"","Woodfordhill","","Commonwealth of Dominica","","","dm","","Field: West Indies"); INSERT INTO address VALUES(47,46,"","9620 Alexandra","","Richmond","British Columbia","","ca","",""); INSERT INTO address VALUES(48,47,"","c/o Baptist Bible Fellowship","","Springfield","MO",65801,"us","","Field: Croatia"); INSERT INTO address VALUES(49,48,"","World Baptist Fellowship","","Arlington","TX",76094,"us","","Field: US, WBF"); INSERT INTO address VALUES(50,49,"","P.O. Box 100794","","Scottsville 3209","Pietermaritzburg","","za","","Field: South Africa"); INSERT INTO address VALUES(51,50,"","Apartado 413","","Saltillo","Coah.",25000,"mx","","Field: Mexico"); INSERT INTO address VALUES(52,51,"","B.P 1299","","Yaounde","","","cm","","Field: West Africa"); INSERT INTO address VALUES(53,52,"","c/o World Baptist Fellowship","","Arlington","TX",76094,"us","","Field: Ukraine"); INSERT INTO address VALUES(54,53,"","811 Horizon Hills Drive","","Dallas","TX",75253,"us","","Field: AWANA"); INSERT INTO address VALUES(55,54,"","pending...","","","","",0,"",""); INSERT INTO address VALUES(56,55,"","c/o Lynx Air","","Ft. Lauderdale","FL",33340,"do","","Field: Dominican Isl"); INSERT INTO address VALUES(57,56,"","Lighthouse Children\\\'s Home","","Del Rio","TX",78841,"us","","Field: US"); INSERT INTO address VALUES(58,57,"","A.A. 55941","","Medellin","","","co","","Field: Colombia"); INSERT INTO address VALUES(59,58,"","1160 Dorothy Lane","","Harker Heights","TX","","us","","Field: Italy"); INSERT INTO address VALUES(60,59,"","7054 Kittridge Drive","","Fayetteville","NC",28314,"us","","Field: US"); INSERT INTO address VALUES(61,60,"","P.O. Box 191","","Springfield","MO",65801,"us","","Field: Nicaragua"); INSERT INTO address VALUES(62,61,"","West Orlando Baptist Church","","Orlando","FL",32818,"us","","Field: Congo"); INSERT INTO address VALUES(63,62,"","World Baptist Fellowship","","Arlington","TX",76094,"us","","Field: Indonesia"); INSERT INTO address VALUES(64,63,"","2 Dyfed Drive","","Caerphilly","Wales","CF833RF","gb","","Field: Wales"); INSERT INTO address VALUES(65,64,"","P.O. Box 2308","","Cleveland","TN",37320,"us","","Field: US Prisons"); INSERT INTO address VALUES(66,65,"","c/o Baptist Bible Fellowship","","Springfield","MO",65801,"us","","Field: Russia"); INSERT INTO address VALUES(67,66,"","Apartado 31","","Sinalao","","","mx","",""); INSERT INTO address VALUES(68,67,"","2708 Monet Place","","Dallas","TX",75287,"us","214.732.7376","Field: US"); INSERT INTO contact VALUES(1,"Al","Anderson","",1,"0000-11-09","","","","2005-12-29 00:12:35",0,"athomas"); INSERT INTO contact VALUES(2,"Gary","Bacon","",2,"0000-00-00","","","","2006-01-02 08:12:25",0,"athomas"); INSERT INTO contact VALUES(3,"Brian","Beard","",4,"0000-00-00","","","","2005-12-29 00:13:12",0,"athomas"); INSERT INTO contact VALUES(4,"Clark","Bosher","",5,"0000-00-00","","","","2005-12-29 00:13:29",0,"athomas"); INSERT INTO contact VALUES(5,"Mark","Bounds","",6,"0000-00-00","","","","2005-12-29 00:14:05",0,"athomas"); INSERT INTO contact VALUES(6,"Daniel","Bowles","",7,"0000-00-00","","","","2005-12-29 00:14:24",0,"athomas"); INSERT INTO contact VALUES(7,"Frank","Brim","",8,"0000-00-00","","","","2005-12-29 00:14:38",0,"athomas"); INSERT INTO contact VALUES(8,"Dick","Burdine","",9,"0000-00-00","","","","2005-12-29 00:15:03",0,"athomas"); INSERT INTO contact VALUES(9,"Paul","Byars","",10,"0000-00-00","","","","2005-12-29 00:15:25",0,"athomas"); INSERT INTO contact VALUES(10,"Stephen","Byrd","",11,"0000-00-00","","","","2005-12-29 00:15:54",0,"athomas"); INSERT INTO contact VALUES(11,"Talmadge","Campbell","",12,"0000-00-00","","","","2005-12-29 00:16:29",0,"athomas"); INSERT INTO contact VALUES(12,"Richard","Crotts","",13,"0000-00-00","","","","2005-12-29 00:17:32",0,"athomas"); INSERT INTO contact VALUES(13,"James","Denman","",14,"0000-00-00","","","","2005-12-29 00:17:54",0,"athomas"); INSERT INTO contact VALUES(14,"George","Dimakos","",15,"0000-00-00","","","","2005-12-29 00:18:36",0,"athomas"); INSERT INTO contact VALUES(15,"Scott","Edwards","",16,"0000-00-00","","","","2005-12-29 00:19:24",0,"athomas"); INSERT INTO contact VALUES(16,"Brian","Fisher","",17,"0000-00-00","","","","2005-12-29 00:19:45",0,"athomas"); INSERT INTO contact VALUES(17,"Christine","Fulmer","",18,"0000-00-00","","","","2005-12-29 00:20:03",0,"athomas"); INSERT INTO contact VALUES(18,"Rick","Geisler","",19,"0000-00-00","","","","2005-12-29 00:21:34",0,"athomas"); INSERT INTO contact VALUES(19,"Phil","Harris","",20,"0000-00-00","","","","2005-12-29 00:21:56",0,"athomas"); INSERT INTO contact VALUES(20,"Bill","Harvey","",21,"0000-00-00","","","","2006-01-02 07:34:01",0,"athomas"); INSERT INTO contact VALUES(21,"Bradley","Hastings","",22,"0000-09-27","","brad_ronda_hastings.gif","We are presently beginning a new work in Wellington\\\'s Hutt Valley. It is a large valley located on the northside of Wellington\\\'s harbor with a population of over 150,000. This will be the second church we have planted in our service in New Zealand. Please visit our website for more information. Many thanks for your interest in promoting our Lord\\\'s work in New Zealand! Sincerely, Brad Hastings","2006-01-20 10:54:52",0,"athomas"); INSERT INTO contact VALUES(22,"Joe","Hawkins","",23,"0000-00-00","","","","2006-01-02 07:44:41",0,"athomas"); INSERT INTO contact VALUES(23,"Bill","Horton","",24,"0000-00-00","","","","2006-01-02 07:46:15",0,"athomas"); INSERT INTO contact VALUES(24,"Neil","Jackson","",25,"0000-00-00","","","","2006-01-02 07:47:22",0,"athomas"); INSERT INTO contact VALUES(25,"David","Jackson","",26,"0000-00-00","","","","2006-01-02 07:49:38",0,"athomas"); INSERT INTO contact VALUES(26,"Gary","Janky","",27,"0000-00-00","","","","2006-01-02 07:50:59",0,"athomas"); INSERT INTO contact VALUES(27,"C. L.","Jones","",28,"0000-00-00","","","","2006-01-02 07:53:07",0,"athomas"); INSERT INTO contact VALUES(28,"Larry","Koehn","",29,"0000-00-00","","","","2006-01-02 07:54:48",0,"athomas"); INSERT INTO contact VALUES(29,"Richard","Koons","E.",30,"0000-00-00","","","","2006-01-02 07:56:31",0,"athomas"); INSERT INTO contact VALUES(30,"Mike","Landry","",31,"0000-00-00","","","","2006-01-02 07:58:29",0,"athomas"); INSERT INTO contact VALUES(31,"Dennis","Leavell","",32,"0000-00-00","","","","2006-01-02 08:11:35",0,"athomas"); INSERT INTO contact VALUES(32,"Rhee Pyo","Lee","",33,"0000-00-00","","","","2006-01-02 08:07:29",0,"athomas"); INSERT INTO contact VALUES(33,"","Lighthouse Children\\\'s Home","",34,"0000-00-00","","","","2006-01-02 08:09:47",0,"athomas"); INSERT INTO contact VALUES(34,"Kenny","McComas","",35,"0000-00-00","","","","2006-01-02 08:11:58",0,"athomas"); INSERT INTO contact VALUES(35,"Mark","McDonald","",36,"0000-00-00","","","","2006-01-02 08:17:57",0,"athomas"); INSERT INTO contact VALUES(36,"Scott","Merritt","",37,"0000-00-00","","","","2006-01-02 08:19:16",0,"athomas"); INSERT INTO contact VALUES(37,"Bessie","Millican","Lee",38,"0000-00-00","","","","2006-01-02 08:20:38",0,"athomas"); INSERT INTO contact VALUES(38,"Don","Mingo","",39,"0000-00-00","","","","2006-01-02 08:22:31",0,"athomas"); INSERT INTO contact VALUES(39,"Joseph","Mohler","",40,"0000-00-00","","","","2006-01-02 08:23:43",0,"athomas"); INSERT INTO contact VALUES(40,"Terry","Morse","",41,"0000-00-00","","","","2006-01-02 08:25:41",0,"athomas"); INSERT INTO contact VALUES(41,"John","Napier","",42,"0000-00-00","","","","2006-01-02 08:30:53",0,"athomas"); INSERT INTO contact VALUES(42,"Mel","Neill","",43,"0000-00-00","","","","2006-01-02 08:31:42",0,"athomas"); INSERT INTO contact VALUES(43,"Christine","Pelletier","",44,"0000-00-00","","","","2006-01-02 08:32:45",0,"athomas"); INSERT INTO contact VALUES(44,"Tommy","Raley","",45,"0000-00-00","","","","2006-01-02 08:53:23",0,"athomas"); INSERT INTO contact VALUES(45,"Ed","Richards","",46,"0000-00-00","","","","2006-01-02 08:41:09",0,"athomas"); INSERT INTO contact VALUES(46,"Will","Rogers","",47,"0000-00-00","","","","2006-01-02 08:42:43",0,"athomas"); INSERT INTO contact VALUES(47,"Joel","Rumbaugh","",48,"0000-00-00","","","","2006-01-02 08:45:20",0,"athomas"); INSERT INTO contact VALUES(48,"David","Schembera","",49,"0000-00-00","","","","2006-01-02 08:53:44",0,"athomas"); INSERT INTO contact VALUES(49,"Mark","Schladenhauffen","",50,"0000-00-00","","","","2006-01-02 08:49:00",0,"athomas"); INSERT INTO contact VALUES(50,"Marty","Starling","",51,"0000-00-00","","","","2006-01-02 08:50:26",0,"athomas"); INSERT INTO contact VALUES(51,"Minnie","Stoumbaugh","",52,"0000-00-00","","","","2006-01-02 08:52:42",0,"athomas"); INSERT INTO contact VALUES(52,"Shaun","Sullivan","",53,"0000-00-00","","","","2006-01-02 08:55:43",0,"athomas"); INSERT INTO contact VALUES(53,"Bill","Tunison","",54,"0000-00-00","","","","2006-01-02 08:56:44",0,"athomas"); INSERT INTO contact VALUES(54,"Terry","Unruh","",55,"0000-00-00","","","","2006-01-02 08:57:39",0,"athomas"); INSERT INTO contact VALUES(55,"Ron","Valeria","",56,"0000-00-00","","","","2006-01-02 08:59:08",0,"athomas"); INSERT INTO contact VALUES(56,"Royce","Vick","",57,"0000-00-00","","","","2006-01-02 09:00:18",0,"athomas"); INSERT INTO contact VALUES(57,"Rick","Washburn","",58,"0000-00-00","","","","2006-01-02 09:01:43",0,"athomas"); INSERT INTO contact VALUES(58,"Dominic","Vivona","",59,"0000-00-00","","","","2006-01-02 09:04:01",0,"athomas"); INSERT INTO contact VALUES(59,"Jack","Weaver","",60,"0000-00-00","","","","2006-01-02 09:05:37",0,"athomas"); INSERT INTO contact VALUES(60,"Brian","Weed","",61,"0000-00-00","","","","2006-01-02 09:07:02",0,"athomas"); INSERT INTO contact VALUES(61,"Frank","Wells","",62,"0000-00-00","","","","2006-01-02 09:08:34",0,"athomas"); INSERT INTO contact VALUES(62,"Karen","Werth","",63,"0000-00-00","","","","2006-01-02 09:09:50",0,"athomas"); INSERT INTO contact VALUES(63,"Tom","Wheeler","",64,"0000-00-00","","","","2006-01-02 09:11:24",0,"athomas"); INSERT INTO contact VALUES(64,"Stephen","Wiest","",65,"0000-00-00","","","","2006-01-02 09:12:46",0,"athomas"); INSERT INTO contact VALUES(65,"Jeff","Williams","",66,"0000-00-00","","","","2006-01-02 09:14:09",0,"athomas"); INSERT INTO contact VALUES(66,"Barbara","Wimm","",67,"0000-00-00","","","","2006-01-02 09:15:08",0,"athomas"); INSERT INTO contact VALUES(67,"Amanda","Thomas","",68,"0000-05-28","","amandathomas.gif","Amanda serves to provide marketing support to Christian ministries and missionaries. Amanda specializes in creative design, and spans both web and print mediums. She is married and has three children. Northside Baptist Church (Carrollton, TX) is Amanda\\\'s church home.","2006-01-02 09:46:09",1,"athomas"); INSERT INTO email VALUES(1,"a_uganda@swiftuganda.com",""); INSERT INTO email VALUES(3,"ozrev1@yahoo.com",""); INSERT INTO email VALUES(5,"WVBM@altavista.com",""); INSERT INTO email VALUES(6,"danlbowl@zamnet.zm",""); INSERT INTO email VALUES(8,"ibncambodia@camnet.com.kh",""); INSERT INTO email VALUES(9,"pdbyars@cav.pworld.nrt.ph",""); INSERT INTO email VALUES(12,"rcrotts@ourtownusa.net",""); INSERT INTO email VALUES(13,"gospelradio@juno.com",""); INSERT INTO email VALUES(14,"Dimakos@hol.gr",""); INSERT INTO email VALUES(15,"104035.3547@compuserve.com",""); INSERT INTO email VALUES(17,"Malaika@net2000ke.com",""); INSERT INTO email VALUES(18,"rgeisler@alles.or.jp",""); INSERT INTO email VALUES(19,"bublybpts@hotmail.com",""); INSERT INTO email VALUES(23,"wernbel@amazon.com.br",""); INSERT INTO email VALUES(26,"gjanky@ecuanex.net.ec",""); INSERT INTO email VALUES(28,"lkoehn@compunet.net.co",""); INSERT INTO email VALUES(29,"celebrationbaptist@juno.com",""); INSERT INTO email VALUES(30,"mc4rom@transdata.ro",""); INSERT INTO email VALUES(33,"lch@kowper.com",""); INSERT INTO email VALUES(31,"The_NetherBel_Team@compuserve.com",""); INSERT INTO email VALUES(35,"markmcd@telecom.nov.ru",""); INSERT INTO email VALUES(36,"0002108941@mcimail.com",""); INSERT INTO email VALUES(38,"donaldmingo@futurnet.co.za",""); INSERT INTO email VALUES(39,"jemohler@aol.com",""); INSERT INTO email VALUES(40,"106306.1750@compuserve.com",""); INSERT INTO email VALUES(41,"jgnapier@dove.net.au",""); INSERT INTO email VALUES(43,"MALAIKAA@MAF.net",""); INSERT INTO email VALUES(45,"richardse@cwdom.dm",""); INSERT INTO email VALUES(46,"willrogers@telus.net",""); INSERT INTO email VALUES(47,"jrumbaugh@mail.datanet.hu",""); INSERT INTO email VALUES(49,"mssch@mweb.co.za",""); INSERT INTO email VALUES(50,"mxgatorguy@netscape.net",""); INSERT INTO email VALUES(51,"minnie_stoumbaugh@sil.org",""); INSERT INTO email VALUES(44,"wbfraley@onramp.net",""); INSERT INTO email VALUES(48,"daves@baptists.org",""); INSERT INTO email VALUES(52,"ASull65@aol.com",""); INSERT INTO email VALUES(53,"missionary@awana-nct.org",""); INSERT INTO email VALUES(55,"drron@tricom.net",""); INSERT INTO email VALUES(58,"dvivona@juno.com",""); INSERT INTO email VALUES(63,"thomas.wheeler@virgin.net",""); INSERT INTO email VALUES(64,"SWIEST2116@AOL.COM",""); INSERT INTO email VALUES(65,"williams2russia@iname.com",""); INSERT INTO email VALUES(67,"amandathomas@momstrade.com",""); INSERT INTO email VALUES(21,"rev_hastings@compuserve.com","Bradley"); INSERT INTO email VALUES(21,"ronda2nz@hotmail.com","Ronda"); INSERT INTO grouplist VALUES(0,"(all entries)"); INSERT INTO grouplist VALUES(1,"(ungrouped entries)"); INSERT INTO grouplist VALUES(2,"(hidden entries)"); INSERT INTO grouplist VALUES(3,"Missionaries"); INSERT INTO grouplist VALUES(4,"Brazil"); INSERT INTO grouplist VALUES(5,"Africa"); INSERT INTO grouplist VALUES(6,"Mexico"); INSERT INTO grouplist VALUES(7,"United States"); INSERT INTO grouplist VALUES(8,"Philippines"); INSERT INTO grouplist VALUES(9,"South America"); INSERT INTO grouplist VALUES(10,"North America"); INSERT INTO grouplist VALUES(11,"Oceania"); INSERT INTO grouplist VALUES(12,"Canada"); INSERT INTO grouplist VALUES(13,"Asia"); INSERT INTO grouplist VALUES(14,"Europe"); INSERT INTO grouplist VALUES(15,"Antarctica"); INSERT INTO grouplist VALUES(16,"Uganda"); INSERT INTO grouplist VALUES(17,"Zambia"); INSERT INTO grouplist VALUES(18,"Cambodia"); INSERT INTO grouplist VALUES(19,"Ecuador"); INSERT INTO grouplist VALUES(20,"Israel"); INSERT INTO grouplist VALUES(21,"Papua New Guinea"); INSERT INTO grouplist VALUES(22,"Greece"); INSERT INTO grouplist VALUES(23,"Portugal"); INSERT INTO grouplist VALUES(24,"Kenya"); INSERT INTO grouplist VALUES(25,"Japan"); INSERT INTO grouplist VALUES(26,"New Zealand"); INSERT INTO grouplist VALUES(27,"Colombia"); INSERT INTO grouplist VALUES(28,"Romania"); INSERT INTO grouplist VALUES(29,"Belgium"); INSERT INTO grouplist VALUES(30,"Korea"); INSERT INTO grouplist VALUES(31,"Russia"); INSERT INTO grouplist VALUES(32,"South Africa"); INSERT INTO grouplist VALUES(33,"France"); INSERT INTO grouplist VALUES(34,"Australia"); INSERT INTO grouplist VALUES(35,"Kenya"); INSERT INTO grouplist VALUES(36,"Dominica"); INSERT INTO grouplist VALUES(37,"West Indies"); INSERT INTO grouplist VALUES(38,"Croatia"); INSERT INTO grouplist VALUES(39,"Cameroon"); INSERT INTO grouplist VALUES(40,"West Africa"); INSERT INTO grouplist VALUES(41,"Ukraine"); INSERT INTO grouplist VALUES(42,"Dominican Islands"); INSERT INTO grouplist VALUES(43,"Italy"); INSERT INTO grouplist VALUES(44,"Nicaragua"); INSERT INTO grouplist VALUES(45,"Congo"); INSERT INTO grouplist VALUES(46,"Indonesia"); INSERT INTO grouplist VALUES(47,"United Kingdom"); INSERT INTO groups VALUES(1,5); INSERT INTO groups VALUES(1,3); INSERT INTO groups VALUES(1,16); INSERT INTO groups VALUES(3,6); INSERT INTO groups VALUES(3,3); INSERT INTO groups VALUES(3,10); INSERT INTO groups VALUES(4,3); INSERT INTO groups VALUES(4,10); INSERT INTO groups VALUES(4,7); INSERT INTO groups VALUES(5,13); INSERT INTO groups VALUES(5,3); INSERT INTO groups VALUES(5,8); INSERT INTO groups VALUES(6,5); INSERT INTO groups VALUES(6,3); INSERT INTO groups VALUES(6,17); INSERT INTO groups VALUES(7,4); INSERT INTO groups VALUES(7,3); INSERT INTO groups VALUES(7,9); INSERT INTO groups VALUES(8,5); INSERT INTO groups VALUES(8,3); INSERT INTO groups VALUES(8,18); INSERT INTO groups VALUES(9,13); INSERT INTO groups VALUES(9,3); INSERT INTO groups VALUES(9,8); INSERT INTO groups VALUES(10,3); INSERT INTO groups VALUES(10,9); INSERT INTO groups VALUES(10,19); INSERT INTO groups VALUES(11,13); INSERT INTO groups VALUES(11,3); INSERT INTO groups VALUES(11,20); INSERT INTO groups VALUES(12,3); INSERT INTO groups VALUES(12,11); INSERT INTO groups VALUES(12,21); INSERT INTO groups VALUES(13,3); INSERT INTO groups VALUES(13,10); INSERT INTO groups VALUES(13,7); INSERT INTO groups VALUES(14,14); INSERT INTO groups VALUES(14,3); INSERT INTO groups VALUES(14,22); INSERT INTO groups VALUES(15,14); INSERT INTO groups VALUES(15,3); INSERT INTO groups VALUES(15,23); INSERT INTO groups VALUES(16,3); INSERT INTO groups VALUES(16,10); INSERT INTO groups VALUES(16,7); INSERT INTO groups VALUES(17,5); INSERT INTO groups VALUES(17,3); INSERT INTO groups VALUES(17,24); INSERT INTO groups VALUES(18,13); INSERT INTO groups VALUES(18,3); INSERT INTO groups VALUES(18,25); INSERT INTO groups VALUES(19,4); INSERT INTO groups VALUES(19,3); INSERT INTO groups VALUES(19,9); INSERT INTO groups VALUES(20,6); INSERT INTO groups VALUES(20,3); INSERT INTO groups VALUES(20,10); INSERT INTO groups VALUES(22,4); INSERT INTO groups VALUES(22,3); INSERT INTO groups VALUES(22,9); INSERT INTO groups VALUES(23,4); INSERT INTO groups VALUES(23,3); INSERT INTO groups VALUES(23,9); INSERT INTO groups VALUES(24,4); INSERT INTO groups VALUES(24,3); INSERT INTO groups VALUES(24,9); INSERT INTO groups VALUES(25,3); INSERT INTO groups VALUES(25,10); INSERT INTO groups VALUES(25,7); INSERT INTO groups VALUES(26,19); INSERT INTO groups VALUES(26,3); INSERT INTO groups VALUES(26,9); INSERT INTO groups VALUES(27,6); INSERT INTO groups VALUES(27,3); INSERT INTO groups VALUES(27,10); INSERT INTO groups VALUES(28,3); INSERT INTO groups VALUES(28,9); INSERT INTO groups VALUES(28,27); INSERT INTO groups VALUES(29,3); INSERT INTO groups VALUES(29,10); INSERT INTO groups VALUES(29,7); INSERT INTO groups VALUES(30,14); INSERT INTO groups VALUES(30,3); INSERT INTO groups VALUES(30,28); INSERT INTO groups VALUES(32,13); INSERT INTO groups VALUES(32,30); INSERT INTO groups VALUES(32,3); INSERT INTO groups VALUES(33,3); INSERT INTO groups VALUES(33,10); INSERT INTO groups VALUES(33,7); INSERT INTO groups VALUES(31,29); INSERT INTO groups VALUES(31,14); INSERT INTO groups VALUES(31,3); INSERT INTO groups VALUES(34,3); INSERT INTO groups VALUES(34,10); INSERT INTO groups VALUES(34,7); INSERT INTO groups VALUES(2,6); INSERT INTO groups VALUES(2,3); INSERT INTO groups VALUES(2,10); INSERT INTO groups VALUES(35,14); INSERT INTO groups VALUES(35,3); INSERT INTO groups VALUES(35,31); INSERT INTO groups VALUES(36,3); INSERT INTO groups VALUES(36,10); INSERT INTO groups VALUES(36,7); INSERT INTO groups VALUES(37,6); INSERT INTO groups VALUES(37,3); INSERT INTO groups VALUES(37,10); INSERT INTO groups VALUES(38,5); INSERT INTO groups VALUES(38,3); INSERT INTO groups VALUES(38,32); INSERT INTO groups VALUES(39,29); INSERT INTO groups VALUES(39,14); INSERT INTO groups VALUES(39,3); INSERT INTO groups VALUES(40,14); INSERT INTO groups VALUES(40,3); INSERT INTO groups VALUES(40,33); INSERT INTO groups VALUES(41,3); INSERT INTO groups VALUES(41,11); INSERT INTO groups VALUES(41,34); INSERT INTO groups VALUES(42,19); INSERT INTO groups VALUES(42,3); INSERT INTO groups VALUES(42,9); INSERT INTO groups VALUES(43,5); INSERT INTO groups VALUES(43,3); INSERT INTO groups VALUES(43,35); INSERT INTO groups VALUES(45,36); INSERT INTO groups VALUES(45,3); INSERT INTO groups VALUES(45,10); INSERT INTO groups VALUES(45,37); INSERT INTO groups VALUES(46,12); INSERT INTO groups VALUES(46,3); INSERT INTO groups VALUES(46,10); INSERT INTO groups VALUES(47,14); INSERT INTO groups VALUES(47,3); INSERT INTO groups VALUES(47,38); INSERT INTO groups VALUES(49,5); INSERT INTO groups VALUES(49,3); INSERT INTO groups VALUES(49,32); INSERT INTO groups VALUES(50,6); INSERT INTO groups VALUES(50,3); INSERT INTO groups VALUES(50,10); INSERT INTO groups VALUES(51,5); INSERT INTO groups VALUES(51,39); INSERT INTO groups VALUES(51,3); INSERT INTO groups VALUES(51,40); INSERT INTO groups VALUES(44,3); INSERT INTO groups VALUES(44,10); INSERT INTO groups VALUES(44,7); INSERT INTO groups VALUES(48,3); INSERT INTO groups VALUES(48,10); INSERT INTO groups VALUES(48,7); INSERT INTO groups VALUES(52,14); INSERT INTO groups VALUES(52,3); INSERT INTO groups VALUES(52,41); INSERT INTO groups VALUES(53,3); INSERT INTO groups VALUES(53,10); INSERT INTO groups VALUES(53,7); INSERT INTO groups VALUES(55,3); INSERT INTO groups VALUES(55,10); INSERT INTO groups VALUES(55,42); INSERT INTO groups VALUES(56,3); INSERT INTO groups VALUES(56,10); INSERT INTO groups VALUES(56,7); INSERT INTO groups VALUES(57,27); INSERT INTO groups VALUES(57,3); INSERT INTO groups VALUES(57,9); INSERT INTO groups VALUES(58,14); INSERT INTO groups VALUES(58,3); INSERT INTO groups VALUES(58,43); INSERT INTO groups VALUES(59,3); INSERT INTO groups VALUES(59,10); INSERT INTO groups VALUES(59,7); INSERT INTO groups VALUES(60,3); INSERT INTO groups VALUES(60,9); INSERT INTO groups VALUES(60,44); INSERT INTO groups VALUES(61,5); INSERT INTO groups VALUES(61,3); INSERT INTO groups VALUES(61,45); INSERT INTO groups VALUES(62,13); INSERT INTO groups VALUES(62,3); INSERT INTO groups VALUES(62,46); INSERT INTO groups VALUES(63,14); INSERT INTO groups VALUES(63,3); INSERT INTO groups VALUES(63,47); INSERT INTO groups VALUES(64,3); INSERT INTO groups VALUES(64,10); INSERT INTO groups VALUES(64,7); INSERT INTO groups VALUES(65,14); INSERT INTO groups VALUES(65,3); INSERT INTO groups VALUES(65,31); INSERT INTO groups VALUES(66,6); INSERT INTO groups VALUES(66,3); INSERT INTO groups VALUES(66,10); INSERT INTO groups VALUES(67,10); INSERT INTO groups VALUES(67,7); INSERT INTO groups VALUES(21,3); INSERT INTO groups VALUES(21,26); INSERT INTO groups VALUES(21,11); INSERT INTO options VALUES(21,0,0,1,1,140,140,1,1,0,"

Please log in to access the Address Book."," ","",0,0,0,"english","",0); INSERT INTO websites VALUES(67,"http://www.momstrade.com","Mom\\\'s Trade"); INSERT INTO websites VALUES(21,"http://www.wbfi.net/missionaries/hastings/hastings.htm",""); INSERT INTO users VALUES(1,"admin","admin","21232f297a57a5a743894a0e4a801fc3","","",1,"","","","","","",""); INSERT INTO users VALUES(2,"guest","user","084e0343a0486ff05530df6c705c8bb4","","",1,"","","","","","",""); INSERT INTO users VALUES(3,"athomas","admin","863a2250b89e0bdcd681b08e6dd16e6a","amandathomas@momstrade.com","",1,"","","","","","",""); INSERT INTO users VALUES(4,"jfoster","admin","4fa2837426bcb1f4a30933c6b17fd8df","","",1,"","","","","","",""); INSERT INTO users VALUES(5,"NorthsideBC","user","aa08769cdcb26674c6706093503ff0a3","","",1,"","","","","","",""); INSERT INTO scratchpad VALUES("");