/****** Object: Table [dbo].[vevo_szl_fizetesek] Script Date: 2016.02.17. 13:50:08 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[vevo_szl_fizetesek]') AND type in (N'U')) DROP TABLE [dbo].[vevo_szl_fizetesek] GO /****** Object: Table [dbo].[szall_szl_fizetesek] Script Date: 2016.02.17. 13:50:08 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[szall_szl_fizetesek]') AND type in (N'U')) DROP TABLE [dbo].[szall_szl_fizetesek] GO /****** Object: Table [dbo].[szall_szl_fizetesek] Script Date: 2016.02.17. 13:50:08 ******/ 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].[szall_szl_fizetesek]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[szall_szl_fizetesek]( [biz_tipus] [char](10) NOT NULL, [bizszam] [varchar](50) NOT NULL, [osszeg] [dbo].[egyseg_ar] NOT NULL, [fiz_datum] [dbo].[datum] NOT NULL, [kicsoda] [dbo].[kicsoda] NOT NULL, [rog_datum] [dbo].[datum_ora] NOT NULL ) ON [PRIMARY] END GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[vevo_szl_fizetesek] Script Date: 2016.02.17. 13:50:08 ******/ 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].[vevo_szl_fizetesek]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[vevo_szl_fizetesek]( [biz_tipus] [char](10) NOT NULL, [bizszam] [varchar](50) NOT NULL, [osszeg] [dbo].[egyseg_ar] NOT NULL, [fiz_datum] [dbo].[datum] NOT NULL, [kicsoda] [dbo].[kicsoda] NOT NULL, [rog_datum] [dbo].[datum_ora] NOT NULL ) ON [PRIMARY] END GO SET ANSI_PADDING OFF GO insert into verzio values('upg','Ver. 2.30', dbo.mygetdatetime()) go