jennapaphornE
New Member
I'm designing a database in MySQL and PHP for a basic CMS. The CMS will have a front end which will allow sorting and searching. The backend will allow authorized users to upload files.I'm using PHPMyAdmin and I'd like help setting up my database. I am open to answers explaining various MySQL datatypes and what they are good for as well . Use common database fields as examples please.Below is a list of what I'd like. What's missing and what datatypes do I need to use?\[quote\] Resources (For my files)
- file_id
- filename (Files are presorted and display names and paths are derived from here.)
- file_type (PDF | AUDIO | VIDEO | PHOTO [Also used to generate file urls])
- upload date (timestamp in PHP or MySQL)
- uploaded_by (User ID from Users table)
- event (event_id from Events table, optional)
- user_id
- first_name
- last_name
- password
- phone_number (optional)
- permissions_level (read only, upload)
- creation_date
- event_id
- event_name
- event_location
- event_date
- event_description
- entry_date