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: MSSQL Server Database support

add new sql scripts for mssql support,
modified some function in SqlFuncProc php for automatic database
selection,
add links for download pages
Date: 2 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;