in reply to best data model for chat program

CREATE TABLE chat_room
(
    handle NOT NULL PRIMARY KEY VARCHAR(30),
    password  NOT NULL VARCHAR(30),
    INDEX (handle)
);

[download]
That should just about do it. 
()-()
 \"/
  `

Replies are listed 'Best First'.
Re: Re: best data model for chat program
by dev2000 (Sexton) on May 21, 2002 at 21:33 UTC
    Sure, this is a good structure for the login, but what about the actual chat data, like sending/receiving messages in the current room or to/from other chatters?
[reply]
      Think about it. 
      ()-()
 \"/
  `
[reply]

In Section Seekers of Perl Wisdom