Website Message System: Updated

Brief

This shows how to setup a simple set of database tables to be integrated into a website for a contact messaging system. Update: Added link to message page

Message Table

CREATE TABLE `messages` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `sender_id` int(11) unsigned default NULL,
  `recipient_id` int(11) unsigned default NULL,
  `subject` varchar(100) default NULL,
  `message` varchar(500) default NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  `replied` bit(1) default NULL,
  PRIMARY KEY  (`id`)
)

Users Table

CREATE TABLE `users` (
  `id` int(11) default NULL,
  `first_name` varchar(40) default NULL,
  `last_name` varchar(40) default NULL,
  `email` varchar(255) default NULL,
  `website` varchar(255) default NULL,
  `password` varchar(40) default NULL,
  `created` datetime default NULL,
  `updated` datetime default NULL
)