Edit D:\SQL20160530-20170910\17.08.04.32_0001_Pub_VideoPush_Add.sql
/****** Object: Table [dbo].[Pub_VideoPush] Script Date: 08/04/2017 16:51:29 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF not EXISTS (SELECT * FROM sysobjects WHERE name = 'Pub_VideoPush') Begin CREATE TABLE [dbo].[Pub_VideoPush]( [Guid] [nvarchar](32) NOT NULL, [Version] [int] NOT NULL, [VideoGuid] [nvarchar](32) NOT NULL, [Createime] [datetime] NOT NULL, [Status] [int] NOT NULL, [Remark] [nvarchar](2000) NULL, [FinishTime] [datetime] NULL, CONSTRAINT [PK_Pub_VideoPush] PRIMARY KEY CLUSTERED ( [Guid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Guid type:text primary:true tooltip:????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'Guid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'Version' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'??Guid type:text required:true required_msg:???Guid???? required_default:null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'VideoGuid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:datetime required:true required_msg:??????? required_default:null regex:datetime regex_msg:?????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'Createime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:checkbox enum:{???=0,???=1,???=2} default:0 tooltip:???????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'Status' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'?? type:text' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'Remark' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:datetime regex:datetime regex_msg:?????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush', @level2type=N'COLUMN',@level2name=N'FinishTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'??????? fk_name:VideoGuid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_VideoPush' END
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de