Changeset 15918

Timestamp:

01/24/12 20:08:16 (4 months ago)

Author:

Alexander Trofimov

Message:

Groups - installable

Location:

trunk/modules/boonex/groups/install/sql

Files:

• enable.sql (modified) (4 diffs)
• install.sql (modified) (10 diffs)
• uninstall.sql (modified) (1 diff)

trunk/modules/boonex/groups/install/sql/enable.sql

@@ -60 +60 @@
 
 -- vote objects
-INSERT INTO `sys_objects_vote` VALUES (NULL, 'bx_groups', '[db_prefix]rating', '[db_prefix]rating_track', 'gal_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', '[db_prefix]main', 'rate', 'rate_count', 'id', 'BxGroupsVoting', 'modules/boonex/groups/classes/BxGroupsVoting.php');
+INSERT INTO `sys_objects_vote` VALUES (NULL, 'bx_groups', 'bx_groups_rating', 'bx_groups_rating_track', 'gal_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'bx_groups_main', 'rate', 'rate_count', 'id', 'BxGroupsVoting', 'modules/boonex/groups/classes/BxGroupsVoting.php');
 
 -- comments objects
-INSERT INTO `sys_objects_cmts` VALUES (NULL, 'bx_groups', '[db_prefix]cmts', '[db_prefix]cmts_track', '0', '1', '90', '5', '1', '-3', 'slide', '2000', '1', '1', 'cmt', '[db_prefix]main', 'id', 'comments_count', 'BxGroupsCmts', 'modules/boonex/groups/classes/BxGroupsCmts.php');
+INSERT INTO `sys_objects_cmts` VALUES (NULL, 'bx_groups', 'bx_groups_cmts', 'bx_groups_cmts_track', '0', '1', '90', '5', '1', '-3', 'slide', '2000', '1', '1', 'cmt', 'bx_groups_main', 'id', 'comments_count', 'BxGroupsCmts', 'modules/boonex/groups/classes/BxGroupsCmts.php');
 
 -- views objects
-INSERT INTO `sys_objects_views` VALUES(NULL, 'bx_groups', '[db_prefix]views_track', 86400, '[db_prefix]main', 'id', 'views', 1);
+INSERT INTO `sys_objects_views` VALUES(NULL, 'bx_groups', 'bx_groups_views_track', 86400, 'bx_groups_main', 'id', 'views', 1);
 
 -- users actions
@@ -88 +88 @@
 
 SET @iMenuSiteMaxOrder := (SELECT MAX(`order`) FROM `sys_menu_items` WHERE `set_name` = 'sys_site');
-INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `hidden_for_levels`, `active`, `order`) VALUES
-('sys_site', 'bx_groups', 'groups', '_bx_groups_menu_root', 'modules/?r=groups/home/', '', '', '', 0, 1, @iMenuSiteMaxOrder + 1);
+INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `visible_for_levels`, `active`, `order`) VALUES
+('sys_site', 'bx_groups', 'groups', '_bx_groups_menu_root', 'modules/?r=groups/home/', '', '', '', 2147483647, 1, @iMenuSiteMaxOrder + 1);
 
 -- groups menu 
@@ -99 +99 @@
 ('bx_groups', 'bx_groups', '_bx_groups_menu_set_title_main', 0);
 
-INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `hidden_for_levels`, `active`, `order`) VALUES
-('bx_groups', 'bx_groups', 'main_page', '_bx_groups_menu_main', 'modules/?r=groups/home/', '', '', '', 0, 1, 1),
-('bx_groups', 'bx_groups', 'recent', '_bx_groups_menu_recent', 'modules/?r=groups/browse/recent', '', '', '', 0, 1, 2),
-('bx_groups', 'bx_groups', 'top_rated', '_bx_groups_menu_top_rated', 'modules/?r=groups/browse/top', '', '', '', 0, 1, 3),
-('bx_groups', 'bx_groups', 'popular', '_bx_groups_menu_popular', 'modules/?r=groups/browse/popular', '', '', '', 0, 1, 4),
-('bx_groups', 'bx_groups', 'featured', '_bx_groups_menu_featured', 'modules/?r=groups/browse/featured', '', '', '', 0, 1, 5),
-('bx_groups', 'bx_groups', 'tags', '_bx_groups_menu_tags', 'modules/?r=groups/tags', '', '', '', 0, 1, 6),
-('bx_groups', 'bx_groups', 'categories', '_bx_groups_menu_categories', 'modules/?r=groups/categories', '', '', '', 0, 1, 7),
-('bx_groups', 'bx_groups', 'calendar', '_bx_groups_menu_calendar', 'modules/?r=groups/calendar', '', '', '', 0, 1, 8),
-('bx_groups', 'bx_groups', 'search', '_bx_groups_menu_search', 'modules/?r=groups/search', '', '', '', 0, 1, 9);
+INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `visible_for_levels`, `active`, `order`) VALUES
+('bx_groups', 'bx_groups', 'main_page', '_bx_groups_menu_main', 'modules/?r=groups/home/', '', '', '', 2147483647, 1, 1),
+('bx_groups', 'bx_groups', 'recent', '_bx_groups_menu_recent', 'modules/?r=groups/browse/recent', '', '', '', 2147483647, 1, 2),
+('bx_groups', 'bx_groups', 'top_rated', '_bx_groups_menu_top_rated', 'modules/?r=groups/browse/top', '', '', '', 2147483647, 1, 3),
+('bx_groups', 'bx_groups', 'popular', '_bx_groups_menu_popular', 'modules/?r=groups/browse/popular', '', '', '', 2147483647, 1, 4),
+('bx_groups', 'bx_groups', 'featured', '_bx_groups_menu_featured', 'modules/?r=groups/browse/featured', '', '', '', 2147483647, 1, 5),
+('bx_groups', 'bx_groups', 'tags', '_bx_groups_menu_tags', 'modules/?r=groups/tags', '', '', '', 2147483647, 1, 6),
+('bx_groups', 'bx_groups', 'categories', '_bx_groups_menu_categories', 'modules/?r=groups/categories', '', '', '', 2147483647, 1, 7),
+('bx_groups', 'bx_groups', 'calendar', '_bx_groups_menu_calendar', 'modules/?r=groups/calendar', '', '', '', 2147483647, 1, 8),
+('bx_groups', 'bx_groups', 'search', '_bx_groups_menu_search', 'modules/?r=groups/search', '', '', '', 2147483647, 1, 9);
 
 -- group view menu 
@@ -119 +119 @@
 ('bx_groups_vew', 'bx_groups', '_bx_groups_menu_set_title_group_view', 0);
 
-INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `hidden_for_levels`, `active`, `order`) VALUES
-('bx_groups_view', 'bx_groups', 'view', '_bx_groups_menu_view_group', 'modules/?r=groups/view/{bx_groups_view_uri}', '', '', '', 0, 1, 1),
-('bx_groups_view', 'bx_groups', 'view_forum', '_bx_groups_menu_view_forum', 'forum/groups/forum/{bx_groups_view_uri}-0.htm', '', '', '', 0, 1, 2),
-('bx_groups_view', 'bx_groups', 'view_fans', '_bx_groups_menu_view_fans', 'modules/?r=groups/browse_fans/{bx_groups_view_uri}', '', '', '', 0, 1, 3),
-('bx_groups_view', 'bx_groups', 'view_comments', '_bx_groups_menu_view_comments', 'modules/?r=groups/comments/{bx_groups_view_uri}', '', '', '', 0, 1, 4);
+INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `visible_for_levels`, `active`, `order`) VALUES
+('bx_groups_view', 'bx_groups', 'view', '_bx_groups_menu_view_group', 'modules/?r=groups/view/{bx_groups_view_uri}', '', '', '', 2147483647, 1, 1),
+('bx_groups_view', 'bx_groups', 'view_forum', '_bx_groups_menu_view_forum', 'forum/groups/forum/{bx_groups_view_uri}-0.htm', '', '', '', 2147483647, 1, 2),
+('bx_groups_view', 'bx_groups', 'view_fans', '_bx_groups_menu_view_fans', 'modules/?r=groups/browse_fans/{bx_groups_view_uri}', '', '', '', 2147483647, 1, 3),
+('bx_groups_view', 'bx_groups', 'view_comments', '_bx_groups_menu_view_comments', 'modules/?r=groups/comments/{bx_groups_view_uri}', '', '', '', 2147483647, 1, 4);
 
 
 -- site stats
 
-INSERT INTO `sys_stat_site` VALUES(NULL, 'bx_groups', 'bx_groups', 'modules/?r=groups/', 'SELECT COUNT(`id`) FROM `[db_prefix]main` WHERE `status` = ''approved''', '../modules/?r=groups/administration', 'SELECT COUNT(`id`) FROM `[db_prefix]main` WHERE `status` != ''approved''', 'modules/boonex/groups/|groups.png', 0);
+INSERT INTO `sys_stat_site` VALUES(NULL, 'bx_groups', 'bx_groups', 'modules/?r=groups/', 'SELECT COUNT(`id`) FROM `bx_groups_main` WHERE `status` = ''approved''', '../modules/?r=groups/administration', 'SELECT COUNT(`id`) FROM `bx_groups_main` WHERE `status` != ''approved''', 'modules/boonex/groups/|groups.png', 0);
 
 -- PQ statistics
-INSERT INTO `sys_stat_member` VALUES ('bx_groups', 'SELECT COUNT(*) FROM `[db_prefix]main` WHERE `author_id` = ''__member_id__'' AND `status`=''approved''');
-INSERT INTO `sys_stat_member` VALUES ('bx_groupsp', 'SELECT COUNT(*) FROM `[db_prefix]main` WHERE `author_id` = ''__member_id__'' AND `Status`!=''approved''');
+INSERT INTO `sys_stat_member` VALUES ('bx_groups', 'SELECT COUNT(*) FROM `bx_groups_main` WHERE `author_id` = ''__member_id__'' AND `status`=''approved''');
+INSERT INTO `sys_stat_member` VALUES ('bx_groupsp', 'SELECT COUNT(*) FROM `bx_groups_main` WHERE `author_id` = ''__member_id__'' AND `Status`!=''approved''');
 INSERT INTO `sys_account_custom_stat_elements` VALUES(NULL, '_bx_groups', '__bx_groups__ __l_created__ (<a href="modules/?r=groups/browse/my&bx_groups_filter=add_group">__l_add__</a>)');
 

trunk/modules/boonex/groups/install/sql/install.sql

@@ -15 +15 @@
 
 -- create tables
-CREATE TABLE IF NOT EXISTS `[db_prefix]main` (
+CREATE TABLE IF NOT EXISTS `bx_groups_main` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `title` varchar(100) NOT NULL default '',
@@ -52 +52 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]fans` (
+CREATE TABLE IF NOT EXISTS `bx_groups_fans` (
   `id_entry` int(10) unsigned NOT NULL,
   `id_profile` int(10) unsigned NOT NULL,
@@ -60 +60 @@
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]admins` (
+CREATE TABLE IF NOT EXISTS `bx_groups_admins` (
   `id_entry` int(10) unsigned NOT NULL,
   `id_profile` int(10) unsigned NOT NULL,
@@ -67 +67 @@
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]images` (
+CREATE TABLE IF NOT EXISTS `bx_groups_images` (
   `entry_id` int(10) unsigned NOT NULL,
   `media_id` int(10) unsigned NOT NULL,
@@ -73 +73 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]rating` (
+CREATE TABLE IF NOT EXISTS `bx_groups_rating` (
   `gal_id` smallint( 6 ) NOT NULL default '0',
   `gal_rating_count` int( 11 ) NOT NULL default '0',
@@ -80 +80 @@
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]rating_track` (
+CREATE TABLE IF NOT EXISTS `bx_groups_rating_track` (
   `gal_id` smallint( 6 ) NOT NULL default '0',
   `gal_ip` varchar( 20 ) default NULL,
@@ -87 +87 @@
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]cmts` (
+CREATE TABLE IF NOT EXISTS `bx_groups_cmts` (
   `cmt_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
   `cmt_parent_id` int( 11 ) NOT NULL default '0',
@@ -102 +102 @@
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]cmts_track` (
+CREATE TABLE IF NOT EXISTS `bx_groups_cmts_track` (
   `cmt_system_id` int( 11 ) NOT NULL default '0',
   `cmt_id` int( 11 ) NOT NULL default '0',
@@ -112 +112 @@
 ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]views_track` (
+CREATE TABLE IF NOT EXISTS `bx_groups_views_track` (
   `id` int(10) unsigned NOT NULL,
   `viewer` int(10) unsigned NOT NULL,
@@ -121 +121 @@
 
 -- tag objects
-INSERT INTO `sys_objects_tag` VALUES (NULL, 'bx_groups', 'SELECT `Tags` FROM `[db_prefix]main` WHERE `id` = {iID} AND `status` = ''approved''', 'bx_groups_permalinks', 'm/groups/browse/tag/{tag}', 'modules/?r=groups/browse/tag/{tag}', '_bx_groups');
+INSERT INTO `sys_objects_tag` VALUES (NULL, 'bx_groups', 'SELECT `Tags` FROM `bx_groups_main` WHERE `id` = {iID} AND `status` = ''approved''', 'bx_groups_permalinks', 'm/groups/browse/tag/{tag}', 'modules/?r=groups/browse/tag/{tag}', '_bx_groups');
 
 -- category objects
-INSERT INTO `sys_objects_categories` VALUES (NULL, 'bx_groups', 'SELECT `Categories` FROM `[db_prefix]main` WHERE `id` = {iID} AND `status` = ''approved''', 'bx_groups_permalinks', 'm/groups/browse/category/{tag}', 'modules/?r=groups/browse/category/{tag}', '_bx_groups');
+INSERT INTO `sys_objects_categories` VALUES (NULL, 'bx_groups', 'SELECT `Categories` FROM `bx_groups_main` WHERE `id` = {iID} AND `status` = ''approved''', 'bx_groups_permalinks', 'm/groups/browse/category/{tag}', 'modules/?r=groups/browse/category/{tag}', '_bx_groups');
 
 INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES 

trunk/modules/boonex/groups/install/sql/uninstall.sql

@@ -6 +6 @@
 
 -- tables
-DROP TABLE IF EXISTS `[db_prefix]main`;
-DROP TABLE IF EXISTS `[db_prefix]fans`;
-DROP TABLE IF EXISTS `[db_prefix]admins`;
-DROP TABLE IF EXISTS `[db_prefix]images`;
-DROP TABLE IF EXISTS `[db_prefix]rating`;
-DROP TABLE IF EXISTS `[db_prefix]rating_track`;
-DROP TABLE IF EXISTS `[db_prefix]cmts`;
-DROP TABLE IF EXISTS `[db_prefix]cmts_track`;
-DROP TABLE IF EXISTS `[db_prefix]views_track`;
+DROP TABLE IF EXISTS `bx_groups_main`;
+DROP TABLE IF EXISTS `bx_groups_fans`;
+DROP TABLE IF EXISTS `bx_groups_admins`;
+DROP TABLE IF EXISTS `bx_groups_images`;
+DROP TABLE IF EXISTS `bx_groups_rating`;
+DROP TABLE IF EXISTS `bx_groups_rating_track`;
+DROP TABLE IF EXISTS `bx_groups_cmts`;
+DROP TABLE IF EXISTS `bx_groups_cmts_track`;
+DROP TABLE IF EXISTS `bx_groups_views_track`;
 
 -- system objects