aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2005-08-19 13:54:40 +0000
committerplegall <plg@piwigo.org>2005-08-19 13:54:40 +0000
commitede184cacc411173ba29f05f9b8a12d18a595e0f (patch)
tree02ef32bc51fe1969ab4929ae29e3161efd0b4422 /install/phpwebgallery_structure.sql
parentc8bf225cd4e2bc6c55a0e05b60537a00fdfee142 (diff)
- 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
Diffstat (limited to 'install/phpwebgallery_structure.sql')
-rw-r--r--install/phpwebgallery_structure.sql14
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;