PHP Classes
elePHPant
Icontem

File: sql/cchat.sql

Recommend this page to a friend!
  Classes of Martin Latter  >  PHP Secure Chat  >  sql/cchat.sql  >  Download  
File: sql/cchat.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP Secure Chat
Chat box between users using encrypted messages
Author: By
Last change:
Date: 2 years ago
Size: 370 bytes
 

 

Contents

Class file image Download
CREATE DATABASE cchat CHARACTER SET latin1 COLLATE latin1_general_ci;


USE cchat;


CREATE TABLE `chatbox` (

	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` CHAR(15) NOT NULL,
	`message` VARCHAR(384) NOT NULL, -- 255 = ~352 bytes of base64
	`date` INT(10) UNSIGNED NOT NULL,
	KEY `kdate` (`date`),
	PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;