/*
   2010. február 17.11:32:39
   User: sa
   Server: 192.168.1.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_broker int NULL
GO

update belepes set jog_broker=0
go
COMMIT
go



/****** Object:  Table [dbo].[ugyletek]    Script Date: 02/19/2010 11:37:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ugyletek](
	[bizszam] [dbo].[bizonylat_szam] NOT NULL,
	[ugyletkod] [varchar](20) NOT NULL,
	[biztipus] [varchar](20) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
go



/****** Object:  Table [dbo].[broker_allapotok]    Script Date: 02/19/2010 11:41:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[broker_allapotok]') AND type in (N'U'))
DROP TABLE [dbo].[broker_allapotok]
GO
/****** Object:  Table [dbo].[broker_allapotok]    Script Date: 02/19/2010 11:41:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[broker_allapotok]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[broker_allapotok](
	[allapot_kod] [dbo].[kulcs] NOT NULL,
	[allapot_nev] [dbo].[nev] NOT NULL,
 CONSTRAINT [PK_broker_allapotok] PRIMARY KEY CLUSTERED 
(
	[allapot_kod] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (11, N'Kérés')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (12, N'Kalkuláció alatt')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (13, N'Kalkulált')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (14, N'Kiajánlott')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (15, N'Vevő nem kéri')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (16, N'Vevő megrendelte')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (21, N'Kiküldött')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (22, N'Beérkezett')
INSERT [dbo].[broker_allapotok] ([allapot_kod], [allapot_nev]) VALUES (23, N'Lezárt')

go


/****** Object:  Table [dbo].[cikk_tipusok]    Script Date: 02/19/2010 16:46:18 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cikk_tipusok]') AND type in (N'U'))
DROP TABLE [dbo].[cikk_tipusok]
GO
/****** Object:  Table [dbo].[cikk_tipusok]    Script Date: 02/19/2010 16:46:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cikk_tipusok]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[cikk_tipusok](
	[kod] [dbo].[kulcs] NOT NULL,
	[tipus_nev] [dbo].[nev] NOT NULL,
 CONSTRAINT [PK_cikk_tipusok] 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]
END
GO
SET ANSI_PADDING OFF
GO



INSERT [dbo].[cikk_tipusok] ([kod], [tipus_nev]) VALUES (1, N'NEW')
INSERT [dbo].[cikk_tipusok] ([kod], [tipus_nev]) VALUES (2, N'RENEW')
INSERT [dbo].[cikk_tipusok] ([kod], [tipus_nev]) VALUES (3, N'Bontott')
go




/* 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
CREATE TABLE dbo.Tmp_vevo_szl_fizetve
	(
	biz_tipus char(10) NULL,
	bizszam dbo.bizonylat_szam NOT NULL,
	fiz_datum dbo.datum NULL,
	fizetve char(1) NOT NULL,
	hatralek dbo.egyseg_ar NULL,
	fizetett dbo.egyseg_ar NULL,
	kicsoda dbo.kicsoda NULL,
	keszult dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.vevo_szl_fizetve)
	 EXEC('INSERT INTO dbo.Tmp_vevo_szl_fizetve (biz_tipus, bizszam, fiz_datum, fizetve, kicsoda, keszult)
		SELECT biz_tipus, bizszam, fiz_datum, fizetve, kicsoda, keszult FROM dbo.vevo_szl_fizetve WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_szl_fizetve
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_szl_fizetve', N'vevo_szl_fizetve', 'OBJECT' 
GO
CREATE NONCLUSTERED INDEX IX_vevo_szl_fizetve_bizszam ON dbo.vevo_szl_fizetve
	(
	bizszam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT


update vevo_szl_fizetve set fizetett = 0
GO

update vevo_szl_fizetve set hatralek = 0
GO

update vevo_szl_fizetve set hatralek = 
brutto_ertek from vvevo_szle_ertek
where fizetve <> 'X' and 
vevo_szl_fizetve.bizszam = vvevo_szle_ertek.bizszam
and biz_tipus='száll.lev.'
GO

update vevo_szl_fizetve set hatralek = 
brutto_ertek from vvevo_szla_ertek
where fizetve <> 'X' and 
vevo_szl_fizetve.bizszam = vvevo_szla_ertek.bizszam
and biz_tipus='számla'
GO


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[szall_szl_fizetve](
	[biz_tipus] [char](10) NULL,
	[bizszam] [dbo].[bizonylat_szam] NOT NULL,
	[fiz_datum] [dbo].[datum] NULL,
	[fizetve] [char](1) NOT NULL,
	[hatralek] [dbo].[egyseg_ar] NULL,
	[fizetett] [dbo].[egyseg_ar] NULL,
	[kicsoda] [dbo].[kicsoda] NULL,
	[keszult] [dbo].[datum_ora] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF