DROP TABLE IF EXISTS `site_plugin_socialmedia_services`;
CREATE TABLE IF NOT EXISTS `site_plugin_socialmedia_services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_order` int(11) NOT NULL,
  `service_name` varchar(255) NOT NULL,
  `service_profile` text NOT NULL,
  `service_icon` varchar(100) NOT NULL,
  `service_status` int(1) NOT NULL,
  `service_url` text NOT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

INSERT INTO `site_plugin_socialmedia_services` (`service_id`, `service_order`, `service_name`, `service_profile`, `service_icon`, `service_status`, `service_url`) VALUES
(6, 6, 'Facebook', '', 'icomoon icon-facebook', 1, 'https://www.facebook.com/sharer/sharer.php?u={URL}'),
(7, 7, 'Twitter', '', 'icomoon icon-twitter', 1, 'https://twitter.com/home?status={URL}'),
(8, 8, 'Google Plus', '', 'icomoon icon-google-plus', 1, 'https://plus.google.com/share?url='),
(9, 9, 'Pinterest', '', 'icomoon icon-pinterest', 1, 'https://pinterest.com/pin/create/button/?url={URL}&media={IMAGE}&description={DESCRIPTION}');

DROP TABLE IF EXISTS `site_plugin_socialmedia_services_lang`;
CREATE TABLE IF NOT EXISTS `site_plugin_socialmedia_services_lang` (
  `service_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `service_desc` text NOT NULL,
  KEY `service_id` (`service_id`),
  KEY `lang_id` (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `site_plugin_socialmedia_services_lang` (`service_id`, `lang_id`, `service_desc`) VALUES
(6, 1, ''),
(7, 1, ''),
(8, 1, ''),
(9, 1, '');
