diff options
| author | rvelices <rv-github@modusoptimus.com> | 2006-02-14 01:14:31 +0000 |
|---|---|---|
| committer | rvelices <rv-github@modusoptimus.com> | 2006-02-14 01:14:31 +0000 |
| commit | f328dd14bba142c256dbd2ff47713ec6813c07c2 (patch) | |
| tree | 7ab82bc88ebf80ed6ac7dcce2a89f59f30c417b3 /install/phpwebgallery_structure.sql | |
| parent | 3411ec84f694c92d71f331a213c522e24448ee41 (diff) | |
feature 251: Rating For Anonymous users
fix: page['items'] for favorites category and remove old use of $has_next,
$has_prev in picture.php (slideshow and favorites section)
optimization: one less sql query in picture.php when there are no comments
display of the refresh url in redirect.tpl (useful when debugging with
browser meta redirects disabled)
git-svn-id: http://piwigo.org/svn/trunk@1041 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 30ea8b0bd..cc8608afe 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -173,8 +173,10 @@ DROP TABLE IF EXISTS `phpwebgallery_rate`; CREATE TABLE `phpwebgallery_rate` ( `user_id` smallint(5) NOT NULL default '0', `element_id` mediumint(8) unsigned NOT NULL default '0', + `anonymous_id` varchar(45) NOT NULL default '', `rate` tinyint(2) unsigned NOT NULL default '0', - PRIMARY KEY (`user_id`,`element_id`) + `date` date NOT NULL default '0000-00-00', + PRIMARY KEY (`element_id`,`user_id`,`anonymous_id`) ) TYPE=MyISAM; -- |