[sabret00the]

| prs_user                                                                         |
=================================================
| recordid | userid | subscriptions | favourites | responseupdate |
---------------------------------------------------------------

basically as soon a user either tries to subscribe, mark something as a favourite are ask for a response update it creates a record for the user.

more info on the schema

[sql]CREATE TABLE `prs_users` (
`recordid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`subscriptions` mediumtext collate latin1_general_ci NOT NULL,
`favourites` mediumtext collate latin1_general_ci NOT NULL,
`responseupdate` enum('1','0') collate latin1_general_ci NOT NULL default '1',
PRIMARY KEY (`recordid`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;[/sql]