Changeset 15700 for trunk/install

Timestamp:

11/24/11 03:33:53 (6 months ago)

Author:

Alexander Trofimov

Message:

Accounts and Profiles

File:

• trunk/install/sql/v70.sql (modified) (5 diffs)

trunk/install/sql/v70.sql

@@ -2846 +2846 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_stat_site`
---
-
-INSERT INTO `sys_stat_site` VALUES(1, 'all', 'Members', 'browse.php', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = ''Active'' AND (`Couple`=''0'' OR `Couple`>`ID`)', 'profiles.php?profiles=Approval', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`!=''Active'' AND (`Couple`=''0'' OR `Couple`>`ID`)', 'mbs.png', 1);
-INSERT INTO `sys_stat_site` VALUES(3, 'onl', 'Online', 'search.php?online_only=1', 'SELECT COUNT(`ID`) AS `count_onl` FROM `Profiles` WHERE `DateLastNav` > SUBDATE(NOW(), INTERVAL 5 MINUTE) AND (`Couple`=0 OR `Couple`>`ID`)', '', '', 'mbs_online.png', 2);
-INSERT INTO `sys_stat_site` VALUES(5, 'ntd', 'New Today', 'browse.php', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = ''Active'' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 1 AND (`Couple`=0 OR `Couple`>`ID`)', '', '', 'mbs.png', 3);
-INSERT INTO `sys_stat_site` VALUES(7, 'nmh', 'This Month', 'browse.php', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = ''Active'' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 30 AND (`Couple`=0 OR `Couple`>`ID`)', '', '', 'mbs.png', 5);
-INSERT INTO `sys_stat_site` VALUES(8, 'tgs', 'Tags', 'tags.php?tags_mode=profile', 'SELECT COUNT( DISTINCT `Tag` ) FROM `sys_tags`', '', '', 'tgs.png', 6);
-INSERT INTO `sys_stat_site` VALUES(10, 'nyr', 'This Year', 'browse.php', 'SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = ''Active'' AND (TO_DAYS(NOW()) - TO_DAYS(`DateReg`)) <= 365 AND (`Couple`=0 OR `Couple`>`ID`)', '', '', 'mbs.png', 7);
-
 -- --------------------------------------------------------
 
@@ -2872 +2861 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
 
---
--- Dumping data for table 'sys_objects_search'
---
-
-INSERT INTO `sys_objects_search` VALUES(3, 'profile', '_Profiles', 'BxTemplSearchProfile', 'templates/tmpl_{tmpl}/scripts/BxTemplSearchProfile.php');
 
 -- --------------------------------------------------------
@@ -2940 +2924 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_objects_tag`
---
-
-INSERT INTO `sys_objects_tag` VALUES(1, 'profile', 'SELECT `Tags` FROM `Profiles` WHERE `ID` = {iID} AND `Status` = ''Active''', 'enable_modrewrite', 'search/tag/{tag}', 'search.php?Tags={tag}', '_Profiles');
 
 -- --------------------------------------------------------
@@ -3155 +3134 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_objects_vote`
---
-
-INSERT INTO `sys_objects_vote` VALUES(1, 'profile', 'sys_profile_rating', 'sys_profile_voting_track', 'pr_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'Profiles', 'Rate', 'RateCount', 'ID', '', '');
 
 -- -------------------------------------------------------
@@ -3371 +3345 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_objects_views`
---
-
-INSERT INTO `sys_objects_views` VALUES(NULL, 'profiles', 'sys_profile_views_track', 86400, 'Profiles', 'ID', 'Views', 1);
 
 --