1
0

mssql-CreateItemsTable.sql 1.4 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. SET ANSI_NULLS ON
  2. SET QUOTED_IDENTIFIER ON
  3. SET ANSI_PADDING ON
  4. CREATE TABLE [inventoryitems] (
  5. [inventoryID] [varchar](36) NOT NULL default '',
  6. [assetID] [varchar](36) default NULL,
  7. [assetType] [int] default NULL,
  8. [parentFolderID] [varchar](36) default NULL,
  9. [avatarID] [varchar](36) default NULL,
  10. [inventoryName] [varchar](64) default NULL,
  11. [inventoryDescription] [varchar](64) default NULL,
  12. [inventoryNextPermissions] [int] default NULL,
  13. [inventoryCurrentPermissions] [int] default NULL,
  14. [invType] [int] default NULL,
  15. [creatorID] [varchar](36) default NULL,
  16. [inventoryBasePermissions] [int] NOT NULL default 0,
  17. [inventoryEveryOnePermissions] [int] NOT NULL default 0,
  18. PRIMARY KEY CLUSTERED
  19. (
  20. [inventoryID] ASC
  21. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  22. ) ON [PRIMARY]
  23. CREATE NONCLUSTERED INDEX [owner] ON [inventoryitems]
  24. (
  25. [avatarID] ASC
  26. )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]
  27. CREATE NONCLUSTERED INDEX [folder] ON [inventoryitems]
  28. (
  29. [parentFolderID] ASC
  30. )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]
  31. SET ANSI_PADDING OFF