diff options
| author | Christian Fowler <spider@viovio.com> | 2010-04-22 21:24:49 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2010-04-22 21:24:49 +0000 |
| commit | 57fbb79c2513a9c89fc548500f9bcbddf925ade8 (patch) | |
| tree | 1af8888d860d0305dff74b99f5c306d587003836 /admin | |
| parent | 34b57be8c124252088ed75567d101e8d7391b77f (diff) | |
| download | stats-57fbb79c2513a9c89fc548500f9bcbddf925ade8.tar.gz stats-57fbb79c2513a9c89fc548500f9bcbddf925ade8.tar.bz2 stats-57fbb79c2513a9c89fc548500f9bcbddf925ade8.zip | |
Add code to tracking referering url to registered user_id
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 25 | ||||
| -rw-r--r-- | admin/upgrades/1.0.1.php | 44 |
2 files changed, 69 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 434e8f7..faeddfc 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -13,6 +13,18 @@ $tables = array( pageviews I8 ", +'stats_referer_urls' => " + referer_url_id I4 PRIMARY, + referer_url X NOTNULL +", + +'stats_referer_users_map' => " + referer_url_id I4 PRIMARY, + user_id I4 PRIMARY + CONSTRAINT ' + , CONSTRAINT `stats_referer_users_url_ref` FOREIGN KEY (`referer_url_id`) REFERENCES `".BIT_DB_PREFIX."stats_referer_urls` (`referer_url_id`) + , CONSTRAINT `stats_referer_users_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`) ' +", ); global $gBitInstaller; @@ -26,6 +38,19 @@ $gBitInstaller->registerPackageInfo( STATS_PKG_NAME, array( 'license' => '<a href="http://www.gnu.org/licenses/licenses.html#LGPL">LGPL</a>', ) ); +// ### 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() ), +); +$gBitInstaller->registerSchemaIndexes( STATS_PKG_NAME, $indices ); + +// ### Sequences +$sequences = array ( + 'stats_referer_url_id_seq' => array( 'start' => 1 ) +); +$gBitInstaller->registerSchemaSequences( STATS_PKG_NAME, $sequences ); + // ### Default Preferences $gBitInstaller->registerPreferences( STATS_PKG_NAME, array( array(STATS_PKG_NAME, 'stats_referers','y'), diff --git a/admin/upgrades/1.0.1.php b/admin/upgrades/1.0.1.php new file mode 100644 index 0000000..3aeea49 --- /dev/null +++ b/admin/upgrades/1.0.1.php @@ -0,0 +1,44 @@ +<?php +/** + * @version $Header: /cvsroot/bitweaver/_bit_stats/admin/upgrades/1.0.1.php,v 1.1 2010/04/22 21:24:49 spiderr Exp $ + */ +global $gBitInstaller; + +$infoHash = array( + 'package' => STATS_PKG_NAME, + 'version' => str_replace( '.php', '', basename( __FILE__ )), + 'description' => "Add referer URL tracking for user registrations.", + 'post_upgrade' => NULL, +); +$gBitInstaller->registerPackageUpgrade( $infoHash, array( + array( 'DATADICT' => array( + array( 'CREATE' => array( + 'stats_referer_urls' => " + referer_url_id I4 PRIMARY, + referer_url X NOTNULL + ", + )), + array( 'CREATEINDEX' => array( + 'stats_referer_url_idx' => array( 'stats_referer_urls', 'referer_url', array() ), + )), + array( 'CREATESEQUENCE' => array( + 'stats_referer_url_id_seq', + )), + array( 'CREATE' => array( + 'stats_referer_users_map' => " + referer_url_id I4 PRIMARY, + user_id I4 PRIMARY + CONSTRAINT ' + , CONSTRAINT `stats_referer_users_url_ref` FOREIGN KEY (`referer_url_id`) REFERENCES `".BIT_DB_PREFIX."stats_referer_urls` (`referer_url_id`) + , CONSTRAINT `stats_referer_users_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`) ' + ", + )), + 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() ), + )), + array( 'CREATESEQUENCE' => array( + 'stats_referer_url_id_seq', + )), + )), +)); |