# DB Design

**URL:** <https://forum.kirupa.com/t/db-design/248593>\
**Category:** programming\
**Created:** [January 9, 2008, 11:52pm UTC](https://forum.kirupa.com/t/db-design/248593 "2008-01-09T23:52:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cki](https://avatars.discourse-cdn.com/v4/letter/c/85f322/32.png) [@cki](https://forum.kirupa.com/u/cki)\
**Post date:** [January 9, 2008, 11:52pm UTC](https://forum.kirupa.com/t/db-design/248593/1 "2008-01-09T23:52:29Z")

</div>

Creating a CMS for a (1) Page Site [http://working.bushidodeep.com/kevon/index.html](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.

```auto

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

```