Edit C:\Users\Administrator\Desktop\SQL20150830-20160530\15.09.01.24_0011_Pub_JYQNotice_Add.sql
/****** Object: Table [dbo].[Pub_JYQNotice] Script Date: 09/02/2015 15:06:31 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF not EXISTS (SELECT * FROM sysobjects WHERE name = 'Pub_JYQNotice') Begin CREATE TABLE [dbo].[Pub_JYQNotice]( [Guid] [nvarchar](32) NOT NULL, [Version] [int] NOT NULL, [SortNumber] [int] NOT NULL, [Status] [int] NOT NULL, [JiaoYanQuanGuid] [nvarchar](32) NOT NULL, [Title] [nvarchar](256) NOT NULL, [Description] [ntext] NULL, [AddTime] [datetime] NOT NULL, [ActiveBeginDate] [datetime] NOT NULL, [ActiveEndDate] [datetime] NULL, CONSTRAINT [PK_PUB_JYQNOTICE] 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] TEXTIMAGE_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_JYQNotice', @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_JYQNotice', @level2type=N'COLUMN',@level2name=N'Version' 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_JYQNotice', @level2type=N'COLUMN',@level2name=N'SortNumber' 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_JYQNotice', @level2type=N'COLUMN',@level2name=N'Status' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:selectbox fk_table:Pub_JiaoYanQuan 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_JYQNotice', @level2type=N'COLUMN',@level2name=N'JiaoYanQuanGuid' 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_JYQNotice', @level2type=N'COLUMN',@level2name=N'Title' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:textarea css:width400 height100' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_JYQNotice', @level2type=N'COLUMN',@level2name=N'Description' 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_JYQNotice', @level2type=N'COLUMN',@level2name=N'AddTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:date required:true required_msg:??????? required_default:null regex:date regex_msg:?????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_JYQNotice', @level2type=N'COLUMN',@level2name=N'ActiveBeginDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:date regex:date regex_msg:?????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_JYQNotice', @level2type=N'COLUMN',@level2name=N'ActiveEndDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? ref_table: autosort:SortNumber ASC fk_name:Version' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Pub_JYQNotice' END
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de