File: SqlFuncProc/SqlProc/sqlsrv_initialize.sql

Recommend this page to a friend!
  Classes of Andras Toth  >  Call Me  >  SqlFuncProc/SqlProc/sqlsrv_initialize.sql  >  Download  
File: SqlFuncProc/SqlProc/sqlsrv_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
add links for download pages
Date: 2 months ago
Size: 367 bytes


Class file image Download
IF NOT EXISTS (SELECT * FROM sysobjects	WHERE name = 'callme_users'	AND xtype = 'U')
	CREATE TABLE [dbo].[callme_users](
		[id] [int] IDENTITY(1,1) NOT NULL,
		[name] [nvarchar](12) NULL,
		[email] [nvarchar](50) NULL,
		[pass] [nvarchar](12) NULL,
		[peer_id] [nvarchar](20) NULL,
		[img] [varbinary](MAX) NULL,
		[updated]  AS (getdate())