CreateAssetsTable.sql 558 B

12345678910111213141516171819
  1. SET ANSI_NULLS ON
  2. SET QUOTED_IDENTIFIER ON
  3. SET ANSI_PADDING ON
  4. CREATE TABLE [assets] (
  5. [id] [varchar](36) NOT NULL,
  6. [name] [varchar](64) NOT NULL,
  7. [description] [varchar](64) NOT NULL,
  8. [assetType] [tinyint] NOT NULL,
  9. [invType] [tinyint] NOT NULL,
  10. [local] [tinyint] NOT NULL,
  11. [temporary] [tinyint] NOT NULL,
  12. [data] [image] NOT NULL,
  13. PRIMARY KEY CLUSTERED
  14. (
  15. [id] ASC
  16. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  17. ) ON [PRIMARY]
  18. SET ANSI_PADDING OFF