游戏代练源码

CREATE TABLE [LP_Topic]( [ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [BoardID] [int] NULL, [TopicName] [nvarchar](100) NULL, [PostContent] [ntext] NULL, [UserID] [int] NULL, [AuthorName] [nvarchar](20) NULL, [AuthorSex] [tinyint] NULL, [AuthorProvince] [int] NULL, [AuthorFrom] [nvarchar](20) NULL, [AuthorEmail] [nvarchar](50) NULL, [AuthorWebsite] [nvarchar](50) NULL, [AuthorQQ] [nvarchar](12) NULL, [AuthorFace] [nvarchar](50) NULL, [AuthorHead] [nvarchar](50) NULL, [PostIP] [nvarchar](32) NULL, [PostDateTime] [datetime] DEFAULT getdate() NULL, [IsPublic] [tinyint] DEFAULT 1 NULL, [ViewPassword] [nvarchar](20) NULL, [Auditing] [tinyint] DEFAULT 1 NULL ) GO CREATE TABLE [LP_User]( [ID] [int] PRIMARY KEY NOT NULL, [UserName] [nvarchar](20) NOT NULL, [NickName] [nvarchar](20) NULL, [UserSex] [tinyint] NULL, [UserPassword] [nvarchar](64) NULL, [UserPower] [nvarchar](16) NULL, [Province] [int] NULL, [ComeFrom] [nvarchar](20) NULL, [Email] [nvarchar](50) NULL, [WebSite] [nvarchar](50) NULL, [TencentQQ] [nvarchar](12) NULL, [UserHead] [nvarchar](50) NULL, [RegisterIP] [nvarchar](32) NULL, [RegisterTime] [datetime] DEFAULT getdate() NULL, [LastLoginIP] [nvarchar](32) NULL, [LastLoginTime] [datetime] NULL ) GO CREATE TABLE [LP_Announcement]( [ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [BoardID] [int] NULL, [Title] [nvarchar](255) NULL, [PostContent] [ntext] NULL, [AddDateTime] [datetime] DEFAULT getdate() NULL ) GO CREATE TABLE [LP_Board]( [ID] [int] PRIMARY KEY NOT NULL, [BoardName] [nvarchar](50) NULL, [ParentID] [int] DEFAULT 0 NOT NULL, [ParentStr] [nvarchar](250) NULL, [RootID] [int] DEFAULT 0 NULL, [Depth] [int] DEFAULT 0 NULL, [BoardMaster] [nvarchar](100) NULL, [Orders] [int] DEFAULT 0 NULL ) GO CREATE TABLE [LP_Comment]( [ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL, [TopicID] [int] NOT NULL, [BoardID] [int] NULL, [PostContent] [ntext] NULL, [UserID] [int] NULL, [UserName] [nvarchar](20) NULL, [PostIP] [nvarchar](32) NULL, [PostDateTime] [datetime] DEFAULT getdate() NULL ) GO CREATE TABLE [LP_Province]( [ID] [int] PRIMARY KEY NOT NULL, [ProvinceName] [nvarchar](8) NULL ) GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(1,'安徽') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(2,'澳门') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(3,'北京') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(4,'福建') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(5,'甘肃') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(6,'广东') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(7,'广西') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(8,'贵州') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(9,'海南') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(10,'河北') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(11,'河南') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(12,'黑龙江') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(13,'湖北') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(14,'湖南') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(15,'吉林') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(16,'江苏') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(17,'江西') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(18,'辽宁') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(19,'内蒙古') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(20,'宁夏') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(21,'青海') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(22,'山东') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(23,'山西') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(24,'陕西') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(25,'上海') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(26,'四川') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(27,'台湾') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(28,'天津') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(29,'西藏') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(30,'香港') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(31,'新疆') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(32,'云南') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(33,'浙江') GO INSERT INTO LP_Province(ID,ProvinceName) VALUES(34,'重庆') GO INSERT INTO LP_User(ID,UserName,NickName,UserSex,UserPassword,UserPower,Province,ComeFrom,Email,WebSite,TencentQQ,UserHead,RegisterIP,RegisterTime,LastLoginIP,LastLoginTime) VALUES(1,'qiuyi','秋忆',1,'ab12ae7c368baf403b02a8eebefb246e','b0da978cd9d5e2ee',6,'广州','mylove21@163.com','http://www.skymean.com','64878563','m03.gif','::1',cast('2007-8-5 12:12:12' as datetime),'::1',cast('2007-9-2 20:55:17' as datetime)) GO