003_UserStore.sql 387 B

123456789101112131415
  1. BEGIN TRANSACTION
  2. CREATE TABLE [avatarattachments] (
  3. [UUID] varchar(36) NOT NULL
  4. , [attachpoint] int NOT NULL
  5. , [item] varchar(36) NOT NULL
  6. , [asset] varchar(36) NOT NULL)
  7. CREATE NONCLUSTERED INDEX IX_avatarattachments ON dbo.avatarattachments
  8. (
  9. UUID
  10. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  11. COMMIT