VbzCart
Having evaluated osCommerce and found that, although it had many features I would like to have on vbz.net, it also lacked some crucial features currently needed (many of which are provided by the existing shopping cart system, and some of which would be needed in order to effectively manage porting the data from the existing system).
So I'm writing a new system, in PHP, based on the data design of the existing VBZ cart system and adding new pieces as needed.
I will be taking notes on this page and gradually refining them into something resembling documentation, with the ultimate goal of producing a system which could be released under an open source license.
Tables
Fields which are used as keys (i.e. unique identifiers) are in italics
Administration
- admin_users -- users with access to the admin system
- ID - int(4)
- Name - varchar(32)
- Email - varchar(128)
- admin_groups -- each group has a role to play, and each role requires a particular set of privileges
- ID - int(4)
- Name - varchar(32)
- Descr
- admin_privs -- particular privileges; meaning is defined in code
- ID - int(4)
- Name - varchar(32)
- Descr
Collection/link tables:
- admin_user_groups -- users in each group / groups to which each user belongs
- ID_User - int(4)
- ID_Group - int(4)
- admin_group_privs -- privileges each group has / groups having a particular privilege
- ID_Group - int(4)
- ID_Priv - int(4)
