CreateFoldersTable.sql 1.1 KB

123456789101112131415161718192021222324252627
  1. SET ANSI_NULLS ON
  2. SET QUOTED_IDENTIFIER ON
  3. SET ANSI_PADDING ON
  4. CREATE TABLE [inventoryfolders] (
  5. [folderID] [varchar](36) NOT NULL default '',
  6. [agentID] [varchar](36) default NULL,
  7. [parentFolderID] [varchar](36) default NULL,
  8. [folderName] [varchar](64) default NULL,
  9. [type] [smallint] NOT NULL default 0,
  10. [version] [int] NOT NULL default 0,
  11. PRIMARY KEY CLUSTERED
  12. (
  13. [folderID] ASC
  14. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  15. ) ON [PRIMARY]
  16. CREATE NONCLUSTERED INDEX [owner] ON [inventoryfolders]
  17. (
  18. [agentID] ASC
  19. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  20. CREATE NONCLUSTERED INDEX [parent] ON [inventoryfolders]
  21. (
  22. [parentFolderID] ASC
  23. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  24. SET ANSI_PADDING OFF