from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search

At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below).

Data Design

The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form *_X_*). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary.

At this point, I'm trying to eliminate the need for PROCs and queries (VIEWs), but work is still in progress.

Other data-related stuff: