VbzCart/coding

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

• procs
• queries
• tables

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:

• /integrity checks

Code

• GitHub: code repository
• Redmine @ vbz: project tracker

Links

Trivia

• International Address Formats: reference for how addresses should be formatted for different countries