log.txt

1.杀人游戏系列 2.学生成绩管理系统 3.屏幕录像软件 4.Vista风格日历控件C#源码 5.LOKI97加密解密算法

CREATE DATABASE [killperson]

.Net SqlClient Data Provider: Changed database context to 'killperson'..
SET ARITHABORT ON
CREATE TABLE [dbo].[Activity](
  [ActivityNo] Int NOT NULL IDENTITY, 
  [GameNo] Int NOT NULL, 
  [ActivityTypeID] Int, 
  [RoundCount] Int NOT NULL, 
  CONSTRAINT [PK_dbo.Activity] PRIMARY KEY ([ActivityNo])
  )
CREATE TABLE [dbo].[Role](
  [RoleID] Int NOT NULL, 
  [Name] NVarChar(50) NOT NULL, 
  CONSTRAINT [PK_dbo.Role] PRIMARY KEY ([RoleID])
  )
CREATE TABLE [dbo].[ActivityType](
  [ActivityTypeID] Int NOT NULL, 
  [ActivityTypeName] NVarChar(50) NOT NULL, 
  [TimeCollapse] Int NOT NULL, 
  CONSTRAINT [PK_dbo.ActivityType] PRIMARY KEY ([ActivityTypeID])
  )
CREATE TABLE [dbo].[Game](
  [GameNo] Int NOT NULL IDENTITY, 
  [StartTime] DateTime NOT NULL, 
  [EndTime] DateTime, 
  [WhoWin] Int, 
  [CivilianNum] Int, 
  [KillerNum] Int, 
  [PoliceNum] Int, 
  [GameName] NVarChar(50) NOT NULL, 
  [GameStatus] Int, 
  [EndpointAddress] NVarChar(200) NOT NULL, 
  CONSTRAINT [PK_dbo.Game] PRIMARY KEY ([GameNo])
  )
CREATE TABLE [dbo].[User](
  [UserID] NVarChar(50) NOT NULL, 
  [Name] NVarChar(50) NOT NULL, 
  [IsOnline] Int NOT NULL, 
  [WinNum] Int NOT NULL, 
  [PlayNum] Int NOT NULL, 
  [IP] NVarChar(200), 
  [Password] NVarChar(4000) NOT NULL, 
  CONSTRAINT [PK_dbo.User] PRIMARY KEY ([UserID])
  )
CREATE TABLE [dbo].[Player](
  [UserID] NVarChar(50) NOT NULL, 
  [GameNo] Int NOT NULL, 
  [IsActive] Int NOT NULL, 
  [RoleID] Int NOT NULL, 
  [DeadActivityNo] Int NOT NULL, 
  CONSTRAINT [PK_dbo.Player] PRIMARY KEY ([UserID], [GameNo])
  )
CREATE TABLE [dbo].[Vote](
  [ActivityNo] Int NOT NULL, 
  [RoundNo] Int NOT NULL, 
  [Voter] NVarChar(50) NOT NULL, 
  [Candidate] NVarChar(50) NOT NULL, 
  CONSTRAINT [PK_dbo.Vote] PRIMARY KEY ([ActivityNo], [RoundNo], [Voter])
  )
CREATE TABLE [GameStatus](
  [StatusID] Int, 
  [StatusName] NVarChar(50) NOT NULL, 
  CONSTRAINT [PK_GameStatus] PRIMARY KEY ([StatusID])
  )
ALTER TABLE [dbo].[Activity]
  ADD CONSTRAINT [ActivityType_Activity] FOREIGN KEY ([ActivityTypeID]) REFERENCES [dbo].[ActivityType]([ActivityTypeID])
ALTER TABLE [dbo].[Activity]
  ADD CONSTRAINT [Game_Activity] FOREIGN KEY ([GameNo]) REFERENCES [dbo].[Game]([GameNo])
ALTER TABLE [dbo].[Game]
  ADD CONSTRAINT [GameStatus_Game] FOREIGN KEY ([GameStatus]) REFERENCES [GameStatus]([StatusID])
ALTER TABLE [dbo].[Player]
  ADD CONSTRAINT [Game_Player] FOREIGN KEY ([GameNo]) REFERENCES [dbo].[Game]([GameNo])
ALTER TABLE [dbo].[Player]
  ADD CONSTRAINT [User_Player] FOREIGN KEY ([UserID]) REFERENCES [dbo].[User]([UserID])
ALTER TABLE [dbo].[Player]
  ADD CONSTRAINT [Role_Player] FOREIGN KEY ([RoleID]) REFERENCES [dbo].[Role]([RoleID])
ALTER TABLE [dbo].[Vote]
  ADD CONSTRAINT [Activity_Vote] FOREIGN KEY ([ActivityNo]) REFERENCES [dbo].[Activity]([ActivityNo])
ALTER TABLE [dbo].[Vote]
  ADD CONSTRAINT [User_Vote] FOREIGN KEY ([Voter]) REFERENCES [dbo].[User]([UserID])
ALTER TABLE [dbo].[Vote]
  ADD CONSTRAINT [User_Vote1] FOREIGN KEY ([Candidate]) REFERENCES [dbo].[User]([UserID])


INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6)
-- @p0: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [tom]
-- @p1: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [tom]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null]
-- @p6: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [tom]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6)
-- @p0: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [boler]
-- @p1: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [boler]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null]
-- @p6: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [boler]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6)
-- @p0: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [peter]
-- @p1: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [peter]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null]
-- @p6: Input NVarChar (Size = 5; Prec = 0; Scale = 0) [peter]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6)
-- @p0: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [sean]
-- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [sean]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null]
-- @p6: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [sean]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[User]([UserID], [Name], [IsOnline], [WinNum], [PlayNum], [IP], [Password])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6)
-- @p0: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [cloudy]
-- @p1: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [cloudy]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p3: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p4: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p5: Input NVarChar (Size = 0; Prec = 0; Scale = 0) [Null]
-- @p6: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [cloudy]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[Role]([RoleID], [Name])
VALUES (@p0, @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- @p1: Input NVarChar (Size = 8; Prec = 0; Scale = 0) [Civilian]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[Role]([RoleID], [Name])
VALUES (@p0, @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2]
-- @p1: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Killer]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[Role]([RoleID], [Name])
VALUES (@p0, @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [4]
-- @p1: Input NVarChar (Size = 6; Prec = 0; Scale = 0) [Police]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [GameStatus]([StatusID], [StatusName])
VALUES (@p0, @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- @p1: Input NVarChar (Size = 3; Prec = 0; Scale = 0) [Run]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [GameStatus]([StatusID], [StatusName])
VALUES (@p0, @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2]
-- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [Wait]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [GameStatus]([StatusID], [StatusName])
VALUES (@p0, @p1)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [4]
-- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [Dead]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[ActivityType]([ActivityTypeID], [ActivityTypeName], [TimeCollapse])
VALUES (@p0, @p1, @p2)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [Vote]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [4]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[ActivityType]([ActivityTypeID], [ActivityTypeName], [TimeCollapse])
VALUES (@p0, @p1, @p2)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [2]
-- @p1: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [Kill]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0

INSERT INTO [dbo].[ActivityType]([ActivityTypeID], [ActivityTypeName], [TimeCollapse])
VALUES (@p0, @p1, @p2)
-- @p0: Input Int (Size = 0; Prec = 0; Scale = 0) [4]
-- @p1: Input NVarChar (Size = 11; Prec = 0; Scale = 0) [Investigate]
-- @p2: Input Int (Size = 0; Prec = 0; Scale = 0) [1]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20917.0