Login   Register  
PHP Classes
elePHPant
Icontem

File: libSiteMessage.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Cornelius Bolten  >  libSiteMessage  >  libSiteMessage.sql  >  Download  
File: libSiteMessage.sql
Role: Auxiliary data
Content type: text/plain
Description: Tables needed.
Class: libSiteMessage
Web based messaging system for community sites
Author: By
Last change:
Date: 2004-08-02 02:33
Size: 854 bytes
 

Contents

Class file image Download
#
#	$RCSfile: libSiteMessage.sql,v $
#	@author 	$Author: Cornelius Bolten $
#	@version	$Revision: 1.1 $
#
#	@description:
#	sql-setup-script for libSiteMessage SQLITE
#

CREATE TABLE libSiteMessage (
        sm_id			INTEGER		PRIMARY KEY NOT NULL,
        sm_sender_id    INTEGER     NOT NULL,
       	sm_receiver_id  INTEGER     NOT NULL,
       	sm_subject_data TEXT		NOT NULL,
        sm_message_data TEXT		NOT NULL,
        sm_message_date VARCHAR(15) NOT NULL,
		sm_message_read	VARCHAR(15) NULL,
		sm_folder_id	INTEGER 	NULL,
        UNIQUE (sm_id)
);

CREATE TABLE libSiteMessageFolders (
		sm_folder_id	INTEGER 	PRIMARY KEY	NOT NULL,
		sm_user_id		INTEGER		NOT NULL,		
		sm_folder_name	VARCHAR(50)	NOT NULL,
		sm_parent_id	INTEGER(10)	NULL,
		sm_folder_date	VARCHAR(15)	NOT NULL,
		UNIQUE (sm_user_id,sm_folder_name)
);