Edit C:\Users\Administrator\Desktop\SQL20150830-20160530\16.04.25.27_0002_Pub_WebCastUrl_Upd.sql
/****** Object: Table [dbo].[Pub_WebCastUrl] Script Date: 04/25/2016 10:09:52 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF not EXISTS (SELECT * FROM sysobjects WHERE name = 'Pub_WebCastUrl') Begin CREATE TABLE [dbo].[Pub_WebCastUrl]( [Guid] [nvarchar](32) NOT NULL, [Version] [int] NOT NULL, [WebCastGuid] [nvarchar](32) NOT NULL, [LiveUrl] [nvarchar](2000) NOT NULL, [Status] [int] NOT NULL, [LiveUrlType] [int] NOT NULL, [UrlWeight] [int] NOT NULL, CONSTRAINT [PK_Pub_WebCastUrl] 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_WebCastUrl', @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_WebCastUrl', @level2type=N'COLUMN',@level2name=N'Version' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'????? type:selectbox fk_table:Pub_WebCast fk_key:Guid fk_name:Name required:true required_msg:???????? required_default:null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_WebCastUrl', @level2type=N'COLUMN',@level2name=N'WebCastGuid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:text required:true required_msg:??????? required_default:null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_WebCastUrl', @level2type=N'COLUMN',@level2name=N'LiveUrl' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'?? type:checkbox enum:{??=0,??=1} default:0 tooltip:????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_WebCastUrl', @level2type=N'COLUMN',@level2name=N'Status' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'?????? type:select enum:{RTSP=0,RTMP=1,HLS=2} default:0 required:true required_msg:??????? required_default:null' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_WebCastUrl', @level2type=N'COLUMN',@level2name=N'LiveUrlType' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'??? type:text default:0 required:true required_msg:?????? required_default:null regex:num1 regex_msg:??????? tooltip:????????????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_WebCastUrl', @level2type=N'COLUMN',@level2name=N'UrlWeight' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'?????? ref_table: autosort:true fk_name:Pub_WebCast.Name,LiveUrl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_WebCastUrl' ALTER TABLE [dbo].[Pub_WebCastUrl] ADD CONSTRAINT [DF_Pub_WebCastUrl_Status] DEFAULT ((1)) FOR [Status] END
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de