t_role_equip.sql 1.3 KB

123456789101112131415161718192021
  1. /****** 对象: Table [dbo].[t_role_equip] 脚本日期: 12/21/2011 11:04:58 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6. SET ANSI_PADDING ON
  7. GO
  8. CREATE TABLE [dbo].[t_role_equip](
  9. [group_id] [int] NULL,
  10. [id] [int] NOT NULL,
  11. [uid] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
  12. CONSTRAINT [PK_t_role_equip] PRIMARY KEY CLUSTERED
  13. (
  14. [id] ASC
  15. )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  16. ) ON [PRIMARY]
  17. GO
  18. SET ANSI_PADDING OFF
  19. GO
  20. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'-- 设备的UID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N't_role_equip', @level2type=N'COLUMN', @level2name=N'uid'