Help with Data Modeling -> free/ open-source project on keyboard short

data modeling mysql example

[benni_203]

Hello,
Would somebody with data modeling experience look at the data model I developed? I am working on a site dedicated to keyboard shortcuts driven by a MySQL database. The first version works, but is not that great. I am trying to come up with something better and can use some help. It is a hobby of mine and I think the world could use one user-driven database with all keyboard shortcuts as a reference.
Thanks!
Max (aka Benni)

Project:
- Database-driven Keyboard Shortcut Site

Database in place:
- Two tables for each application.
- Table 1 = Shortcuts per Application
- Table 2 = Shortcut Categories within application

Data Model planned:
- Only one table for Shortcuts and one for Shortcut Categories
- User can now upload/edit shortcuts. User Management through phpBB forum
- Since Users can edit, each relevant table has columns to trace changes
- Applications are categorized by type (e.g. Spreadsheets, Text Editors), by provider (e.g. Microsoft, Open Source), and by platform (e.g. Linux, Windows)

[edited by: coopster at 12:29 am (utc) on Feb. 27, 2009]
[edit reason] removed urls per TOS [webmasterworld.com] [/edit]

[coopster]

Can you post the CREATE TABLE statements for the database in place, categories and shortcuts?