--
-- Table structure for table `qs_SocialLinkDictionary`
--

CREATE TABLE IF NOT EXISTS `qs_SocialLinkDictionary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iconName` varchar(30) NOT NULL,
  `serviceName` varchar(30) NOT NULL,
  `exampleLink` varchar(255) NOT NULL,
  `sorter` int(11) NOT NULL,
  `show` enum('y','n') NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `qs_SocialLinkDictionary`
--

INSERT INTO `qs_SocialLinkDictionary` (`id`, `iconName`, `serviceName`, `exampleLink`, `sorter`, `show`) VALUES
(1, 'facebook', 'Facebook', 'http://www.facebook.com/pages/Adapta-Interactive/332475043438985', 0, 'y'),
(2, 'twitter', 'Twitter', 'https://twitter.com/AdaptaInc', 1, 'y'),
(3, 'linkedin', 'LinkedIn', 'http://www.linkedin.com/company/adapta-interactive', 2, 'y'),
(4, 'google-plus', 'Google+', 'https://plus.google.com/102237682850456704870/posts', 3, 'y');



ALTER TABLE  `qs_People` ADD  `email` VARCHAR( 255 ) NULL AFTER  `name` ,
ADD  `phone` VARCHAR( 40 ) NULL AFTER  `email`;