Icontem

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:
Date: 4 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;