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
selection,
add links for download pages
Date: 2 years ago
Size: 367 bytes
 

Contents

Class file image Download 
IF NOT EXISTS (SELECT * FROM sysobjects	WHERE name = 'callme_users'	AND xtype = 'U')
BEGIN
	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())
	) ON [PRIMARY]
END;