/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_zz_Settings` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `idCategory` int(11) NOT NULL DEFAULT '0',
  `fieldType` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `options` text NOT NULL,
  `description` text NOT NULL,
  `required` enum('y','n') NOT NULL DEFAULT 'y',
  `system` enum('y','n') NOT NULL DEFAULT 'n',
  `sorter` int(11) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES ('adminEmail',1,'emails','General Notification Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding all the forms submissions on your site</span>','test@kloo.fr-wd.com','','Use commas to separate email addresses','y','n',5,'2009-04-16 18:00:47','2012-03-21 17:44:35'),('siteFrom',1,'text','From Email','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',6,'2009-04-16 18:00:47','2012-03-21 17:44:35'),('userRegistrationEmailFrom',4,'text','From Email Address','','','','n','n',159,'2010-10-01 17:41:39','2012-01-05 16:04:12'),('userRegistrationAdminEmailBody',4,'HtmlEditor','Message Body','<p>New User has been registered&nbsp;at&nbsp; Adapta Interactive Framework web site.</p>\r\n<p>First Name: <strong>{firstName}</strong><br />\r\nLast Name: <strong>{lastName}</strong><br />\r\nLogin: <strong>{login}</strong><br />\r\nEmail: <strong>{email}</strong><br />\r\nPhone Number: {phone}<br />\r\nHome Address: {address}<br />\r\nCity: {city}<br />\r\nState: {state}<br />\r\nZip Code: {zip}<br />\r\n&nbsp;<br />\r\n&nbsp;</p>\r\n<pre>\r\n{$smarty|@print_r}\r\n</pre>\r\n<p><a target=\"_blank\" href=\"{link}\">Click here to view details</a>.</p>','Basic','Constants: {firstName} {lastName} {login} {email} {phone} {address} {city} {state} {zip} {link}','y','n',600,'2010-10-01 17:23:18','2012-01-05 16:04:12'),('userRegistrationAdminEmailFrom',4,'text','From Email Address','','','','n','n',501,'2010-10-01 17:23:18','2012-01-05 16:04:12'),('footer',1,'htmlEditor','Footer','<table style=\"width:100%\">\r\n    <tbody>\r\n        <tr>\r\n            <td>\r\n            <p>Copyright &copy; {currentYear} Adapta Interactive Framework | <a onclick=\"window.open(this.href, \'QuickSiteFramework_frwd_sc\', \'width=500,height=212\').focus(); return false;\" target=\"_blank\" href=\"site-credits.html\">Site Credits</a> | <a href=\"site-map.html\">Site Map</a> | <a href=\"contact\">Contact Us</a></p>\r\n            </td>\r\n            <td>\r\n            <p style=\"text-align:right; font-size:12px\">To schedule an appointment, call <strong>952-767-6700</strong></p>\r\n            </td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n<p>&nbsp;</p>','','Constants: {currentYear}','y','n',7,'2009-09-11 12:35:43','2012-03-21 17:44:35'),('contactFormEmailHeader',2,'header','','Contact Form Submission Notification','','','n','n',0,'2010-07-13 11:22:59','2010-07-13 11:22:59'),('contactFormEmailSubject',2,'text','Subject','New comments have been submitted','','','y','n',1,'2010-07-13 11:28:19','2012-03-05 16:36:28'),('contactFormEmailFrom',2,'text','From Email Address','Adapta Interactive Framework <qsf@frontierwebdev.com>','','','y','n',2,'2010-07-13 11:29:43','2012-03-05 16:36:28'),('contactFormEmailTo',2,'emails','To Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding Contact form submissions on your site</span>','test@kloo.fr-wd.com','','Use commas to separate email addresses','n','n',3,'2010-07-13 11:30:45','2012-03-05 16:36:28'),('contactFormEmailBody',2,'HtmlEditor','Message Body','New comments have been submitted. <br />\r\n<br />\r\nName: <b>{name}</b><br />\r\nE-mail or phone number: <b>{emailOrPhone}</b><br />\r\nComments:   <blockquote><b>{comments}</b><b><br />\r\n</b></blockquote>   <br />\r\nClick <a href=\"{link}\">here</a> to view details.<br />\r\n<br />','','Constants: {name} {emailOrPhone} {comments} {link}','y','n',4,'2010-07-13 11:34:51','2012-03-05 16:36:28'),('stsAuthLink',1,'htmlEditor','STS Link Text','<p>Need a change made? Use our online support system. <a target=\"_blank\" href=\"{url}\" class=\"login_btn\">online support system</a> <a href=\"http://www.twitter.com/adaptainc\" class=\"twitter_btn\" target=\"_blank\">Twitter</a> <a href=\"http://www.facebook.com/pages/Adapta-Interactive/332475043438985\" class=\"facebook_btn\" target=\"_blank\">Facebook</a> <a href=\"http://www.linkedin.com/company/adapta-interactive\" class=\"inid_btn\" target=\"_blank\">LinkedIn</a></p>','','Constants: {url}','y','y',8,'2010-08-25 00:00:00','2012-02-01 15:11:29'),('forgotPasswordEmailHeader',4,'header','','User \"Forgot Password\" Email Template','','','n','n',90,'2010-09-13 15:54:08','2010-09-13 15:54:08'),('forgotPasswordEmailSubject',4,'text','Subject','Recovery account password at Adapta Interactive Framework','','','y','n',100,'2010-09-13 15:54:08','2012-01-05 16:04:12'),('userRegistrationEmailHeader',4,'header','','User Registration Email Template (sends to user)','','','y','n',140,'2010-10-01 16:40:17','2010-10-01 16:40:17'),('forgotPasswordEmailFrom',4,'text','From Email Address','','','','n','n',120,'2010-09-13 15:54:08','2012-01-05 16:04:12'),('forgotPasswordEmailBody',4,'HtmlEditor','Message Body','<div style=\"font-family: Arial,Helvetica,sans-serif;\">\r\n<p>Please review your renewed password information at Adapta Interactive Framework web site below.</p>\r\n<p>Email Address: <strong>{email}</strong><br />\r\nNew Password: <strong>{newPassword}</strong><br />\r\nExpiration date for activation: <strong>{recoverCodeExpirationDate}</strong></p>\r\n<p>To activate your new password click <a href=\"{link}\" target=\"_blank\">here</a>.</p>\r\n</div>','','Constants: {firstName} {lastName} {email} {newPassword} {recoverCodeExpirationDate} {link}','y','n',130,'2010-09-13 15:54:08','2012-01-05 16:04:12'),('userRegistrationEmailSubject',4,'text','Subject','You have created an account at Adapta Interactive Framework','','','y','n',150,'2010-10-01 16:40:17','2012-01-05 16:04:12'),('userRegistrationEmailBody',4,'HtmlEditor','Message Body','<div style=\"font-family: Arial,Helvetica,sans-serif;\">\r\n<p>Congratulations! You have been successfully registered at Adapta Interactive Framework web site!</p>\r\n<p>Your Email: <strong>{email}</strong><br />\r\nYour Password: <strong>{password}</strong></p>\r\n<p><a href=\"{link}\" target=\"_blank\">Click here to login at Quick Site Framework web site</a>.</p>\r\n</div>','','Constants: {email} {password} {link}','y','n',160,'2010-10-01 16:40:17','2012-01-05 16:04:12'),('userRegistrationAdminEmailHeader',4,'Header','','User Registration Email Template (sends to admin)','','','n','n',400,'2010-10-01 17:23:18','2010-10-01 17:23:18'),('userRegistrationAdminEmailSubject',4,'text','Subject','New User has been registered','','','y','n',500,'2010-10-01 17:23:18','2012-01-05 16:04:12'),('analyticsCode',1,'text','Google Analytics Tracking Code','UA-123456-7','','Example: UA-xxxxxx-x','n','n',100,'2011-05-09 00:00:00','2012-03-21 17:44:35');