-
Install AccessDatabaseEngine
-
Install Redis 2.4.5 For Windows
-
Create Database
IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = 'LeaderBoard') BEGIN CREATE DATABASE LeaderBoard END USE [LeaderBoard] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Users]( [Id] [int] IDENTITY(1,1) NOT NULL, [Username] [nvarchar](100) NULL, CONSTRAINT [PK_dbo.Users] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UserScores]( [Id] [int] IDENTITY(1,1) NOT NULL, [UserId] [int] NULL, [CreateDate] [datetime2](7) NULL, [UpdateDate] [datetime2](7) NULL, [ScoreDate] [datetime2](7) NULL, [Score] [int] NULL, CONSTRAINT [PK_UserScores] PRIMARY KEY CLUSTERED ( [Id] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[UserScores] WITH CHECK ADD CONSTRAINT [FK_UserScores_Users] FOREIGN KEY([UserId]) REFERENCES [dbo].[Users] ([Id]) GO ALTER TABLE [dbo].[UserScores] CHECK CONSTRAINT [FK_UserScores_Users] GO