maker.sql

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

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

BEGIN
CREATE TABLE [dbo].[quanxian]([qxid] [int] IDENTITY(1,1) NOT NULL,
[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'quanxian', @level2type=N'COLUMN', @level2name=N'qx'
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[dz] [VARCHAR](40),
[dh] [VARCHAR](40),
[nl] [VARCHAR](40),
[dzyx] [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'yonghu', @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'yonghu', @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'yonghu', @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'yonghu', @level2type=N'COLUMN', @level2name=N'dz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'dh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'nl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮箱' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'dzyx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'qx'
BEGIN
CREATE TABLE [dbo].[zhuanye]([zyid] [int] IDENTITY(1,1) NOT NULL,
[zy] [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'zhuanye', @level2type=N'COLUMN', @level2name=N'zy'
BEGIN
CREATE TABLE [dbo].[keti]([ktid] [int] IDENTITY(1,1) NOT NULL,
[ktmc] [VARCHAR](40),
[zy] [VARCHAR](40),
[ktnr] [VARCHAR](40),
[fbjs] [VARCHAR](40),
[shzt] [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'keti', @level2type=N'COLUMN', @level2name=N'ktmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'keti', @level2type=N'COLUMN', @level2name=N'zy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'课题内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'keti', @level2type=N'COLUMN', @level2name=N'ktnr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布教师' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'keti', @level2type=N'COLUMN', @level2name=N'fbjs'
GO