file auditing
+ Reply to Thread
Results 1 to 3 of 3

Thread: Proper Database Structure that may support IM

  1. #1
    Join Date
    May 2008
    Posts
    6

    Proper Database Structure that may support IM

    IR*7;m planning a web application, but later the scripting may change, but I donR*7;t want the database structure to change, so for the start I want to get it right.

    The application will later have an IM (instant messenger) just like Yahoo/MSN, so what is the proper way to store the userR*7;s information now.
    Then later I will find I way of connecting to it.

    Note: The registration form will contain: username,password,fullname,email&country

    But if you have any knowledge of how is properly done, I will appreciate it.

    I`m using MySql/PHP, But the IM will later be written in Python.
    Please tell me what I need then I start making necessary arrangement towards it.

    Thank you.
    Abah

  2. #2
    Join Date
    Jan 2005
    Posts
    623
    Welcome to the forum Abah.

    Well for starters I would structure your main (SERVER SIDE) database as followed:

    TABLENAME: name_of_your_messenger
    FIELDS: username, password, email, name, age, country, last_login, status

    Status will be one of your most important fields to prevent multiple users from loggin into the same account.

    If you plan to keep a history of chat logs you will need a second table Chat_Logs and will need to add a primary key for each user in your main name_of_your_messenger database. In the Chat_Logs database you would need the following fields: user_id, receiver_id, timestamp, message

    For the client side registry keys I would use:
    REGKEY: hkey_localmachine/software/name_of_your_messenger
    REGKEY: hkey_localmachine/software/name_of_your_messenger/username

    Under each username key I would have a password and port key.

    I've never written an instant messenger system but if I were to try, this is the first structure that comes to mind.
    Last edited by SyntaXmasteR; 05-29-2008 at 11:25 AM.
    [url=http://www.syntax******.info/tools/services.php]Speed Up Windows XP[/url]
    [url=http://www.syntax******.info/tools/ip.php]Get An Ip Address[/url]
    [url=http://www.syntax******.info/tools/base_converter.php]Base Converter[/url]
    --------------------------------
    [URL=http://www.boninroad.com/syntax******/]Old Site[/URL]
    [URL=http://www.syntax******.info]Comming Soon[/URL]

  3. #3
    Join Date
    May 2008
    Posts
    1

    xdd nnice

    xdddddd nice lol

+ Reply to Thread

Similar Threads

  1. BIN Database
    By EL_Speciale in forum Programming
    Replies: 12
    Last Post: 03-30-2010, 02:13 AM
  2. BIN Database
    By Geoff in forum General discussion
    Replies: 1
    Last Post: 11-28-2007, 07:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts