File: sql/cchat.sql

Recommend this page to a friend!
  Classes of Martin Latter   JavaScript Cryptographic Chat   sql/cchat.sql   Download  
File: sql/cchat.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: JavaScript Cryptographic Chat
Chat system that exchanges encrypted messages
Author: By
Last change: revise schema for MySQL 8
Date: 2 years 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;