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: 11 years ago
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 | |
+-------------+--------------+------+-----+-----------------+----------------+