https://bugs.gpodder.org/show_bug.cgi?id=617
Stefan Kögl <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|low |high --- Comment #1 from Stefan Kögl <[email protected]> 2009-11-01 22:25:51 GMT --- The current initialization scripts contain a separate subscription-table with a public-flag. DROP TABLE IF EXISTS subscription; CREATE TABLE subscription ( device_id INT REFERENCES device (id), podcast_id INT REFERENCES podcast (id), public TINYINT(1) NOT NULL DEFAULT 1, PRIMARY KEY (device_id, podcast_id) ); This table should be replaced by a view containing (device_id, podcast_id, user_id) and one record for each currently subscribed podcast per user and device (i.e. each podcast which has a subscription_log with action=subscribe, not followed by action=unsubscribe for a given device_id) -- Configure bugmail: https://bugs.gpodder.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes. _______________________________________________ gPodder-Bugs mailing list [email protected] https://lists.berlios.de/mailman/listinfo/gpodder-bugs
