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
c#版QQ源码+SQL（QQ风格）
需积分: 9 58 浏览量
2008-09-20
14:47:49
上传
评论
收藏 8.41MB RAR 举报
c#版QQ源码+SQL（QQ风格） （607个子文件） 
MaiFormBG.bmp 236KB MaiFormBG.bmp 236KB ToolBarBackground.bmp 14KB ToolBarBackground.bmp 14KB 35.bmp 5KB 38.bmp 5KB 56.bmp 5KB 63.bmp 5KB 8.bmp 5KB 65.bmp 5KB 81.bmp 5KB 19.bmp 5KB 11.bmp 5KB 16.bmp 5KB 85.bmp 5KB 82.bmp 5KB 31.bmp 5KB 99.bmp 5KB 44.bmp 5KB 69.bmp 5KB 3.bmp 5KB 75.bmp 5KB 41.bmp 5KB 2.bmp 5KB 100.bmp 5KB 22.bmp 5KB 9.bmp 5KB 30.bmp 5KB 79.bmp 5KB 25.bmp 5KB 97.bmp 5KB 93.bmp 5KB 60.bmp 5KB 89.bmp 5KB 98.bmp 5KB 57.bmp 5KB 12.bmp 5KB 78.bmp 5KB 15.bmp 5KB 26.bmp 5KB 37.bmp 5KB 86.bmp 5KB 14.bmp 5KB 46.bmp 5KB 10.bmp 5KB 29.bmp 5KB 73.bmp 5KB 52.bmp 5KB 50.bmp 5KB 23.bmp 5KB 6.bmp 5KB 20.bmp 5KB 27.bmp 5KB 45.bmp 5KB 96.bmp 5KB 4.bmp 5KB 76.bmp 5KB 49.bmp 5KB 87.bmp 5KB 36.bmp 5KB 7.bmp 5KB 58.bmp 5KB 53.bmp 5KB 55.bmp 5KB 95.bmp 5KB 47.bmp 5KB 21.bmp 5KB 59.bmp 5KB 67.bmp 5KB 54.bmp 5KB 83.bmp 5KB 66.bmp 5KB 72.bmp 5KB 77.bmp 5KB 17.bmp 5KB 28.bmp 5KB 18.bmp 5KB 91.bmp 5KB 5.bmp 5KB 40.bmp 5KB 71.bmp 5KB 51.bmp 5KB 88.bmp 5KB 1.bmp 5KB 48.bmp 5KB 24.bmp 5KB 68.bmp 5KB 32.bmp 5KB 84.bmp 5KB 61.bmp 5KB 43.bmp 5KB 92.bmp 5KB 80.bmp 5KB 39.bmp 5KB 62.bmp 5KB 74.bmp 5KB 13.bmp 5KB 33.bmp 5KB 90.bmp 5KB 94.bmp 5KB共 607 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
