/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `qs_SideBlock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `hideTitle` enum('y','n') NOT NULL DEFAULT 'n',
  `content` text NOT NULL,
  `blockType` varchar(50) NOT NULL DEFAULT 'html',
  `pageType` enum('all','custom') NOT NULL DEFAULT 'custom',
  `linkType` enum('none','page','url') NOT NULL DEFAULT 'none',
  `linkPageId` int(11) NOT NULL DEFAULT '0',
  `linkTitle` varchar(255) NOT NULL DEFAULT '',
  `linkUrl` varchar(255) NOT NULL DEFAULT '',
  `show` enum('y','n') NOT NULL DEFAULT 'y',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `show` (`show`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_SideBlock` (`id`, `title`, `hideTitle`, `content`, `blockType`, `pageType`, `linkType`, `linkPageId`, `linkTitle`, `linkUrl`, `show`, `added`, `changed`) VALUES (12,'Last News','n','','recentNews','custom','page',20,'View All News','','y','2012-01-31 12:29:31','2012-11-20 14:13:11'),(13,'Featured News','n','','featuredNews','custom','page',20,'View All News','','y','2012-01-31 14:39:21','2012-12-07 14:09:52'),(4,'Appointments','n','<p>\r\n	To make an appointment or to request more information, give us a call at <strong>952-767-6700</strong>. To save time at your appoinrment, fill out <a href=\"{BASE_URL_HTTP}/userfiles/ckfiles/files/__test.pdf\">the following forms</a> and bring them into our office when you visit.</p>\r\n<p>\r\n	<img alt=\"\" height=\"150\" src=\"{BASE_URL}/userfiles/ckfiles/images/stock-photo-16701665-schedule.jpg\" width=\"260\" /></p>\r\n','html','custom','page',8,'Contact Us','','y','2011-10-12 17:43:28','2012-11-26 10:42:57'),(5,'Our Office','n','<p>\r\n	Visit our office in Minneapolis. Click for more information and directions.</p>\r\n<h5 style=\"margin: 1pt 0pt 15px;\">\r\n	<a href=\"contact\"><img alt=\"\" src=\"{BASE_URL}/userfiles/ckfiles/images/stock-photo-15850553-office-interior.jpg\" style=\"width: 260px; height: 150px;\" /></a></h5>\r\n','html','custom','page',8,'More Information','','y','2011-10-12 17:46:05','2012-05-15 09:34:47'),(18,'Testimonials','n','','testimonial','custom','page',154,'View All Testimonials','http://google.com','y','2012-04-25 10:50:16','2012-09-17 10:39:30'),(22,'Subscribe to Newsletter','n','<br />\r\n','subscription','all','none',0,'','','y','2012-05-31 15:14:15','2012-06-19 11:50:50'),(23,'Newsletters','n','<p>\r\n	content</p>\r\n','newsLetters','custom','page',172,'View All Newsletters','http://www.adaptainc.com','y','2012-06-05 12:13:47','2012-09-10 17:09:22'),(28,'Contact Us','n','','contactForm','custom','page',172,'link title','','y','2012-06-14 12:39:44','2012-11-28 18:01:42'),(31,'Featured Blog Posts','n','','featuredPosts','custom','none',0,'','','y','2012-11-30 12:17:46','2012-11-30 12:49:13');
