-- MySQL dump 9.10 -- -- Host: localhost Database: bsp -- ------------------------------------------------------ -- Server version 4.0.17-standard -- -- Table structure for table `announcements` -- CREATE TABLE announcements ( id int(5) unsigned NOT NULL auto_increment, subject varchar(200) default NULL, body text, post_date date default NULL, valid_until date default NULL, is_active enum('Y','N') default 'Y', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `announcements` -- INSERT INTO announcements VALUES (78,'Secret Sister','Please remember your Sister Sister................','2007-09-05','0000-00-00','Y'); -- -- Table structure for table `events` -- CREATE TABLE events ( id int(5) unsigned NOT NULL auto_increment, title varchar(200) default NULL, type varchar(100) default NULL, date date default NULL, host varchar(200) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `events` -- INSERT INTO events VALUES (82,'Final Meeting','','2008-05-19','Julie'); INSERT INTO events VALUES (81,'Luncheon','Mother\'s Day','2008-05-10',''); INSERT INTO events VALUES (83,'Dinner/Meeting','Founder\'s Day','2008-04-28',''); INSERT INTO events VALUES (79,'Meeting','','2008-04-14','Belva'); INSERT INTO events VALUES (78,'Meeting','','2008-03-24','Helen'); INSERT INTO events VALUES (77,'Meeting','','2008-03-10','Patty'); INSERT INTO events VALUES (76,'Meeting','','2008-02-25','Denise'); INSERT INTO events VALUES (75,'Meeting','','2008-02-11','Wanda/Terri'); INSERT INTO events VALUES (74,'Meeting','','2008-01-28','Carolyn F.'); INSERT INTO events VALUES (66,'Meeting','','2007-09-10','Diane'); INSERT INTO events VALUES (67,'Meeting','','2007-09-24','Ellen'); INSERT INTO events VALUES (68,'Meeting','','2007-10-08',''); INSERT INTO events VALUES (69,'Meeting','','2007-10-22','Keila'); INSERT INTO events VALUES (70,'Meeting','','2007-11-12','Carolyn Solmon'); INSERT INTO events VALUES (71,'Meeting','','2007-11-26','Phyllis'); INSERT INTO events VALUES (72,'Christmas Party','','2007-12-08',''); INSERT INTO events VALUES (73,'Meeting','','2008-01-14','Ruth'); -- -- Table structure for table `member_profiles` -- CREATE TABLE member_profiles ( id int(5) unsigned NOT NULL auto_increment, member_id int(5) default NULL, subject varchar(200) default NULL, description text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `member_profiles` -- INSERT INTO member_profiles VALUES (1,1,'Favorite color','black and red'); -- -- Table structure for table `members` -- CREATE TABLE members ( id int(4) unsigned NOT NULL auto_increment, first_name varchar(20) default NULL, middle_name varchar(20) default NULL, last_name varchar(50) default NULL, addr1 varchar(100) default NULL, addr2 varchar(100) default NULL, city varchar(100) default NULL, state char(2) default NULL, zip varchar(10) default NULL, h_phone varchar(10) default NULL, w_phone varchar(10) default NULL, m_phone varchar(10) default NULL, email varchar(200) default NULL, dob date default NULL, anniversary date default NULL, husband varchar(100) default NULL, telephone_group varchar(100) default NULL, profile text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `members` -- INSERT INTO members VALUES (1,'Lynne','L.','Murkerson','206 Warthen Street','','La Fayette','GA','30728','7066386944','7066380702','4233640131','lynne@ advancedreporters.com, lynnecourt@aol.com','0000-06-28','0000-04-25','Larry','2','[b]Favorite color:[/b] black/red\r\n\r\n[b]Favorite flowers:[/b] roses and tulips (anything that can be planted outdoors)\r\n\r\n[b]Kitchen colors:[/b] green, black, white\r\n\r\n[b]Bath colors:[/b] (1) burgundy, black, white (2) green, white, burgundy\r\n\r\n[b]China: [/b] Christmas Rose - Spode, Royal Orchard - Noritake, Royal Hunt by Noritake\r\n\r\n[b]Perfume:[/b] Fendi Eau de Parfum only\r\n\r\n[b]Lingerie:[/b] french cut panties, cotton night shirts by VS\r\n\r\n[b]Jewelry:[/b] pierced, silver, costume, sparkly\r\n\r\n[b]Hobbies:[/b] traveling, decorating, baseball, football, boating\r\n\r\n[b]Special Likes: [/b] UGA football, Falcon football, gardening, books, kitchen items\r\n\r\n[b]Shoe Size:[/b] 7 1/2\r\n\r\n[b]Wish List:[/b] fashionable winter scarves, costume jewelry, cute reading glasses, gardening tools, belts, cotton pj\'s, restaurant gift certificates \r\n\r\n[b]Favorite Wine:[/b] Chardonnay'); INSERT INTO members VALUES (2,'Ruth','','Bass','Post Office Box 1795','','La Fayette','GA','30728','7066381524','7066382733','4234887115','rblha@windstream.net','0000-07-17','1988-04-04','Johnny','2','Favorite colors: blue, cream, red, and black and white\r\n\r\nKitchen colors: blue and white\r\n\r\nBath colors: blue, white and gray\r\n\r\nPerfume: Sung-Alfred Sung \r\n\r\nLingerie: medium\r\n\r\nJewelry: gold and silver (pierced ears)\r\n\r\nFavorite flowers: yellow roses and daises\r\n\r\nHobbies: reading, collecting Santas and angels, and gardening\r\n\r\nSpecial likes: going to new places and living\r\n\r\nWish list: Casual 4x6 or 3x5 picture frames, striped cotton scarf, candles, restaurant gift certificate, anything to do with traveling \r\n\r\nShoe Size: 8'); INSERT INTO members VALUES (4,'Carolyn','','Florence','Post Office Box 791','','La Fayette','GA','30728','7066381983','7066383114','4236053424','CLFlorence3@windstream.net','0000-03-14','1977-06-11','Neal','3','Favorite color: blue, green\r\n\r\nFavorite flower: green plants\r\n\r\nBath colors: green, gold, and cranberry\r\n\r\nNew bath: yellow and blue\r\n\r\nKitchen colors: cream, green, neutral \r\n\r\nLingerie: gown, medium\r\n\r\nJewelry: silver (pierced ears), bracelets\r\n\r\nHobbies: traveling, walking\r\n\r\nShoe Size: 9\r\n\r\nWish List: Christmas China is Spode, gift certificates to L&N Nails, Georgia Bulldogs, restaurant gift certificates, costume jewelry, Christmas ornaments (red, green, gold) picture frames, books on tape\r\n\r\nFavorite Wine: Risling'); INSERT INTO members VALUES (5,'Helen','','Gamble','582 Scoggins Lane','','Summerville','GA','30747','7063972494','','4235032231','gamblefarm@windstream.net','0000-03-09','0000-03-03','Robert','3','Favorite colors: red, green\r\n\r\nFavorite flower: rose\r\n\r\nBath colors: green and white\r\n\r\nKitchen colors: green and cranberry\r\n\r\nPerfume: Liz Claiborne, woodsy scents\r\n\r\nLingerie: small, medium pajamas\r\n\r\nJewelry: silver, yellow gold, earrings, pierced and pins\r\n\r\nWine: White Zin\r\n\r\nShoe Size: 8\r\n\r\nFavorite Things: trays, picture frames, birdhouses\r\n\r\nChristmas Wish List: Taste of Home Baking Cookbook, fuzzy house socks, black earrings, candles'); INSERT INTO members VALUES (6,'Keila','','Beaird','342 Pledger Street','','La Fayette','GA','30728','7066386196','','4239020478','doublebfarm@peoplepc.com','0000-10-06','2004-07-07','Butch','2','Favorite color: teal and cranberry\r\n\r\nFavorite flowers: yellow roses and white daisies\r\n\r\nBath colors: white, tan\r\n\r\nKitchen colors: hunter green, white, and cranberry\r\n\r\nPerfume: Giorgio, Vanderbilt and Beautiful\r\n\r\nLingerie: large cotton pjs or short gown, panties-7, high-cut nylon, thongs\r\n\r\nJewelry: gold (pierced ears)\r\n\r\nHobbies: crossword and jigsaw puzzles, horseback riding, billiards\r\n\r\nSpecial Likes: pitchers, teapots\r\n\r\nWish List: picture frames, restaurant gift certificates \r\n\r\nShoe Size: 7 \r\n\r\nFavorite Wine: White Zin or Red\r\n\r\nSports Team: Braves and Dawgs'); INSERT INTO members VALUES (7,'Belva','','Gilbert','569 Sleepy Hollow Road','','La Fayette','GA','30728','7066386847','','4238024515','HGilb76425@aol.com','0000-04-01','0000-12-18','Henry','1','Favorite color: red\r\n\r\nFavorite flower: rose\r\n\r\nDen: rust, gold, cream, olive green\r\n\r\nLiving Room: yellow, blue, gold, red \r\n\r\nBath colors: beige, green, rose\r\n\r\nKitchen colors: gold, rust and red\r\n\r\nPerfume: White Linen, Ann Taylor fragrance\r\n\r\nLingerie: medium (feminine)\r\n\r\nJewelry: silver chandelier (not pierced ears)\r\n\r\nChina: Potpourri-Wedgewood and Reverie-Noritake\r\n\r\nShoe Size: 8 M\r\n\r\nHobbies: antiques, decorating, thimbles, Christmas decorations, cooking, and pineapples, cobalt blue items, Blue Willow items, pretty trays\r\n\r\nSpecial Likes: Christmas china by Spode\r\n\r\nChristmas Wish List: Black scarf (warm), black gloves, any color clip earrings, massage (upper body), gift certificates, dining gift certificates, movie gift certificates, long sleeve cotton knit pajamas.\r\n\r\nWine: White'); INSERT INTO members VALUES (9,'Carleen','','Vaughn','807 Azalea Drive','','La Fayette','GA','30728','7066385297','','4234882354','','0000-05-27','0000-00-00','','2','Favorite color: blue\r\n\r\nFavorite flowers: green plants and roses\r\n\r\nBath colors: cranberry and gold\r\n\r\nKitchen colors: blue and mauve, yellow\r\n\r\nPerfume: Vivid, Carolina Herrera\r\n\r\nLingerie: large\r\n\r\nJewelry: yellow gold and silver (nickel free)\r\n\r\nChina: Poppies on Blue\r\n\r\nHobbies: reading, cooking, and partying\r\n\r\nSpecial Likes: candles, picture frames, baskets, flower pots'); INSERT INTO members VALUES (10,'Phyllis','','Maddox','709 Dogwood Circle','','La Fayette','GA','30728','7066386842','7063750740','4042342019','ptmaddox@netzero.net','0000-09-23','0000-00-00','','2','Bath colors: camel and green, green \r\n\r\nKitchen colors: Almond with black and ruby red\r\n\r\nPerfume: Kenzo\r\n\r\nFlowers: Hydrangeas\r\n\r\nLingerie: silk pajamas, flannel pj�s\r\n\r\nJewelry: gold and silver, pierced earrings\r\n\r\nHobbies: sports, reading\r\n\r\nSpecial Likes: perfume bottles, broadway musicals, decorator eggs, crystal, all music except for country, candles, Bath Body Works ( lotion, spray & body wash Berganot Coriander and Orange Ginger\r\n\r\nWine: Chardonnay and Merlot\r\n\r\nShoe Size: 9'); INSERT INTO members VALUES (12,'Julie','','McCary','5 Sunrise Drive','','La Fayette','GA','30728','7066383224','','4239020408','mhmccary@comcast.net','0000-01-14','0000-08-23','Mike','3','Favorite color: red\r\n\r\nFavorite flowers: tulips, anything red or pink\r\n\r\nBed and bath colors: dark green and red\r\n\r\nKitchen colors: Red, yellow, green\r\n\r\nPerfume: Intuition \r\n\r\nLingerie: large French-cut panties, gown\r\n\r\nJewelry: silver or gold (pierced ears), bracelets, necklaces\r\n\r\nHobbies: reading, cross stitching, traveling\r\n\r\nWish List: Long nightgown-sleeveless, large, new slippers, size 6, books-bestseller list, nice sweatshirt, chocolate, surprise me!\r\n\r\nFavorite Wine: Chardonnay \r\n\r\nChristmas Wish List: knit warm gloves, Chico\'s jewelry\r\n\r\nShoe Size: 6'); INSERT INTO members VALUES (13,'Karen','','Moore','Post Office Box 1046','','La Fayette','GA','30728','7066385374','','7066397981','moorek614@comcast.net','0000-10-23','0000-06-14','Joe','1','Favorite color: yellow\r\n\r\nFavorite flower: daisy\r\n\r\nBath colors: hunter green and yellow\r\n\r\nKitchen colors: hunter green\r\n\r\nLingerie: short PJ�s with boxers, large\r\n\r\nJewelry: pierced ears, fun things, Georgia Bulldogs\r\n\r\nChina: Spode-Christmas china-miscellaneous pieces\r\n\r\nHobbies: gardening, reading, new recipes, and antiques\r\n\r\nSpecial Likes: Georgia Bulldogs, green plants, candles, antique teacups and saucers'); INSERT INTO members VALUES (14,'Denise','','Shahan','409 Brookwood Lane','','La Fayette','GA','30728','7066385882','','4233047019','D5M5S@aol.com','0000-02-10','1999-10-08','Jim','3','Favorite color: blue, any shade\r\n\r\nFavorite flowers: roses, daffodils, pansies\r\n\r\nBath colors: jewel tones & white/cranberry\r\n\r\nKitchen colors: yellow and cobalt\r\n\r\nPerfume: Ysatis-Givenchy, Victoria\'s Secret Pear Glace, Givenchy Very Irrestible\r\n\r\nLingerie: large, 38 or 7 (whichever applies)\r\n\r\nJewelry: yellow gold (pierced ears), two-tone silver/gold\r\n\r\nChina: Port Meriaon Botanic Garden, Christmastime-Nikko\r\n\r\nSilver: Grand Heritage-Rogers\r\n\r\nCrystal: Century-Lenox\r\n\r\nShoe Size: 8\r\n\r\nHobbies: water sports, reading and snow skiing, cooking\r\n\r\nSpecial likes: anything traditional, personal items, traveling, snow villages, collect Swarvosky crystal pieces, unusual things such as china oyster plates, leather covered decanters, crystal anything, fancy table linens, Itunes\r\n\r\nFavorite Wine: Red\r\n\r\nWish List: flannel or cotton lounge pants- XL (pink or blue) long sleeve tee to match XL or 1X, crystal ball spiral mobile for home office'); INSERT INTO members VALUES (15,'Carolyn','','Solmon','185 Forrestway Drive','','La Fayette','GA','30728','7067641838','','4233641790','csolmon@comcast.net','0000-07-22','0000-00-00','','1','Favorite colors: black, gold, red, taupe\r\n\r\nFavorite flowers: roses, hydrangea, azalea, daisies \r\n\r\nBath colors: (1) cream, taupe, wine; (2) dark green and gold, white\r\nPerfume: Chanel No. 5, Tresor\r\n\r\nLingerie: Large, lounging, mid-calf slip, panties - 8\r\n\r\nJewelry: silver (pierced ears)\r\n\r\nHobbies: Playing piano, eating out, shopping, traveling\r\n\r\nSpecial likes: Fiesta dinnerware (original - will find at antique shops or booth), silver picture frames, antiques, books (classics)\r\n\r\nFavorite Wine: Chardonnay, Lambrusco, White Zin\r\n\r\nShoe Size: 8\r\n\r\nWish List: Dark red wine or mimosa glass stemware, Christmas pitcher, Christmas napkins, Fiesta dinnerware (original, not the new reproductions), and silver picture frames'); INSERT INTO members VALUES (17,'Patty','','Wallace','Post Office Box 1288','','La Fayette','GA','30728','7066382677','7066381869','7067646009','pattywallace@walkerschools.org','0000-02-16','0000-10-23','Allen','1','Favorite color: blue\r\n\r\nFavorite flowers: yellow roses and daisies\r\n\r\nBath colors: country blue, browns, beiges, hunter green\r\n\r\nKitchen colors: country blue and burgundy\r\n\r\nLingerie: 34, gown (medium or large, depending on style)\r\n\r\nJewelry: pierced ears\r\n\r\nHobbies: arts and crafts, reading, printer’s drawer items, and collecting Hallmark Christmas ornaments (especially with mice)\r\n\r\nSpecial Likes: country crafts, decorations, bookmarks, Noah’s ark, and mice, snowmen, Santas, books'); INSERT INTO members VALUES (18,'Diane','','Brock','Post Office Box 667','','La Fayette','GA','30728','7066383939','','4233044365','deebee320@aol.com','0000-03-20','1979-12-09','Denny','3','Favorite colors: red, black, blue\r\n\r\nFavorite flowers: red roses, daisies\r\n\r\nBath colors: blue, white, rose\r\n\r\nKitchen colors: blue and yellow\r\n\r\nPerfume: Chanel No. 5\r\n\r\nLingerie: small, cotton, not frilly\r\n\r\nJewelry: gold, pierced, yellow gold\r\n\r\nHobbies: classical piano, reading, gardening, eating out\r\n\r\nSpecial likes: collecting Christmas ornaments, Godiva chocolates\r\n\r\nWish List: Anything, I love GA Bulldogs and dark, dark chocolate, small delicate Christmas ornaments.'); INSERT INTO members VALUES (24,'Wanda','','Chapman','6817 Chiswick Drive','','Chattanooga','TN','37421','4232960429','7066385203','4234002931','wanda6868@comcast.net','0000-04-09','0000-06-08','Byron','3','Favorite colors: red\r\n\r\nKitchen Colors: burgundy, neutral\r\n\r\nFavorite flowers: tulips\r\n\r\nBath colors: moss green, neutral\r\n\r\nPerfume: Ralph Lauren Romance\r\n\r\nLingerie: Medium PJ\'s, cotton panties - 7\r\n\r\nJewelry: silver (pierced ears)\r\n\r\nHobbies: Golf, eating, audio books\r\n\r\nSpecial likes: Bike riding, golf, any sports\r\n\r\nWish List: Candles, sweat and t-shirts, white chocolate (no dark chocolate), socks, silver earrings (pierced), audio books, napking rings, water pictures, gift certificates, Bath & Body Works\r\n\r\nFavorite Wine: White Zin\r\n\r\nFavorite Sports Team: Vols, Yellow Jackets'); INSERT INTO members VALUES (25,'Ellen','','Jackson','480 North Ridge Drive','','La Fayette','GA','30728','7066382981','','4239026828','KFEGJAX@aol.com','0000-06-03','0000-01-11','Kenneth','1','Favorite colors: pinks, reds, black\r\n\r\nKitchen Colors: yellow, green, beige, cranberry\r\n\r\nFavorite flowers: outdoor hanging -impatiens, geraniums\r\n\r\nBath colors: neutrals\r\n\r\nPerfume: Armige/Coco Chanel, Ysatis\r\n\r\nLingerie: VS cotton panties - medium 34, shorty gown\r\n\r\nJewelry: yellow gold, pierced, or silver\r\n\r\nHobbies: Piano, reading, lake life \r\n\r\nSpecial likes: Food\r\n\r\nWish List: belt, Bath & Body, purse, earrings, bracelet, anything, cotton short pj (gown)\r\n\r\nShoe Size: 8\r\n\r\nFavorite Wine: Chardonnay & Merlot, Kendall Jackson, Yellow Tail\r\n\r\nFavorite Sports Team: Auburn'); INSERT INTO members VALUES (26,'Terri','','Morrison','902 Anthony Street','','La Fayette','GA','30728','7066382890','7066381020','4234130433','info@flexabed.com','0000-07-11','0000-06-10','Max','2','Favorite colors: greens, yellows, reds, gold\r\n\r\nKitchen Colors: moss green, cream\r\n\r\nFavorite flowers: spring bouquet or yellow roses \r\n\r\nBath colors: metallic gold, bronzey, taupe, clay & cream\r\n\r\nLingerie: Small, short cotton gown, panties, french cut, 6\r\n\r\nJewelry: Pearls, yellow gold and silver (pierced) and pins\r\n\r\nHobbies: Walking, shopping, traveling, eating out \r\n\r\nSpecial likes: Spending time with children\r\n\r\nWish List: Pfaltzgraff Christmas dishes, chocolate, purses, belts, jewelry, longer scarves\r\n\r\nFavorite Wine: Chardonnay, White Zin'); INSERT INTO members VALUES (29,'Donna','','Clements','325 Tennant Circle','','Chickamauga','GA','30707','7063758299','','4236058179','donnaclements@walkerschools.org','0000-08-08','1981-05-30','Pat','2','Favorite color: pink\r\nFavorite flower: daisy\r\nBath colors: beige and golds\r\nKitchen colors: gold, brown, beige\r\nPerfume: Tresor\r\nLingerie: night shirts, cotton pajamas\r\nJewelry: gold, silver (pierced)\r\nHobbies: camping, antiques, reading, movies\r\nSpecial Likes: books, china plates, toiletries, picture frames, candles\r\nFavorite wine: white zinfindel\r\nWish List: I love anything.'); INSERT INTO members VALUES (28,'Mary Jane','','Carlock','P.O. Box 779','2260 Peavine Road','Rock Spring','GA','30739','7063756680','','','fmjcarlock@aol.com','0000-08-31','0000-12-31','Frank','1','Favorite Color(s): Pretty much anything\r\n\r\nKitchen Colors: Pretty much anything\r\n\r\nBath Colors: Pretty much anything\r\n\r\nPerfume: Design\r\n\r\nLingerie: T-shirts (big)\r\n\r\nJewelry: Gold - pierced\r\n\r\nFavorite Flower: Any\r\n\r\nHobbies: Not really any\r\n\r\nSpecial Likes: Everything\r\n\r\nWish List: Candles - any kind\r\n\r\nShoe Size: 7-1/2 - 8');