IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_vevo_szlaf_export_vevo_szlaf]') AND parent_object_id = OBJECT_ID(N'[dbo].[vevo_szlaf_export]'))
ALTER TABLE [dbo].[vevo_szlaf_export] DROP CONSTRAINT [FK_vevo_szlaf_export_vevo_szlaf]
GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_vevo_szlaf_export_vevotel]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[vevo_szlaf_export] DROP CONSTRAINT [DF_vevo_szlaf_export_vevotel]
END

GO

/****** Object:  Table [dbo].[vevo_szlaf_export]    Script Date: 07/16/2012 17:55:52 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szlaf_export]') AND type in (N'U'))
DROP TABLE [dbo].[vevo_szlaf_export]
GO



/****** Object:  Table [dbo].[vevo_szlaf_export]    Script Date: 07/16/2012 12:06:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[vevo_szlaf_export](
	[BIZSZAM] [dbo].[bizonylat_szam] NOT NULL,
	[vevotel] [char](4) NOT NULL,
	[MEGJEGYZES1] [varchar](80) NOT NULL,
	[rendszam] [varchar](50) NOT NULL,
	[szall_felt] [varchar](50) NOT NULL,
	[szall_mod] [varchar](50) NOT NULL,
	[csomag] [varchar](50) NOT NULL,
	[suly] [varchar](50) NOT NULL,
	[zaradek] [varchar](1500) NOT NULL,
 CONSTRAINT [PK_vevo_szlaf_export] PRIMARY KEY CLUSTERED 
(
	[BIZSZAM] 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

ALTER TABLE [dbo].[vevo_szlaf_export]  WITH CHECK ADD  CONSTRAINT [FK_vevo_szlaf_export_vevo_szlaf] FOREIGN KEY([BIZSZAM])
REFERENCES [dbo].[vevo_szlaf] ([BIZSZAM])
GO

ALTER TABLE [dbo].[vevo_szlaf_export] CHECK CONSTRAINT [FK_vevo_szlaf_export_vevo_szlaf]
GO

ALTER TABLE [dbo].[vevo_szlaf_export] ADD  CONSTRAINT [DF_vevo_szlaf_export_vevotel]  DEFAULT ('0') FOR [vevotel]
GO


/****** Object:  Table [dbo].[szall_modok]    Script Date: 07/16/2012 18:03:47 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[szall_modok]') AND type in (N'U'))
DROP TABLE [dbo].[szall_modok]
GO

/****** Object:  Table [dbo].[szall_modok]    Script Date: 07/16/2012 12:10:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[szall_modok](
	[szall_mod] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/*
   2012. július 16.15:47:09
   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.vevo_szlaf_export
	DROP COLUMN MEGJEGYZES1
GO
COMMIT
go