diff options
| author | Christian Fowler <spider@viovio.com> | 2007-05-04 05:57:13 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-05-04 05:57:13 +0000 |
| commit | b2978e5e6a02527e9e7071a0a2eaf1bcd1095ce9 (patch) | |
| tree | f2d164ec97f6b06315e1991bf893219fe6d2fd0a /admin | |
| parent | 2940f2246492b6d92151be6bf460a3bdb26ece1d (diff) | |
| download | newsletters-b2978e5e6a02527e9e7071a0a2eaf1bcd1095ce9.tar.gz newsletters-b2978e5e6a02527e9e7071a0a2eaf1bcd1095ce9.tar.bz2 newsletters-b2978e5e6a02527e9e7071a0a2eaf1bcd1095ce9.zip | |
SCHEMA CHANGE: add mail_clickthrough table
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 9 | ||||
| -rw-r--r-- | admin/upgrade_inc.php | 10 |
2 files changed, 19 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index b9c7fc8..a33560e 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -72,6 +72,15 @@ $tables = array( , CONSTRAINT `mailq_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users`( `user_id` )' " +'mail_clickthrough' => " + user_id I4 NOTNULL, + content_id I4 NOTNULL, + clicked_url C(250) NOTNULL, + clicks I4 + CONSTRAINT ', CONSTRAINT `mail_clickthrough_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`), + CONSTRAINT `mail_clickthrough_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' +" + ); global $gBitInstaller; diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index a026749..6ccfc63 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -72,6 +72,16 @@ array( 'DATADICT' => array( 'tiki_mail_mailings' => 'mail_mailings', 'tiki_mail_queue' => 'mail_queue', )), + array( 'CREATE' => array ( + 'mail_clickthrough' => " + user_id I4 NOTNULL, + content_id I4 NOTNULL, + clicked_url C(250) NOTNULL, + clicks I4 + CONSTRAINT ', CONSTRAINT `mail_clickthrough_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`), + CONSTRAINT `mail_clickthrough_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' + " + )), )), ) ), |