CREATE TABLE IF NOT EXISTS `{PREFIX}activities` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`parent_id` INT( 10 ) NOT NULL DEFAULT '0',
`action` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`text` text COLLATE utf8_unicode_ci NOT NULL,
`content` text COLLATE utf8_unicode_ci NOT NULL,
`items` text COLLATE utf8_unicode_ci NOT NULL,
`item_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`item_id` int(10) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL ,
`activity_comment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`query` tinyint(1) unsigned NOT NULL DEFAULT '0',
`privacy` tinyint(2) unsigned NOT NULL DEFAULT '1',
`modified` datetime DEFAULT NULL,
`params` text COLLATE utf8_unicode_ci NOT NULL,
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`plugin` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`edited` tinyint(1) NOT NULL DEFAULT '0',
`share` TINYINT( 1 ) NOT NULL DEFAULT 0,
`status` enum('ok','waiting') COLLATE utf8_unicode_ci DEFAULT 'ok',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `guest_home` (`type`,`privacy`,`modified`),
KEY `profile` (`target_id`,`type`,`action`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}activity_comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`activity_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text COLLATE utf8_unicode_ci NOT NULL,
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`edited` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `wall_id` (`activity_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0;
CREATE TABLE IF NOT EXISTS `{PREFIX}admin_notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`message` text COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`read` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}albums` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` text COLLATE utf8_unicode_ci NOT NULL,
`created` datetime DEFAULT NULL,
`photo_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`cover` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`modified` datetime DEFAULT NULL,
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`comment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`privacy` tinyint(2) unsigned NOT NULL DEFAULT '1',
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `category_id` (`category_id`),
KEY `privacy` (`privacy`,`id`),
FULLTEXT KEY `title` (`title`,`description`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}attachments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`plugin_id` int(10) unsigned NOT NULL DEFAULT '0',
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`filename` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`original_filename` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`extension` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`downloads` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `plugin_id` (`plugin_id`,`target_id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}blogs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`body` text COLLATE utf8_unicode_ci NOT NULL,
`thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`privacy` tinyint(2) unsigned NOT NULL DEFAULT '1',
`comment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`share_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `privacy` (`privacy`,`id`),
FULLTEXT KEY `title` (`title`,`body`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}cake_sessions` (
`id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`data` text COLLATE utf8_unicode_ci NOT NULL,
`expires` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `expires` (`expires`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`message` text COLLATE utf8_unicode_ci NOT NULL,
`created` datetime DEFAULT NULL,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`edited` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `type` (`type`,`target_id`,`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}conversations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`message` text COLLATE utf8_unicode_ci NOT NULL,
`created` datetime DEFAULT NULL,
`message_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`lastposter_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `lastposter_id` (`lastposter_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}conversation_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`conversation_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`unread` tinyint(1) unsigned NOT NULL DEFAULT '1',
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `conversation_id` (`conversation_id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` text COLLATE utf8_unicode_ci NOT NULL,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`location` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`from` date DEFAULT NULL,
`from_time` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`to` date DEFAULT NULL,
`to_time` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`type` tinyint(2) unsigned NOT NULL DEFAULT '1',
`photo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`event_rsvp_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`address` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`timezone` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'America/New_York',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `category_id` (`category_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}event_rsvps` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`event_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`rsvp` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `rsvp_list` (`event_id`,`rsvp`,`id`),
KEY `event_id` (`event_id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}friends` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`friend_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `friend_id` (`friend_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}friend_requests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sender_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`message` text COLLATE utf8_unicode_ci NOT NULL,
`created` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `sender_id` (`sender_id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`description` text COLLATE utf8_unicode_ci NOT NULL,
`type` tinyint(2) unsigned NOT NULL DEFAULT '0',
`photo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`group_user_count` smallint(5) unsigned NOT NULL DEFAULT '1',
`created` datetime DEFAULT NULL,
`photo_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`topic_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`video_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`event_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`featured` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `category_id` (`category_id`),
KEY `type` (`type`),
FULLTEXT KEY `name` (`name`,`description`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}group_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`status` tinyint(2) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `group_id` (`group_id`),
KEY `user_id` (`user_id`),
KEY `status` (`status`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}likes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`thumb_up` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `type` (`type`,`target_id`,`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}notifications` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`sender_id` int(10) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`action` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`read` tinyint(1) unsigned NOT NULL DEFAULT '0',
`params` TEXT COLLATE utf8_unicode_ci NOT NULL,
`plugin` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `sender_id` (`sender_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}pages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`alias` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`content` text COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`params` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`menu` tinyint(1) unsigned NOT NULL DEFAULT '0',
`icon_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`weight` int(10) unsigned NOT NULL DEFAULT '0',
`url` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`uri` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`keywords` text COLLATE utf8_unicode_ci NOT NULL,
`custom` tinyint(1) NOT NULL DEFAULT '1',
`fragment` tinyint(1) NOT NULL DEFAULT '0',
`layout` int(11) NOT NULL DEFAULT '0',
`levels` text COLLATE utf8_unicode_ci,
`provides` text COLLATE utf8_unicode_ci,
`view_count` int(11) unsigned NOT NULL DEFAULT '0',
`type` enum('core','plugin','page') COLLATE utf8_unicode_ci DEFAULT NULL,
`search` tinyint(1) NOT NULL DEFAULT '0',
`theme_id` int(11) unsigned NOT NULL DEFAULT '0',
`core_content_count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `alias` (`alias`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=100;
INSERT INTO `{PREFIX}pages` (`id`, `title`, `alias`, `content`, `permission`, `params`, `created`, `modified`, `menu`, `icon_class`, `weight`, `url`, `uri`, `description`, `keywords`, `custom`, `fragment`, `layout`, `levels`, `provides`, `view_count`, `type`, `search`, `theme_id`, `core_content_count`) VALUES
(1, 'Home Page', 'home_index', '', '', '', '0000-00-00 00:00:00', '2014-09-10 02:06:12', 0, '', 0, '/home', 'home.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 15),
(2, 'Contact Page', 'home_contact', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/home/contact', 'home.contact', '', '', 1, 0, 3, NULL, NULL, 0, 'core', 0, 0, 4),
(3, 'People Page', 'users_index', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/users', 'users.index', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 7),
(4, 'Profile Page', 'users_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/users/view/$id', 'users.view', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 5),
(6, 'Blogs Browse Page', 'blogs_index', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/blogs', 'blogs.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 8),
(8, 'Blog Detail Page', 'blogs_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/blogs/view/$id', 'blogs.view', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 7),
(9, 'Photos Browse Page', 'photos_index', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/photos', 'photos.index', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 6),
(10, 'Album Detail Page', 'albums_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/albums/view/$id/{album name}', 'albums.view', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 3),
(11, 'Photo Detail Page', 'photos_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/photos/view/$id', 'photos.view', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 2),
(12, 'Videos Browse Page', 'videos', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/videos', 'videos.index', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 7),
(13, 'Video Detail Page', 'videos_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/videos/view/$id/{video''s name}', 'videos.view', '', '', 1, 0, 3, NULL, NULL, 0, 'core', 0, 0, 5),
(15, 'Topic Detail Page', 'topics_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/topics/view/$id/{topic''s name}', 'topics.view', '', '', 1, 0, 2, NULL, NULL, 0, 'core', 0, 0, 6),
(16, 'Groups Browse Page', 'groups', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/groups', 'groups.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 8),
(18, 'Group Detail Page', 'groups_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/groups/view/$id/{group''s name}', 'groups.view', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 9),
(19, 'Events Browse Page', 'events', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/events', 'events.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 7),
(21, 'Event Detail Page', 'events_view', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/events/view/$id/{event''s name}', 'events.view', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 9),
(22, 'Forgot Password Page', 'user_recover', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/users/recover', 'users.recover', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 3),
(23, 'Topics Browse Page', 'topics', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, '/topics', 'topics.index', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 8),
(63, 'Landing Page', 'landing_index', '', '', '', '2014-08-28 04:20:32', '2014-08-28 04:20:32', 0, '', 0, '/home/landing', 'home.landing', '', '', 1, 0, 1, NULL, NULL, 0, 'core', 0, 0, 12),
(68, 'Site Header', 'site_header', '', '', '', '0000-00-00 00:00:00', '2014-09-08 01:58:40', 0, '', 0, 'site/header', 'site.header', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 1),
(69, 'Site Footer', 'site_footer', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', 0, 'site/footer', 'site.footer', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 2),
(90, 'Sign in', 'signin', '', '', '', '2014-09-11 09:14:58', '2014-09-11 09:14:58', 0, '', 0, '/users/member_login', 'users.member_login', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 2),
(96, 'Sign up', 'signup', '', '', '', '2014-09-15 03:34:56', '2014-09-15 03:34:56', 0, '', 0, '/users/register', 'users.register', '', '', 1, 0, 4, NULL, NULL, 0, 'core', 0, 0, 2),
(100, 'About Us', 'about-us', '<p><span>This is the About Us page</span></p>', '', '', '2015-06-11 09:41:53', '2015-06-11 09:41:53', 0, '', 0, '/pages/about-us', 'pages.about-us', '', '', 1, 0, 0, NULL, NULL, 0, 'page', 0, 0, 2),
(101, 'Term of Service', 'term-of-service', '<p><span>This is the Term of Service page</span></p>', '', '', '2015-06-11 09:43:12', '2015-06-11 09:43:12', 0, '', 0, '/pages/term-of-service', 'pages.term-of-service', '', '', 1, 0, 0, NULL, NULL, 0, 'page', 0, 0, 2),
(102, 'Privacy Policy', 'privacy-policy', '<p><span>This is the Privacy Policy page</span></p>', '', '', '2015-06-11 09:44:06', '2015-06-11 09:44:06', 0, '', 0, '/pages/privacy-policy', 'pages.privacy-policy', '', '', 1, 0, 0, NULL, NULL, 0, 'page', 0, 0, 2);
CREATE TABLE IF NOT EXISTS `{PREFIX}password_requests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `code` (`code`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}photos` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`caption` text COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`original` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`comment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`privacy` INT NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `target_id` (`target_id`,`type`,`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}photo_tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`photo_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`tagger_id` int(10) unsigned NOT NULL DEFAULT '0',
`value` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`style` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `photo_id` (`photo_id`),
KEY `tagger_id` (`tagger_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}profile_fields` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` text COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`values` text COLLATE utf8_unicode_ci NOT NULL,
`required` tinyint(1) unsigned NOT NULL DEFAULT '0',
`registration` tinyint(1) unsigned NOT NULL DEFAULT '0',
`searchable` tinyint(1) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`weight` smallint(5) unsigned NOT NULL DEFAULT '0',
`profile` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}profile_field_values` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`profile_field_id` int(10) unsigned NOT NULL DEFAULT '0',
`value` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `profile_field_id` (`profile_field_id`),
FULLTEXT KEY `value` (`value`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}reports` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`reason` text COLLATE utf8_unicode_ci NOT NULL,
`created` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}spam_challenges` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`answers` text COLLATE utf8_unicode_ci NOT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}tags` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`target_id` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`),
KEY `tag` (`tag`),
KEY `target_id` (`target_id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}topics` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`body` text COLLATE utf8_unicode_ci NOT NULL,
`thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`last_post` datetime DEFAULT NULL,
`comment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`share_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`lastposter_id` int(10) unsigned NOT NULL DEFAULT '0',
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`group_id` int(10) unsigned NOT NULL DEFAULT '0',
`pinned` tinyint(1) unsigned NOT NULL DEFAULT '0',
`attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `topic_category_id` (`category_id`),
KEY `lastposter_id` (`lastposter_id`),
FULLTEXT KEY `title` (`title`,`body`),
KEY `group_id` (`group_id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`role_id` tinyint(3) unsigned NOT NULL DEFAULT '2',
`avatar` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`photo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`photo_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`friend_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`notification_count` tinyint(3) unsigned NOT NULL DEFAULT '0',
`friend_request_count` tinyint(3) unsigned NOT NULL DEFAULT '0',
`blog_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`topic_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`group_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`event_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`conversation_user_count` tinyint(3) unsigned NOT NULL DEFAULT '0',
`video_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`gender` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`birthday` date DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
`confirmed` tinyint(1) unsigned NOT NULL DEFAULT '1',
`code` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`notification_email` tinyint(1) unsigned NOT NULL DEFAULT '1',
`timezone` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`ip_address` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`privacy` tinyint(2) unsigned NOT NULL DEFAULT '1',
`username` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`about` text COLLATE utf8_unicode_ci NOT NULL,
`featured` tinyint(1) unsigned NOT NULL DEFAULT '0',
`lang` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`hide_online` tinyint(1) unsigned NOT NULL DEFAULT '0',
`cover` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`approved` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'admin approved user feature',
`is_social` TINYINT(1) NOT NULL DEFAULT '0',
`has_active_subscription` TINYINT(1) NOT NULL DEFAULT '0',
`receive_message_from_non_friend` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
KEY `gender` (`gender`),
KEY `active` (`active`,`id`),
KEY `username` (`username`),
FULLTEXT KEY `name` (`name`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}videos` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`category_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` text COLLATE utf8_unicode_ci NOT NULL,
`thumb` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`destination` VARCHAR( 255 ) NOT NULL DEFAULT '',
`in_process` TINYINT( 1 ) NOT NULL DEFAULT '0' ,
`pc_upload` TINYINT( 1 ) NOT NULL DEFAULT '0' ,
`source` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`source_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`like_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`dislike_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`comment_count` smallint(5) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`privacy` tinyint(2) unsigned NOT NULL DEFAULT '1',
`group_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `category_id` (`category_id`),
KEY `privacy` (`privacy`,`id`),
FULLTEXT KEY `title` (`title`,`description`),
KEY `group_id` (`group_id`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}acos` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `group` (`group`,`key`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT IGNORE `{PREFIX}acos` (`group`, `key`, `description`) VALUES
('user', 'username', 'Select username'),
('blog', 'view', 'View blog entry'),
('blog', 'create', 'Create/Edit blog entry'),
('album', 'create', 'Create/Edit photo album'),
('album', 'view', 'View photo album'),
('event', 'create', 'Create/Edit event'),
('event', 'view', 'View event'),
('group', 'create', 'Create/Edit group'),
('group', 'view', 'View group'),
('photo', 'upload', 'Upload photos'),
('photo', 'view', 'View photo'),
('topic', 'create', 'Create/Edit topic'),
('topic', 'view', 'View topic'),
('video', 'share', 'Share video'),
('video', 'view', 'View video'),
('attachment', 'upload', 'Upload attachment'),
('attachment', 'download', 'Download attachment');
CREATE TABLE IF NOT EXISTS `{PREFIX}categories` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`item_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
`weight` smallint(5) unsigned NOT NULL DEFAULT '0',
`header` tinyint(1) unsigned NOT NULL DEFAULT '0',
`create_permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `type` (`type`,`active`,`weight`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci PACK_KEYS=0;
INSERT IGNORE `{PREFIX}categories` (`id`, `type`, `name`, `description`, `item_count`, `active`, `weight`) VALUES
(1, 'Photo', 'Member Albums', '', 0, 1, 0),
(2, 'Group', 'Default Category', '', 0, 1, 0),
(3, 'Topic', 'Default Category', '', 0, 1, 0),
(4, 'Video', 'Default Category', '', 0, 1, 0),
(5, 'Event', 'Default Category', '', 0, 1, 0);
CREATE TABLE IF NOT EXISTS `{PREFIX}hooks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`controller` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`action` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`position` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`weight` smallint(6) NOT NULL DEFAULT '0',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
`version` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`settings` text COLLATE utf8_unicode_ci NOT NULL,
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`),
KEY `controller` (`controller`),
KEY `action` (`action`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT IGNORE `{PREFIX}hooks` (`name`, `key`, `controller`, `action`, `position`, `weight`, `enabled`, `version`, `settings`, `permission`) VALUES
('Featured Members', 'featured_members', 'home', 'index', 'home_sidebar', 6, 1, '2.0', '', ''),
('Popular Blogs', 'popular_blogs', 'blogs', 'index', 'blogs_sidebar', 2, 1, '2.0', '', ''),
('Popular Albums', 'popular_albums', 'photos', 'index', 'photos_sidebar', 3, 1, '2.0', '', ''),
('Today Birthdays', 'today_birthdays', 'home', 'index', 'home_sidebar', 4, 1, '2.0', '', ''),
('Online Users', 'online_users', '', '', 'global_sidebar', 5, 1, '2.0', '', ''),
('Recently Joined', 'recently_joined', 'home', 'index', 'home_sidebar', 7, 1, '2.0', '', ''),
('Popular Events', 'popular_events', 'events', 'index', 'events_sidebar', 8, 1, '2.0', '', ''),
('Popular Groups', 'popular_groups', 'groups', 'index', 'groups_sidebar', 9, 1, '2.0', '', ''),
('Popular Topics', 'popular_topics', 'topics', 'index', 'topics_sidebar', 10, 1, '2.0', '', ''),
('Popular Videos', 'popular_videos', 'videos', 'index', 'videos_sidebar', 11, 1, '2.0', '', ''),
('Friend Suggestions', 'friend_suggestions', '', '', 'global_sidebar', 12, 1, '2.0', '', ''),
('Featured Groups', 'featured_groups', 'groups', 'index', 'groups_sidebar', 13, 1, '2.0', '', '');
CREATE TABLE IF NOT EXISTS `{PREFIX}languages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`rtl` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT IGNORE `{PREFIX}languages` (`id`, `key`, `name`) VALUES
(1, 'eng', 'English');
CREATE TABLE IF NOT EXISTS `{PREFIX}plugins` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`key` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`permission` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
`core` tinyint(1) unsigned NOT NULL DEFAULT '0',
`version` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`weight` smallint(5) unsigned NOT NULL DEFAULT '0',
`menu` tinyint(1) unsigned NOT NULL DEFAULT '1',
`url` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`icon_class` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`bootstrap` tinyint(1) NOT NULL DEFAULT '0',
`routes` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{PREFIX}plugins` (`name`, `key`, `permission`, `enabled`, `core`, `version`, `weight`, `menu`, `url`, `icon_class`, `bootstrap`, `routes`) VALUES
('Billing', 'Billing', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Menu', 'Menu', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Payment Gateway', 'PaymentGateway', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Cron', 'Cron', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Mail', 'Mail', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Photo', 'Photo', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Video', 'Video', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Page', 'Page', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Event', 'Event', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Topic', 'Topic', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Blog', 'Blog', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Group', 'Group', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Social Integration', 'SocialIntegration', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('MooUpload', 'MooUpload', '', 1, 1, '2.2.0', 0, 1, '', '', 1, 1),
('Subscription', 'Subscription', '', 1, 1, '2.2.1', 0, 1, '', '', 1, 1),
('Paypal Adaptive', 'PaypalAdaptive', '', 1, 1, '2.2.1', 0, 1, '', '', 1, 1);
CREATE TABLE IF NOT EXISTS `{PREFIX}roles` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_super` tinyint(1) unsigned NOT NULL DEFAULT '0',
`params` text COLLATE utf8_unicode_ci NOT NULL,
`core` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT IGNORE `{PREFIX}roles` (`id`, `name`, `is_admin`, `is_super`, `params`, `core`) VALUES
(1, 'Super Admin', 1, 1, 'global_search,user_username,blog_view,blog_create,album_create,album_view,event_create,event_view,group_create,group_view,group_delete,photo_upload,photo_view,topic_create,topic_view,video_share,video_view,attachment_upload,attachment_download', 1),
(2, 'Member', 0, 0, 'global_search,user_username,blog_view,blog_create,album_create,album_view,event_create,event_view,group_create,group_view,photo_upload,photo_view,topic_create,topic_view,video_share,video_view,attachment_upload,attachment_download', 1),
(3, 'Guest', 0, 0, 'global_search,user_username,blog_view,blog_create,album_create,album_view,event_create,event_view,group_create,group_view,group_delete,photo_upload,photo_view,topic_create,topic_view,video_share,video_view,attachment_upload,attachment_download', 1);
CREATE TABLE IF NOT EXISTS `{PREFIX}settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) DEFAULT NULL,
`label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`field` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`is_hidden` tinyint(1) NOT NULL DEFAULT '0',
`version_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`type_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`value_actual` mediumtext COLLATE utf8_unicode_ci,
`value_default` mediumtext COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
`ordering` tinyint(3) NOT NULL DEFAULT '0',
`is_boot` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `{PREFIX}settings` (`group_id`, `label`, `name`, `field`, `value`, `is_hidden`, `version_id`, `type_id`, `value_actual`, `value_default`, `description`, `ordering`, `is_boot`) VALUES
(1, 'Site Name', 'site_name', 'site_name', 'test', 0, NULL, 'text', 'mooSocial', 'mooSocial', NULL, 1, 0),
(1, 'Site Email', 'site_email', 'site_email', 'info@socialloft.com', 0, NULL, 'text', 'info@socialloft.com', 'info@socialloft.com', NULL, 2, 0),
(1, 'Site Keywords', 'site_keywords', 'site_keywords', '', 0, NULL, 'textarea', '', '', '', 3, 0),
(1, 'Site Description', 'site_description', 'site_description', '', 0, NULL, 'textarea', '', '', '', 4, 0),
(1, 'Default Home Feed', 'default_feed', 'default_feed', 'everyone', 0, NULL, 'select', '[{"name":"Everyone","value":"everyone","select":1},{"name":"Friends & Me","value":"friends","select":0}]', '[{"name":"Everyone","value":"everyone","select":0},{"name":"Friends & Me","value":"friends","select":0}]', NULL, 10, 0),
(1, 'Note', 'admin_notes', 'admin_notes', '', 0, NULL, 'textarea', '', '', '', 4, 0),
(3, 'Enable reCaptcha', 'recaptcha', 'recaptcha', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"1"}]', 'You must enter recaptcha public and private key if you<br>enable this. Click <a href="http://www.google.com/recaptcha" target="_blank">this</a> for more details', 2, 0),
(3, 'reCaptcha Public Key', 'recaptcha_publickey', 'recaptcha_publickey', '', 0, NULL, 'text', '', '', NULL, 3, 0),
(3, 'reCaptcha Private Key', 'recaptcha_privatekey', 'recaptcha_privatekey', '', 0, NULL, 'text', '', '', NULL, 4, 0),
(3, 'Require Email Validation', 'email_validation', 'email_validation', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 1, 0),
(4, 'Homepage Guest Message', 'guest_message', 'guest_message', '', 0, NULL, 'textarea', '', '', NULL, 2, 0),
(4, 'Header Block Code', 'header_code', 'header_code', '', 0, NULL, 'textarea', '', '', NULL, 4, 0),
(4, 'Footer Block Code', 'footer_code', 'footer_code', '', 0, NULL, 'textarea', '', '', NULL, 7, 0),
(4, 'Homepage Member Message', 'member_message', 'member_message', '', 0, NULL, 'textarea', '', '', NULL, 3, 0),
(2, 'Allow Users To Select Theme', 'select_theme', 'select_theme', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 8, 0),
(2, 'Allow Guests To Search', 'guest_search', 'guest_search', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 1, 0),
(2, 'Photo theater mode', 'photo_theater_mode', 'photo_theater_mode', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 1, 0),
(1, 'Default Theme', 'default_theme', 'default_theme', 'default', 0, NULL, 'select', '[{"name":"Default Theme","value":"default","select":1}]', 'default', NULL, 9, 0),
(2, 'Force Login', 'force_login', 'force_login', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this to force users to login to view the site', 5, 0),
(4, 'Homepage Block Code', 'homepage_code', 'homepage_code', '', 0, NULL, 'textarea', '', '', NULL, 6, 0),
(3, 'Ban IP Addresses', 'ban_ips', 'ban_ips', '', 0, NULL, 'textarea', '', '', 'Enter xyz.xyz.xyz.xyz to ban the exact ip address<br>Or xyz.xyz.xyz to ban ip addresses that start with xyz.xyz.xyz<br>One ip address per line', 5, 0),
(3, 'Ban Email Addresses', 'ban_emails', 'ban_emails', '', '0', NULL, 'textarea', '', '', 'Enter xyz@abc.com to ban the exact email address<br>Or abc@* to ban email addresses that start with abc@<br>Or *@abc.com to ban email addresses that end with @abc.com<br>One email address per line', '5', '0'),
(2, 'Enable Activities Feed Selection', 'feed_selection', 'feed_selection', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 2, 0),
(9, 'Take Site Offline', 'site_offline', 'site_offline', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 5, 0),
(9, 'Offline Message', 'offline_message', 'offline_message', '', 0, NULL, 'textarea', '', '', '', 6, 0),
(1, 'Default Profile Privacy', 'profile_privacy', 'profile_privacy', '[{"name":"Everyone","value":"1","select":1},{"name":"Friends & Me","value":"2","select":0},{"name":"Only Me","value":"3","select":0}]', 0, NULL, 'select', '[{"name":"Everyone","value":"1","select":1},{"name":"Friends & Me","value":"2","select":0},{"name":"Only Me","value":"3","select":0}]', '1', NULL, 8, 0),
(1, 'Popular Items Interval', 'popular_interval', 'popular_interval', '30', 0, NULL, 'text', '30', '30', 'Display popular items within X days ', 7, 0),
(1, 'Default Language', 'default_language', 'default_language', 'eng', 0, NULL, 'language', 'eng', 'eng', '', 15, 0),
(2, 'Disable Registration', 'disable_registration', 'disable_registration', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 6, 0),
(1, 'Time Format', 'time_format', 'time_format', '12h', 0, NULL, 'select', '[{"name":"12-hour","value":"12","select":1},{"name":"24-hour","value":"24","select":0}]', '[{"name":"12-hour","value":"12","select":"1"},{"name":"24-hour","value":"24","select":0}]', NULL, 11, 0),
(1, 'Date Format', 'date_format', 'date_format', '%B %d at %I:%M %p', 0, NULL, 'text', '%B %d at %I:%M %p', '%B %d at %I:%M %p', '<a target="_blank" href="http://php.net/manual/en/function.date.php">Refer to PHP date function for more information about<br>date format. Click this for more details</a>', 12, 0),
(6, 'Upload New Logo', 'logo', 'logo', 'img/logo.png', 0, NULL, 'text', 'img/logo.png', '', NULL, 1, 0),
(3, 'Remove Admin Link', 'hide_admin_link', 'hide_admin_link', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this box to remove Admin link from user menu', 6, 0),
(2, 'Allow Users To Select Language', 'select_language', 'select_language', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 9, 0),
(5, 'Analytics Code', 'analytics_code', 'analytics_code', '', 0, NULL, 'textarea', '', '', 'Enter your analytics code here<br>Click <a href="http://www.google.com/analytics/" target="_blank">this</a> to visit Google Analytics', 4, 0),
(2, 'Registration Notification', 'registration_notify', 'registration_notify', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this to enable the system to send a notification email to the site email whenever a new user signs up', 7, 0),
(2, 'Hide Activities Feed From Guests', 'hide_activites', 'hide_activites', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '0', NULL, 3, 0),
(2, 'Allow Username Change', 'username_change', 'username_change', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 11, 0),
(2, 'Save Original Image', 'save_original_image', 'save_original_image', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this to store original image when users upload photos<br/>You might wanna disable if you are concerned about server space', 4, 0),
(3, 'Restricted Usernames', 'restricted_usernames', 'restricted_usernames', '', 0, NULL, 'textarea', '', '', 'Enter usernames that you do not want users to register with. One username per line', 7, 0),
(3, 'Enable Registration Code', 'enable_registration_code', 'enable_registration_code', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this box to force users to enter the correct registration code defined below in order to register', 8, 0),
(3, 'Registration Code', 'registration_code', 'registration_code', '', 0, NULL, 'text', '', '', NULL, 9, 0),
(5, 'Google Developer Key', 'google_dev_key', 'google_dev_key', ' ', 0, NULL, 'text', '', '', 'Use for youtube API for more info please go to <a href="https://developers.google.com/youtube/v3/getting-started">link</a>', 5, 0),
(1, 'Default Timezone', 'timezone', 'timezone', 'Africa/Accra', 0, NULL, 'timezone', 'Asia/Ho_Chi_Minh', 'Asia/Ho_Chi_Minh', '', 13, 0),
(1, 'Enable Timezone Selection', 'enable_timezone_selection', 'enable_timezone_selection', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"0"}]', 'If your users live in different timezones then enable this ', 14, 0),
(2, 'Require Birthday', 'require_birthday', 'require_birthday', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 12, 0),
(3, 'Enable Spam Challenge', 'enable_spam_challenge', 'enable_spam_challenge', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Check this box to force users to answer a<br>challenge question in order to register<br>Click <a href="/admin/spam_challenges">here</a> to manage challenge questions/answers', 10, 0),
(1, 'Show "Powered by" link', 'show_credit', 'show_credit', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', NULL, 16, 0),
(2, 'Allow Name Change', 'name_change', 'name_change', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', 'Check this to allow users to change name ', 10, 0),
(4, 'Registration Message', 'registration_message', 'registration_message', '', 0, NULL, 'textarea', '', '', NULL, 1, 0),
(3, 'Enable SSL Mode', 'ssl_mode', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":0}]', '[{"name":"","value":"1","select":0}]', '', 1, 1),
(9, 'System Mode', 'production_mode', NULL, '', 0, NULL, 'radio', '[{"name":"Production","value":"0","select":1},{"name":"Development 1","value":"1","select":0},{"name":"Development 2","value":"2","select":0}]', '[{"name":"Production","value":"0","select":1},{"name":"Development 1","value":"1","select":0},{"name":"Development 2","value":"2","select":0}]', 'Production Mode: No error messages, errors, or warnings shown. Flash messages redirect.Development Mode: 1: Errors and warnings shown, model caches refreshed, flash messages halted. 2: As in 1, but also with full debug messages and SQL output.', 1, 1),
(1, 'Notification Interval', 'notification_interval', 'notification_interval', '10', 0, NULL, 'text', '10', '10', 'Refresh notification within X seconds', 7, 0),
(1, 'Version', 'version', 'version', '2.3.0', 0, NULL, 'text', '2.3.0', '2.3.0', '', 17, 0),
(3, 'Approve Users', 'approve_users', 'approve_users', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', 'Enable this if you want to approve users before they can do activities on the site.', 1, 0),
(1, 'Photo Image Sizes', 'photo_image_sizes', 'photo_image_sizes', '75_square|150_square|300_square|250|450|850|1500', 0, NULL, 'text', '75_square|150_square|300_square|250|450|850|1500', NULL, 'File sizes to crop when user upload photo', 18, 0),
(13, 'Enable Blog Plugin', 'blog_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(12, 'Trigger Access Key', 'cron_key', NULL, '', 0, NULL, 'text', '3FSE@', '3FSE@', 'Used to prevent unauthorized running of the task scheduler.', 1, 0),
(12, 'Concurrent Processes', 'cron_processes', NULL, '', 0, NULL, 'text', '2', '2', 'The maximum number of concurrent processes running tasks that are allowed.', 1, 0),
(12, 'Tasks Run per Request', 'cron_count', NULL, '', 0, NULL, 'text', '1', '1', 'The maximum number of tasks that are run during each request. If a task is determined to have done nothing, it may not count towards this number.', 1, 0),
(12, 'Time per Request', 'cron_time', NULL, '', 0, NULL, 'text', '120', '120', 'The maximum time allowed per request. This number will be automatically scaled if ini_get() can read max_execution_time from php.ini.', 1, 0),
(12, 'Process Timeout', 'cron_timeout', NULL, '', 0, NULL, 'text', '900', '900', 'The maximum time before a task is considered to have died. The task will then be reset and freed to execute again.', 1, 0),
(12, 'Concurrent Jobs', 'cron_jobs', NULL, '', 0, NULL, 'text', '3', '3', 'The maximum number of concurrently running jobs. This setting is limited by "Concurrent Processes"', 1, 0),
(12, 'Javascript Enable', 'cron_javascript', NULL, '', 0, NULL, 'checkbox', '[{"name":"Enable","value":"1","select":"1"}]', '[{"name":"Enable","value":"1","select":"1"}]', 'Cron job auto call when user go to site', 2, 0),
(14, 'Item per pages', 'topic_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(14, 'Enable Topic Plugin', 'topic_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(13, 'Item per pages', 'blog_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', 'The number of blogs to display per page', 1, 0),
(15, 'Photo item per pages', 'photo_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(15, 'Album item per pages', 'album_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(15, 'Enable Photo Plugin', 'photo_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(16, 'Enable Video Plugin', 'video_enabled', '', '', 0, '2.2.0', 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', NULL, 1, 1),
(16, 'Item per pages', 'video_item_per_pages', NULL, '', 0, '2.2.0', 'text', '10', '10', NULL, 1, 0),
(17, 'Enable Page Plugin', 'page_enabled', '', '', 0, '2.2.0', 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', NULL, 1, 1),
(18, 'Enable Event Plugin', 'event_enabled', '', '', 0, '2.2.0', 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', NULL, 1, 1),
(18, 'Item per pages', 'event_item_per_pages', NULL, '', 0, '2.2.0', 'text', '10', '10', NULL, 1, 0),
(19, 'Item per pages', 'group_item_per_pages', NULL, '', 0, NULL, 'text', '10', '10', '', 1, 0),
(19, 'Enable Group Plugin', 'group_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 1, 1),
(7, 'From Name', 'mail_name', NULL, '', 0, NULL, 'text', '', '', 'Enter the name you want the emails from the system to come from in the field below.', 1, 0),
(7, 'From Address', 'mail_from', NULL, '', 0, NULL, 'text', '', '', 'Enter the email address you want the emails from the system to come from in the field below.', 2, 0),
(7, 'Send through SMTP', 'mail_smtp', 'mail_smtp', 'Mail', 0, NULL, 'radio', '[{"name":"Use the built-in mail() function","value":"0","select":1},{"name":"Send emails through an SMTP server","value":"1","select":0}]', '[{"name":"Use the built-in mail() function","value":"0","select":1},{"name":"Send emails through an SMTP server","value":"1","select":0}]', 'Emails typically get sent through the web server using the PHP mail() function. Alternatively you can have emails sent out using SMTP, usually requiring a username and password, and optionally using an external mail server.', 5, 0),
(7, 'SMTP Host', 'mail_smtp_host', 'mail_smtp_host', 'localhost', 0, NULL, 'text', 'localhost', 'localhost', 'In some cases, you might need to include ssl:// in the hostname ', 6, 0),
(7, 'SMTP Username', 'mail_smtp_username', 'mail_smtp_username', '', 0, NULL, 'text', '', '', NULL, 8, 0),
(7, 'SMTP Password', 'mail_smtp_password', 'mail_smtp_password', '', 0, NULL, 'text', '', '', NULL, 9, 0),
(7, 'SMTP Port', 'mail_smtp_port', 'mail_smtp_port', '', 0, NULL, 'text', '', '', 'Default: 25. Also commonly on port 465 (SMTP over SSL) or port 587.', 7, 0),
(7, 'Email Queue', 'mail_queueing', 'mail_queueing', '', 0, NULL, 'radio', '[{"name":"Yes, enable email queue","value":"1","select":0},{"name":"No, always send emails immediately","value":"0","select":1}]', '[{"name":"Yes, enable email queue","value":"1","select":0},{"name":"No, always send emails immediately","value":"0","select":1}]', 'Utilizing an email queue, you can allow your website to throttle the emails being sent out to prevent overloading the mail server.', 4, 0),
(7, 'Use SSL or TLS?', 'mail_smtp_ssl', NULL, '', 0, NULL, 'radio', '[{"name":"None","value":"","select":1},{"name":"TLS","value":"tls","select":0},{"name":"SSL","value":"ssl","select":0}]', '[{"name":"None","value":"","select":1},{"name":"TLS","value":"tls","select":0},{"name":"SSL","value":"ssl","select":0}]', '', 10, 0),
(7, 'Mail Count', 'mail_count', NULL, '', 0, NULL, 'text', '25', '25', 'The number of emails to send out each time the Background Mailer task is run.', 3, 0),
(21, 'Facebook App Api', 'facebook_app_id', NULL, '1413388488948132', 0, NULL, 'text', '', '', '', 2, 0),
(21, 'Facebook App Secret', 'facebook_app_secret', NULL, '', 0, NULL, 'text', '', '', '', 3, 0),
(21, 'Scope', 'facebook_app_scope', NULL, '', 0, NULL, 'textarea', 'public_profile, email, user_friends', '', '', 4, 0),
(21, 'Return Url', 'facebook_app_return_url', NULL, '', 0, NULL, 'text', 'http://localhost/social/auths/endpoint/facebook/', '', '', 5, 0),
(21, 'SDK version', 'facebook_sdk_version', 'facebook_sdk_version', '[{"name":"5.0.0","value":"5.0.0","select":0},{"name":"3.2.3","value":"3.2.3","select":1}]', 0, NULL, 'select', '[{"name":"5.0.0","value":"5.0.0","select":0},{"name":"3.2.3","value":"3.2.3","select":1}]', '5.0.0', NULL, 6, 0),
(21, 'Enable', 'facebook_integration', 'facebook_integration', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"0","select":"1"}]', 'You must enter FB application ID and secret if you enable this', 7, 0),
(22, 'Google App Api', 'google_app_id', 'google_app_id', '', 0, NULL, 'text', '', '', '', 2, 0),
(22, 'Google Client secret', 'google_app_secret', NULL, '', 0, NULL, 'text', '', '', '', 6, 0),
(22, 'Scope', 'google_app_scope', NULL, '', 0, NULL, 'textarea', 'profile email', '', '', 7, 0),
(22, 'Return Url', 'google_app_return_url', NULL, '', 0, NULL, 'text', 'http://localhost/social/auths/endpoint/google?hauth.done=Google', '', '', 8, 0),
(22, 'Enable', 'google_integration', 'google_integration', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"0","select":"1"}]', 'You must enter Google application ID and secret if you enable this', 9, 0),
(2, 'Allow Profile Picture upload during SignUp', 'allow_upload_avatar_signup', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', '', 13, 0),
(2, 'Allow and require Profile Picture upload during SignUp', 'require_upload_avatar', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '[{"name":"","value":"1","select":"1"}]', '', 14, 0),
(2, 'Auto add friend with', 'auto_add_friend', NULL, '', 0, NULL, 'text', '', '', '', 15, 0),
(2, 'Auto Load More', 'auto_load_more', 'auto_load_more', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', NULL, 16, 0),
(2, 'Enable hashtag on activity feed', 'enable_hashtag_activity', NULL, '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', '', 17, 0),
(13, 'Enable Blog Hashtag', 'blog_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(14, 'Enable Topic Hashtag', 'topic_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(15, 'Enable Photo Hashtag', 'photo_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(16, 'Enable Video Hashtag', 'video_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(18, 'Enable Event Hashtag', 'event_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(19, 'Enable Group Hashtag', 'group_hashtag_enabled', NULL, '', 0, NULL, 'radio', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '[{"name":"Disable","value":"0","select":0},{"name":"Enable","value":"1","select":1}]', '', 2, 0),
(11, 'Enable Subscription Packages', 'enable_subscription_packages', NULL, '', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":0}]', 'Enable Subscription Packages ', 1, 0),
(11, 'Select theme', 'select_theme_subscription_packages', NULL, '', 0, NULL, 'radio', '[{"name":"Select plan basic theme","value":"0","select":1},{"name":"Select plan compare table theme","value":"1","select":0}]', '[{"name":"Select plan basic theme","value":"0","select":1},{"name":"Select plan compare table theme","value":"1","select":0}]', 'Select Theme Subscription Packages ', 1, 0),
(2, 'Enable Cookies', 'enable_cookies', 'enable_cookies', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', 'You must enter deny url if you<br>enable this.', 17, 0),
(2, 'Deny Url', 'deny_url', 'deny_url', '', 0, NULL, 'text', '', '', 'Please include protocol http:// or https://', 17, 0),
(2, 'Hide dislike', 'hide_dislike', 'hide_dislike', '0', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"0"}]', '[{"name":"","value":"1","select":"0"}]', '', 19, 0),
(2, 'Allow sending message to non-friend', 'send_message_to_non_friend', 'send_message_to_non_friend', '1', 0, NULL, 'checkbox', '[{"name":"","value":"1","select":"1"}]', '1', 'Check if users are allowed to send message to non-friend. Individual users can set option whether or not to only receive message from friend in profile setting. Otherwise, If unchecked, users can send message to friends only.', 18, 0);
CREATE TABLE IF NOT EXISTS `{PREFIX}setting_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`lft` int(11) DEFAULT NULL,
`rght` int(11) DEFAULT NULL,
`group_type` varchar(255) NOT NULL DEFAULT '',
`module_id` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `group_id` (`id`)
) DEFAULT CHARSET=utf8 ;
INSERT INTO `{PREFIX}setting_groups` (`id`, `parent_id`, `lft`, `rght`, `group_type`, `module_id`, `name`) VALUES
(1, 0, NULL, NULL, 'core', 'core', 'General'),
(2, 0, NULL, NULL, 'core', 'core', 'Features'),
(3, 0, NULL, NULL, 'core', 'core', 'Security'),
(4, 0, NULL, NULL, 'core', 'core', 'Custom Blocks'),
(5, 0, NULL, NULL, 'core', 'core', 'Intergration'),
(6, 0, NULL, NULL, 'core', 'core', 'Logo'),
(7, 0, NULL, NULL, 'core', 'Mail', 'Mail'),
(9, 0, NULL, NULL, 'core', 'core', 'System Mode'),
(10, 0, NULL, NULL, 'core', 'Billing', 'Billing'),
(11, 0, NULL, NULL, 'core', 'Subscription', 'Subscription'),
(12, 0, NULL, NULL, 'core', 'Cron', 'Cron'),
(13, 0, NULL, NULL, 'Blog', 'Blog', 'Blog'),
(14, 0, NULL, NULL, 'Topic', 'Topic', 'Topic'),
(15, 0, NULL, NULL, 'Photo', 'Photo', 'Photo'),
(16, 0, NULL, NULL, 'Video', 'Video', 'Video'),
(17, 0, NULL, NULL, 'Page', 'Page', 'Page'),
(18, 0, NULL, NULL, 'Event', 'Event', 'Event'),
(19, 0, NULL, NULL, 'Group', 'Group', 'Group'),
(20,0,NULL,NULL,'SocialIntegration','SocialIntegration','Social Integration'),
(21,20,NULL,NULL,'FacebookIntegration','FacebookIntegration','Facebook Integration'),
(22,20,NULL,NULL,'GoogleIntegration','GoogleIntegration','Google Integration');
CREATE TABLE IF NOT EXISTS `{PREFIX}themes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`core` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT IGNORE `{PREFIX}themes` (`id`, `key`, `name`, `core`) VALUES
(1, 'default', 'Default Theme', 1);
CREATE TABLE IF NOT EXISTS `{PREFIX}core_blocks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(75) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`path_view` varchar(75) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`params` text NOT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
`plugin_id` int(11) NOT NULL DEFAULT '0',
`group` varchar(75) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`restricted` text NOT NULL,
`plugin` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `is_active` (`is_active`)
) ;
INSERT INTO `{PREFIX}core_blocks` (`id`, `name`, `path_view`, `params`, `is_active`, `plugin_id`, `group`, `restricted`, `plugin`) VALUES
(1, 'Who''s Online', 'user.onlineUsers', '{"0":{"label":"Title","input":"text","value":"Who''s Online","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Show member only","name":"member_only"},"3":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '', ''),
(4, 'Recently Joined', 'user.recentlyJoined', '{"0":{"label":"Title","input":"text","value":"Recently Joined","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '', ''),
(5, 'Tags', 'core.tags', '{"0":{"label":"Title","input":"text","value":"Tags","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Type","input":"select","value":{"all":"all","activities":"activity","comments":"comment","blogs":"blog","albums":"album","photos":"photo","topics":"topic","events":"event","videos":"video","groups":"group"},"name":"type"},"3":{"label":"Order by","input":"select","value":{"newest":"Newest","popular":"Popular","random":"Random"},"name":"order_by"},"4":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', '', ''),
(6, 'What''s New ', 'ajax.home_activity', '{"0":{"label":"Title","input":"text","value":"What''s new","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, '', 'home.landing', ''),
(7, 'Friends', 'user.friend', '{"0":{"label":"Title","input":"text","value":"Friends","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '', ''),
(8, 'Upcoming Events', 'events.upcoming', '{"0":{"label":"Title","input":"text","value":"Upcoming Events","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}', 1, 0, 'event', '', 'Event'),
(9, 'My Joined Groups', 'groups.myJoined', '{"0":{"label":"Title","input":"text","value":"My Joined Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}', 1, 0, 'group', '', 'Group'),
(10, 'Login', 'user.login', '{"0":{"label":"Title","input":"text","value":"Login","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'landing', 'home.landing', ''),
(11, 'Sign up', 'user.signup', '{"0":{"label":"Title","input":"text","value":"Sign up","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'landing', 'home.landing', ''),
(14, 'Popular Blogs', 'blogs.popular', '{"0":{"label":"Title","input":"text","value":"Popular Blogs","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Blog","name":"plugin"}}', 1, 0, 'blogs', '', 'Blog'),
(15, 'Popular Albums ', 'photos.popularAlbums', '{"0":{"label":"Title","input":"text","value":"Popular Albums","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Photo","name":"plugin"}}', 1, 0, 'photo', '', 'Photo'),
(16, 'Popular Videos', 'videos.popular', '{"0":{"label":"Title","input":"text","value":"Popular Videos","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Video","name":"plugin"}}', 1, 0, 'video', '', 'Video'),
(17, 'Popular Topics', 'topics.popular', '{"0":{"label":"Title","input":"text","value":"Popular Topics","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Topic","name":"plugin"}}', 1, 0, 'topic', '', 'Topic'),
(18, 'Popular Groups', 'groups.popular', '{"0":{"label":"Title","input":"text","value":"Popular Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}', 1, 0, 'group', '', 'Group'),
(19, 'Popular Events', 'events.popular', '{"0":{"label":"Title","input":"text","value":"Popular Events","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}', 1, 0, 'event', '', 'Event'),
(21, 'Mutual Friends', 'user.mutualFriends', '{"0":{"label":"Title","input":"text","value":"Mutual Friends","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', 'users.view', ''),
(49, 'Featured Members', 'user.featured', '{"0":{"label":"Title","input":"text","value":"Featured Members","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '', ''),
(51, 'Group Admin', 'groups.adminList', '{"0":{"label":"Title","input":"text","value":"Admin","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}', 1, 0, 'group', 'groups.view', 'Group'),
(52, 'Group Members', 'groups.memberList', '{"0":{"label":"Title","input":"text","value":"Members","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}', 1, 0, 'group', 'groups.view', 'Group'),
(53, 'People You Might Know', 'user.suggestions', '{"0":{"label":"Title","input":"text","value":"People You Might Know","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '', ''),
(54, 'RSVP', 'events.rsvp', '{"0":{"label":"Title","input":"text","value":"RSVP","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"2":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}', 1, 0, 'events', 'events.view', 'Event'),
(55, 'Event Attending', 'events.attending', '{"0":{"label":"Title","input":"text","value":"Event Attending","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"2":{"label":"plugin","input":"hidden","value":"Event","name":"plugin"}}', 1, 0, 'events', 'events.view', 'Event'),
(56, 'HTML Block', 'htmlBlock', '{"0":{"label":"Title","input":"text","value":"HTML Block","name":"title"},"1":{"label":"Html Content","input":"textarea","value":"","name":"html_block"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', '', ''),
(57, 'Today''s Birthday', 'birthdayBlock', '{"0":{"label":"Title","input":"text","value":"Today''s Birthday","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'user', '', ''),
(58, 'Themes & Languages', 'theme_lang', '{"0":{"label":"Title","input":"text","value":"Themes & Languages","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', '', ''),
(59, 'User Menu', 'welcomeBox', '{"0":{"label":"Title","input":"text","value":"User Menu","name":"title"},"1":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"}}', 1, 0, 'core', 'home.index', ''),
(60, 'Main Menu', 'menu.widget', '[{"label":"Title","input":"text","value":"Main Menu","name":"title"},{"label":"Plugin","input":"hidden","value":"Menu","name":"plugin"},{"label":"Menu ID","input":"hidden","value":"1","name":"menu_id"}]', 1, 0, 'menu', '', 'Menu'),
(61, 'Footer Menu', 'menu.widget', '[{"label":"Title","input":"text","value":"Footer Menu","name":"title"},{"label":"Plugin","input":"hidden","value":"Menu","name":"plugin"},{"label":"Menu ID","input":"hidden","value":"2","name":"menu_id"}]', 1, 0, 'menu', '', 'Menu'),
(62, 'Featured Groups', 'groups.featured', '{"0":{"label":"Title","input":"text","value":"Featured Groups","name":"title"},"1":{"label":"Number of item to show","input":"text","value":"10","name":"num_item_show"},"2":{"label":"Title","input":"checkbox","value":"Enable Title","name":"title_enable"},"3":{"label":"plugin","input":"hidden","value":"Group","name":"plugin"}}', 1, 0, 'group', '', 'Group');
CREATE TABLE IF NOT EXISTS `{PREFIX}core_contents` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`page_id` int(11) unsigned NOT NULL DEFAULT '0',
`type` enum('container','widget') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'widget',
`name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`component` varchar(64) NOT NULL DEFAULT '',
`parent_id` int(11) unsigned DEFAULT NULL,
`order` int(11) NOT NULL DEFAULT '1',
`params` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`attribs` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`lft` int(11) unsigned DEFAULT NULL,
`rght` int(10) unsigned DEFAULT NULL,
`column` tinyint(1) unsigned NOT NULL DEFAULT '0',
`core_block_id` int(11) unsigned NOT NULL DEFAULT '0',
`core_content_count` int(11) unsigned NOT NULL DEFAULT '0',
`invisible` int(1) NOT NULL DEFAULT '0',
`core_block_title` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`plugin` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `page_id` (`page_id`,`order`)
);
INSERT INTO `{PREFIX}core_contents` (`id`, `page_id`, `type`, `name`, `component`, `parent_id`, `order`, `params`, `attribs`, `lft`, `rght`, `column`, `core_block_id`, `core_content_count`, `invisible`, `core_block_title`, `plugin`) VALUES
(1, 1, 'container', 'west', '', NULL, 1, NULL, NULL, 1, 10, 0, 0, 4, 0, '', ''),
(2, 1, 'widget', 'welcomeBox', '', 1, 1, '{"title":"Home Menu"}', NULL, 2, 3, 0, 59, 0, 0, '', ''),
(3, 1, 'container', 'east', '', NULL, 1, NULL, NULL, 11, 24, 0, 0, 6, 0, '', ''),
(4, 1, 'widget', 'theme_lang', '', 3, 6, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 12, 13, 0, 58, 0, 0, '', ''),
(5, 1, 'container', 'center', '', NULL, 1, NULL, NULL, 25, 30, 0, 0, 2, 0, '', ''),
(6, 1, 'widget', 'ajax.home_activity', '', 5, 2, '{"title":"What''s New","title_enable":"1"}', NULL, 26, 27, 0, 6, 0, 0, '', ''),
(8, 1, 'widget', 'groups.myJoined', '', 1, 2, '{"title":"My Joined Groups","num_item_show":"4","title_enable":"1","plugin":"Group"}', NULL, 4, 5, 0, 9, 0, 0, '', 'Group'),
(10, 1, 'widget', 'photos.popularAlbums', '', 1, 3, '{"title":"Popular Albums","num_item_show":"5","title_enable":"1","plugin":"Photo"}', NULL, 6, 7, 0, 15, 0, 0, '', 'Photo'),
(13, 1, 'widget', 'events.popular', '', 1, 4, '{"title":"Popular Events","num_item_show":"5","title_enable":"1","plugin":"Event"}', NULL, 8, 9, 0, 19, 0, 0, '', 'Event'),
(14, 1, 'widget', 'user.onlineUsers', '', 3, 1, '{"title":"Who''s Online","num_item_show":"10","member_only":"1","title_enable":"1"}', NULL, 14, 15, 0, 1, 0, 0, '', ''),
(18, 1, 'widget', 'user.suggestions', '', 3, 3, '{"title":"People You Might Know","num_item_show":"10","title_enable":"1"}', NULL, 16, 17, 0, 53, 0, 0, '', ''),
(19, 2, 'container', 'east', '', NULL, 1, NULL, NULL, 31, 34, 0, 0, 1, 0, '', ''),
(20, 2, 'widget', 'theme_lang', '', 19, 1, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 32, 33, 0, 58, 0, 0, '', ''),
(21, 2, 'container', 'center', '', NULL, 1, NULL, NULL, 35, 38, 0, 0, 1, 0, '', ''),
(22, 2, 'widget', 'invisiblecontent', '', 21, 1, '{"title":"Contact","maincontent":"1"}', NULL, 36, 37, 0, 1, 0, 0, '', ''),
(23, 3, 'container', 'west', '', NULL, 1, NULL, NULL, 39, 46, 0, 0, 3, 0, '', ''),
(24, 3, 'widget', 'invisiblecontent', '', 23, 1, '{"title":"Menu Friend Search","maincontent":"1"}', NULL, 40, 41, 0, 1, 0, 0, '', ''),
(25, 3, 'container', 'east', '', NULL, 1, NULL, NULL, 47, 48, 0, 0, 0, 0, '', ''),
(27, 3, 'container', 'center', '', NULL, 1, NULL, NULL, 49, 52, 0, 0, 1, 0, '', ''),
(28, 3, 'widget', 'invisiblecontent', '', 27, 1, '{"title":"People","maincontent":"1"}', NULL, 50, 51, 0, 4, 0, 0, '', ''),
(29, 4, 'container', 'west', '', NULL, 1, NULL, NULL, 53, 58, 0, 0, 2, 0, '', ''),
(30, 4, 'widget', 'invisiblecontent', '', 29, 1, '{"title":"Profile menu & Users","maincontent":"1"}', NULL, 54, 55, 0, 1, 0, 0, '', ''),
(31, 4, 'container', 'center', '', NULL, 1, NULL, NULL, 59, 62, 0, 0, 1, 0, '', ''),
(32, 4, 'widget', 'invisiblecontent', '', 31, 1, '{"title":"Recent Activities","maincontent":"1"}', NULL, 60, 61, 0, 4, 0, 0, '', ''),
(34, 6, 'container', 'west', '', NULL, 1, NULL, NULL, 63, 68, 0, 0, 2, 0, '', ''),
(35, 6, 'widget', 'invisiblecontent', '', 34, 1, '{"title":"Blogs menu & Search","maincontent":"1"}', NULL, 64, 65, 0, 1, 0, 0, '', ''),
(36, 6, 'container', 'east', '', NULL, 1, NULL, NULL, 69, 74, 0, 0, 2, 0, '', ''),
(37, 6, 'widget', 'theme_lang', '', 36, 2, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 70, 71, 0, 58, 0, 0, '', ''),
(38, 6, 'container', 'center', '', NULL, 1, NULL, NULL, 75, 78, 0, 0, 1, 0, '', ''),
(39, 6, 'widget', 'invisiblecontent', '', 38, 1, '{"title":"Blogs","maincontent":"1"}', NULL, 76, 77, 0, 4, 0, 0, '', ''),
(42, 8, 'container', 'west', '', NULL, 1, NULL, NULL, 79, 84, 0, 0, 2, 0, '', ''),
(43, 8, 'widget', 'invisiblecontent', '', 42, 1, '{"title":"Blogs settings","maincontent":"1"}', NULL, 80, 81, 0, 1, 0, 0, '', ''),
(44, 8, 'container', 'east', '', NULL, 1, NULL, NULL, 85, 88, 0, 0, 1, 0, '', ''),
(45, 8, 'widget', 'invisiblecontent', '', 44, 1, '{"title":"Other Entries","maincontent":"1"}', NULL, 86, 87, 0, 5, 0, 0, '', ''),
(46, 8, 'container', 'center', '', NULL, 1, NULL, NULL, 89, 92, 0, 0, 1, 0, '', ''),
(47, 8, 'widget', 'invisiblecontent', '', 46, 1, '{"title":"Blog Detail","maincontent":"1"}', NULL, 90, 91, 0, 4, 0, 0, '', ''),
(48, 9, 'container', 'west', '', NULL, 1, NULL, NULL, 93, 100, 0, 0, 3, 0, '', ''),
(49, 9, 'widget', 'invisiblecontent', '', 48, 1, '{"title":"List photos & Search","maincontent":"1"}', NULL, 94, 95, 0, 1, 0, 0, '', ''),
(50, 9, 'container', 'center', '', NULL, 1, NULL, NULL, 101, 104, 0, 0, 1, 0, '', ''),
(51, 9, 'widget', 'invisiblecontent', '', 50, 1, '{"title":"Photos","maincontent":"1"}', NULL, 102, 103, 0, 4, 0, 0, '', ''),
(52, 9, 'widget', 'photos.popularAlbums', '', 48, 3, '{"title":"Popular Albums","num_item_show":"5","title_enable":"1","plugin":"Photo"}', NULL, 96, 97, 0, 15, 0, 0, '', 'Photo'),
(53, 10, 'container', 'east', '', NULL, 1, NULL, NULL, 105, 106, 0, 0, 0, 0, '', ''),
(55, 10, 'container', 'center', '', NULL, 1, NULL, NULL, 107, 110, 0, 0, 1, 0, '', ''),
(56, 10, 'widget', 'invisiblecontent', '', 55, 1, '{"title":"Album''s photos","maincontent":"1"}', NULL, 108, 109, 0, 1, 0, 0, '', ''),
(57, 11, 'container', 'center', '', NULL, 1, NULL, NULL, 111, 114, 0, 0, 1, 0, '', ''),
(58, 11, 'widget', 'invisiblecontent', '', 57, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 112, 113, 0, 1, 0, 0, '', ''),
(61, 12, 'container', 'west', '', NULL, 1, NULL, NULL, 115, 122, 0, 0, 3, 0, '', ''),
(62, 12, 'widget', 'invisiblecontent', '', 61, 1, '{"title":"Menu video & Search","maincontent":"1"}', NULL, 116, 117, 0, 1, 0, 0, '', ''),
(63, 12, 'container', 'east', '', NULL, 1, NULL, NULL, 123, 124, 0, 0, 0, 0, '', ''),
(65, 12, 'container', 'center', '', NULL, 1, NULL, NULL, 125, 128, 0, 0, 1, 0, '', ''),
(66, 12, 'widget', 'invisiblecontent', '', 65, 1, '{"title":"Videos","maincontent":"1"}', NULL, 126, 127, 0, 4, 0, 0, '', ''),
(67, 12, 'widget', 'videos.popular', '', 61, 3, '{"title":"Popular Videos","num_item_show":"10","title_enable":"1","plugin":"Video"}', NULL, 118, 119, 0, 16, 0, 0, '', 'Video'),
(68, 13, 'container', 'east', '', NULL, 1, NULL, NULL, 129, 134, 0, 0, 2, 0, '', ''),
(69, 13, 'widget', 'invisiblecontent', '', 68, 1, '{"title":"Tags & Similar Videos","maincontent":"1"}', NULL, 130, 131, 0, 4, 0, 0, '', ''),
(70, 13, 'container', 'center', '', NULL, 1, NULL, NULL, 135, 138, 0, 0, 1, 0, '', ''),
(71, 13, 'widget', 'invisiblecontent', '', 70, 1, '{"title":"Video''s content","maincontent":"1"}', NULL, 136, 137, 0, 1, 0, 0, '', ''),
(72, 15, 'container', 'west', '', NULL, 1, NULL, NULL, 139, 144, 0, 0, 2, 0, '', ''),
(73, 15, 'widget', 'invisiblecontent', '', 72, 1, '{"title":"Topic''s setting","maincontent":"1"}', NULL, 140, 141, 0, 1, 0, 0, '', ''),
(74, 15, 'container', 'east', '', NULL, 1, NULL, NULL, 145, 146, 0, 0, 0, 0, '', ''),
(76, 15, 'container', 'center', '', NULL, 1, NULL, NULL, 147, 150, 0, 0, 1, 0, '', ''),
(77, 15, 'widget', 'invisiblecontent', '', 76, 1, '{"title":"Topics contents","maincontent":"1"}', NULL, 148, 149, 0, 4, 0, 0, '', ''),
(78, 15, 'widget', 'core.tags', '', 72, 2, '{"title":"Tags","num_item_show":"10","type":"topics","order_by":"newest","title_enable":"1"}', NULL, 142, 143, 0, 5, 0, 0, '', ''),
(80, 16, 'container', 'west', '', NULL, 1, NULL, NULL, 151, 156, 0, 0, 2, 0, '', ''),
(81, 16, 'widget', 'invisiblecontent', '', 80, 1, '{"title":"Groups menu & Search","maincontent":"1"}', NULL, 152, 153, 0, 1, 0, 0, '', ''),
(82, 16, 'container', 'east', '', NULL, 1, NULL, NULL, 157, 162, 0, 0, 2, 0, '', ''),
(83, 16, 'widget', 'theme_lang', '', 82, 2, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 158, 159, 0, 58, 0, 0, '', ''),
(84, 16, 'container', 'center', '', NULL, 1, NULL, NULL, 163, 166, 0, 0, 1, 0, '', ''),
(85, 16, 'widget', 'invisiblecontent', '', 84, 1, '{"title":"Groups","maincontent":"1"}', NULL, 164, 165, 0, 4, 0, 0, '', ''),
(86, 18, 'container', 'west', '', NULL, 1, NULL, NULL, 167, 170, 0, 0, 1, 0, '', ''),
(87, 18, 'widget', 'invisiblecontent', '', 86, 1, '{"title":"Group info & setting","maincontent":"1"}', NULL, 168, 169, 0, 1, 0, 0, '', ''),
(88, 18, 'container', 'east', '', NULL, 1, NULL, NULL, 171, 180, 0, 0, 4, 0, '', ''),
(89, 18, 'widget', 'theme_lang', '', 88, 4, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 172, 173, 0, 58, 0, 0, '', ''),
(90, 18, 'container', 'center', '', NULL, 1, NULL, NULL, 181, 184, 0, 0, 1, 0, '', ''),
(91, 18, 'widget', 'invisiblecontent', '', 90, 1, '{"title":"Info & Photos & Recent Activities","maincontent":"1"}', NULL, 182, 183, 0, 4, 0, 0, '', ''),
(94, 19, 'container', 'west', '', NULL, 1, NULL, NULL, 185, 188, 0, 0, 1, 0, '', ''),
(95, 19, 'widget', 'invisiblecontent', '', 94, 1, '{"title":"Events menu & Search","maincontent":"1"}', NULL, 186, 187, 0, 1, 0, 0, '', ''),
(96, 19, 'container', 'east', '', NULL, 1, NULL, NULL, 189, 194, 0, 0, 2, 0, '', ''),
(97, 19, 'widget', 'theme_lang', '', 96, 2, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 190, 191, 0, 58, 0, 0, '', ''),
(98, 19, 'container', 'center', '', NULL, 1, NULL, NULL, 195, 198, 0, 0, 1, 0, '', ''),
(99, 19, 'widget', 'invisiblecontent', '', 98, 1, '{"title":"Events","maincontent":"1"}', NULL, 196, 197, 0, 4, 0, 0, '', ''),
(101, 21, 'container', 'west', '', NULL, 1, NULL, NULL, 199, 204, 0, 0, 2, 0, '', ''),
(102, 21, 'widget', 'invisiblecontent', '', 101, 1, '{"title":"Event''s setting","maincontent":"1"}', NULL, 200, 201, 0, 1, 0, 0, '', ''),
(103, 21, 'container', 'east', '', NULL, 1, NULL, NULL, 205, 212, 0, 0, 3, 0, '', ''),
(104, 21, 'widget', 'theme_lang', '', 103, 3, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 206, 207, 0, 58, 0, 0, '', ''),
(105, 21, 'container', 'center', '', NULL, 1, NULL, NULL, 213, 216, 0, 0, 1, 0, '', ''),
(106, 21, 'widget', 'invisiblecontent', '', 105, 1, '{"title":"Event''s detail & Message","maincontent":"1"}', NULL, 214, 215, 0, 4, 0, 0, '', ''),
(109, 22, 'container', 'east', '', NULL, 1, NULL, NULL, 217, 218, 0, 0, 0, 0, '', ''),
(111, 22, 'container', 'center', '', NULL, 1, NULL, NULL, 219, 222, 0, 0, 1, 0, '', ''),
(112, 22, 'widget', 'invisiblecontent', '', 111, 1, '{"title":"Forgot Password","maincontent":"1"}', NULL, 220, 221, 0, 1, 0, 0, '', ''),
(113, 23, 'container', 'west', '', NULL, 1, NULL, NULL, 223, 228, 0, 0, 2, 0, '', ''),
(114, 23, 'widget', 'invisiblecontent', '', 113, 1, '{"title":"Topics menu & Search","maincontent":"1"}', NULL, 224, 225, 0, 1, 0, 0, '', ''),
(115, 23, 'container', 'east', '', NULL, 1, NULL, NULL, 229, 234, 0, 0, 2, 0, '', ''),
(116, 23, 'widget', 'theme_lang', '', 115, 2, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 230, 231, 0, 58, 0, 0, '', ''),
(117, 23, 'container', 'center', '', NULL, 1, NULL, NULL, 235, 238, 0, 0, 1, 0, '', ''),
(118, 23, 'widget', 'invisiblecontent', '', 117, 1, '{"title":"Topics","maincontent":"1"}', NULL, 236, 237, 0, 4, 0, 0, '', ''),
(119, 63, 'container', 'east', '', NULL, 1, NULL, NULL, 239, 250, 0, 0, 5, 0, '', ''),
(120, 63, 'widget', 'theme_lang', '', 119, 5, '{"title":"Themes & Languages","title_enable":"1"}', NULL, 240, 241, 0, 58, 0, 0, '', ''),
(121, 63, 'container', 'west', '', NULL, 1, NULL, NULL, 251, 258, 0, 0, 3, 0, '', ''),
(122, 63, 'widget', 'events.upcoming', '', 121, 2, '{"title":"Upcoming Events","num_item_show":"5","title_enable":"1","plugin":"Event"}', NULL, 252, 253, 0, 8, 0, 0, '', 'Event'),
(125, 63, 'widget', 'photos.popularAlbums', '', 121, 3, '{"title":"Popular Albums","num_item_show":"5","title_enable":"1","plugin":"Photo"}', NULL, 254, 255, 0, 15, 0, 0, '', 'Photo'),
(132, 63, 'widget', 'user.onlineUsers', '', 119, 1, '{"title":"Who''s Online","num_item_show":"10","member_only":"1","title_enable":"1"}', NULL, 242, 243, 0, 1, 0, 0, '', ''),
(133, 63, 'widget', 'user.recentlyJoined', '', 119, 2, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 244, 245, 0, 4, 0, 0, '', ''),
(137, 63, 'container', 'center', '', NULL, 1, NULL, NULL, 259, 262, 0, 0, 1, 0, '', ''),
(139, 63, 'widget', 'ajax.home_activity', '', 137, 1, '{"title":"What''s new","title_enable":"1"}', NULL, 260, 261, 0, 6, 0, 0, '', ''),
(140, 90, 'container', 'center', '', NULL, 1, NULL, NULL, 263, 266, 0, 0, 1, 0, '', ''),
(141, 90, 'widget', 'invisiblecontent', '', 140, 1, '{"title":"Login form","maincontent":"1"}', NULL, 264, 265, 0, 1, 0, 0, '', ''),
(142, 96, 'container', 'center', '', NULL, 1, NULL, NULL, 267, 270, 0, 0, 1, 0, '', ''),
(143, 96, 'widget', 'invisiblecontent', '', 142, 1, '{"title":"Register Form","maincontent":"1"}', NULL, 268, 269, 0, 1, 0, 0, '', ''),
(145, 1, 'widget', 'birthdayBlock', '', 3, 2, '{"title":"Today''s Birthday","title_enable":"1"}', NULL, 18, 19, 0, 57, 0, 0, '', ''),
(146, 100, 'container', 'center', '', NULL, 1, NULL, NULL, 271, 274, 0, 0, 1, 0, '', NULL),
(147, 100, 'widget', 'invisiblecontent', '', 146, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 272, 273, 0, 0, 0, 0, '', NULL),
(148, 101, 'container', 'center', '', NULL, 1, NULL, NULL, 275, 278, 0, 0, 1, 0, '', NULL),
(149, 101, 'widget', 'invisiblecontent', '', 148, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 276, 277, 0, 0, 0, 0, '', NULL),
(150, 102, 'container', 'center', '', NULL, 1, NULL, NULL, 279, 282, 0, 0, 1, 0, '', NULL),
(151, 102, 'widget', 'invisiblecontent', '', 150, 1, '{"title":"Page Content","maincontent":"1"}', NULL, 280, 281, 0, 0, 0, 0, '', NULL),
(152, 69, 'container', 'footer', '', NULL, 1, NULL, NULL, 283, 286, 0, 0, 1, 0, '', NULL),
(153, 69, 'widget', 'menu.widget', '', 152, 1, '{"title":"Footer Menu","plugin":"Menu","menu_id":"2"}', NULL, 284, 285, 0, 61, 0, 0, 'Footer Menu', 'Menu'),
(154, 63, 'widget', 'user.login', '', 121, 1, '{"title":"Login","title_enable":"1"}', NULL, 256, 257, 0, 10, 0, 0, 'Login', ''),
(155, 63, 'widget', 'videos.popular', '', 119, 3, '{"title":"Popular Videos","num_item_show":"3","title_enable":"1","plugin":"Video"}', NULL, 246, 247, 0, 16, 0, 0, 'Popular Videos', 'Video'),
(156, 63, 'widget', 'blogs.popular', '', 119, 4, '{"title":"Popular Blogs","num_item_show":"5","title_enable":"1","plugin":"Blog"}', NULL, 248, 249, 0, 14, 0, 0, 'Popular Blogs', 'Blog'),
(157, 1, 'widget', 'videos.popular', '', 3, 4, '{"title":"Popular Videos","num_item_show":"4","title_enable":"1","plugin":"Video"}', NULL, 20, 21, 0, 16, 0, 0, 'Popular Videos', 'Video'),
(158, 1, 'widget', 'blogs.popular', '', 3, 5, '{"title":"Popular Blogs","num_item_show":"5","title_enable":"1","plugin":"Blog"}', NULL, 22, 23, 0, 14, 0, 0, 'Popular Blogs', 'Blog'),
(159, 1, 'widget', 'user.recentlyJoined', '', 5, 1, '{"title":"Recently Joined","num_item_show":"10","title_enable":"1"}', NULL, 28, 29, 0, 4, 0, 0, 'Recently Joined', ''),
(160, 3, 'widget', 'user.suggestions', '', 23, 2, '{"title":"People You Might Know","num_item_show":"10","title_enable":"1"}', NULL, 42, 43, 0, 53, 0, 0, 'People You Might Know', ''),
(161, 3, 'widget', 'user.featured', '', 23, 3, '{"title":"Featured Members","num_item_show":"10","title_enable":"1"}', NULL, 44, 45, 0, 49, 0, 0, 'Featured Members', ''),
(162, 6, 'widget', 'core.tags', '', 34, 2, '{"title":"Tags","num_item_show":"10","type":"blogs","order_by":"newest","title_enable":"1"}', NULL, 66, 67, 0, 5, 0, 0, 'Tags', ''),
(163, 6, 'widget', 'blogs.popular', '', 36, 1, '{"title":"Popular Blogs","num_item_show":"10","title_enable":"1","plugin":"Blog"}', NULL, 72, 73, 0, 14, 0, 0, 'Popular Blogs', 'Blog'),
(164, 8, 'widget', 'blogs.popular', '', 42, 2, '{"title":"Popular Blogs","num_item_show":"5","title_enable":"1","plugin":"Blog"}', NULL, 82, 83, 0, 14, 0, 0, 'Popular Blogs', 'Blog'),
(165, 9, 'widget', 'core.tags', '', 48, 2, '{"title":"Tags","num_item_show":"10","type":"albums","order_by":"newest","title_enable":"1"}', NULL, 98, 99, 0, 5, 0, 0, 'Tags', ''),
(166, 13, 'widget', 'videos.popular', '', 68, 2, '{"title":"Popular Videos","num_item_show":"5","title_enable":"1","plugin":"Video"}', NULL, 132, 133, 0, 16, 0, 0, 'Popular Videos', 'Video'),
(167, 23, 'widget', 'core.tags', '', 113, 2, '{"title":"Tags","num_item_show":"10","type":"topics","order_by":"newest","title_enable":"1"}', NULL, 226, 227, 0, 5, 0, 0, 'Tags', ''),
(168, 23, 'widget', 'topics.popular', '', 115, 1, '{"title":"Popular Topics","num_item_show":"10","title_enable":"1","plugin":"Topic"}', NULL, 232, 233, 0, 17, 0, 0, 'Popular Topics', 'Topic'),
(169, 16, 'widget', 'groups.myJoined', '', 80, 2, '{"title":"My Joined Groups","num_item_show":"5","title_enable":"1","plugin":"Group"}', NULL, 154, 155, 0, 9, 0, 0, 'My Joined Groups', 'Group'),
(170, 16, 'widget', 'groups.popular', '', 82, 1, '{"title":"Popular Groups","num_item_show":"10","title_enable":"1","plugin":"Group"}', NULL, 160, 161, 0, 18, 0, 0, 'Popular Groups', 'Group'),
(171, 18, 'widget', 'groups.adminList', '', 88, 1, '{"title":"Group Admin","num_item_show":"10","title_enable":"Enable Title","plugin":"Group"}', NULL, 174, 175, 0, 51, 0, 0, 'Group Admin', 'Group'),
(172, 18, 'widget', 'groups.memberList', '', 88, 2, '{"title":"Group Members","num_item_show":"10","title_enable":"Enable Title","plugin":"Group"}', NULL, 176, 177, 0, 52, 0, 0, 'Group Members', 'Group'),
(173, 18, 'widget', 'groups.popular', '', 88, 3, '{"title":"Popular Groups","num_item_show":"5","title_enable":"","plugin":"Group"}', NULL, 178, 179, 0, 18, 0, 0, 'Popular Groups', 'Group'),
(174, 19, 'widget', 'events.upcoming', '', 96, 1, '{"title":"Upcoming Events","num_item_show":"10","title_enable":"1","plugin":"Event"}', NULL, 192, 193, 0, 8, 0, 0, 'Upcoming Events', 'Event'),
(175, 4, 'widget', 'user.suggestions', '', 29, 2, '{"title":"People You Might Know","num_item_show":"10","title_enable":"1"}', NULL, 56, 57, 0, 53, 0, 0, 'People You Might Know', ''),
(176, 12, 'widget', 'core.tags', '', 61, 2, '{"title":"Tags","num_item_show":"10","type":"videos","order_by":"newest","title_enable":"1"}', NULL, 120, 121, 0, 5, 0, 0, 'Tags', ''),
(177, 21, 'widget', 'events.popular', '', 101, 2, '{"title":"Popular Events","num_item_show":"10","title_enable":"Enable Title","plugin":"Event"}', NULL, 202, 203, 0, 19, 0, 0, 'Popular Events', 'Event'),
(178, 21, 'widget', 'events.rsvp', '', 103, 1, '{"title":"RSVP","title_enable":"Enable Title","plugin":"Event"}', NULL, 208, 209, 0, 54, 0, 0, 'RSVP', 'Event'),
(179, 21, 'widget', 'events.attending', '', 103, 2, '{"title":"Event Attending","title_enable":"Enable Title","plugin":"Event"}', NULL, 210, 211, 0, 55, 0, 0, 'Event Attending', 'Event');
CREATE TABLE IF NOT EXISTS `{PREFIX}activity_fetch_videos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`source` char(10) DEFAULT NULL,
`source_id` varchar(300) DEFAULT NULL,
`title` varchar(300) DEFAULT NULL,
`description` text,
`thumb` varchar(300) DEFAULT NULL,
`activity_id` int(11) NOT NULL DEFAULT '0',
`category_id` int(11) DEFAULT NULL,
`privacy` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}currencies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`currency_code` varchar(3) NOT NULL DEFAULT '',
`symbol` varchar(15) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`description` text,
`ordering` mediumint(8) unsigned NOT NULL DEFAULT '0',
`is_default` tinyint(1) NOT NULL DEFAULT '0',
`is_active` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
INSERT INTO `{PREFIX}currencies`(`id`,`currency_code`,`symbol`,`name`,`description`,`ordering`,`is_default`,`is_active`) VALUES
(1,'HKD','HK$','Hong Kong Dollar','',0,0,1),
(2,'SGD','SGD$','Singapore Dollar','',0,0,1),
(3,'CHF','Fr','Swiss Franc','',0,0,1),
(4,'CNY','Â¥','Chinese Yuan','',0,0,0),
(5,'AUD','A$','Australian Dollar',NULL,0,0,1),
(6,'CAD','C$','Canadian Dollar',NULL,0,0,1),
(7,'JPY','Â¥','Japanese Yen','This currency does not support decimals. Passing a decimal amount will throw an error.',0,0,1),
(8,'GBP','£','Pound Sterling ','',0,0,1),
(9,'EUR','€','Euro','',0,0,1),
(10,'USD','$','U.S. Dollar ','',0,1,1);
CREATE TABLE IF NOT EXISTS `{PREFIX}gateways` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL DEFAULT '',
`description` text,
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
`plugin` varchar(128) NOT NULL DEFAULT '',
`test_mode` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ipn_log` tinyint(1) unsigned NOT NULL DEFAULT '0',
`config` text NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `{PREFIX}gateways`(`id`,`name`,`description`,`enabled`,`plugin`,`test_mode`,`ipn_log`,`config`) VALUES
(1,'PayPal Adaptive','PayPal Adaptive',0,'PaypalAdaptive',0,0,'');
CREATE TABLE IF NOT EXISTS `{PREFIX}tasks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`plugin` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`timeout` int(11) unsigned NOT NULL DEFAULT '60',
`processes` smallint(3) unsigned NOT NULL DEFAULT '1',
`semaphore` smallint(3) NOT NULL DEFAULT '0',
`started_last` int(11) NOT NULL DEFAULT '0',
`started_count` int(11) unsigned NOT NULL DEFAULT '0',
`completed_last` int(11) NOT NULL DEFAULT '0',
`completed_count` int(11) unsigned NOT NULL DEFAULT '0',
`failure_last` int(11) NOT NULL DEFAULT '0',
`failure_count` int(11) unsigned NOT NULL DEFAULT '0',
`success_last` int(11) NOT NULL DEFAULT '0',
`success_count` int(11) unsigned NOT NULL DEFAULT '0',
`enable` tinyint(1) NOT NULL DEFAULT '0',
`class` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `started_last` (`started_last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
INSERT INTO `{PREFIX}tasks` (`id`, `title`, `plugin`, `timeout`, `processes`, `semaphore`, `started_last`, `started_count`, `completed_last`, `completed_count`, `failure_last`, `failure_count`, `success_last`, `success_count`, `enable`, `class`) VALUES
(1, 'Job Queue', 'Cron', 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Cron_Task_Jobs'),
(2, 'Subscription', 'Subscription', 600, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Subscription_Task_Subscription'),
(3,'Background Mailer', 'Mail', 60, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Mail_Task_Cron'),
(4,'Notifications Summary', 'Core', 86400, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Task_Reminder_Notifications');
CREATE TABLE IF NOT EXISTS `{PREFIX}jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`jobtype_id` int(10) unsigned NOT NULL DEFAULT '0',
`state` enum('pending','active','sleeping','failed','cancelled','completed','timeout') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
`is_complete` tinyint(1) unsigned NOT NULL DEFAULT '0',
`progress` decimal(5,4) unsigned NOT NULL DEFAULT '0.0000',
`creation_date` datetime DEFAULT NULL,
`modified_date` datetime DEFAULT NULL,
`started_date` datetime DEFAULT NULL,
`completion_date` datetime DEFAULT NULL,
`priority` mediumint(9) NOT NULL DEFAULT '100',
`data` text COLLATE utf8_unicode_ci,
`messages` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `jobtype_id` (`jobtype_id`),
KEY `state` (`state`),
KEY `is_complete` (`is_complete`,`priority`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `{PREFIX}jobtypes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`class` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`plugin` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
`priority` mediumint(9) NOT NULL DEFAULT '100',
`multi` tinyint(3) unsigned DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=2 ;
INSERT INTO `{PREFIX}jobtypes` (`id`, `title`, `class`, `plugin`, `enabled`, `priority`, `multi`) VALUES
(1, 'Test', 'Cron_Task_Job_Test', 'cron', 1, 100, 1);
CREATE TABLE IF NOT EXISTS `{PREFIX}processes` (
`pid` int(10) unsigned NOT NULL,
`parent_pid` int(10) unsigned NOT NULL DEFAULT '0',
`system_pid` int(10) unsigned NOT NULL DEFAULT '0',
`started` int(10) unsigned NOT NULL DEFAULT '0',
`timeout` mediumint(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (`pid`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `{PREFIX}core_menus` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(256) NOT NULL DEFAULT '',
`style` enum('horizontal','vertical') NOT NULL DEFAULT 'horizontal',
`alias` varchar(255) NOT NULL DEFAULT '',
`menuid` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
INSERT INTO `{PREFIX}core_menus` (`id`, `name`, `style`, `alias`, `menuid`) VALUES
(1, 'Main Menu', 'horizontal', 'main-menu', 'menu-1'),
(2, 'Footer Menu', 'horizontal', 'footer-menu', 'menu-2');
CREATE TABLE IF NOT EXISTS `{PREFIX}core_menu_items` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL,
`lft` int(11) NOT NULL DEFAULT '0',
`rght` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`original_name` varchar(255) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
`title_attribute` varchar(255) NOT NULL DEFAULT '',
`font_class` varchar(255) NOT NULL DEFAULT '',
`is_active` tinyint(1) NOT NULL DEFAULT '0',
`new_blank` tinyint(1) NOT NULL DEFAULT '0',
`role_access` text NOT NULL,
`menu_id` int(11) NOT NULL DEFAULT '0',
`type` enum('page','link','header','plugin') DEFAULT NULL,
`menu_order` int(11) NOT NULL DEFAULT '0',
`plugin` varchar(255) NOT NULL DEFAULT '',
`group` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 ;
INSERT INTO `{PREFIX}core_menu_items` (`id`, `parent_id`, `lft`, `rght`, `name`, `original_name`, `url`, `title_attribute`, `font_class`, `is_active`, `new_blank`, `role_access`, `menu_id`, `type`, `menu_order`, `plugin`, `group`) VALUES
(1, NULL, 1, 2, 'Home', 'Home', '/home', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 1, '', ''),
(2, NULL, 9, 10, 'People', 'People', '/users', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 2, '', ''),
(3, NULL, 11, 12, 'Blogs', 'Blogs', '/blogs', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 3, '', ''),
(4, NULL, 13, 14, 'Photos', 'Photos', '/photos', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 4, '', ''),
(5, NULL, 5, 6, 'Groups', 'Groups', '/groups', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 7, '', ''),
(6, NULL, 3, 4, 'Topics', 'Topics', '/topics', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 6, '', ''),
(7, NULL, 15, 16, 'Videos', 'Videos', '/videos', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 5, '', ''),
(8, NULL, 7, 8, 'Events', 'Events', '/events', '', '', 1, 0, '["1","2", "3"]', 1, 'page', 8, '', ''),
(9, NULL, 23, 24, 'Contact Us', 'Contact Page', '/home/contact', '', '', 1, 0, '["1","2","3"]', 2, 'page', 4, '', ''),
(10, NULL, 17, 18, 'About Us', 'About Us', '/pages/about-us', '', '', 1, 0, '["1","2","3"]', 2, 'page', 1, '', ''),
(11, NULL, 19, 20, 'Term of Service', 'Term of Service', '/pages/term-of-service', '', '', 1, 0, '["1","2","3"]', 2, 'page', 2, '', ''),
(12, NULL, 21, 22, 'Privacy Policy', 'Privacy Policy', '/pages/privacy-policy', '', '', 1, 0, '["1","2","3"]', 2, 'page', 3, '', '');
CREATE TABLE IF NOT EXISTS `{PREFIX}i18n` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`locale` varchar(6) NOT NULL DEFAULT '',
`model` varchar(255) NOT NULL DEFAULT '',
`foreign_key` int(10) NOT NULL DEFAULT '0',
`field` varchar(255) NOT NULL DEFAULT '',
`content` text,
PRIMARY KEY (`id`),
KEY `locale` (`locale`),
KEY `model` (`model`),
KEY `row_id` (`foreign_key`),
KEY `field` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
INSERT INTO `{PREFIX}i18n` (`id`, `locale`, `model`, `foreign_key`, `field`, `content`) VALUES
(1, 'eng', 'Category', 1, 'name', 'Member Albums'),
(2, 'eng', 'Category', 2, 'name', 'Default Category'),
(3, 'eng', 'Category', 3, 'name', 'Default Category'),
(4, 'eng', 'Category', 4, 'name', 'Default Category'),
(5, 'eng', 'Category', 5, 'name', 'Default Category'),
(6, 'eng', 'Mailtemplate', 1, 'content', 'Hello,'),
(7, 'eng', 'Mailtemplate', 1, 'subject', ''),
(8, 'eng', 'Mailtemplate', 2, 'content', '<p>Best Regards,<br />Social Network Administration</p>'),
(9, 'eng', 'Mailtemplate', 2, 'subject', ''),
(10, 'eng', 'Mailtemplate', 3, 'content', '<p>Hello [recipient_title],</p>'),
(11, 'eng', 'Mailtemplate', 3, 'subject', ''),
(12, 'eng', 'Mailtemplate', 4, 'subject', ''),
(13, 'eng', 'Mailtemplate', 4, 'content', '<p>Best Regards,<br />Social Network Administration</p>'),
(14, 'eng', 'Mailtemplate', 5, 'content', '<p>[header]</p><p>[name] has sent you a message using the contact page:</p><p>Email : [sender_email]</p><p>Subject: [subject]</p><p>Message:</p><p>[message]</p><p>[footer]</p>'),
(15, 'eng', 'Mailtemplate', 5, 'subject', 'A member has sent you a message using the contact page.'),
(16, 'eng', 'Mailtemplate', 6, 'content', '<p>[header]</p>\r\n<p>You have been invited to join the event "[event_title]". Please click the following link to view it:</p>\r\n<p><a href="[event_link]">[event_title]</a></p>\r\n<p>[footer]</p>'),
(17, 'eng', 'Mailtemplate', 6, 'subject', 'You have been invited to join the event [event_title]'),
(18, 'eng', 'Mailtemplate', 7, 'content', '<p>[header]</p>\r\n<p>[sender_title] wants to be friends with you.</p>\r\n<p>[message]</p>\r\n<p><a href="[request_link]">Click here</a> to respond this request</p>\r\n<p>[footer]</p>'),
(19, 'eng', 'Mailtemplate', 7, 'subject', '[sender_title] has sent you a friend request.'),
(20, 'eng', 'Mailtemplate', 8, 'content', '<p>[header]</p>\r\n<p>You have been invited by [sender_title] to join our social network. To join, please follow the link below:</p>\r\n<p><a href="[signup_link]">[signup_link]</a></p>\r\n<p>----------------------------------------<br />[message]<br />----------------------------------------</p>\r\n<p>[footer]</p>'),
(21, 'eng', 'Mailtemplate', 8, 'subject', 'You have received an invitation to join our social network.'),
(22, 'eng', 'Mailtemplate', 9, 'content', '<p>[header]</p>\r\n<p>You have been invited to join the group "[group_title]". Please click the following link to view it:</p>\r\n<p><a href="[group_link]">[group_title]</a></p>\r\n<p>[footer]</p>'),
(23, 'eng', 'Mailtemplate', 9, 'subject', 'You have been invited to join the group [group_title]'),
(24, 'eng', 'Mailtemplate', 10, 'content', ''),
(25, 'eng', 'Mailtemplate', 10, 'subject', ''),
(26, 'eng', 'Mailtemplate', 11, 'content', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Click the following link and enter your information below to login:</p>\r\n<p><a href="[login_link]">[login_link]</a></p>\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>'),
(27, 'eng', 'Mailtemplate', 11, 'subject', 'Welcome to [site_name]'),
(28, 'eng', 'Mailtemplate', 12, 'content', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Please click the link below to validate your email:</p>\r\n<p><a href="[confirm_link]">[confirm_link]</a></p>\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>'),
(29, 'eng', 'Mailtemplate', 12, 'subject', 'Welcome to [site_name]'),
(30, 'eng', 'Mailtemplate', 13, 'content', '<p>[header]</p>\r\n<p><a href="[new_user_link]">[new_user_title]</a> has just signed up on [site_name]</p>\r\n<p>[footer]</p>'),
(31, 'eng', 'Mailtemplate', 13, 'subject', 'New Registration'),
(32, 'eng', 'Mailtemplate', 14, 'content', '<p>[header]</p>\r\n<p>A request to reset password was submitted. If it''s not you, please ignore this email.</p>\r\n<p>To reset your password, please click <a href="[reset_link]">[reset_link]</a></p>\r\n<p>[footer]</p>'),
(33, 'eng', 'Mailtemplate', 14, 'subject', 'Password Change Request'),
(34, 'eng', 'Mailtemplate', 15, 'content', '<p>[header]</p>\r\n<p>The admin has changed your password to [password]</p>\r\n<p>[footer]</p>'),
(35, 'eng', 'Mailtemplate', 15, 'subject', 'Your password has been changed'),
(36, 'eng', 'Mailtemplate', 16, 'content', '<p>[header]</p>\r\n<p>[element]</p>\r\n<p>[footer]</p>'),
(37, 'eng', 'Mailtemplate', 16, 'subject', 'Your Notifications Summary'),
(39, 'eng', 'CoreContent', 2, 'core_block_title', 'User Menu'),
(40, 'eng', 'CoreContent', 4, 'core_block_title', 'Themes & Language'),
(41, 'eng', 'CoreContent', 6, 'core_block_title', 'What''s New'),
(43, 'eng', 'CoreContent', 8, 'core_block_title', 'My Joined Groups'),
(45, 'eng', 'CoreContent', 10, 'core_block_title', 'Popular Albums'),
(48, 'eng', 'CoreContent', 13, 'core_block_title', 'Popular Events'),
(49, 'eng', 'CoreContent', 14, 'core_block_title', 'Who''s Online'),
(53, 'eng', 'CoreContent', 18, 'core_block_title', 'People You Might Know'),
(54, 'eng', 'CoreContent', 20, 'core_block_title', 'Themes & Languages'),
(55, 'eng', 'CoreContent', 22, 'core_block_title', 'Contact'),
(56, 'eng', 'CoreContent', 24, 'core_block_title', 'Menu friend & Search'),
(58, 'eng', 'CoreContent', 28, 'core_block_title', 'People'),
(59, 'eng', 'CoreContent', 30, 'core_block_title', 'Profile menu & Users'),
(60, 'eng', 'CoreContent', 32, 'core_block_title', 'Recent Activities'),
(61, 'eng', 'CoreContent', 35, 'core_block_title', 'Blogs menu & Search'),
(62, 'eng', 'CoreContent', 37, 'core_block_title', 'Themes & Languages'),
(63, 'eng', 'CoreContent', 39, 'core_block_title', 'Blogs'),
(66, 'eng', 'CoreContent', 43, 'core_block_title', 'Blogs settings'),
(67, 'eng', 'CoreContent', 45, 'core_block_title', 'Other Entries'),
(68, 'eng', 'CoreContent', 47, 'core_block_title', 'Blog Detail'),
(69, 'eng', 'CoreContent', 49, 'core_block_title', 'List photos & Search'),
(70, 'eng', 'CoreContent', 51, 'core_block_title', 'Photos'),
(71, 'eng', 'CoreContent', 52, 'core_block_title', 'Popular Albums'),
(73, 'eng', 'CoreContent', 56, 'core_block_title', 'Album''s photos'),
(74, 'eng', 'CoreContent', 58, 'core_block_title', 'Page Content'),
(77, 'eng', 'CoreContent', 62, 'core_block_title', 'Menu video & Search'),
(79, 'eng', 'CoreContent', 66, 'core_block_title', 'Videos'),
(80, 'eng', 'CoreContent', 67, 'core_block_title', 'Popular Videos'),
(81, 'eng', 'CoreContent', 69, 'core_block_title', 'Tags & Similar Videos'),
(82, 'eng', 'CoreContent', 71, 'core_block_title', 'Video''s content'),
(83, 'eng', 'CoreContent', 73, 'core_block_title', 'Topic''s setting'),
(85, 'eng', 'CoreContent', 77, 'core_block_title', 'Topics contents'),
(86, 'eng', 'CoreContent', 78, 'core_block_title', 'Tags'),
(88, 'eng', 'CoreContent', 81, 'core_block_title', 'Groups menu & Search'),
(89, 'eng', 'CoreContent', 83, 'core_block_title', 'Themes & Languages'),
(90, 'eng', 'CoreContent', 85, 'core_block_title', 'Groups'),
(91, 'eng', 'CoreContent', 87, 'core_block_title', 'Group info & setting'),
(92, 'eng', 'CoreContent', 89, 'core_block_title', 'Themes & Languages'),
(93, 'eng', 'CoreContent', 91, 'core_block_title', 'Info & Photos & Recent Activities'),
(96, 'eng', 'CoreContent', 95, 'core_block_title', 'Events menu & Search'),
(97, 'eng', 'CoreContent', 97, 'core_block_title', 'Themes & Languages'),
(98, 'eng', 'CoreContent', 99, 'core_block_title', 'Events'),
(100, 'eng', 'CoreContent', 102, 'core_block_title', 'Event''s setting'),
(101, 'eng', 'CoreContent', 104, 'core_block_title', 'Themes & Languages'),
(102, 'eng', 'CoreContent', 106, 'core_block_title', 'Event''s detail & Message'),
(105, 'eng', 'CoreContent', 112, 'core_block_title', 'Forgot Password'),
(106, 'eng', 'CoreContent', 114, 'core_block_title', 'Topics menu & Search'),
(107, 'eng', 'CoreContent', 116, 'core_block_title', 'Themes & Languages'),
(108, 'eng', 'CoreContent', 118, 'core_block_title', 'Topics'),
(109, 'eng', 'CoreContent', 120, 'core_block_title', 'Themes & Languages'),
(110, 'eng', 'CoreContent', 122, 'core_block_title', 'Upcoming Events'),
(113, 'eng', 'CoreContent', 125, 'core_block_title', 'Popular Albums'),
(120, 'eng', 'CoreContent', 132, 'core_block_title', 'Who''s Online'),
(121, 'eng', 'CoreContent', 133, 'core_block_title', 'Recently Joined'),
(126, 'eng', 'CoreContent', 139, 'core_block_title', 'What''s new'),
(127, 'eng', 'CoreContent', 141, 'core_block_title', 'Login form'),
(128, 'eng', 'CoreContent', 143, 'core_block_title', 'Register Form'),
(129, 'eng', 'CoreContent', 145, 'core_block_title', 'Today''s birthday'),
(130, 'eng', 'CoreContent', 147, 'core_block_title', ''),
(131, 'eng', 'CoreContent', 156, 'core_block_title', 'Popular Blogs'),
(132, 'eng', 'CoreContent', 119, 'core_block_title', ''),
(133, 'eng', 'CoreContent', 121, 'core_block_title', ''),
(134, 'eng', 'CoreContent', 137, 'core_block_title', ''),
(135, 'eng', 'CoreContent', 148, 'core_block_title', ''),
(136, 'eng', 'CoreContent', 152, 'core_block_title', ''),
(137, 'eng', 'CoreContent', 53, 'core_block_title', ''),
(138, 'eng', 'CoreContent', 55, 'core_block_title', ''),
(139, 'eng', 'CoreContent', 42, 'core_block_title', ''),
(140, 'eng', 'CoreContent', 44, 'core_block_title', ''),
(141, 'eng', 'CoreContent', 46, 'core_block_title', ''),
(142, 'eng', 'CoreContent', 34, 'core_block_title', ''),
(143, 'eng', 'CoreContent', 36, 'core_block_title', ''),
(144, 'eng', 'CoreContent', 38, 'core_block_title', ''),
(145, 'eng', 'CoreContent', 19, 'core_block_title', ''),
(146, 'eng', 'CoreContent', 21, 'core_block_title', ''),
(147, 'eng', 'CoreContent', 101, 'core_block_title', ''),
(148, 'eng', 'CoreContent', 103, 'core_block_title', ''),
(149, 'eng', 'CoreContent', 105, 'core_block_title', ''),
(150, 'eng', 'CoreContent', 94, 'core_block_title', ''),
(151, 'eng', 'CoreContent', 96, 'core_block_title', ''),
(152, 'eng', 'CoreContent', 98, 'core_block_title', ''),
(153, 'eng', 'CoreContent', 109, 'core_block_title', ''),
(154, 'eng', 'CoreContent', 111, 'core_block_title', ''),
(155, 'eng', 'CoreContent', 86, 'core_block_title', ''),
(156, 'eng', 'CoreContent', 88, 'core_block_title', ''),
(157, 'eng', 'CoreContent', 90, 'core_block_title', ''),
(158, 'eng', 'CoreContent', 80, 'core_block_title', ''),
(159, 'eng', 'CoreContent', 82, 'core_block_title', ''),
(160, 'eng', 'CoreContent', 84, 'core_block_title', ''),
(161, 'eng', 'CoreContent', 1, 'core_block_title', ''),
(162, 'eng', 'CoreContent', 3, 'core_block_title', ''),
(163, 'eng', 'CoreContent', 5, 'core_block_title', ''),
(164, 'eng', 'CoreContent', 23, 'core_block_title', ''),
(165, 'eng', 'CoreContent', 25, 'core_block_title', ''),
(166, 'eng', 'CoreContent', 27, 'core_block_title', ''),
(167, 'eng', 'CoreContent', 57, 'core_block_title', ''),
(168, 'eng', 'CoreContent', 48, 'core_block_title', ''),
(169, 'eng', 'CoreContent', 50, 'core_block_title', ''),
(170, 'eng', 'CoreContent', 29, 'core_block_title', ''),
(171, 'eng', 'CoreContent', 31, 'core_block_title', ''),
(172, 'eng', 'CoreContent', 140, 'core_block_title', ''),
(173, 'eng', 'CoreContent', 142, 'core_block_title', ''),
(174, 'eng', 'CoreContent', 72, 'core_block_title', ''),
(175, 'eng', 'CoreContent', 74, 'core_block_title', ''),
(176, 'eng', 'CoreContent', 76, 'core_block_title', ''),
(177, 'eng', 'CoreContent', 113, 'core_block_title', ''),
(178, 'eng', 'CoreContent', 115, 'core_block_title', ''),
(179, 'eng', 'CoreContent', 117, 'core_block_title', ''),
(180, 'eng', 'CoreContent', 68, 'core_block_title', ''),
(181, 'eng', 'CoreContent', 70, 'core_block_title', ''),
(182, 'eng', 'CoreContent', 61, 'core_block_title', ''),
(183, 'eng', 'CoreContent', 63, 'core_block_title', ''),
(184, 'eng', 'CoreContent', 65, 'core_block_title', ''),
(185, 'eng', 'CoreMenuItem', 1, 'name', 'Home'),
(186, 'eng', 'CoreMenuItem', 2, 'name', 'People'),
(187, 'eng', 'CoreMenuItem', 3, 'name', 'Blogs'),
(188, 'eng', 'CoreMenuItem', 4, 'name', 'Photos'),
(189, 'eng', 'CoreMenuItem', 5, 'name', 'Groups'),
(190, 'eng', 'CoreMenuItem', 6, 'name', 'Topics'),
(191, 'eng', 'CoreMenuItem', 7, 'name', 'Videos'),
(192, 'eng', 'CoreMenuItem', 8, 'name', 'Events'),
(193, 'eng', 'CoreContent', 146, 'core_block_title', ''),
(194, 'eng', 'CoreContent', 149, 'core_block_title', ''),
(195, 'eng', 'CoreContent', 150, 'core_block_title', ''),
(196, 'eng', 'CoreContent', 151, 'core_block_title', ''),
(197, 'eng', 'CoreMenuItem', 9, 'name', 'Contact Us'),
(198, 'eng', 'CoreMenuItem', 10, 'name', 'About Us'),
(199, 'eng', 'CoreMenuItem', 11, 'name', 'Term of Service'),
(200, 'eng', 'CoreMenuItem', 12, 'name', 'Privacy Policy'),
(201, 'eng', 'CoreContent', 153, 'core_block_title', 'Footer Menu'),
(202, 'eng', 'CoreContent', 154, 'core_block_title', 'Login'),
(203, 'eng', 'CoreContent', 155, 'core_block_title', 'Popular Videos'),
(204, 'eng', 'CoreContent', 157, 'core_block_title', 'Popular Videos'),
(205, 'eng', 'CoreContent', 158, 'core_block_title', 'Popular Blogs'),
(206, 'eng', 'CoreContent', 159, 'core_block_title', 'Recently Joined'),
(207, 'eng', 'CoreContent', 160, 'core_block_title', 'People You Might Know'),
(208, 'eng', 'CoreContent', 161, 'core_block_title', 'Featured Members'),
(209, 'eng', 'CoreContent', 162, 'core_block_title', 'Tags'),
(210, 'eng', 'CoreContent', 163, 'core_block_title', 'Popular Blogs'),
(211, 'eng', 'CoreContent', 164, 'core_block_title', 'Popular Blogs'),
(212, 'eng', 'CoreContent', 165, 'core_block_title', 'Tags'),
(213, 'eng', 'CoreContent', 166, 'core_block_title', 'Popular Videos'),
(214, 'eng', 'CoreContent', 167, 'core_block_title', 'Tags'),
(215, 'eng', 'CoreContent', 168, 'core_block_title', 'Popular Topics'),
(216, 'eng', 'CoreContent', 169, 'core_block_title', 'My Joined Groups'),
(217, 'eng', 'CoreContent', 170, 'core_block_title', 'Popular Groups'),
(218, 'eng', 'CoreContent', 171, 'core_block_title', 'Group Admin'),
(219, 'eng', 'CoreContent', 172, 'core_block_title', 'Group Members'),
(220, 'eng', 'CoreContent', 173, 'core_block_title', 'Popular Groups'),
(221, 'eng', 'CoreContent', 174, 'core_block_title', 'Upcoming Events'),
(222, 'eng', 'CoreContent', 175, 'core_block_title', 'People You Might Know'),
(223, 'eng', 'CoreContent', 176, 'core_block_title', 'Tags'),
(224, 'eng', 'CoreContent', 177, 'core_block_title', 'Popular Events'),
(225, 'eng', 'CoreContent', 178, 'core_block_title', 'RSVP'),
(226, 'eng', 'CoreContent', 179, 'core_block_title', 'Event Attending'),
(227, 'eng', 'Mailtemplate', 17, 'content', '<p>[header]</p>\r\n<p>Thank you for subscribing to our social network! Your subscription is now active.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to sign in.</p>\r\n<p><a href="[login_link]">[login_link]</a></p>\r\n<p>[footer]</p>'),
(228, 'eng', 'Mailtemplate', 17, 'subject', 'Your subscription is now active.'),
(229, 'eng', 'Mailtemplate', 18, 'content', '<p>[header]</p>\r\n<p>Your subscription cannot be completed because of a failed or missed payment.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to try again.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
(230, 'eng', 'Mailtemplate', 18, 'subject', 'Your subscription is Pending.'),
(231, 'eng', 'Mailtemplate', 19, 'content', '<p>[header]</p>\r\n<p>Your subscription has expired.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to renew your subscription.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p></p>\r\n<p>[footer]</p>'),
(232, 'eng', 'Mailtemplate', 19, 'subject', 'Your subscription has expired.'),
(233, 'eng', 'Mailtemplate', 20, 'content', '<p>[header]</p>\r\n<p>Your [subscription_title] will be expired on [expire_time].</p>\r\n<p>Please follow the link below to renew your membership.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
(234, 'eng', 'Mailtemplate', 20, 'subject', 'Subscription Reminder'),
(235, 'eng', 'Mailtemplate', 21, 'content', '<p>[header]</p>\r\n<p>Your subscription has been billed. You should receive an email from the</p>\r\n<p>payment gateway regarding this charge. Thank you for subscribing to our social</p>\r\n<p>network.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>You may follow the link below to sign in.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
(236, 'eng', 'Mailtemplate', 21, 'subject', 'Your subscription has been billed'),
(237, 'eng', 'Mailtemplate', 22, 'content', '<p>[header]</p>\r\n<p>[sender_title] cancels his/her subscription.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Reason: [Reason]</p>\r\n<p>[footer]</p>'),
(238, 'eng', 'Mailtemplate', 22, 'subject', '[sender_title] cancelled his subscription'),
(239, 'eng', 'Mailtemplate', 23, 'content', '<p>[header]</p>\r\n<p>[sender_title] sent a refund request.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Reason: [Reason]</p>\r\n<p>[footer]</p>'),
(240, 'eng', 'Mailtemplate', 23, 'subject', 'Request Refund'),
(241, 'eng', 'Mailtemplate', 24, 'content', '<p>[header]</p>\r\n<p>Admin denies your refund request.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Reason: [Reason]</p>\r\n<p>Please follow the link below to sign in.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
(242, 'eng', 'Mailtemplate', 24, 'subject', 'Refund Deny'),
(243, 'eng', 'Mailtemplate', 25, 'content', '<p>[header]</p>\r\n<p></p>\r\n<p>Your subscription has been refunded and is no longer active.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to choose a different package.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p></p>\r\n<p>[footer]</p>'),
(244, 'eng', 'Mailtemplate', 25, 'subject', 'Accept Refund'),
(245, 'eng', 'Mailtemplate', 26, 'content', '<p>[header]</p>\r\n<p>Your subscription has been cancelled.</p>\r\n<p>[subscription_title]</p>\r\n<p>[subscription_description]</p>\r\n<p>[plan_title]</p>\r\n<p>[plan_description]</p>\r\n<p>Please follow the link below to re-subscribe.</p>\r\n<p><a href="[link]">[link]</a></p>\r\n<p>[footer]</p>'),
(246, 'eng', 'Mailtemplate', 26, 'subject', 'Your subscription has been cancelled.'),
(247, 'eng', 'Mailtemplate', 27, 'content', '<p>Hi [shared_user]</p>\r\n<p>[user_shared] shared for you a link: <a href="[shared_link]">[shared_link]</a></p>\r\n<p>[shared_content]</p>\r\n<p>Please see my link guy</p>\r\n<p>[footer]</p>'),
(248, 'eng', 'Mailtemplate', 27, 'subject', '[user_shared] shared for you a link');
CREATE TABLE IF NOT EXISTS `{PREFIX}mailtemplates` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '',
`content` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`plugin` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`vars` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`subject` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
INSERT INTO `{PREFIX}mailtemplates` (`id`, `type`, `content`, `plugin`, `vars`, `subject`) VALUES
(1, 'header', '', 'Mail', '', ''),
(2, 'footer', '', 'Mail', '', ''),
(3, 'header_member', '', 'Mail', '', ''),
(4, 'footer_member', '', 'Mail', '', ''),
(5, 'mail_contact', '', 'Mail', '[message],[name],[subject],[sender_email]', ''),
(6, 'event_invite_none_member', '<p>[header]</p>\r\n<p>You have been invited to join the event "[event_title]". Please click the following link to view it:</p>\r\n<p><a href="[event_link]">[event_title]</a></p>\r\n<p>[footer]</p>', 'Event', '[email],[sender_title],[sender_link],[event_link],[event_title]', 'You have been invited to join the event [event_title]'),
(7, 'friend_request', '<p>[header]</p>\r\n<p>[sender_title] wants to be friends with you.</p>\r\n<p>[message]</p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[sender_title],[sender_link],[message],[request_link]', '[sender_title] has sent you a friend request.'),
(8, 'site_invite', '<p>[header]</p>\r\n<p>You have been invited by [sender_title] to join our social network. To join, please follow the link below:</p>\r\n<p><a href="[signup_link]">[signup_link]</a></p>\r\n<p>----------------------------------------<br />[message]<br />----------------------------------------</p>\r\n<p>[footer]</p>', 'Mail', '[email],[sender_title],[sender_link],[message],[sigup_link]', 'You have received an invitation to join our social network.'),
(9, 'group_invite_none_member', '<p>[header]</p>\r\n<p>You have been invited to join the group "[group_title]". Please click the following link to view it:</p>\r\n<p><a href="[group_link]">[group_title]</a></p>\r\n<p>[footer]</p>', 'Group', '[email],[sender_title],[sender_link],[group_link],[group_title]', 'You have been invited to join the group [group_title]'),
(10, 'bulkmail', '', 'Mail', '[recipient_title],[recipient_link],[sender_title],[sender_link]', ''),
(11, 'welcome_user', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Click the following link and enter your information below to login:</p>\r\n<p><a href="[login_link]">[login_link]</a></p>\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[site_name],[login_link],[email]', 'Welcome to [site_name]'),
(12, 'welcome_user_confirm', '<p>[header]</p>\r\n<p>Thank you for joining our social network. Please click the link below to validate your email:</p>\r\n<p><a href="[confirm_link]">[confirm_link]</a></p>\r\n<p>Email: [email]</p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[site_name],[email],[confirm_link]', 'Welcome to [site_name]'),
(13, 'new_registration', '<p>[header]</p>\r\n<p><a href="[new_user_link]">[new_user_title]</a> has just signed up on [site_name]</p>\r\n<p>[footer]</p>', 'Mail', '[new_user_title],[new_user_link],[site_name]', 'New Registration'),
(14, 'reset_password', '<p>[header]</p>\r\n<p>A request to reset password was submitted. If it\'s not you, please ignore this email.</p>\r\n<p>To reset your password, please click <a href="[reset_link]">[reset_link]</a></p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[reset_link]', 'Password Change Request'),
(15, 'admin_change_password', '<p>[header]</p>\r\n<p>The admin has changed your password to [password]</p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[password]', 'Your password has been changed'),
(16, 'notifications_summary', '<p>[header]</p>\r\n<p>[element]</p>\r\n<p>[footer]</p>', 'Mail', '[recipient_title],[recipient_link],[element]', 'Your Notifications Summary'),
(17, 'subscription_activated', '', 'Subscription', '[subscription_title],[subscription_description],[login_link],[plan_title],[plan_description]', ''),
(18, 'subscription_pending', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
(19, 'subscription_expire', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
(20, 'subscription_reminder', '', 'Subscription', '[subscription_title],[subscription_description],[link],[expire_time],[plan_title],[plan_description]', ''),
(21, 'subscription_recurrence', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
(22, 'subscription_cancel_admin', '', 'Subscription', '[subscription_title],[subscription_description],[sender_title],[sender_link],[reason],[plan_title],[plan_description]', ''),
(23, 'subscription_refund_admin', '', 'Subscription', '[subscription_title],[subscription_description],[sender_title],[sender_link],[reason],[plan_title],[plan_description]', ''),
(24, 'subscription_refund_deny', '', 'Subscription', '[subscription_title],[subscription_description],[reason],[link],[plan_title],[plan_description]', ''),
(25, 'subscription_refund_accept', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
(26, 'subscription_cancel', '', 'Subscription', '[subscription_title],[subscription_description],[link],[plan_title],[plan_description]', ''),
(27, 'shared_item', '<p>[header]</p>\r\n<p>', 'Mail', '[email],[shared_user],[user_shared],[shared_link][shared_content]', '<p>Hi [shared_user]</p>\r\n<p>[user_shared] shared for you a link: <a href="[shared_link]">[shared_link]</a></p>\r\n<p>[shared_content]</p>\r\n<p>Please see my link guy</p>');
CREATE TABLE IF NOT EXISTS `{PREFIX}mailrecipients` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`params` longtext COLLATE utf8_unicode_ci NOT NULL,
`priority` smallint(3) DEFAULT '100',
`creation_time` datetime DEFAULT NULL,
`recipient` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`type` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `{PREFIX}notification_stops` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL DEFAULT '0',
`item_type` varchar(255) NOT NULL DEFAULT '',
`item_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
CREATE TABLE `{PREFIX}social_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`provider` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`provider_uid` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`access_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`code_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`expires` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `{PREFIX}comment_histories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`content` text NOT NULL,
`created` datetime DEFAULT NULL,
`photo` int(1) NOT NULL DEFAULT '0',
`type` varchar(128) NOT NULL DEFAULT '',
`target_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `{PREFIX}hashtags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL DEFAULT '0',
`item_table` varchar(80) NOT NULL DEFAULT '',
`hashtags` varchar(800) CHARACTER SET utf8 NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{PREFIX}user_taggings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL DEFAULT '0',
`item_table` varchar(80) NOT NULL DEFAULT '',
`users_taggings` varchar(800) CHARACTER SET utf8 NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{PREFIX}user_mentions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL DEFAULT '0',
`item_table` varchar(80) NOT NULL DEFAULT '',
`users_mentions` varchar(800) CHARACTER SET utf8 NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{PREFIX}group_user_invites` (
`id` int(11) unsigned NOT NULL,
`group_id` int(11) unsigned NOT NULL DEFAULT '0',
`email` varchar(50) NOT NULL DEFAULT '',
`invite_checksum` varchar(50) NOT NULL DEFAULT '',
`created` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_packages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL DEFAULT '',
`description` text NOT NULL,
`role_id` int(10) DEFAULT '0',
`recommended` tinyint(1) unsigned NOT NULL DEFAULT '1',
`default` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) DEFAULT '1',
`deleted` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_package_plans` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(128) NOT NULL DEFAULT '',
`subscription_package_id` int(11) unsigned NOT NULL DEFAULT '0',
`type` tinyint(2) NOT NULL DEFAULT '0',
`price` decimal(16,2) unsigned NOT NULL DEFAULT '0',
`plan_duration` int(11) unsigned NOT NULL DEFAULT '0',
`plan_type` enum('day','week','month','year','forever') NOT NULL DEFAULT 'day',
`expiration_reminder` int(11) unsigned NOT NULL DEFAULT '0',
`expiration_reminder_type` enum('day','week','month','year') NOT NULL DEFAULT 'day',
`show_at` varchar(50) NOT NULL DEFAULT '',
`enable_plan` tinyint(1) NOT NULL DEFAULT '0',
`billing_cycle` int(11) unsigned NOT NULL DEFAULT '0',
`billing_cycle_type` enum('day','week','month','year') NOT NULL DEFAULT 'day',
`trial_price` decimal(16,2) unsigned NOT NULL DEFAULT '0',
`trial_duration` int(11) unsigned NOT NULL DEFAULT '0',
`trial_duration_type` enum('day','week','month','year') NOT NULL DEFAULT 'day',
`deleted` tinyint(2) NOT NULL DEFAULT '0',
`order` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}subscribes` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
`plan_id` int(11) unsigned NOT NULL DEFAULT '0',
`status` enum('initial','active','pending','expired','refunded','failed','cancel','process','inactive') NOT NULL DEFAULT 'initial',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`expiration_date` datetime DEFAULT NULL,
`reminder_date` datetime DEFAULT NULL,
`pay_date` datetime DEFAULT NULL,
`end_date` datetime DEFAULT NULL,
`gateway_id` int(10) DEFAULT NULL,
`is_warning_email_sent` tinyint(1) DEFAULT '0',
`currency_code` text NOT NULL,
`package_id` int(11) NOT NULL DEFAULT '0',
`is_trial` tinyint(1) NOT NULL DEFAULT '1',
`is_request_refund` tinyint(1) NOT NULL DEFAULT '0',
`transaction_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_transactions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`subscribes_id` int(11) DEFAULT NULL,
`package_id` int(11) DEFAULT NULL,
`gateway_id` int(10) unsigned NOT NULL DEFAULT '0',
`status` enum('initial','completed','pending','expired','refunded','failed','cancel','inactive') NOT NULL DEFAULT 'initial',
`amount` decimal(16,2) NOT NULL DEFAULT '0',
`currency` char(3) NOT NULL DEFAULT '',
`callback_params` text,
`plan_id` int(11) NOT NULL DEFAULT '0',
`created` datetime DEFAULT NULL,
`type` enum('receive','pay') NOT NULL DEFAULT 'receive',
`admin` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_compares` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`compare_name` varchar(255) NOT NULL DEFAULT '',
`compare_value` text NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}subscription_refunds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscribe_id` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`status` enum('initial','denied','process','completed','failed') NOT NULL DEFAULT 'initial',
`account` varchar(128) NOT NULL DEFAULT '',
`reason` text NOT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`transaction_id` int(11) NOT NULL DEFAULT '0',
`plan_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `{PREFIX}ratings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`plugin` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`type_id` int(10) DEFAULT NULL,
`score` tinyint(2) NOT NULL DEFAULT '0',
`rating_user_count` int(10) unsigned DEFAULT NULL,
`total_score` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `{PREFIX}rating_users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
`rating_id` int(11) unsigned NOT NULL DEFAULT '0',
`score` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `{PREFIX}rating_settings` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(50) NOT NULL DEFAULT '',
`name` varchar(50) NOT NULL DEFAULT '',
`value` text NOT NULL,
`type` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
INSERT INTO `{PREFIX}rating_settings` (`id`, `label`, `name`, `value`, `type`) VALUES
(1, 'Enable Rating', 'enable_rating', '{"users":"1","blogs":"1","albums":"1","photos":"1","topics":"1","events":"1","videos":"1","groups":"1"}', 'checkbox'),
(2, 'Allow re-rating', 're_rating', '1', 'checkbox'),
(3, 'Skin', 'skin', 'skin.png', 'text'),
(4, 'Rating system', 'rating_system', '5', 'number');
CREATE TABLE IF NOT EXISTS `{PREFIX}oauth_access_tokens` (
`access_token` varchar(40) NOT NULL DEFAULT '',
`client_id` varchar(80) DEFAULT NULL,
`user_id` varchar(255) DEFAULT NULL,
`expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`scope` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`access_token`)
);
CREATE TABLE IF NOT EXISTS `{PREFIX}oauth_refresh_tokens` (
`refresh_token` varchar(40) NOT NULL DEFAULT '',
`client_id` varchar(80) DEFAULT NULL,
`user_id` varchar(255) DEFAULT NULL,
`expires` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`scope` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`refresh_token`)
);