USE [master]
GO
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'G:\temp\test.mdf' , SIZE = 6072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'test_log', FILENAME = N'G:\temp\test_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
use test
CREATE TABLE [dbo].[Tb_Locator](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[Value] [nvarchar](200) NOT NULL,
[Type] [nvarchar](50) NOT NULL,
[Desc] [nvarchar](50) NOT NULL,
[status] [int] NOT NULL,
[createtime] [datetime] NOT NULL,
CONSTRAINT [PK_Tb_Locator] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增编号，主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_Locator', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'元素标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_Locator', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'查找元素类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_Locator', @level2type=N'COLUMN',@level2name=N'Type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'元素描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_Locator', @level2type=N'COLUMN',@level2name=N'Desc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'元素状态，0正常，1锁定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_Locator', @level2type=N'COLUMN',@level2name=N'status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间，系统自动生成' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Tb_Locator', @level2type=N'COLUMN',@level2name=N'createtime'
GO
ALTER TABLE [dbo].[Tb_Locator] ADD CONSTRAINT [DF_Tb_Locator_status] DEFAULT ((0)) FOR [status]
GO
ALTER TABLE [dbo].[Tb_Locator] ADD CONSTRAINT [DF_Tb_Locator_createtime] DEFAULT (getdate()) FOR [createtime]
GO
ElementsManagement20170315.zip （10个子文件） 
ElementsManagement 
ElementsManagement.exe 20KB
ElementsManagement.vshost.application 2KB ElementsManagement.exe.config 364B ElementsManagement.exe.manifest 3KB ElementsManagement.pdb 38KB ElementsManagement.vshost.exe.config 375B ElementsManagement.application 2KB ElementsManagement.vshost.exe 24KB 元素管理工具建库语句.sql 2KB ElementsManagement.vshost.exe.manifest 3KB资源评论
