The database I made for this script is pretty simple. It contains 8 columns. Wanted to just store basic information, as to keep things simple. What i’m doing is giving each website a category of products that CMH sells, a unique cascading style sheet, and a small amount of webpage related content, such as page title, and comments.

You may be asking asking yourself “Where does the category come into play?”.
Well, we have an existing product database. Each product belongs to a category. By defining a catagory for our website, then we should be able to pull all of the products from the existing db, and generate pages for them, with existing product content.

Preamble is a column I made to give a brief explination of what the website is about. Comments is where I will be putting the content for our front page.

mysql> show columns from virtual_1;
+————+————–+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————+————–+——+—–+———+——-+
| category | varchar(30) | | PRI | | |
| site_id | varchar(100) | YES | | NULL | |
| stylesheet | varchar(100) | YES | | NULL | |
| page_title | varchar(100) | YES | | NULL | |
| comments | text | YES | | NULL | |
| meta_desc | varchar(250) | YES | | NULL | |
| meta_kw | varchar(1000) | YES | | NULL | |
| preamble | text | YES | | NULL | |
+————+————–+——+—–+———+——-+