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