c#版QQ源码+SQL（QQ风格）

USE [master] GO /****** 对象: Database [MyQQ] 脚本日期: 05/24/2008 13:21:56 ******/ CREATE DATABASE [MyQQ] ON PRIMARY ( NAME = N'MyQQ', FILENAME = N'E:\projectMyQQ\MyQQ.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'MyQQ_log', FILENAME = N'E:\projectMyQQ\MyQQ_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO EXEC dbo.sp_dbcmptlevel @dbname=N'MyQQ', @new_cmptlevel=90 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [MyQQ].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [MyQQ] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [MyQQ] SET ANSI_NULLS OFF GO ALTER DATABASE [MyQQ] SET ANSI_PADDING OFF GO ALTER DATABASE [MyQQ] SET ANSI_WARNINGS OFF GO ALTER DATABASE [MyQQ] SET ARITHABORT OFF GO ALTER DATABASE [MyQQ] SET AUTO_CLOSE OFF GO ALTER DATABASE [MyQQ] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [MyQQ] SET AUTO_SHRINK OFF GO ALTER DATABASE [MyQQ] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [MyQQ] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [MyQQ] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [MyQQ] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [MyQQ] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [MyQQ] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [MyQQ] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [MyQQ] SET ENABLE_BROKER GO ALTER DATABASE [MyQQ] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [MyQQ] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [MyQQ] SET TRUSTWORTHY OFF GO ALTER DATABASE [MyQQ] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [MyQQ] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [MyQQ] SET READ_WRITE GO ALTER DATABASE [MyQQ] SET RECOVERY SIMPLE GO ALTER DATABASE [MyQQ] SET MULTI_USER GO ALTER DATABASE [MyQQ] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [MyQQ] SET DB_CHAINING OFF USE [MyQQ] GO /****** 对象: Table [dbo].[tbl_FriendshipPolicy] 脚本日期: 05/24/2008 13:23:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_FriendshipPolicy]( [Id] [int] IDENTITY(1,1) NOT NULL, [FriendshipPolicy] [varchar](50) NOT NULL, CONSTRAINT [PK_tbl_FriendshipPolicy] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 对象: Table [dbo].[tbl_Star] 脚本日期: 05/24/2008 13:23:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_Star]( [Id] [int] IDENTITY(1,1) NOT NULL, [Star] [varchar](10) NOT NULL, CONSTRAINT [PK_tbl_Star] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 对象: Table [dbo].[tbl_BloodType] 脚本日期: 05/24/2008 13:23:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_BloodType]( [Id] [int] IDENTITY(1,1) NOT NULL, [BloodType] [varchar](10) NOT NULL, CONSTRAINT [PK_tbl_BloodType] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 对象: Table [dbo].[tbl_MessageType] 脚本日期: 05/24/2008 13:23:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_MessageType]( [Id] [int] IDENTITY(1,1) NOT NULL, [MessageType] [varchar](50) NOT NULL, CONSTRAINT [PK_tbl_MessageType] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 对象: Table [dbo].[tbl_users] 脚本日期: 05/24/2008 13:23:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_users]( [Id] [int] IDENTITY(10000,1) NOT NULL, [LoginPwd] [varchar](20) NOT NULL, [UserState] [varchar](50) NOT NULL, [FriendshipPolicyId] [int] NOT NULL, [NickName] [varchar](20) NOT NULL, [FaceId] [int] NULL, [Sex] [varchar](2) NOT NULL, [Age] [tinyint] NOT NULL, [Name] [varchar](10) NULL, [StarId] [int] NULL, [BloodTypeId] [int] NULL, CONSTRAINT [PK_tbl_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) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 对象: Table [dbo].[tbl_Message] 脚本日期: 05/24/2008 13:23:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_Message]( [Id] [int] IDENTITY(1,1) NOT NULL, [FromUserId] [int] NOT NULL, [ToUserId] [int] NOT NULL, [Message] [varchar](50) NULL, [MessageTypeId] [int] NOT NULL, [MessageState] [int] NOT NULL, [MessageTime] [datetime] NOT NULL, CONSTRAINT [PK_tbl_Message] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 对象: Table [dbo].[tbl_Friends] 脚本日期: 05/24/2008 13:23:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tbl_Friends]( [Id] [int] IDENTITY(1,1) NOT NULL, [HostId] [int] NOT NULL, [FriendId] [int] NOT NULL, CONSTRAINT [PK_tbl_Friends] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** 对象: Check [CK_tbl_users] 脚本日期: 05/24/2008 13:23:25 ******/ ALTER TABLE [dbo].[tbl_users] WITH CHECK ADD CONSTRAINT [CK_tbl_users] CHECK (([Sex]='男' OR [Sex]='女')) GO ALTER TABLE [dbo].[tbl_users] CHECK CONSTRAINT [CK_tbl_users] GO /****** 对象: ForeignKey [FK_tbl_Friends_tbl_users] 脚本日期: 05/24/2008 13:23:25 ******/ ALTER TABLE [dbo].[tbl_Friends] WITH CHECK ADD CONSTRAINT [FK_tbl_Friends_tbl_users] FOREIGN KEY([HostId]) REFERENCES [dbo].[tbl_users] ([Id]) GO ALTER TABLE [dbo].[tbl_Friends] CHECK CONSTRAINT [FK_tbl_Friends_tbl_users] GO /****** 对象: ForeignKey [FK_tbl_Friends_tbl_users1] 脚本日期: 05/24/2008 13:23:25 ******/ ALTER TABLE [dbo].[tbl_Friends] WITH CHECK ADD CONSTRAINT [FK_tbl_Friends_tbl_users1] FOREIGN KEY([FriendId]) REFERENCES [dbo].[tbl_users] ([Id]) GO ALTER TABLE [dbo].[tbl_Friends] CHECK CONSTRAINT [FK_tbl_Friends_tbl_users1] GO /****** 对象: ForeignKey [FK_tbl_Message_tbl_MessageType] 脚本日期: 05/24/2008 13:23:25 ******/ ALTER TABLE [dbo].[tbl_Message] WITH CHECK ADD CONSTRAINT [FK_tbl_Message_tbl_MessageType] FOREIGN KEY([MessageTypeId]) REFERENCES [dbo].[tbl_MessageType] ([Id]) GO ALTER TABLE [dbo].[tbl_Message] CHECK CONSTRAINT [FK_tbl_Message_tbl_MessageType] GO /****** 对象: ForeignKey [FK_tbl_Message_tbl_users] 脚本日期: 05/24/2008 13:23:25 ******/ ALTER TABLE [dbo].[tbl_Message] WITH CHECK ADD CONSTRAINT [FK_tbl_Message_tbl_users] FOREIGN KEY([FromUserId]) REFERENCES [dbo].[tbl_users] ([Id]) GO ALTER TABLE [dbo].[tbl_Message] CHECK CONSTRAINT [FK_tbl_Message_tbl_users] GO /****** 对象: ForeignKey [FK_tbl_Message_tbl_users1] 脚本日期: 05/24/2008 13:23:25 ******/ ALTER TABLE [dbo].[tbl_Message] WITH CHECK ADD CONSTRAINT [FK_tbl_Message_tbl_users1] FOREIGN KEY([ToUserId]) REFERENCES [dbo].[tbl_users] ([Id]) GO ALTER TABLE [dbo].[tbl_Message] CHECK CONSTRAINT [FK_tbl_Message_tbl_users1] G