PHP Classes

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: revise schema for MySQL 8
Date: 1 year ago
Size: 388 bytes
 

Contents

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


USE cchat;


CREATE TABLE `chatbox`
(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` CHAR(16) NOT NULL,
    `message` VARCHAR(384) NOT NULL COMMENT '255 = ~352 bytes of base64',
    `date` INT UNSIGNED NOT NULL,
    KEY `idx_date` (`date`),
    PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;
For more information send a message to info at phpclasses dot org.