#
# Table structure for table `estline`
#

CREATE TABLE `estline` (
  `lineid` smallint(6) NOT NULL default '0',
  `groupid` smallint(6) NOT NULL default '0',
  `linename` varchar(30) NOT NULL default '',
  `sequencenum` smallint(6) NOT NULL default '0',
  `linetype` char(2) NOT NULL default '',
  `linetext` text NOT NULL,
  `linecost` decimal(7,2) NOT NULL default '0.00',
  `depline` smallint(6) NOT NULL default '0',
  `depoption` smallint(6) NOT NULL default '0',
  `imagename` varchar(20) NOT NULL default '',
  `helpid` smallint(6) NOT NULL default '0',
  `deperrmsg` varchar(100) NOT NULL default '',
  `product` char(1) NOT NULL default '',
  `helptitle` varchar(100) NOT NULL default '',
  `helptext` text NOT NULL,
  `refquantitylineid` smallint(6) NOT NULL default '0',
  `refcostlineid` smallint(6) NOT NULL default '0',
  `lookuplineid1` smallint(6) NOT NULL default '0',
  `lookuplineid2` smallint(6) NOT NULL default '0',
  `imagelineid` smallint(6) NOT NULL default '0',
  `hidesum` char(1) NOT NULL default '',
  `displine` char(1) NOT NULL default '',
  `textcd` char(1) NOT NULL default '',
  `imagetexttemplate` varchar(20) NOT NULL default 'eeimagetext.tpl',
  `selecttemplate` varchar(20) NOT NULL default '',
  `selectsize` tinyint(4) NOT NULL default '0',
  `maxselectsize` tinyint(4) NOT NULL default '0',
  `maxselecterrmsgid` smallint(6) NOT NULL default '0',
  `minselectsize` tinyint(4) NOT NULL default '0',
  `minselecterrmsgid` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`lineid`,`groupid`),
  KEY `seqinx` (`groupid`,`sequencenum`)
) TYPE=MyISAM;

#
# Dumping data for table `estline`
#

INSERT INTO `estline` VALUES (3, 1, 'Base Cost', 150, 'C1', 'Basic  Event Minimum with 1 camera', '700.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (30, 18, 'web design discount', 1075, 'D1', 'Referral discount for Web Design', '0.00', 29, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (29, 18, 'web design sub total', 1050, 'B3', 'Web Design Sub-total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (28, 18, 'video selector desc', 950, 'T1', 'Video Selector is an advanced application for  managing Web video', '0.00', 0, 0, '', 0, '', 's', 'Video Selector', 'Video Selector assists with simplifying the choices presented when multiple video formats or multiple videos can be chosen.', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (22, 18, 'Video', 1000, 'S5', 'Add Video Selector', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (23, 18, 'blue1', 1100, 'I1', '', '0.00', 0, 0, 'blue', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (24, 18, 'hosting', 1300, 'S5', 'Web Hosting', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (25, 18, 'web host desc', 1200, 'T1', 'Web Hosting includes initial setup and monitoring', '0.00', 0, 0, '', 0, '', 's', 'Web Hosting', 'Web hosting includes initial setup of the web site, setting-up of email accounts, and error monitoring.  Unusual web sites with very high volume may cost more.', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (26, 18, 'reg', 1400, 'S5', 'Web Site Registration', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (14, 18, 'total', 1800, 'G1', 'Grand Total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (35, 18, 'Shipping', 1496, 'S5', 'Shipping Method', '0.00', 34, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (11, 18, 'California Sales Tax', 1600, 'F1', 'Sales Tax', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (12, 18, 'Taxable Sub-total', 1500, 'B1', 'Taxable sub-total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (15, 18, 'logo', 300, 'S5', 'Custom Logo', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (16, 18, 'add graphics', 400, 'C3', 'Additional graphics $20/each', '20.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (17, 18, 'Text desc', 500, 'T1', 'Text in electronic format no additional charge', '0.00', 0, 0, '', 0, '', 's', 'Text', 'Text provided in electronic format is at no additional charge.  Text submitted using paper or fax is $10 per page.', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (18, 18, 'text cost', 600, 'C3', 'Text supplied using paper $10/page', '10.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (19, 18, 'chat room', 700, 'S5', 'Chat Room', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (20, 18, 'forum', 800, 'S5', 'Discussion Board/Forum', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (21, 18, 'Photo slide show', 900, 'S5', 'Photo Slide show', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (14, 17, 'total', 850, 'G1', 'Grand Total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (19, 17, 'Additional text and titles', 375, 'C3', 'Additional text and titles $5 each after beginning and ending titles', '5.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (2, 18, 'Heading', 100, 'H1', 'Web Site Design Service Estimates', '0.00', 0, 0, '', 0, '', 's', 'Web Site Design Service Estimate', 'This is intended to assist you with understanding the options and their costs for creating, maintaining, and promoting a web site. ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (3, 18, 'Base Cost', 200, 'C1', 'Basic Web site with 10 to 20 pages', '300.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (11, 17, 'California Sales Tax', 650, 'F1', 'Sales Tax', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (13, 17, 'referral discount', 750, 'D3', 'Discounts', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (12, 17, 'Taxable Sub-total', 600, 'B1', 'Taxable sub-total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (10, 17, 'VHS', 550, 'S3', 'VHS Tapes', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (8, 17, 'DVDs', 450, 'C3', 'DVDs requested', '20.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (9, 17, 'DVD desc', 400, 'T1', 'DVDs come with custom labels and DVD case designs, must be ordered separately', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (16, 17, 'add video', 300, 'C3', 'Add video clips at $5 per minute', '5.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (17, 17, 'add music', 350, 'C3', 'Custom music supplied by Sizzling Video $8/song', '8.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (18, 17, 'add music desc', 325, 'T1', 'Music you supply or suppied by Sizzling Video', '0.00', 0, 0, '', 0, '', 's', 'Music Options', 'Mackground music can be supplied by you on original CDs and will be returned to you at no charge.  Custom music supplied by Sizzling Video International is $8 per song and the music selection is at the discretion of Sizzling Video International.', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (15, 17, 'addl photos', 200, 'S1', 'Additional Photos,  1-10 at $1 each,  after that $0.80 each', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (27, 18, 'blue2', 1350, 'I1', '', '0.00', 0, 0, 'blue', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (3, 17, 'Base Cost', 150, 'C1', 'Basic Photo Montage with up to 30 photos', '200.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (2, 17, 'Heading', 50, 'H1', 'Photo Montage Service Estimate', '0.00', 0, 0, '', 0, '', 's', 'Photo Montage', 'Photo montages are very popular to bring old photos to life.  Photos are artistically combined with text and music to tell a person\\\'s or couple\\\'s story.  These are great for anniversaries and important birthdays. ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (14, 16, 'total', 850, 'G1', 'Grand Total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (13, 16, 'referral discount', 750, 'D3', 'Discounts', '0.00', 10, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (11, 16, 'California Sales Tax', 650, 'F1', 'Sales Tax', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (10, 16, 'VHS', 550, 'S3', 'VHS Tapes', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (12, 16, 'Taxable Sub-total', 600, 'B1', 'Taxable sub-total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (2, 1, 'Heading', 50, 'H1', 'Wedding and Event Video Services Estimates', '0.00', 0, 0, '', 0, '', 's', 'Wedding and Event Services', 'This is intended to assist you with understanding the options and their costs for wedding and other event video services. ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (4, 1, 'additional camera', 250, 'S5', 'Additional Cameras', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (5, 1, 'add camera heading', 200, 'T1', 'Additional cameras add to capturing the entire wedding', '0.00', 0, 0, '', 0, '', 's', 'Additional Cameras', 'Additional cameras allow for multiple angles to captured insuring that the video is as good as it can be and nothing is messed.', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (6, 1, 'additional camera person', 350, 'S5', 'Additional Camera Person', '0.00', 4, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (7, 1, 'additional person desc', 300, 'T1', 'Additional camera person to video more', '0.00', 0, 0, '', 0, '', 's', 'Additional Camera Person', 'An additional camera person can see and capture more of your event on video, including additional interviews', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (8, 1, 'DVDs', 450, 'C3', 'DVDs requested', '20.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (9, 1, 'DVD desc', 400, 'T1', 'DVDs come with custom labels and DVD case designs, must be ordered separately', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (10, 1, 'VHS', 550, 'S3', 'VHS Tapes', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (11, 1, 'California Sales Tax', 650, 'F1', 'Sales Tax', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (12, 1, 'Taxable Sub-total', 600, 'B1', 'Taxable sub-total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (13, 1, 'referral discount', 750, 'D3', 'Discounts', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (14, 1, 'total', 850, 'G1', 'Grand Total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (9, 16, 'DVD desc', 400, 'T1', 'DVDs come with custom labels and DVD case designs, must be ordered separately', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (8, 16, 'DVDs', 450, 'C3', 'DVDs requested', '20.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, 'n', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (6, 16, 'additional camera person', 296, 'S5', 'Additional Camera Person', '0.00', 4, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (7, 16, 'additional person desc', 300, 'T1', 'Additional camera person to video more', '0.00', 0, 0, '', 0, '', 's', 'Additional Camera Person', 'An additional camera person can see and capture more of your event on video, including additional interviews', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (4, 16, 'additional camera', 224, 'S5', 'Additional Cameras', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (5, 16, 'add camera heading', 200, 'T1', 'Additional cameras add to capturing the entire wedding', '0.00', 0, 0, '', 0, '', 's', 'Additional Cameras', 'Additional cameras allow for multiple angles to captured insuring that the video is as good as it can be and nothing is messed.', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (3, 16, 'Base Cost', 150, 'C1', 'Basic  Event Minimum with 1 camera', '700.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (2, 16, 'Heading', 50, 'H1', 'Wedding and Event Video Services Estimates', '0.00', 0, 0, '', 0, '', 's', 'Wedding and Event Services', 'This is intended to assist you with understanding the options and their costs for wedding and other event video services. ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (32, 18, 'web promote', 1475, 'S5', 'Web Site Promotion', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (33, 18, 'blue again', 1487, 'I1', '', '0.00', 0, 0, 'blue', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (34, 18, 'cd', 1493, 'S5', 'Delivery method', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (2, 51, 'Heading', 100, 'H1', 'Custom T-shirts Estimates', '0.00', 0, 0, '', 0, '', 's', 'Custom T-shirts Estimates', 'This is intended to assist you with understanding the options and their costs for ordering custom T-shirts. ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (15, 51, 'T-shirt quality', 300, 'S5', 'T-shirt quality', '0.00', 0, 0, '', 0, '', 'c', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (3, 51, 'Base Cost', 200, 'C1', 'Basic T-shirt', '10.00', 0, 0, '', 0, '', 'c', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (26, 51, 'Order sub-total', 1300, 'C3', 'Order sub-total', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 21, 27, 0, 0, 0, 'n', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (22, 51, 'cost  for ink', 1100, 'L1', 'Cost for ink', '0.00', 0, 0, '', 0, '', 'c', '', ' ', -1, 0, 19, 21, 0, 'n', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (23, 51, 'T-shirt! quality', 800, 'S5', 'T-shirt quality', '0.00', 0, 0, '', 0, '', 'c', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (28, 51, 'Discount', 1650, 'D3', 'Referral Discount', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (27, 51, 'cost per shirt', 1200, 'B7', 'Cost per T-shirt', '0.00', 23, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (36, 18, 'blues', 1437, 'I1', '', '0.00', 0, 0, 'blue', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (21, 51, 'Quantity Ordered', 1000, 'L5', 'Quantity Ordered', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (20, 51, 'Cost for all T-shirts', 600, 'C3', 'Quantity of  T-shirts', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 0, 17, 0, 0, 0, 'n', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (32, 51, 'cap select', 1546, 'L3', 'Cap Selection', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 29, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (33, 51, 'cap tot', 1624, 'L1', 'Caps Total Cost', '0.00', 0, 0, '', 0, '', 'p', '', ' ', 34, 0, 32, 34, 0, 'n', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (34, 51, 'cap quantity', 1593, 'L5', 'Quantity Ordered', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (36, 51, 'Line36', 1400, 'I1', '', '0.00', 0, 0, 'blue', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (35, 51, 'minorder', 1569, 'T1', 'A minimum of 5 caps are required per order', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'n', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (29, 51, 'cap images', 1500, 'I1', '', '0.00', 0, 0, 'black cap', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (14, 51, 'total', 1900, 'G1', 'Grand Total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (11, 51, 'California Sales Tax', 1800, 'F1', 'Sales Tax', '0.00', 26, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (12, 51, 'Taxable Sub-total', 1700, 'B1', 'Taxable sub-total', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (16, 51, 'Inks', 400, 'S1', 'Number of inks used', '0.00', 0, 0, '', 0, '', 'c', '', ' ', 0, 0, 0, 0, 0, 'n', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (17, 51, 'Per T-shirt cost', 500, 'B7', 'Per T-shirt cost', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (18, 51, 'separator', 700, 'I1', '', '0.00', 0, 0, 'blue', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);
INSERT INTO `estline` VALUES (19, 51, 'Number of inks', 900, 'L3', 'Number of inks', '0.00', 0, 0, '', 0, '', 's', '', ' ', 0, 0, 0, 0, 0, '', 'a', 'l', 'eeimagetext.tpl', '', 0, 0, 0, 0, 0);

# --------------------------------------------------------

#
# Table structure for table `groupstyle`
#

CREATE TABLE `groupstyle` (
  `groupid` smallint(6) NOT NULL default '0',
  `linetype` char(2) NOT NULL default '',
  `textstyle` varchar(70) NOT NULL default '',
  `inputstyle` varchar(70) NOT NULL default '',
  PRIMARY KEY  (`groupid`,`linetype`)
) TYPE=MyISAM;

#
# Dumping data for table `groupstyle`
#

INSERT INTO `groupstyle` VALUES (0, 'C1', '', '');
INSERT INTO `groupstyle` VALUES (0, 'D4', '', '');
INSERT INTO `groupstyle` VALUES (0, 'D3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'T3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I7', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I8', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I6', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S5', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S6', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S7', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S1', '', '');
INSERT INTO `groupstyle` VALUES (18, 'S8', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I5', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I1', '', '');
INSERT INTO `groupstyle` VALUES (18, 'H4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'H3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'H2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'H1', 'font-size:20px; font-weight:bold;', '');
INSERT INTO `groupstyle` VALUES (18, 'G4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'G3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'G2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'G1', 'font-weight:bold; font-size:20px;', '');
INSERT INTO `groupstyle` VALUES (18, 'F4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'F3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'F2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'F1', '', '');
INSERT INTO `groupstyle` VALUES (18, 'D4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'D3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'D2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'D1', '', '');
INSERT INTO `groupstyle` VALUES (18, 'C4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'C3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'C2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'C1', '', '');
INSERT INTO `groupstyle` VALUES (18, 'B4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'B3', '', '');
INSERT INTO `groupstyle` VALUES (18, 'B2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'B1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'C1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'C2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S5', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S6', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S7', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S8', '', '');
INSERT INTO `groupstyle` VALUES (17, 'D1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'D2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'D3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'D4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S4', '', '');
INSERT INTO `groupstyle` VALUES (18, 'T2', '', '');
INSERT INTO `groupstyle` VALUES (18, 'I9', '', '');
INSERT INTO `groupstyle` VALUES (18, 'T1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'B3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'B2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'B1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'C4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'C3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I9', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I8', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I7', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I6', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I5', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'I1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'H4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'H3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'H2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'H1', 'font-size:20px; font-weight:bold;', '');
INSERT INTO `groupstyle` VALUES (17, 'B4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'F1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'F2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'F3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'F4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'T1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'T2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'T3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'T4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'G1', 'font-weight:bold; font-size:20px;', '');
INSERT INTO `groupstyle` VALUES (17, 'G2', '', '');
INSERT INTO `groupstyle` VALUES (17, 'G3', '', '');
INSERT INTO `groupstyle` VALUES (17, 'G4', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S1', '', '');
INSERT INTO `groupstyle` VALUES (17, 'S2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S1', '', '');
INSERT INTO `groupstyle` VALUES (16, 'G4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'G3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'G2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'C1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'C2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S5', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S6', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S7', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S8', '', '');
INSERT INTO `groupstyle` VALUES (1, 'D1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'D2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'D3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'D4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'H1', 'font-size:20px; font-weight:bold;', '');
INSERT INTO `groupstyle` VALUES (1, 'H2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'H3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'H4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I5', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I6', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I7', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I8', '', '');
INSERT INTO `groupstyle` VALUES (1, 'I9', '', '');
INSERT INTO `groupstyle` VALUES (1, 'C3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'C4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'B1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'B2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'B3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'B4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'F1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'F2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'F3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'F4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'T1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'T2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'T3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'T4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'G1', 'font-weight:bold; font-size:20px;', '');
INSERT INTO `groupstyle` VALUES (1, 'G2', '', '');
INSERT INTO `groupstyle` VALUES (1, 'G3', '', '');
INSERT INTO `groupstyle` VALUES (1, 'G4', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S1', '', '');
INSERT INTO `groupstyle` VALUES (1, 'S2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'G1', 'font-weight:bold; font-size:20px;', '');
INSERT INTO `groupstyle` VALUES (16, 'T4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'T3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'T2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'T1', '', '');
INSERT INTO `groupstyle` VALUES (16, 'F4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'F3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'F2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'F1', '', '');
INSERT INTO `groupstyle` VALUES (16, 'B4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'B3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'B2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'B1', '', '');
INSERT INTO `groupstyle` VALUES (16, 'C4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'C3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I9', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I8', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I7', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I6', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I5', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'I1', '', '');
INSERT INTO `groupstyle` VALUES (16, 'H4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'H3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'H2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'H1', 'font-size:20px; font-weight:bold;', '');
INSERT INTO `groupstyle` VALUES (16, 'S4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'D4', '', '');
INSERT INTO `groupstyle` VALUES (16, 'D3', '', '');
INSERT INTO `groupstyle` VALUES (16, 'D2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'D1', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S8', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S7', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S6', '', '');
INSERT INTO `groupstyle` VALUES (16, 'S5', '', '');
INSERT INTO `groupstyle` VALUES (16, 'C2', '', '');
INSERT INTO `groupstyle` VALUES (16, 'C1', '', '');
INSERT INTO `groupstyle` VALUES (18, 'T4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'C1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'B4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'B3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'B2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'B1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S6', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S7', '', '');
INSERT INTO `groupstyle` VALUES (1, 'B6', '', '');
INSERT INTO `groupstyle` VALUES (1, 'B5', '', '');
INSERT INTO `groupstyle` VALUES (16, 'B5', '', '');
INSERT INTO `groupstyle` VALUES (1, '', '', '');
INSERT INTO `groupstyle` VALUES (51, 'T1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S8', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S5', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'S1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I9', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I8', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I7', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I6', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I5', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'I2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'H4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'H3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'H2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'H1', 'font-size:20px; font-weight:bold;', '');
INSERT INTO `groupstyle` VALUES (51, 'G4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'G3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'G2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'G1', 'font-weight:bold; font-size:20px;', '');
INSERT INTO `groupstyle` VALUES (51, 'F4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'F3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'F2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'F1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'D4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'D3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'D2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'D1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'C4', '', '');
INSERT INTO `groupstyle` VALUES (51, 'C3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'C2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'T3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'T2', '', '');
INSERT INTO `groupstyle` VALUES (51, 'L1', '', '');
INSERT INTO `groupstyle` VALUES (51, 'L5', '', '');
INSERT INTO `groupstyle` VALUES (51, 'L3', '', '');
INSERT INTO `groupstyle` VALUES (51, 'B7', '', '');
INSERT INTO `groupstyle` VALUES (51, 'T4', '', '');

# --------------------------------------------------------

#
# Table structure for table `image`
#

CREATE TABLE `image` (
  `imagename` varchar(20) NOT NULL default '',
  `imagesrc` varchar(30) NOT NULL default '',
  `imagechar` varchar(40) NOT NULL default '',
  `imageext` varchar(4) NOT NULL default '',
  `syscode` char(1) NOT NULL default '',
  `imagetext` text NOT NULL,
  PRIMARY KEY  (`imagename`)
) TYPE=MyISAM;

#
# Dumping data for table `image`
#

INSERT INTO `image` VALUES ('green', 'green', 'height="5" width="400"', '.gif', '', 'green');
INSERT INTO `image` VALUES ('blue', 'blue2', 'height="12" width="300"', '.gif', '', 'blue');
INSERT INTO `image` VALUES ('black cap', 'black cap', 'width="360" height="341"', '.jpg', '', 'some text');
INSERT INTO `image` VALUES ('tan cap', 'tan cap3', 'width="360" height="341"', '.jpg', '', 'more text');

# --------------------------------------------------------

#
# Table structure for table `lineoption`
#

CREATE TABLE `lineoption` (
  `groupid` smallint(6) NOT NULL default '0',
  `lineid` smallint(6) NOT NULL default '0',
  `optionid` smallint(6) NOT NULL default '0',
  `cost` decimal(7,2) NOT NULL default '0.00',
  `startrng` mediumint(9) NOT NULL default '0',
  `endrng` mediumint(9) NOT NULL default '0',
  `sequencenum` smallint(6) NOT NULL default '0',
  `optiondesc` varchar(80) NOT NULL default '',
  `imagename` varchar(20) NOT NULL default '',
  `picklineid` smallint(6) NOT NULL default '0',
  `msgid` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`groupid`,`lineid`,`optionid`)
) TYPE=MyISAM;

#
# Dumping data for table `lineoption`
#

INSERT INTO `lineoption` VALUES (18, 34, 2, '5.00', 0, 0, 2, ' CD', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 34, 1, '0.00', 0, 0, 1, ' Electronic Delivery', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 32, 4, '150.00', 0, 0, 4, 'Gold Package', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 32, 3, '100.00', 0, 0, 3, 'Silver Package', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 32, 2, '40.00', 0, 0, 2, 'Bronze Package', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 32, 1, '0.00', 0, 0, 1, ' None', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 30, 2, '10.00', 0, 0, 2, ' Referral Discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 30, 1, '0.00', 0, 0, 1, ' No discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 26, 2, '30.00', 0, 0, 2, ' $30/year', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 26, 1, '0.00', 0, 0, 1, ' No registration', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 24, 2, '240.00', 0, 0, 2, '$240/yr', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 24, 1, '0.00', 0, 0, 1, ' No hosting', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 22, 2, '30.00', 0, 0, 2, 'Video selector', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 21, 2, '30.00', 0, 0, 2, ' Slide show', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 21, 1, '0.00', 0, 0, 1, ' No slide show', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 20, 2, '40.00', 0, 0, 2, ' Forum', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 20, 1, '0.00', 0, 0, 1, ' No Forum', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 35, 1, '7.00', 0, 0, 1, ' Ground Delivery', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 35, 2, '10.00', 0, 0, 2, '2nd Day Air', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 35, 3, '15.00', 0, 0, 3, 'Overnight', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 11, 2, '0.00', 0, 0, 2, ' Not Calif. Resident', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 11, 1, '8.25', 0, 0, 1, ' Calif. Residents', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 15, 1, '0.00', 0, 0, 1, ' Logo will be supplied', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 15, 2, '0.80', 11, 999, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 15, 1, '1.00', 1, 10, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 13, 2, '20.00', 0, 0, 2, 'Referral Discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 13, 1, '0.00', 0, 0, 1, ' No discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 11, 2, '0.00', 0, 0, 2, ' Not Calif. Resident', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 11, 1, '8.25', 0, 0, 1, ' Calif. Residents', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 10, 2, '10.00', 2, 9999, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (17, 10, 1, '15.00', 1, 1, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 19, 3, '20.00', 0, 0, 3, ' Custom chat room', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 19, 2, '10.00', 0, 0, 2, ' Basic chat room', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 19, 1, '0.00', 0, 0, 1, ' No chat  room', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 15, 3, '75.00', 0, 0, 3, 'Create new logo', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 15, 2, '25.00', 0, 0, 2, 'Draft of logo supplied', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 13, 2, '20.00', 0, 0, 2, 'Referral Discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 13, 1, '0.00', 0, 0, 1, ' No discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 11, 2, '0.00', 0, 0, 2, ' Not Calif. Resident', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 11, 1, '8.25', 0, 0, 1, ' Calif. Residents', '', 0, 0);
INSERT INTO `lineoption` VALUES (18, 22, 1, '0.00', 0, 0, 1, ' No video selector', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 4, 1, '0.00', 0, 0, 1, ' No extra cameras', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 4, 2, '200.00', 0, 0, 2, '1 extra camera', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 4, 3, '400.00', 0, 0, 3, '2 extra cameras', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 6, 1, '0.00', 0, 0, 1, ' No additional person', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 6, 2, '200.00', 0, 0, 2, '1 additional camera person', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 10, 1, '15.00', 1, 1, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 10, 2, '10.00', 2, 9999, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 11, 1, '8.25', 0, 0, 1, ' Calif. Residents', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 11, 2, '0.00', 0, 0, 2, ' Not Calif. Resident', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 13, 1, '0.00', 0, 0, 1, ' No discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (1, 13, 2, '20.00', 0, 0, 2, 'Referral Discount', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 10, 2, '0.00', 2, 9, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 10, 1, '15.00', 1, 1, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 6, 2, '200.00', 0, 0, 2, '1 additional camera person', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 6, 1, '0.00', 0, 0, 1, ' No additional person', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 4, 3, '400.00', 0, 0, 3, '2 extra cameras', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 4, 2, '200.00', 0, 0, 2, '1 extra camera', '', 0, 0);
INSERT INTO `lineoption` VALUES (16, 4, 1, '0.00', 0, 0, 1, ' No extra cameras', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 11, 2, '0.00', 0, 0, 2, ' Not Calif. Resident', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 11, 1, '8.25', 0, 0, 1, ' Calif. Residents', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 19, 3, '0.00', 0, 0, 3, ' 3 colors ink', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 21, 1, '0.00', 1, 10, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 21, 2, '0.00', 11, 49, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 21, 3, '0.00', 50, 9999, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 23, 1, '10.00', 0, 0, 1, ' Basic', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 23, 2, '12.00', 0, 0, 2, ' Better', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 23, 3, '15.00', 0, 0, 3, ' Best', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 28, 1, '0.00', 0, 0, 1, ' No Referral', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 15, 1, '0.00', 0, 0, 1, 'Regular', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 15, 2, '2.00', 0, 0, 2, 'Better', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 15, 3, '3.00', 0, 0, 3, 'Best', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 28, 2, '5.00', 0, 0, 2, ' Referral', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 16, 1, '0.20', 1, 3, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 16, 2, '0.18', 4, 9, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 16, 3, '0.16', 10, 9999, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 19, 1, '0.00', 0, 0, 1, ' 1 color ink', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 19, 2, '0.00', 0, 0, 2, ' 2 colors ink', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 32, 1, '0.00', 0, 0, 1, ' Black Cap', 'black cap', 0, 0);
INSERT INTO `lineoption` VALUES (51, 32, 2, '0.00', 0, 0, 2, 'Tan Cap', 'tan cap', 0, 0);
INSERT INTO `lineoption` VALUES (51, 34, 1, '0.00', 0, 0, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 34, 2, '0.00', 1, 4, 0, '', '', 0, 1);
INSERT INTO `lineoption` VALUES (51, 34, 3, '0.00', 6, 9999, 0, '', '', 0, 0);
INSERT INTO `lineoption` VALUES (51, 16, 4, '0.00', 0, 0, 0, '', '', 0, 0);

# --------------------------------------------------------

#
# Table structure for table `systemvars`
#

CREATE TABLE `systemvars` (
  `helpimgcnt` smallint(6) NOT NULL default '0',
  `userid` varchar(60) NOT NULL default '',
  `password` varchar(60) NOT NULL default '',
  `passtry` smallint(6) NOT NULL default '0'
) TYPE=MyISAM;

#
# Dumping data for table `systemvars`
#

INSERT INTO `systemvars` VALUES (8, '', '', 0);

# --------------------------------------------------------

#
# Table structure for table `tbcostlookup`
#

CREATE TABLE `tbcostlookup` (
  `groupid` smallint(6) NOT NULL default '0',
  `optionid` smallint(6) NOT NULL default '0',
  `sndoptionid` smallint(6) NOT NULL default '0',
  `cost` decimal(7,2) NOT NULL default '0.00',
  `lklineid` smallint(6) NOT NULL default '0',
  `imagename` varchar(20) NOT NULL default '',
  `msgid` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`groupid`,`optionid`,`sndoptionid`,`lklineid`)
) TYPE=MyISAM;

#
# Dumping data for table `tbcostlookup`
#

INSERT INTO `tbcostlookup` VALUES (46, 1, 1, '0.00', 5, '', 0);
INSERT INTO `tbcostlookup` VALUES (46, 2, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (46, 3, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (46, 4, 1, '0.00', 4, '', 0);
INSERT INTO `tbcostlookup` VALUES (46, 1, 1, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (46, 1, 2, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (46, 1, 3, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 1, 1, '0.00', 5, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 2, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 3, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 4, 1, '0.00', 4, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 1, 1, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 1, 2, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (47, 1, 3, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 1, 1, '0.00', 5, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 2, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 3, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 4, 1, '0.00', 4, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 1, 1, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 1, 2, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (48, 1, 3, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 1, 1, '0.00', 5, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 2, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 3, 1, '0.00', 3, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 4, 1, '0.00', 4, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 1, 1, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 1, 2, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (49, 1, 3, '0.00', 0, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 1, '5.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 1, '3.10', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 1, '3.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 4, 1, '4.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 1, '0.00', 39, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 2, '0.00', 39, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 3, '0.00', 39, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 2, '0.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 2, '6.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 2, '1.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 4, 2, '2.00', 40, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 1, '1.00', 43, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 2, '2.00', 43, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 1, '2.00', 43, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 2, '3.00', 43, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 1, '4.00', 43, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 2, '45.00', 43, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 1, '0.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 2, '0.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 1, '1.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 2, '200.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 1, '0.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 2, '0.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 4, 1, '0.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 4, 2, '0.00', 42, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 1, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 1, 2, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 1, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 2, 2, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 1, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 3, 2, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 4, 1, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (50, 4, 2, '0.00', 41, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 1, 1, '0.00', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 1, 2, '0.24', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 1, 3, '0.23', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 2, 1, '0.24', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 2, 2, '0.23', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 2, 3, '0.22', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 3, 1, '0.22', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 3, 2, '0.21', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 3, 3, '0.20', 22, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 1, 1, '0.00', 33, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 1, 2, '0.00', 33, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 1, 3, '10.00', 33, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 2, 1, '0.00', 33, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 2, 2, '0.00', 33, '', 0);
INSERT INTO `tbcostlookup` VALUES (51, 2, 3, '11.00', 33, '', 0);

# --------------------------------------------------------

#
# Table structure for table `tbestlog`
#

CREATE TABLE `tbestlog` (
  `referenceprefix` varchar(4) NOT NULL default '',
  `referencenum` int(11) NOT NULL default '0',
  `createdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `custname` varchar(80) NOT NULL default '',
  `custemail` varchar(50) NOT NULL default '',
  `custphone` varchar(20) NOT NULL default '',
  `esttotal` decimal(11,2) NOT NULL default '0.00',
  `esttable` mediumtext NOT NULL,
  `lastaction` varchar(10) NOT NULL default '',
  `infield1` mediumtext NOT NULL,
  `infield2` mediumtext NOT NULL,
  `infield3` mediumtext NOT NULL,
  `infield4` mediumtext NOT NULL,
  `infield5` mediumtext NOT NULL,
  `infield6` mediumtext NOT NULL,
  `previewpage` mediumtext NOT NULL,
  `plaintextemail` mediumtext NOT NULL,
  `uploadext` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`referenceprefix`,`referencenum`)
) TYPE=MyISAM;

#
# Dumping data for table `tbestlog`
#



# --------------------------------------------------------

#
# Table structure for table `tbestlogdet`
#

CREATE TABLE `tbestlogdet` (
  `referenceprefix` varchar(4) NOT NULL default '',
  `referencenum` int(11) NOT NULL default '0',
  `sequencenum` smallint(6) NOT NULL default '0',
  `linetext` text NOT NULL,
  `optiondesc` varchar(30) NOT NULL default '',
  `inputvalue` decimal(11,2) NOT NULL default '0.00',
  `totalvalue` decimal(11,2) NOT NULL default '0.00',
  PRIMARY KEY  (`referenceprefix`,`referencenum`,`sequencenum`)
) TYPE=MyISAM;

#
# Dumping data for table `tbestlogdet`
#


# --------------------------------------------------------

#
# Table structure for table `tbgroup`
#

CREATE TABLE `tbgroup` (
  `groupid` smallint(6) NOT NULL auto_increment,
  `groupname` varchar(30) NOT NULL default '',
  `textsize` smallint(6) NOT NULL default '0',
  `costformat` char(2) NOT NULL default '',
  `helpimg` smallint(6) NOT NULL default '0',
  `helpwinheight` decimal(3,0) NOT NULL default '0',
  `helpwinwidth` decimal(3,0) NOT NULL default '0',
  `createdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `titledisp` char(1) NOT NULL default '',
  `msgsubject` varchar(20) NOT NULL default '',
  `toemail` varchar(50) NOT NULL default '',
  `serveremailname` varchar(50) NOT NULL default '',
  `sendest` char(1) NOT NULL default 'y',
  `custmsg` text NOT NULL,
  `displaysize` smallint(6) NOT NULL default '7',
  `sendbuttontext` varchar(20) NOT NULL default 'Send',
  `sendbuttonimage` varchar(40) NOT NULL default '',
  `tranlogcode` char(1) NOT NULL default 'n',
  `referencenum` int(11) NOT NULL default '1000',
  `referenceprefix` varchar(4) NOT NULL default 'EEST',
  `paypalcode` char(1) NOT NULL default 'n',
  `paypalformname` varchar(15) NOT NULL default 'paypal',
  `paypaltotallineid` smallint(6) NOT NULL default '0',
  `contactques` text NOT NULL,
  `inetextlen` smallint(6) NOT NULL default '0',
  `innametext` varchar(40) NOT NULL default '',
  `innamelen` smallint(6) NOT NULL default '0',
  `innamereq` char(1) NOT NULL default '',
  `inemailtext` varchar(40) NOT NULL default '',
  `inemaillen` smallint(6) NOT NULL default '0',
  `inemailreq` char(1) NOT NULL default '',
  `inphonetext` varchar(40) NOT NULL default '',
  `inphonelen` smallint(6) NOT NULL default '0',
  `inphonereq` char(1) NOT NULL default '',
  `infield1text` varchar(40) NOT NULL default '',
  `infield1len` smallint(6) NOT NULL default '0',
  `infield1req` char(1) NOT NULL default '',
  `infield2text` varchar(40) NOT NULL default '',
  `infield2len` smallint(6) NOT NULL default '0',
  `infield2req` char(1) NOT NULL default '',
  `infield3text` varchar(40) NOT NULL default '',
  `infield3len` smallint(6) NOT NULL default '0',
  `infield3req` char(1) NOT NULL default '',
  `infield4text` varchar(40) NOT NULL default '',
  `infield4len` smallint(6) NOT NULL default '0',
  `infield4req` char(1) NOT NULL default '',
  `infield5text` varchar(40) NOT NULL default '',
  `infield5len` smallint(6) NOT NULL default '0',
  `infield5req` char(1) NOT NULL default '',
  `infield6text` varchar(40) NOT NULL default '',
  `infield6len` smallint(6) NOT NULL default '0',
  `infield6req` char(1) NOT NULL default '',
  `innamemin` smallint(6) NOT NULL default '0',
  `inemailmin` smallint(6) NOT NULL default '0',
  `inphonemin` smallint(6) NOT NULL default '0',
  `infield1min` smallint(6) NOT NULL default '0',
  `infield2min` smallint(6) NOT NULL default '0',
  `infield3min` smallint(6) NOT NULL default '0',
  `infield4min` smallint(6) NOT NULL default '0',
  `infield5min` smallint(6) NOT NULL default '0',
  `infield6min` smallint(6) NOT NULL default '0',
  `emailtemplate` varchar(20) NOT NULL default '',
  `okmsgtext` varchar(100) NOT NULL default '0',
  `printtext` varchar(20) NOT NULL default '',
  `emailphonereq` char(1) NOT NULL default '',
  `emailphonemsg` varchar(80) NOT NULL default '',
  `fieldreqmsg` varchar(80) NOT NULL default '',
  `fieldminmsg` varchar(80) NOT NULL default '',
  `emailmsg` varchar(80) NOT NULL default '',
  `formtemplate` varchar(20) NOT NULL default '',
  `sendbuttonnext` varchar(100) NOT NULL default '',
  `sendbuttonnextp` char(1) NOT NULL default '',
  `sendbutton2text` varchar(20) NOT NULL default '',
  `sendbutton2image` varchar(40) NOT NULL default '',
  `sendbutton2next` varchar(100) NOT NULL default '',
  `sendbutton2nextp` char(1) NOT NULL default '',
  `printbuttonimage` varchar(40) NOT NULL default '',
  `resetbuttontext` varchar(20) NOT NULL default '',
  `resetbuttonimage` varchar(40) NOT NULL default '',
  `savebuttontext` varchar(20) NOT NULL default '',
  `savebuttonimage` varchar(40) NOT NULL default '',
  `previewbuttontext` varchar(20) NOT NULL default '',
  `previewbuttonimage` varchar(40) NOT NULL default '',
  `previewtemplate` varchar(20) NOT NULL default '',
  `previewnext` varchar(20) NOT NULL default '',
  `sendbuttonemail` char(1) NOT NULL default '',
  `sendbutton2email` char(1) NOT NULL default '',
  `plaintextemail` varchar(20) NOT NULL default '',
  `callphp1` varchar(20) NOT NULL default '',
  `callphp2` varchar(20) NOT NULL default '',
  `bounceemail` varchar(50) NOT NULL default '',
  `checkboxtext` text NOT NULL,
  `uploadtext` text NOT NULL,
  `uploadfilesize` int(11) NOT NULL default '0',
  `uploaddirectory` varchar(200) NOT NULL default '',
  `uploadextensions` varchar(200) NOT NULL default '',
  `checkboxerrormsg` varchar(100) NOT NULL default '',
  `uploadexterrmsg` varchar(200) NOT NULL default '',
  `uploadsizeerrmsg` varchar(200) NOT NULL default '',
  `uploadreq` char(1) NOT NULL default '',
  PRIMARY KEY  (`groupid`),
  UNIQUE KEY `grname` (`groupname`),
  UNIQUE KEY `referenceprefix` (`referenceprefix`)
) TYPE=MyISAM AUTO_INCREMENT=67 ;

#
# Dumping data for table `tbgroup`
#

INSERT INTO `tbgroup` VALUES (1, 'default', 350, 'u2', 8, '200', '350', '0000-00-00 00:00:00', 'y', 'EasyEstimate Inquiry', 'easyestimate@sizzlingwebdesign.com', 'EasyEstimates@sizzlingwebdesign.com', 'y', 'Thanks for taking the time to sent in the estimate of services.  Someone will be contacting you shortly.  Sizzling  Web Design.', 7, 'Send', '', 's', 1000, 'EEYY', 'n', '', 3, 'If you would like to be contacted about this estimate, please enter your contact information below.', 35, 'Name', 80, 'y', 'Email', 50, '', 'Phone', 20, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', 4, 6, 7, 0, 0, 0, 0, 0, 0, 'eesample.tpl', 'Email sent', '', 'y', 'Email Address or Phone Number is required', '%fieldname% is required and has not been entered', '%fieldname% must be at least %fieldmin% characters long', 'Invalid Email Address', 'eecontact.tpl', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '');
INSERT INTO `tbgroup` VALUES (18, 'Web Site Design', 350, 'u2', 8, '200', '400', '2004-03-14 00:00:00', 'y', 'EasyEstimate Inquiry', 'EasyEstimates@sizzlingwebdesign.com', 'EasyEstimates@sizzlingwebdesign.com', 'y', 'Thanks for taking the time to sent in the estimate of services.  Someone will be contacting you shortly.  Sizzling  Web Design.', 7, 'Send', '', 's', 1000, 'EESS', 'n', '', 3, 'If you would like to be contacted about this estimate, please enter your contact information below.', 35, 'Name', 80, 'y', 'Email', 50, '', 'Phone', 20, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', 4, 6, 7, 0, 0, 0, 0, 0, 0, 'eesample.tpl', 'Email sent', '', 'y', 'Email Address or Phone Number is required', '%fieldname% is required and has not been entered', '%fieldname% must be at least %fieldmin% characters long', 'Invalid Email Address', 'eecontact.tpl', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '');
INSERT INTO `tbgroup` VALUES (17, 'Photo Montage', 350, 'u2', 5, '200', '400', '2004-03-14 00:00:00', 'y', 'EasyEstimate Inquiry', 'easyestimates@sizzlingwebdesign.com', 'EasyEstimates@sizzlingwebdesign.com', 'y', 'Thanks for taking the time to sent in the estimate of services.  Someone will be contacting you shortly.  Sizzling  Web Design.', 7, 'Send', '', 's', 1000, 'EEST', 'n', '', 3, 'If you would like to be contacted about this estimate, please enter your contact information below.', 35, 'Name', 80, 'y', 'Email', 50, '', 'Phone', 20, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', 4, 6, 7, 0, 0, 0, 0, 0, 0, 'eesample.tpl', 'Email sent', '', 'y', 'Email Address or Phone Number is required', '%fieldname% is required and has not been entered', '%fieldname% must be at least %fieldmin% characters long', 'Invalid Email Address', 'eecontact.tpl', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '');
INSERT INTO `tbgroup` VALUES (16, 'Wedding', 350, 'u2', 5, '200', '400', '2004-03-13 00:00:00', 'y', 'EasyEstimate Inquiry', 'easyestimates@sizzlingwebdesign.com', 'EasyEstimates@sizzlingwebdesign.com', 'y', 'Thanks for taking the time to send in this estimate.  Someone will be contacting you soon.  Sizzling Web Design.', 7, 'Send', '', 's', 1003, 'EETT', 'n', '', 3, 'If you would like to be contacted about this estimate, please enter your contact information below.', 35, 'Name', 80, 'y', 'Email', 50, '', 'Phone', 20, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', 4, 6, 7, 0, 0, 0, 0, 0, 0, 'eesample.tpl', 'Email sent', '', 'y', 'Email Address or Phone Number is required', '%fieldname% is required and has not been entered', '%fieldname% must be at least %fieldmin% characters long', 'Invalid Email Address', 'eecontact.tpl', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '');
INSERT INTO `tbgroup` VALUES (51, 'T-shirts and Caps', 350, 'u2', 8, '200', '400', '2005-06-02 11:48:39', 'y', 'EasyEstimate Inquiry', 'EasyEstimates@sizzlingwebdesign.com', 'EasyEstimates@sizzlingwebdesign.com', 'y', 'Thanks for taking the time to sent in the estimate of services.  Someone will be contacting you shortly.  Sizzling  Web Design.', 7, 'Send', '', 's', 1001, 'EESY', 'n', '', 3, 'If you would like to be contacted about this estimate, please enter your contact information below.', 35, 'Name', 80, 'y', 'Email', 50, '', 'Phone', 20, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', 4, 6, 7, 0, 0, 0, 0, 0, 0, 'eesample.tpl', 'Email sent', '', 'y', 'Email Address or Phone Number is required', '%fieldname% is required and has not been entered', '%fieldname% must be at least %fieldmin% characters long', 'Invalid Email Address', 'eecontact.tpl', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '');

# --------------------------------------------------------

#
# Table structure for table `tblinetype`
#

CREATE TABLE `tblinetype` (
  `linetype` char(2) NOT NULL default '',
  `linetypedesc` varchar(20) NOT NULL default '',
  `linecat` char(2) NOT NULL default '',
  `input` char(1) NOT NULL default '',
  `inputtype` char(2) NOT NULL default '',
  PRIMARY KEY  (`linetype`)
) TYPE=MyISAM;

#
# Dumping data for table `tblinetype`
#

INSERT INTO `tblinetype` VALUES ('H1', 'Heading1', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('H2', 'Heading2', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('H3', 'Heading3', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('H4', 'Heading4', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('T1', 'Text1', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('T2', 'Text2', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('T3', 'Text3', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('T4', 'Text4', 'tx', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('C1', 'Base Cost1', 'cs', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('C2', 'Base Cost2', 'cs', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('C3', 'Straight Line Cost1', 'cs', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('C4', 'Straight Line Cost2', 'cs', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('S1', 'Volume Pricing1', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('S2', 'Volume Pricing2', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('S3', 'Graduated Pricing1', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('S4', 'Graduated Pricing2', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('I1', 'Image Line1', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I2', 'Image Line2', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I3', 'Image Line3', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I4', 'Image Line4', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I5', 'Image Line5', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I6', 'Image Line6', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I7', 'Image Line7', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I8', 'Image Line8', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('I9', 'Image Line9', 'im', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B1', 'Sub-total Products1', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B2', 'Sub-total Services1', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B3', 'Sub-total all1', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B4', 'Sub-total all2', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('D1', 'Discount percent1', 'ds', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('D2', 'Discount percent2', 'ds', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('D3', 'Discount amount3', 'ds', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('D4', 'Discount amount4', 'ds', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('F1', 'Tax products only1', 'ta', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('F2', 'Tax products only2', 'ta', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('F3', 'Tax everything1', 'ta', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('F4', 'Tax everything2', 'ta', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('G1', 'Total1', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('G2', 'Total2', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('G3', 'Total3', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('G4', 'Total4', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('S5', 'Block Pricing1', 'cb', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('S6', 'Block Pricing2', 'cb', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('S7', 'Block+Straight Cost1', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('S8', 'Block+Straight Cost2', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('B5', 'Sub-total Products2', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B6', 'Sub-total Services2', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B7', 'Component sub-total1', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('B8', 'Component sub-total2', 'tt', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('L1', 'Table Look Up1', 'lk', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('L2', 'Table Look Up2', 'lk', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('L3', 'Block Select1', 'ls', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('L4', 'Block Select2', 'ls', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('L5', 'Range Select1', 'lr', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('L6', 'Range Select2', 'lr', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('C5', 'Divide1', 'cs', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('C6', 'Divide2', 'cs', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('P1', 'Line Choice1', 'pk', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('P2', 'Line Choice2', 'pk', 'y', 'sl');
INSERT INTO `tblinetype` VALUES ('S9', 'Range Lookup1', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('SA', 'Range Lookup2', 'ct', 'y', 'vl');
INSERT INTO `tblinetype` VALUES ('SW', 'Total to Input', 'sw', 'n', 'no');
INSERT INTO `tblinetype` VALUES ('R1', 'Radio Button1', 'cb', 'y', 'ra');
INSERT INTO `tblinetype` VALUES ('R2', 'Radio Button2', 'cb', 'y', 'ra');
INSERT INTO `tblinetype` VALUES ('M1', 'Mult-Select1', 'cb', 'y', 'ms');
INSERT INTO `tblinetype` VALUES ('M2', 'Multi-Select2', 'cb', 'y', 'ms');
INSERT INTO `tblinetype` VALUES ('M3', 'Checkbox1', 'cb', 'y', 'bx');
INSERT INTO `tblinetype` VALUES ('M4', 'Checkbox2', 'cb', 'y', 'bx');

# --------------------------------------------------------

#
# Table structure for table `tblmsg`
#

CREATE TABLE `tblmsg` (
  `msgid` smallint(6) NOT NULL default '0',
  `msgname` varchar(8) NOT NULL default '',
  `msgtext` varchar(100) NOT NULL default '',
  `errormsg` char(1) NOT NULL default '',
  `syscode` char(1) NOT NULL default '',
  PRIMARY KEY  (`msgid`)
) TYPE=MyISAM;

#
# Dumping data for table `tblmsg`
#

INSERT INTO `tblmsg` VALUES (1, 'min5', 'For Caps a minimum order is 5', 'y', '');

# --------------------------------------------------------

#
# Table structure for table `tbsumtype`
#

CREATE TABLE `tbsumtype` (
  `sumtypeid` char(1) NOT NULL default '',
  `sumtypedesc` char(15) NOT NULL default '',
  PRIMARY KEY  (`sumtypeid`)
) TYPE=MyISAM;

#
# Dumping data for table `tbsumtype`
#

INSERT INTO `tbsumtype` VALUES ('p', 'Product');
INSERT INTO `tbsumtype` VALUES ('s', 'Service');
INSERT INTO `tbsumtype` VALUES ('c', 'Cost Component');
INSERT INTO `tblinetype` VALUES ('LM', 'Limit Selection', 'lm', 'n', 'no');