DB Design

programming
1

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