Icontem

File: SqlFuncProc/SqlProc/mysql_initialize.sql

Recommend this page to a friend!
  Classes of Andras Toth  >  Call Me  >  SqlFuncProc/SqlProc/mysql_initialize.sql  >  Download  
File: SqlFuncProc/SqlProc/mysql_initialize.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Call Me
Establish video chat communications between users
Author: By
Last change:
Date: 4 years ago
Size: 561 bytes
 

Contents

Class file image Download
CREATE TABLE IF NOT EXISTS `callme_users` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(12) NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci',
	`email` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci',
	`pass` VARCHAR(12) NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci',
	`peer_id` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8_hungarian_ci',
	`img` MEDIUMBLOB NULL,
	`updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	UNIQUE INDEX `email` (`email`)
) COLLATE='utf8_hungarian_ci' ENGINE=InnoDB;