/*!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 '',
  `content` text NOT NULL,
  `blockType` varchar(50) NOT NULL DEFAULT 'html',
  `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=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `qs_SideBlock` (`id`, `title`, `content`, `blockType`, `linkType`, `linkPageId`, `linkTitle`, `linkUrl`, `show`, `added`, `changed`) VALUES (8,'Client Testimonials','','testimonial','none',0,'','','y','2011-11-21 09:37:18','2012-03-22 12:21:05'),(12,'Last News','','recentNews','page',20,'View All News','','y','2012-01-31 12:29:31','2012-03-21 17:34:33'),(13,'Featured News','','featuredNews','page',20,'View All News','','y','2012-01-31 14:39:21','2012-03-22 12:21:05'),(14,'test','<p>text goes here</p>','html','page',124,'services','','y','2012-02-13 17:32:50','2012-03-22 12:21:05'),(15,'Featured Posts','','featuredPosts','none',0,'','','y','2012-03-09 16:17:06','2012-03-09 16:17:06'),(4,'Appointments','<p>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><img width=\"260\" height=\"150\" src=\"{BASE_URL}/userfiles/ckfiles/images/stock-photo-16701665-schedule.jpg\" alt=\"\" /></p>','html','page',8,'Contact Us','','y','2011-10-12 17:43:28','2012-03-22 12:21:05'),(5,'Our Office','<p>Visit our office in Minneapolis. Click for more information and directions.</p>\r\n<h5 style=\"margin: 1pt 0pt 15px;\"><a href=\"contact\"><img width=\"260\" height=\"150\" src=\"{BASE_URL}/userfiles/fck/image/stock-photo-15850553-office-interior.jpg\" alt=\"\" /></a></h5>','html','page',8,'More Information','','y','2011-10-12 17:46:05','2012-02-24 16:41:19'),(16,'ALL PAGES TEST','<p>zzzz xxxx yyy</p>','html','none',0,'','','y','2012-03-22 12:59:34','2012-03-22 12:59:34');