From ede184cacc411173ba29f05f9b8a12d18a595e0f Mon Sep 17 00:00:00 2001 From: plegall Date: Fri, 19 Aug 2005 13:54:40 +0000 Subject: - 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 --- install/phpwebgallery_structure.sql | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) (limited to 'install') 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 @@ -223,6 +223,18 @@ CREATE TABLE `phpwebgallery_user_cache` ( PRIMARY KEY (`user_id`) ) 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; -- cgit v1.2.3