DROP TABLE IF EXISTS `site_plugin_newsletters_groups`;
CREATE TABLE IF NOT EXISTS `site_plugin_newsletters_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) NOT NULL,
  `group_date` int(11) NOT NULL,
  `group_contacts` int(11) NOT NULL,
  `group_system` int(11) NOT NULL,
  `group_code` varchar(32) NOT NULL,
  `group_mc_status` INT( 1 ) NOT NULL ,
  `group_mc_apikey` VARCHAR( 100 ) NOT NULL,
  `group_mc_listid` VARCHAR( 100 ) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

INSERT INTO  `site_plugin_newsletters_groups` (`group_id` ,`group_name` ,`group_date` ,`group_contacts` ,`group_system` ,`group_code`)VALUES (NULL ,  'Default',  UNIX_TIMESTAMP(),  '',  '1',  'default');

DROP TABLE IF EXISTS `site_plugin_newsletters_subscribers`;
CREATE TABLE IF NOT EXISTS `site_plugin_newsletters_subscribers` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_list` text NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_first_name` varchar(50) NOT NULL,
  `item_last_name` varchar(50) NOT NULL,
  `item_email` varchar(255) NOT NULL,
  `item_key` varchar(32) NOT NULL,
  `item_date` int(11) NOT NULL,
  `item_confirm` int(1) NOT NULL,
  `item_status` int(1) NOT NULL,
  `item_stats_date` int(11) NOT NULL,
  `item_stats_ip` varchar(30) NOT NULL,
  `item_stats_confirm_date` int(11) NOT NULL,
  `item_stats_confirm_ip` varchar(30) NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `item_email` (`item_email`),
  FULLTEXT KEY `item_list` (`item_list`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


INSERT INTO `site_core_modules_user` (`mod_id`, `mod_parent`, `mod_order`, `mod_status`, `mod_invisible`, `mod_module`, `mod_module_code`, `mod_settings`, `mod_shopping`, `mod_protected`, `mod_background`, `mod_background_file`, `mod_set_protect_delete`, `mod_set_protect_edit`, `mod_set_protect_seo`, `mod_set_protect_default`, `mod_set_protect_m`, `mod_users`, `mod_user_position`, `mod_groups`, `mod_global`, `mod_external_target`, `mod_onepage_theme`, `mod_onepage_bgcolor`, `mod_onepage_image`, `mod_onepage_bgtype`) VALUES(1210, 1100, 1210, 1, 0, 126, 'text', NULL, 0, 0, 0, '', 0, 0, 0, 1, 0, '', 0, '', '', 0, 0, '', 0, 0);
INSERT INTO `site_core_modules_user` (`mod_id`, `mod_parent`, `mod_order`, `mod_status`, `mod_invisible`, `mod_module`, `mod_module_code`, `mod_settings`, `mod_shopping`, `mod_protected`, `mod_background`, `mod_background_file`, `mod_set_protect_delete`, `mod_set_protect_edit`, `mod_set_protect_seo`, `mod_set_protect_default`, `mod_set_protect_m`, `mod_users`, `mod_user_position`, `mod_groups`, `mod_global`, `mod_external_target`, `mod_onepage_theme`, `mod_onepage_bgcolor`, `mod_onepage_image`, `mod_onepage_bgtype`) VALUES(1211, 1100, 1211, 1, 0, 126, 'text', NULL, 0, 0, 0, '', 0, 0, 0, 1, 0, '', 0, '', '', 0, 0, '', 0, 0);


INSERT INTO `site_core_modules_user_lang` (`mod_id`, `lang_id`, `mod_name`, `mod_long_name`, `mod_urltitle`, `mod_url`, `mod_subtitle`, `mod_external_link`, `seo_title`, `seo_desc`, `seo_meta`) VALUES(1210, 1, 'Subscription', 'Subscription Confirmed', 'Subscription Confirmed', 'subscription-confirmed', '', '', '', '', '');
INSERT INTO `site_core_modules_user_lang` (`mod_id`, `lang_id`, `mod_name`, `mod_long_name`, `mod_urltitle`, `mod_url`, `mod_subtitle`, `mod_external_link`, `seo_title`, `seo_desc`, `seo_meta`) VALUES(1211, 1, 'Invalid Subscription Link', 'Invalid Subscription link', 'Invalid Subscription link', 'invalid-subscription', '', '', '', '', '');

INSERT INTO `site_core_texts` (`module_id`, `sub_id`, `text_image`) VALUES(1210, '', 0);
INSERT INTO `site_core_texts` (`module_id`, `sub_id`, `text_image`) VALUES(1211, '', 0);


INSERT INTO `site_core_texts_lang` (`module_id`, `lang_id`, `text_title`, `text_header`, `text_footer`, `seo_title`, `seo_desc`, `seo_meta`, `seo_conv_head`, `seo_conv_body`, `text_title_page`, `text_header_page`, `seo_title_page`, `seo_desc_page`, `seo_conv_head_page`, `seo_conv_body_page`) VALUES(1210, 1, 'Subscription Confirmed', '<p>Your subscription is now confirmed.</p>\r\n', '', 'Subscription Confirmed', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `site_core_texts_lang` (`module_id`, `lang_id`, `text_title`, `text_header`, `text_footer`, `seo_title`, `seo_desc`, `seo_meta`, `seo_conv_head`, `seo_conv_body`, `text_title_page`, `text_header_page`, `seo_title_page`, `seo_desc_page`, `seo_conv_head_page`, `seo_conv_body_page`) VALUES(1211, 1, 'Invalid Subscription', '<p>The confirmation link you are accessing doesnt exists or expired.</p>\r\n', '', 'Invalid Subscription', '', '', '', '', '', '', '', '', '', '');
