/****** Object:  Table [dbo].[wmozgas]    Script Date: 10/08/2013 09:23:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[wmozgas](
	[MOZGASKOD] [nvarchar](10) NOT NULL,
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[TETEL] [dbo].[bizonylat_tetel] NOT NULL,
	[SORSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[DARAB] [dbo].[mennyiseg] NOT NULL,
	[kicsoda] [dbo].[kicsoda] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[term_veszteseg]    Script Date: 10/08/2013 09:23:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[term_veszteseg](
	[bizszam] [dbo].[bizonylat_szam] NOT NULL,
	[tetel] [dbo].[bizonylat_tetel] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[eredeti_db] [numeric](18, 3) NOT NULL,
	[darab] [numeric](18, 3) NOT NULL,
	[kicsoda] [dbo].[kicsoda] NOT NULL,
	[modido] [dbo].[datum_ora] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[ladak]    Script Date: 10/08/2013 09:23:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ladak](
	[nev] [varchar](50) NOT NULL,
	[suly] [numeric](18, 2) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/*
   2013. szeptember 30.15:35:31
   User: sa
   Server: 192.168.59.85,1137
   Database: aruker
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.term_termeles ADD
	modositva dbo.datum_ora NULL,
	kicsoda dbo.kicsoda NULL
GO
ALTER TABLE dbo.term_termeles SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go