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


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;