diff options
| author | Christian Fowler <spider@viovio.com> | 2010-04-24 16:31:14 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2010-04-24 16:31:14 +0000 |
| commit | cce0032b72bb52db166804415920c5d923ba3ccd (patch) | |
| tree | a7c714f515a133403ead359e03c85303bc694830 /admin | |
| parent | d8e0585f043adf10343f7242dcaaadd8221f1b34 (diff) | |
| download | stats-cce0032b72bb52db166804415920c5d923ba3ccd.tar.gz stats-cce0032b72bb52db166804415920c5d923ba3ccd.tar.bz2 stats-cce0032b72bb52db166804415920c5d923ba3ccd.zip | |
fix indexes names and tablesCVS_HEAD
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 9 | ||||
| -rw-r--r-- | admin/upgrades/1.0.1.php | 7 |
2 files changed, 7 insertions, 9 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index faeddfc..13fff5f 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -40,8 +40,9 @@ $gBitInstaller->registerPackageInfo( STATS_PKG_NAME, array( // ### Indexes $indices = array ( - 'stats_referer_map_url_idx' => array( 'stats_referer_urls', 'referer_url_id', array() ), - 'stats_referer_map_user_idx' => array( 'stats_referer_urls', 'user_id', array() ), + 'stats_referer_url_idx' => array( 'table' => 'stats_referer_urls', 'cols' => 'referer_url', 'opts' => 'UNIQUE' ), + 'stats_referer_map_url_idx' => array( 'table' => 'stats_referer_urls', 'cols' => 'referer_url_id', 'opts' => NULL ), + 'stats_referer_map_user_idx' => array( 'table' => 'stats_referer_urls', 'cols' => 'user_id', 'opts' => NULL ), ); $gBitInstaller->registerSchemaIndexes( STATS_PKG_NAME, $indices ); @@ -63,7 +64,3 @@ $gBitInstaller->registerUserPermissions( STATS_PKG_NAME, array( array('p_stats_view', 'Can view site stats', 'basic', STATS_PKG_NAME), ) ); -// Requirements -$gBitInstaller->registerRequirements( STATS_PKG_NAME, array( - 'liberty' => array( 'min' => '2.1.4' ), -)); diff --git a/admin/upgrades/1.0.1.php b/admin/upgrades/1.0.1.php index 3aeea49..1899c59 100644 --- a/admin/upgrades/1.0.1.php +++ b/admin/upgrades/1.0.1.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_stats/admin/upgrades/1.0.1.php,v 1.1 2010/04/22 21:24:49 spiderr Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_stats/admin/upgrades/1.0.1.php,v 1.2 2010/04/24 16:31:00 spiderr Exp $ */ global $gBitInstaller; @@ -34,8 +34,9 @@ $gBitInstaller->registerPackageUpgrade( $infoHash, array( ", )), array( 'CREATEINDEX' => array( - 'stats_referer_map_url_idx' => array( 'stats_referer_urls', 'referer_url_id', array() ), - 'stats_referer_map_user_idx' => array( 'stats_referer_urls', 'user_id', array() ), + 'stats_referer_urls_idx' => array( 'stats_referer_urls', 'referer_url', array() ), + 'stats_referer_map_url_idx' => array( 'stats_referer_users_map', 'referer_url_id', array() ), + 'stats_referer_map_user_idx' => array( 'stats_referer_users_map', 'user_id', array() ), )), array( 'CREATESEQUENCE' => array( 'stats_referer_url_id_seq', |