Creating a CMS for a (1) Page Site http://working.bushidodeep.com/kevon/index.html
I’ve gotten to the DB design and was wondering if it is as functional as it could be? The upload table will store urls to gif and .pdf files and
The site DB will then populate the site as a PHP template.
Hi, Are the following tables all that would be needed for this site CMS? The upload table URLS would point to image and pdf files. Pardon the vague post. Site Table ID int(6) UNSIGNED No auto_increment header varchar(100) latin1_swedish_ci Yes NULL subhead varchar(100) latin1_swedish_ci Yes NULL content_main text latin1_swedish_ci No content_sub text latin1_swedish_ci Upload Table upload_id int(10) UNSIGNED No auto_increment file_name varchar(30) latin1_swedish_ci No file_size int(6) UNSIGNED No file_type varchar(30) latin1_swedish_ci No description varchar(100) latin1_swedish_ci Yes NULL date_entered timestamp ON UPDATE CURRENT_TIMESTAMP No CURRENT_TIMESTAMP