/****** Object:  Database MT4TRADE    Script Date: 07.05.2008 3:59:58 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'MT4TRADE')
	DROP DATABASE [MT4TRADE]
GO

CREATE DATABASE [MT4TRADE]  ON (NAME = N'MT4TRADE_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\MT4TRADE_Data.MDF' , SIZE = 370, FILEGROWTH = 10%) LOG ON (NAME = N'MT4TRADE_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\MT4TRADE_Log.LDF' , SIZE = 1191, FILEGROWTH = 10%)
 COLLATE SQL_Latin1_General_CP1251_CS_AS
GO

exec sp_dboption N'MT4TRADE', N'autoclose', N'false'
GO

exec sp_dboption N'MT4TRADE', N'bulkcopy', N'false'
GO

exec sp_dboption N'MT4TRADE', N'trunc. log', N'false'
GO

exec sp_dboption N'MT4TRADE', N'torn page detection', N'true'
GO

exec sp_dboption N'MT4TRADE', N'read only', N'false'
GO

exec sp_dboption N'MT4TRADE', N'dbo use', N'false'
GO

exec sp_dboption N'MT4TRADE', N'single', N'false'
GO

exec sp_dboption N'MT4TRADE', N'autoshrink', N'false'
GO

exec sp_dboption N'MT4TRADE', N'ANSI null default', N'false'
GO

exec sp_dboption N'MT4TRADE', N'recursive triggers', N'false'
GO

exec sp_dboption N'MT4TRADE', N'ANSI nulls', N'false'
GO

exec sp_dboption N'MT4TRADE', N'concat null yields null', N'false'
GO

exec sp_dboption N'MT4TRADE', N'cursor close on commit', N'false'
GO

exec sp_dboption N'MT4TRADE', N'default to local cursor', N'false'
GO

exec sp_dboption N'MT4TRADE', N'quoted identifier', N'false'
GO

exec sp_dboption N'MT4TRADE', N'ANSI warnings', N'false'
GO

exec sp_dboption N'MT4TRADE', N'auto create statistics', N'true'
GO

exec sp_dboption N'MT4TRADE', N'auto update statistics', N'true'
GO

if( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) )
	exec sp_dboption N'MT4TRADE', N'db chaining', N'false'
GO

use [MT4TRADE]
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_SIGNAL    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YZ_MT4_SIGNAL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[YZ_MT4_SIGNAL]
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_TICK    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YZ_MT4_TICK]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[YZ_MT4_TICK]
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_HISTORY    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YZ_MT4_HISTORY]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[YZ_MT4_HISTORY]
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_T1    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[YZ_MT4_T1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[YZ_MT4_T1]
GO

/****** Object:  Table [dbo].[BSIGNAL]    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BSIGNAL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BSIGNAL]
GO

/****** Object:  Table [dbo].[EURUSD]    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EURUSD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EURUSD]
GO

/****** Object:  Table [dbo].[MT4HISTORY]    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MT4HISTORY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MT4HISTORY]
GO

/****** Object:  Table [dbo].[MT4TICK]    Script Date: 07.05.2008 4:00:00 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MT4TICK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MT4TICK]
GO

/****** Object:  Login yuraz    Script Date: 07.05.2008 3:59:58 ******/
if not exists (select * from master.dbo.syslogins where loginname = N'yuraz')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'MT4TRADE', @loginlang = N'русский'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'yuraz', null, @logindb, @loginlang
END
GO

/****** Object:  Login BUILTIN\Администраторы    Script Date: 07.05.2008 3:59:58 ******/
exec sp_addsrvrolemember N'BUILTIN\Администраторы', sysadmin
GO

/****** Object:  User yuraz    Script Date: 07.05.2008 3:59:58 ******/
if not exists (select * from dbo.sysusers where name = N'yuraz' and uid < 16382)
	EXEC sp_grantdbaccess N'yuraz', N'yuraz'
GO

/****** Object:  User yuraz    Script Date: 07.05.2008 3:59:58 ******/
exec sp_addrolemember N'db_owner', N'yuraz'
GO

/****** Object:  Table [dbo].[BSIGNAL]    Script Date: 07.05.2008 4:00:00 ******/
CREATE TABLE [dbo].[BSIGNAL] (
	[SignalDateTime] [datetime] NULL ,
	[SIGNAL] [int] NULL ,
	[TP] [decimal](18, 4) NULL ,
	[SL] [decimal](18, 4) NULL ,
	[TRAL] [decimal](18, 4) NULL ,
	[SYMBOL] [char] (6) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL ,
	[FlagSignal] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[EURUSD]    Script Date: 07.05.2008 4:00:00 ******/
CREATE TABLE [dbo].[EURUSD] (
	[Col001] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL ,
	[Col002] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL ,
	[Col003] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL ,
	[Col004] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL ,
	[Col005] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL ,
	[Col006] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL ,
	[Col007] [varchar] (8000) COLLATE SQL_Latin1_General_CP1251_CS_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[MT4HISTORY]    Script Date: 07.05.2008 4:00:00 ******/
CREATE TABLE [dbo].[MT4HISTORY] (
	[idc] [bigint] IDENTITY (1, 1) NOT NULL ,
	[tDateTime] [datetime] NULL ,
	[iTimeFrame] [int] NULL ,
	[sSymbol] [char] (6) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL ,
	[iDateTime] [bigint] NULL ,
	[cOpen] [numeric](18, 4) NULL ,
	[cHigh] [numeric](18, 4) NULL ,
	[cLow] [numeric](18, 4) NULL ,
	[cClose] [numeric](18, 4) NULL ,
	[cVolume] [numeric](18, 4) NULL ,
	[iBar] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[MT4TICK]    Script Date: 07.05.2008 4:00:00 ******/
CREATE TABLE [dbo].[MT4TICK] (
	[idc] [bigint] IDENTITY (1, 1) NOT NULL ,
	[ServerDateTime] [datetime] NULL ,
	[iDateTime] [bigint] NULL ,
	[sSymbol] [char] (6) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL ,
	[cAsk] [numeric](18, 4) NULL ,
	[cBid] [numeric](18, 4) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[MT4TICK] ADD 
	CONSTRAINT [DF_MT4TICK_ServerDateTime] DEFAULT (getdate()) FOR [ServerDateTime]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_HISTORY    Script Date: 07.05.2008 4:00:00 ******/
CREATE PROCEDURE dbo.YZ_MT4_HISTORY
    @RetCode int out
   ,@psSymbol char(6)
   ,@piTimeFrame  int
   ,@piDateTime  bigint
   ,@pdOpen  float
   ,@pdHigh   float
   ,@pdLow   float
   ,@pdClose float
   ,@pdVolume  float
   ,@piBar  int

AS
insert into  MT4HISTORY   ( sSymbol       ,iTimeFrame       ,  iDateTime      , cOpen       , cHigh      , cLow     , cClose      , cVolume      ,iBar) 
                               values  (  @psSymbol ,@piTimeFrame , @piDateTime ,  @pdOpen , @pdHigh,@pdLow, @pdClose ,@pdVolume ,@piBar)
select @RetCode=0
return @RetCode
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_T1    Script Date: 07.05.2008 4:00:00 ******/

CREATE PROCEDURE dbo.YZ_MT4_T1
  @P1  int    out
AS
declare @RET1 int  
select @RET1 = 333
select @P1 = @RET1
return @P1

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_SIGNAL    Script Date: 07.05.2008 4:00:00 ******/

CREATE PROCEDURE  dbo.YZ_MT4_SIGNAL
   @psSymbol char (6)
  , @P1  int    out

AS
select @P1 = SIGNAL  from  BSIGNAL where SYMBOL = @psSymbol
return @P1

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.YZ_MT4_TICK    Script Date: 07.05.2008 4:00:00 ******/

CREATE PROCEDURE dbo.YZ_MT4_TICK
    @RetCode int out
   ,@psSymbol char(6)
   ,@piDateTime  bigint
   ,@pdAsk  float
   ,@pdBid  float
AS
insert into  MT4TICK   ( sSymbol, iDateTime, cAsk, cBid   )  values  ( @psSymbol , @piDateTime,  @pdAsk ,  @pdBid  )
select @RetCode=0
return @RetCode

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO