/*
   2013. július 29.12:49:00
   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.belepes ADD
	jog_termel int NULL
GO
ALTER TABLE dbo.belepes SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go

update belepes set jog_termel='0'
go

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[bontas](
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[acikk_szam] [dbo].[cikk_szam] NOT NULL,
 CONSTRAINT [PK_bontas] PRIMARY KEY CLUSTERED 
(
	[cikk_szam] ASC,
	[acikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[onkoltar](
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[egyseg_ar] [dbo].[egyseg_ar] NOT NULL,
	[kicsoda] [dbo].[kicsoda] NOT NULL,
	[modositva] [dbo].[datum_ora] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/*
   2013. augusztus 6.12:13:41
   User: sa
   Server: 192.168.59.85,1137
   Database: aruker_csenger
   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.anyagszukseglet
	DROP CONSTRAINT FK_anyagszukseglet_raktarak
GO
ALTER TABLE dbo.raktarak SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.anyagszukseglet
	DROP CONSTRAINT FK_anyagszukseglet_cikkek
GO
ALTER TABLE dbo.anyagszukseglet
	DROP CONSTRAINT FK_anyagszukseglet_cikkek1
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_anyagszukseglet
	(
	raktar_kod dbo.kulcs NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	xdb numeric(18, 3) NULL,
	acikk_szam dbo.cikk_szam NOT NULL,
	darab numeric(18, 4) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_anyagszukseglet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.anyagszukseglet)
	 EXEC('INSERT INTO dbo.Tmp_anyagszukseglet (raktar_kod, cikk_szam, acikk_szam, darab)
		SELECT raktar_kod, cikk_szam, acikk_szam, darab FROM dbo.anyagszukseglet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.anyagszukseglet
GO
EXECUTE sp_rename N'dbo.Tmp_anyagszukseglet', N'anyagszukseglet', 'OBJECT' 
GO
ALTER TABLE dbo.anyagszukseglet ADD CONSTRAINT
	PK_anyagszukseglet PRIMARY KEY CLUSTERED 
	(
	raktar_kod,
	cikk_szam,
	acikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_anyagszukseglet ON dbo.anyagszukseglet
	(
	raktar_kod
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_anyagszukseglet_1 ON dbo.anyagszukseglet
	(
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_anyagszukseglet_2 ON dbo.anyagszukseglet
	(
	acikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.anyagszukseglet ADD CONSTRAINT
	FK_anyagszukseglet_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.anyagszukseglet ADD CONSTRAINT
	FK_anyagszukseglet_cikkek1 FOREIGN KEY
	(
	acikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.anyagszukseglet ADD CONSTRAINT
	FK_anyagszukseglet_raktarak FOREIGN KEY
	(
	raktar_kod
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[term_receptura](
	[tevekenyseg] [dbo].[kulcs] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[xdb] [numeric](18, 3) NOT NULL,
	[acikk_szam] [dbo].[cikk_szam] NOT NULL,
	[darab] [numeric](18, 4) NOT NULL,
 CONSTRAINT [PK_term_receptura] PRIMARY KEY CLUSTERED 
(
	[tevekenyseg] ASC,
	[cikk_szam] ASC,
	[acikk_szam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[term_tevekenyseg](
	[kod] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[nev] [dbo].[nev] NOT NULL,
 CONSTRAINT [PK_term_tevekenyseg] PRIMARY KEY CLUSTERED 
(
	[kod] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Table [dbo].[term_termeles]    Script Date: 08/13/2013 11:30:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[term_termeles](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[datum] [dbo].[datum] NOT NULL,
	[tevekenyseg] [dbo].[kulcs] NOT NULL,
	[irany] [int] NOT NULL,
	[focikk_szam] [dbo].[cikk_szam] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[darab] [dbo].[mennyiseg] NOT NULL,
	[egyseg_ar] [dbo].[egyseg_ar] NOT NULL,
	[sarzs] [varchar](50) NOT NULL,
	[term_kulcs] [dbo].[kulcs] NOT NULL,
	[term_datum] [dbo].[datum] NOT NULL,
 CONSTRAINT [PK_term_termeles] PRIMARY KEY CLUSTERED 
(
	[kulcs] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/****** Object:  Table [dbo].[term_veszteseg]    Script Date: 09/27/2013 09:52:02 ******/
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