Advertisement
piotrek77

log w bazie

May 31st, 2012
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.54 KB | None | 0 0
  1. USE [CDNXL_asdfasd]
  2. GO
  3.  
  4. /****** Object:  Table [dbo].[SED_log]    Script Date: 05/31/2012 14:41:14 ******/
  5. SET ANSI_NULLS ON
  6. GO
  7.  
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10.  
  11. SET ANSI_PADDING ON
  12. GO
  13.  
  14. CREATE TABLE [dbo].[SED_log](
  15.     [id] [int] IDENTITY(1,1) NOT NULL,
  16.     [dataczas] [datetime] NULL,
  17.     [program] [varchar](50) NULL,
  18.     [klucz] [varchar](50) NULL,
  19.     [wartosc] [varchar](1024) NULL
  20. ) ON [PRIMARY]
  21.  
  22. GO
  23.  
  24. SET ANSI_PADDING OFF
  25. GO
  26.  
  27. ALTER TABLE [dbo].[SED_log] ADD  CONSTRAINT [DF_SED_log_dataczas]  DEFAULT (getdate()) FOR [dataczas]
  28. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement