Subversion Repositories indexer_suite

Rev

Blame | Last modification | View Log | RSS feed

  1. USE [Indexer]
  2. GO
  3.  
  4. SET ANSI_NULLS ON
  5. GO
  6.  
  7. SET QUOTED_IDENTIFIER ON
  8. GO
  9.  
  10. SET ANSI_PADDING ON
  11. GO
  12.  
  13. CREATE TABLE [dbo].[files](
  14.         [id] [BIGINT] IDENTITY(1,1) NOT NULL,
  15.         [filename] [nvarchar](450) NOT NULL,
  16.         [SIZE] [BIGINT] NULL,
  17.         [created] [datetime] NULL,
  18.         [modified] [datetime] NULL,
  19.         [md5hash] [VARCHAR](32) NULL,
  20.         [error] [nvarchar](200) NULL,
  21.  CONSTRAINT [PK_files] PRIMARY KEY CLUSTERED
  22. (
  23.         [id] ASC
  24. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  25. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  26.  
  27. GO
  28.  
  29. CREATE UNIQUE NONCLUSTERED INDEX [ix_files_filename] ON [dbo].[files]
  30. (
  31.         [filename] ASC
  32. )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)
  33. GO
  34.  
  35. CREATE NONCLUSTERED INDEX [ix_files_md5hash] ON [dbo].[files]
  36. (
  37.         [md5hash] ASC
  38. )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)
  39. GO
  40.  
  41. SET ANSI_PADDING OFF
  42. GO
  43.