Code:
DROP TABLE [dbo].[_PrizeLog]
GO
CREATE TABLE [dbo].[_PrizeLog] (
[ID] int NOT NULL IDENTITY(1,1) ,
[Username] varchar(50) NOT NULL ,
[Prize] int NOT NULL ,
[Date] datetime NOT NULL
)
GO
DBCC CHECKIDENT(N'[dbo].[_PrizeLog]', RESEED, 1006)
GO
-- ----------------------------
-- Indexes structure for table _PrizeLog
-- ----------------------------
-- ----------------------------
-- Primary Key structure for table _PrizeLog
-- ----------------------------
ALTER TABLE [dbo].[_PrizeLog] ADD PRIMARY KEY ([ID])
GO