Login   Register  
PHP Classes
elePHPant
Icontem

File: dbdetails

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Krish Nimishakavi  >  Chat  >  dbdetails  >  Download  
File: dbdetails
Role: Configuration script
Content type: text/plain
Description: This is lists all the mysql tables required for this class
Class: Chat
File based chatting
Author: By
Last change:
Date: 2003-05-12 19:28
Size: 1,799 bytes
 

Contents

Class file image Download
The database tables descriptions are as follows.

1) db table "chat" description.

+-----------+--------------+------+-----+---------------------+----------------+
| Field     | Type         | Null | Key | Default             | Extra          |
+-----------+--------------+------+-----+---------------------+----------------+
| __id      | int(4)       |      | PRI | NULL                | auto_increment |
| sesId     | varchar(128) |      |     |                     |                |
| user      | varchar(64)  |      |     |                     |                |
| room_name | varchar(128) |      |     | Main Room           |                |
| __login   | datetime     |      |     | 0000-00-00 00:00:00 |                |
| __logout  | datetime     |      |     | 0000-00-00 00:00:00 |                |
| ip        | varchar(15)  |      |     | 000.000.000.000     |                |
+-----------+--------------+------+-----+---------------------+----------------+

2) db table "rooms" description

+-------------+--------------+------+-----+-----------------+----------------+
| Field       | Type         | Null | Key | Default         | Extra          |
+-------------+--------------+------+-----+-----------------+----------------+
| __id        | int(4)       |      | PRI | NULL            | auto_increment |
| room_name   | varchar(128) |      |     | Main Room       |                |
| creator     | varchar(64)  |      |     |                 |                |
| no_of_users | int(3)       |      |     | 0               |                |
| ip          | varchar(15)  |      |     | 000.000.000.000 |                |
| status      | tinyint(1)   |      |     | 0               |                |
+-------------+--------------+------+-----+-----------------+----------------+