Facebook
From Unique Eider, 8 Years ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 394
  1. /****** Object:  Table [dbo].[Users]    Script Date: 05/20/2015 13:38:17 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4.  
  5. SET QUOTED_IDENTIFIER ON
  6. GO
  7.  
  8. SET ANSI_PADDING ON
  9. GO
  10.  
  11. CREATE TABLE [dbo].[Users](
  12.         [User_Id] [INT] IDENTITY(1,1) NOT NULL,
  13.         [User_Username] [VARCHAR](50) NOT NULL,
  14.         [User_Password] [VARCHAR](255) NOT NULL,
  15.         [User_Salt] [VARCHAR](255) NOT NULL,
  16.         [User_Role] [INT] NOT NULL,
  17.         [User_LastLogin] [datetime] NULL,
  18.  CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
  19. (
  20.         [User_Id] 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.  
  24. GO
  25.  
  26. SET ANSI_PADDING OFF
  27. GO
  28.  
  29.