SHARE
TWEET

Untitled

a guest Mar 17th, 2017 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE [dbo].[User](
  2.     [Id] [uniqueidentifier] NOT NULL,
  3.     [Country] [smallint] NULL,
  4.     [FirstName] [nvarchar](255) NULL,
  5.     [IsBackOfficeUser] [bit] NOT NULL,
  6.     [LanguageId] [int] NOT NULL,
  7.     [LastName] [nvarchar](255) NULL,
  8.     [NewslettersEnabled] [bit] NOT NULL,
  9.     [PromotionsEnabled] [bit] NOT NULL,
  10.     [LastActivityAt] [datetime2](7) NULL,
  11.     [RegistrationSource] [int] NOT NULL,
  12.     [RegisteredAt] [datetime2](7) NOT NULL,
  13.     [Email] [nvarchar](255) NULL,
  14.     [EmailConfirmed] [bit] NOT NULL,
  15.     [PasswordHash] [nvarchar](max) NULL,
  16.     [SecurityStamp] [nvarchar](max) NULL,
  17.     [PhoneNumber] [nvarchar](max) NULL,
  18.     [PhoneNumberConfirmed] [bit] NOT NULL,
  19.     [TwoFactorEnabled] [bit] NOT NULL,
  20.     [LockoutEndDateUtc] [datetime] NULL,
  21.     [LockoutEnabled] [bit] NOT NULL,
  22.     [AccessFailedCount] [int] NOT NULL,
  23.     [UserName] [nvarchar](max) NULL,
  24.     [IsDeleted] [bit] NOT NULL,
  25.  CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
  26. (
  27.     [Id] ASC
  28. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  29. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  30.  
  31. GO
  32.  
  33. ALTER TABLE [dbo].[User] ADD  DEFAULT (newsequentialid()) FOR [Id]
  34. GO
  35.  
  36. ALTER TABLE [dbo].[User] ADD  DEFAULT ((0)) FOR [IsDeleted]
  37. GO
RAW Paste Data
Top