Here is the design for the PHPMotors database. I'll put it in a table once I figure out how.
Messages
| Column | data type | key type |
| message id | unsigned int | primary key |
| name | varchar(60) | foreign key |
| user id | unsigned int | foreign key |
| user type | unsigned int | foreign key |
| email address | varchar(60) | * |
| message | text | * |
| date | timestamp | * |
| message type | enum | * |
Users
| Column | data type | key? |
| user id | unsigned int | primary key |
| name | varchar(60) | * |
| email address | varchar(60 | * |
| user type | enum | * |
| date joined | date | * |
| last active | timestamp | * |
| address | text | * |
| favorite cars | set | * |
| notes | text | * |
Contact Me | Policies | Colophon
© 2009, Jonathan Dunstan, All Rights Reserved.