id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 10942,Improvements for plugin's db schema,Steffen Hoffmann,Steffen Hoffmann,"In addition to issues with the db code itself (#10706) I feel that the db schema is flawed too. It should definitely follow Trac's resource concept more closely and store (resource) 'realm' and 'resource_id' of voted resources. This would help to avoid string functions in queries using more portable SQL instead (#4546). And while at it lets track the vote time (stamp) too, because there might be a use case mentioned in #7592. So how about making a fresh schema version 2 part of the aforementioned db rework then? Count me in, if you need assistance, code review or in-depended testing.",enhancement,closed,normal,VotePlugin,normal,fixed,schema upgrade db,,