Case 3:

CREATE TABLE content:
content_id	NOT NULL	UNSIGNED	INT	PRIMARY KEY	auto_increment
content_type	NOT NULL		ENUM('Input','Output')
content_data	NOT NULL		VARCHAR2(100,000)
This table stores content from the website.
CREATE TABLE user
user_id	NOT NULL	UNSIGNED	INT	PRIMARY KEY	auto_increment
user_name	NOT NULL		VARCHAR2(15)
user_first_name	NOT NULL		VARCHAR2(40)
user_last_name	NOT NULL		VARCHAR2(40)
user_email	NOT NULL		VARCHAR2(100)
user_phone	NOT NULL		VARCHAR2(15)
user_timestamp	NOT NULL	ON UPDATE CURRENT_TIMESTAMP	TIMESTAMP	CURRENT_TIMESTAMP
This table manages users who may access my database.

Continue > page 2