CREATE TABLE `er1admin` ( `adm_id` int(11) NOT NULL AUTO_INCREMENT, `adm_title1` varchar(100) NOT NULL, `adm_title2` varchar(100) NOT NULL, `adm_introtext1` varchar(4096) NOT NULL, `adm_introtext2` varchar(4096) NOT NULL, `adm_endtext1` varchar(4096) NOT NULL, `adm_chair1_name` varchar(100) NOT NULL, `adm_chair1_email` varchar(100) NOT NULL, `adm_chair1_phone` varchar(20) NOT NULL, `adm_chair1_emailcc` char(1) NOT NULL, `adm_chair2_name` varchar(100) NOT NULL, `adm_chair2_email` varchar(100) NOT NULL, `adm_chair2_phone` varchar(20) NOT NULL, `adm_chair2_emailcc` char(1) NOT NULL, `adm_link_name` varchar(100) NOT NULL, `adm_link_url` varchar(150) NOT NULL, `adm_volneeded_msg` char(1) NOT NULL, `adm_keycode_support` char(1) NOT NULL, `adm_signup_open` date NOT NULL, `adm_signup_close` date NOT NULL, PRIMARY KEY (`adm_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; INSERT INTO er1admin VALUES("2","Test Workshop Registration System","","","","","Mark Darholt","darholt@madhome.net","512-331-6288","Y","Laura Hillsboro","md01@madhome.net","512-331-6288","N","MADHome Main Page","http://www.madhome.net","","","1999-11-30","1999-11-30"); CREATE TABLE `er1attendee` ( `era_id` int(11) NOT NULL AUTO_INCREMENT, `era_name` varchar(100) NOT NULL, `era_addr1` varchar(100) NOT NULL, `era_addr2` varchar(100) NOT NULL, `era_addr3` varchar(100) NOT NULL, `era_phone` varchar(20) NOT NULL, `era_email` varchar(100) NOT NULL, `era_eventid` int(11) NOT NULL, `era_eventname` varchar(100) NOT NULL, `era_eventdate` date NOT NULL, `era_eventtime` varchar(40) NOT NULL, `era_eventprice` int(11) NOT NULL, `era_pricepaid` int(11) NOT NULL, `era_waitlisted` char(1) NOT NULL, `era_comments` varchar(4096) NOT NULL, `era_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`era_id`) ) ENGINE=MyISAM AUTO_INCREMENT=200 DEFAULT CHARSET=latin1; INSERT INTO er1attendee VALUES("199","Jimmy Johnson","100 Main Street","Apt #5","Disney Land, FL 08345","212-934-7629","darholt@madhome.net","57","Workshop with Lenore Crawford - Create a Flower from Your Own Photo","2012-06-06","10 AM and go to 3:30 PM","30","30","","","2011-09-23 20:01:58"); CREATE TABLE `er1event` ( `ere_id` int(11) NOT NULL AUTO_INCREMENT, `ere_sortorder` int(11) NOT NULL, `ere_name` varchar(100) NOT NULL, `ere_maxallowed` int(11) NOT NULL, `ere_maxwaitlisted` int(11) NOT NULL, `ere_desc` varchar(4096) NOT NULL, `ere_date` date NOT NULL, `ere_time` varchar(40) NOT NULL, `ere_price` int(11) NOT NULL, `ere_earlybird_date` date NOT NULL, `ere_earlybird_price` int(11) NOT NULL, `ere_introtext1` varchar(4096) NOT NULL, `ere_introtext2` varchar(4096) NOT NULL, `ere_endtext1` varchar(4096) NOT NULL, `ere_makepaymentto` varchar(100) NOT NULL, `ere_payment_cc` char(1) NOT NULL, `ere_payment_check` char(1) NOT NULL, `ere_chairname` varchar(100) NOT NULL, `ere_chairaddr1` varchar(100) NOT NULL, `ere_chairaddr2` varchar(100) NOT NULL, `ere_chairaddr3` varchar(100) NOT NULL, `ere_chairphone` varchar(20) NOT NULL, `ere_chairemail` varchar(100) NOT NULL, `ere_link_name` varchar(150) NOT NULL, `ere_link_url` varchar(150) NOT NULL, `ere_signup_open` date NOT NULL, `ere_signup_close` date NOT NULL, PRIMARY KEY (`ere_id`) ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1; INSERT INTO er1event VALUES("54","1","Workshop with Karen K. Stone - Indian Orange Peel","15","5","Workshop with Karen K. Stone - Indian Orange Peel - Karen is an award winning quiltmaker and inspiring teacher know world wide. Her popular quilts have been exhibited nationally for the past decade. Her Indian Orange Peel won the People’s Choice Award at Quilt National in 1995.","2012-01-04","10 AM and go to 3:30 PM","35","2011-12-15","30","2012 Workshops - All workshops begin at 10 AM and go to 3:30 PM. You may arrive at 9:30 AM to get set up. We start clean up at 3:30 PM and must be out of the room at 4 PM sharp. If you wish to eat lunch at the workshop, it can be ordered through the Library Cafe or you can leave for lunch. We are not allowed to bring food from outside sources into the Library.","All Workshops MUST be paid for when you sign up. Some workshops may require an additional kit fee and will be noted in the description.","If you need to cancel and we haven\\\'t met our break-even point (depends on cost of speaker) on the workshop, you won\\\'t receive a refund. If the workshop is sold out and we can fill your position from a waiting list, we will refund your money. No-shows receive no refund.
Workshop contact is Gail DuJardin, 512-246-1007.","CTQG","Y","Y","Gail DuJardin","3944 Lord Byron Cir","","Round Rock, Texas 78664","512-246-1007","darholt@madhome.net","","","2011-09-01","2012-01-04"); INSERT INTO er1event VALUES("55","2","Two Day Workshop with Patti Hempen - Kaleidoscope Flowers","15","5","","2012-03-07","10 AM and go to 3:30 PM","35","2012-02-15","30","2012 Workshops - All workshops begin at 10 AM and go to 3:30 PM. You may arrive at 9:30 AM to get set up. We start clean up at 3:30 PM and must be out of the room at 4 PM sharp. If you wish to eat lunch at the workshop, it can be ordered through the Library Cafe or you can leave for lunch. We are not allowed to bring food from outside sources into the Library.","All Workshops MUST be paid for when you sign up. Some workshops may require an additional kit fee and will be noted in the description.","If you need to cancel and we haven\\\'t met our break-even point (depends on cost of speaker) on the workshop, you won\\\'t receive a refund. If the workshop is sold out and we can fill your position from a waiting list, we will refund your money. No-shows receive no refund.
Workshop contact is Gail DuJardin, 512-246-1007.","CTQG","Y","Y","Gail DuJardin","3944 Lord Byron Cir","","Round Rock, Texas 78664","512-246-1007","darholt@madhome.net","","","2011-09-01","2012-03-07"); INSERT INTO er1event VALUES("56","3","Workshop with Sara Miller-Moe - Winding Curves Workshop","15","5","Winding Curves Workshop: This workshop uses the Sew Inspired Design System™ Winding Curves Template, a fun “out of the box” template that creates a unique art quilt. The picture below shows the quilt that will be made in this workshop. Students will be taught Sara’s unique foolproof EZ curved piecing techniques so that even beginning quilters can sew perfect curved quilt blocks. Students will make the blocks for the Winding Curves quilt top and learning how to put them together to create a unique art quilt. Quilt design, and composition will be taught as well as tips and tricks for sewing curved pieced blocks. Sara will show the many different layout options to create original designs. This is a 6 hour hands-on class and students will be provided templates to use in the workshop and for purchase after the class.
http://www.sewinspired.com/","2012-05-02","10 AM and go to 3:30 PM","35","2012-04-15","30","2012 Workshops - All workshops begin at 10 AM and go to 3:30 PM. You may arrive at 9:30 AM to get set up. We start clean up at 3:30 PM and must be out of the room at 4 PM sharp. If you wish to eat lunch at the workshop, it can be ordered through the Library Cafe or you can leave for lunch. We are not allowed to bring food from outside sources into the Library.","All Workshops MUST be paid for when you sign up. Some workshops may require an additional kit fee and will be noted in the description.","If you need to cancel and we haven\\\'t met our break-even point (depends on cost of speaker) on the workshop, you won\\\'t receive a refund. If the workshop is sold out and we can fill your position from a waiting list, we will refund your money. No-shows receive no refund.
Workshop contact is Gail DuJardin, 512-246-1007.","CTQG","Y","Y","Gail DuJardin","3944 Lord Byron Cir","","Round Rock, Texas 78664","512-246-1007","darholt@madhome.net","","","2011-09-01","2012-05-02"); INSERT INTO er1event VALUES("57","4","Workshop with Lenore Crawford - Create a Flower from Your Own Photo","15","5","In this workshop students will learn how to make their own pattern from a photo and create a fused detailed flower, a smaller project than the other classes. You will work from your 11\\\" X 17” photo or Lenore’s making a freezer paper pattern and then using Lenore’s simple fusing technique design your flower from your own fabrics. She will show you how to choose your fabrics, add detail to your flower using your photo as a reference and fabric paint, and finish your art quilt with her simple binding technique. By creating this small piece students will have a simple basic technique they will be able to use to create their own art quilt masterpieces like Lenore does. $10 supplies fee required. Print out your own photo by following Lenore\\\'s instructions at the bottom of the supplies list. Click Here for Supply List
http://www.lenorecrawford.com/","2012-06-06","10 AM and go to 3:30 PM","35","2012-05-15","30","2012 Workshops - All workshops begin at 10 AM and go to 3:30 PM. You may arrive at 9:30 AM to get set up. We start clean up at 3:30 PM and must be out of the room at 4 PM sharp. If you wish to eat lunch at the workshop, it can be ordered through the Library Cafe or you can leave for lunch. We are not allowed to bring food from outside sources into the Library.","All Workshops MUST be paid for when you sign up. Some workshops may require an additional kit fee and will be noted in the description.","If you need to cancel and we haven\\\'t met our break-even point (depends on cost of speaker) on the workshop, you won\\\'t receive a refund. If the workshop is sold out and we can fill your position from a waiting list, we will refund your money. No-shows receive no refund.
Workshop contact is Gail DuJardin, 512-246-1007.","CTQG","Y","Y","Gail DuJardin","3944 Lord Byron Cir","","Round Rock, Texas 78664","512-246-1007","darholt@madhome.net","","","2011-09-01","2012-06-06");