Changeset 1041 for trunk/install

Timestamp:

Feb 14, 2006, 2:14:31 AM (18 years ago)

Author:

rvelices

Message:

feature 251: Rating For Anonymous users

fix: pageitems 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)

Location:

trunk/install

Files:

• db/7-database.php (added)
• phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/phpwebgallery_structure.sql

@@ -174 +174 @@
   `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;