jsbin/jsbin — pull request #1100 by loudwinston (2014-02-07 19:47:55+00:00)
Title: Scripted/upstream/fix/sqlite visibility missing

This pull request mostly fixes issues with new installations running on SQLite. I wasn't able to run jsbin using sqlite from a clone of the github repo, so I figured out why and fixed it :)

There's 4 main changes here.
1) Added the 'visibility' column to the 'owners' table for both mysql and sqlite full db creation scripts.

2) Modify SQLite DB lib to pass a value for the visibility column when calling setBinOwner, (prevents a SQL error because of a missing column value)

3) Standardize the result in some bin handlers to be a single object instead of an array where the calling function uses only the first item.

4) Handle the case where there are no users in the database so the result for ownership is undefined when retrieving bin metadata.