Login   Register  
PHP Classes
elePHPant
Icontem

File: create_table.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 4 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;