maker.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

BEGIN
CREATE TABLE [dbo].[renyuan]([ryid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[qx] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'renyuan', @level2type=N'COLUMN', @level2name=N'qx'
BEGIN
CREATE TABLE [dbo].[jifang]([jfid] [int] IDENTITY(1,1) NOT NULL,
[jfmc] [VARCHAR](40),
[jfdz] [VARCHAR](40),
[fzr] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'机房名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jifang', @level2type=N'COLUMN', @level2name=N'jfmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'机房地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jifang', @level2type=N'COLUMN', @level2name=N'jfdz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jifang', @level2type=N'COLUMN', @level2name=N'fzr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jifang', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[jfsyjl]([jfsyjlid] [int] IDENTITY(1,1) NOT NULL,
[jf] [VARCHAR](40),
[syrq] [VARCHAR](40),
[sysm] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'机房' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jfsyjl', @level2type=N'COLUMN', @level2name=N'jf'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jfsyjl', @level2type=N'COLUMN', @level2name=N'syrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jfsyjl', @level2type=N'COLUMN', @level2name=N'sysm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jfsyjl', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[shebei]([sbid] [int] IDENTITY(1,1) NOT NULL,
[sbmc] [VARCHAR](40),
[sbcj] [VARCHAR](40),
[xh] [VARCHAR](40),
[sm] [VARCHAR](40),
[zt] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'shebei', @level2type=N'COLUMN', @level2name=N'sbmc'
GO