PHP Classes

File: create_table.sql

Recommend this page to a friend!
  Classes of Petr Rezac   Simple chat   create_table.sql   Download  
File: create_table.sql
Role: Auxiliary data
Content type: text/plain
Description: Create table
Class: Simple chat
Simple Web and MySQL based chat system
Author: By
Last change:
Date: 14 years ago
Size: 367 bytes
 

Contents

Class file image Download 
DROP TABLE IF EXISTS chat;
CREATE TABLE IF NOT EXISTS chat (
  id bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `text` varchar(255) COLLATE utf8_bin NOT NULL,
  ip varchar(255) COLLATE utf8_bin NOT NULL,
  color varchar(255) COLLATE utf8_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;