I send this message periodically to the list. Sorry you couldn't find it.
Message table looks like this (at least in my database server's
fieldtypes... M$ SQL Server)
CREATE TABLE [dbo].[Message] (
[message_name] [varchar] (200) NOT NULL ,
[repository_name] [varchar] (200) NOT NULL ,
[message_state] [varchar] (30) NOT NULL ,
[error_message] [text] NULL ,
[sender] [varchar] (200) NOT NULL ,
[recipients] [text] NOT NULL ,
[remote_host] [varchar] (100) NOT NULL ,
[remote_addr] [varchar] (20) NOT NULL ,
[message_body] [image] NOT NULL ,
[last_updated] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Message] WITH NOCHECK ADD
CONSTRAINT [PK_Message] PRIMARY KEY NONCLUSTERED
(
[message_name],
[repository_name]
) ON [PRIMARY]
GO
'text' is arbitrarily long char data, and 'image' is arbitrarily long binary
data.
The Message is used for the spool and mail repositories. You can point
multiple repositories at this single table, so long as you use different
repository_names (part of the town:// construct)
The User table can be any table that has username and password in it. Town
will detect the primary key and assuming username is unique in the table, it
doesn't have to be the primary key. This will probably change in the
future, but that's how it works for now.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Michael Loyd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 4:09 AM
Subject: Database Structure
> Hi. Sorry for posting a novice question that might be obvious to
everyone.
> But I'm just starting out with James and email applications. I tried
> searching the archives but couldn't find the answer.
>
> What are the table structures for all of the tables that James could
> utilize? I'm using MySQL and I saw the script to create the Message
> table... but what about the table for managing users via a database table,
> spools, repositories, etc. Is there any documentation on this?
>
> I understand how to modify the JAMES.conf.xml document to use the database
> but it's just not painfully obvious to me how to set up the database
tables.
>
> Thanks for the help,
> Michael
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
