- modification : RSS feed work only with a given feed identifier. Thus we

  can avoid fixed frequency notification to concentrate on variable
  frequency notification, which is much more interesting. To do this, feeds
  have moved to a dedicated table allowing each user (including guest user)
  to have more than on feed.


git-svn-id: http://piwigo.org/svn/trunk@833 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 12 insertions, 2 deletions

diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 98e81b3e9..28368df69 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -224,6 +224,18 @@ CREATE TABLE `phpwebgallery_user_cache` (
 ) TYPE=MyISAM;
 
 --
+-- Table structure for table `phpwebgallery_user_feed`
+--
+
+DROP TABLE IF EXISTS `phpwebgallery_user_feed`;
+CREATE TABLE `phpwebgallery_user_feed` (
+  `id` varchar(50) binary NOT NULL default '',
+  `user_id` smallint(5) unsigned NOT NULL default '0',
+  `last_check` datetime default NULL,
+  PRIMARY KEY  (`id`)
+) TYPE=MyISAM;
+
+--
 -- Table structure for table `phpwebgallery_user_group`
 --
 
@@ -251,8 +263,6 @@ CREATE TABLE `phpwebgallery_user_infos` (
   `show_nb_comments` enum('true','false') NOT NULL default 'false',
   `recent_period` tinyint(3) unsigned NOT NULL default '7',
   `template` varchar(255) NOT NULL default 'default',
-  `last_feed_check` datetime default NULL,
-  `feed_id` varchar(50) binary default NULL,
   `registration_date` datetime NOT NULL default '0000-00-00 00:00:00',
   UNIQUE KEY `user_infos_ui1` (`user_id`)
 ) TYPE=MyISAM;