I love this product! Therefore I took some time to look into it and I have some suggestions for its database structure
- Rename row time to dateline (as they do in the other vbulletin tables)
- Remove username from table formresults and fetch username by querying user table.
("... FROM formresults, user WHERE formresults.userid=user.userid ...")
- Remove userids from table forms and get this information from table forumresults. This is needed for limit users entries for a question. It is very hard to maintain duplicate (redundant) information. You have all these infos when querying forumresults table
("SELECT count(userid) AS usercount FROM forumresults WHERE fid=$fid AND userid=" . $vbulletin->userinfo[userid] ."")
- Remove redirect from table forms. It is redundant to redirecturl.