/****** Object:  Table [dbo].[vevo_ren_datum]    Script Date: 2013.02.21. 13:49:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[vevo_ren_datum](
	[bizszam] [char](10) NOT NULL,
	[tetel] [int] NOT NULL,
	[cikk_szam] [char](14) NOT NULL,
	[datum] [char](10) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
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
ALTER TABLE dbo.foglalasok ADD
	szav_ido dbo.datum NULL,
	gyari_szam [varchar](20) NULL,
	sarzs_szam [varchar](20) NULL,
	rend_szam dbo.bizonylat_szam NULL,
	tetel dbo.bizonylat_tetel NULL
GO
COMMIT
go

update foglalasok set szav_ido='',gyari_szam='',sarzs_szam='',rend_szam='',tetel=0
go


/****** Object:  Table [dbo].[wpartner]    Script Date: 2013.02.25. 15:54:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[wpartner](
	[tipus] [char](1) NOT NULL,
	[kod] [int] NOT NULL,
	[nev] [varchar](100) NOT NULL,
	[iranyito] [char](15) NOT NULL,
	[varos] [char](30) NOT NULL,
	[cim] [char](70) NOT NULL,
	[kicsoda] [varchar](20) NOT NULL,
	[ujkod] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO