Kod:
DROP TABLE IF EXISTS `engine4_advancedmail_ads`;
CREATE TABLE `engine4_advancedmail_ads` (
`ads_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`conversation_id` int(11) unsigned DEFAULT NULL,
`user_id` int(11) NOT NULL,
`params` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`ads_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4096 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `engine4_advancedmail_settings`;
CREATE TABLE `engine4_advancedmail_settings` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`subwords` text COLLATE utf8_unicode_ci NOT NULL,
`words` text COLLATE utf8_unicode_ci NOT NULL,
`user_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `TESTSITE`.`engine4_advancedmail_settings`
--
/*!40000 ALTER TABLE `engine4_advancedmail_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `engine4_advancedmail_settings` ENABLE KEYS */;
INSERT INTO `engine4_authorization_permissions` (`level_id`,`type`,`name`,`value`,`params`) VALUES
(1,'advancedmail','view',1,NULL),
(2,'advancedmail','view',1,NULL),
(3,'advancedmail','view',1,NULL),
(4,'advancedmail','view',1,NULL),
(5,'advancedmail','view',1,NULL),
INSERT INTO `engine4_core_menuitems` (`id`,`name`,`module`,`label`,`plugin`,`params`,`menu`,`submenu`,`enabled`,`custom`,`order`,`flag_unique`) VALUES(554,'core_mini_advancedmail','advancedmail','Messages','Advancedmail_Plugin_Menus','','core_mini','',1,0,4,0),
(555,'user_profile_advancedmail','advancedmail','Send Message','Advancedmail_Plugin_Menus','','user_profile','',1,0,2,0),
(556,'core_admin_main_plugins_advancedmail','advancedmail','Advanced Mail','','{\"route\":\"admin_default\",\"module\":\"advancedmail\",\"controller\":\"settings\"}','core_admin_main_plugins','',1,0,1003,0),
(557,'advancedmail_admin_main_settings','advancedmail','Main Settings','','{\"route\":\"admin_default\",\"module\":\"advancedmail\",\"controller\":\"settings\"}','advancedmail_admin_main','',1,0,1,0);
INSERT INTO `engine4_core_menuitems` (`id`,`name`,`module`,`label`,`plugin`,`params`,`menu`,`submenu`,`enabled`,`custom`,`order`,`flag_unique`) VALUES
(558,'advancedmail_admin_main_level','advancedmail','Member Level Settings','','{\"route\":\"admin_default\",\"module\":\"advancedmail\",\"controller\":\"settings\",\"action\":\"level\"}','advancedmail_admin_main','',1,0,2,0),
(559,'advancedmail_admin_main_more','advancedmail','More Plugins','','{\"route\":\"admin_default\",\"module\":\"advancedmail\",\"controller\":\"settings\",\"action\":\"more\"}','advancedmail_admin_main','',1,0,3,0);
/*!40000 ALTER TABLE `engine4_core_menuitems` ENABLE KEYS */;
INSERT INTO `engine4_core_modules` (`name`,`title`,`description`,`version`,`enabled`,`type`) VALUES('advancedmail','Advanced Mail','Plugin Advanced Mail replaces the standard functionality of the Mail system which is implemented in SocialEngine. It provides a much more comfortable and familiar user interface that is used by many well-known e-mail clients (e.g. Microsoft Outlook).','4.1.0',1,'extra'),
INSERT INTO `engine4_core_settings` (`name`,`value`) VALUES('advancedmail.enabled','1'),
INSERT INTO `engine4_authorization_permissions` (`level_id`,`type`,`name`,`value`,`params`) VALUES
(6, 'advancedmail', 'view', 1, NULL),
(7, 'advancedmail', 'view', 1, NULL),
(9, 'advancedmail', 'view', 1, NULL),
(11, 'advancedmail', 'view', 1, NULL),