PHP Classes

File: libSiteMessage.sql

Recommend this page to a friend!
  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: 19 years ago
Size: 854 bytes


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) );