ficq.sql

本程序基于 asp.net 2.0 +sql server 2

/****** Object:  Table [dbo].[icqcontact_tb]    Script Date: 2006-6-15 11:30:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[icqcontact_tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[icqcontact_tb]
GO

/****** Object:  Table [dbo].[icqdisable_tb]    Script Date: 2006-6-15 11:30:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[icqdisable_tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[icqdisable_tb]
GO

/****** Object:  Table [dbo].[icqmsgs_tb]    Script Date: 2006-6-15 11:30:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[icqmsgs_tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[icqmsgs_tb]
GO

/****** Object:  Table [dbo].[icqservermsg_tb]    Script Date: 2006-6-15 11:30:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[icqservermsg_tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[icqservermsg_tb]
GO

/****** Object:  Table [dbo].[icqusers_tb]    Script Date: 2006-6-15 11:30:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[icqusers_tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[icqusers_tb]
GO

/****** Object:  Table [dbo].[icqcontact_tb]    Script Date: 2006-6-15 11:30:34 ******/
CREATE TABLE [dbo].[icqcontact_tb] (
	[UIN] [int] NULL ,
	[Contact] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[icqdisable_tb]    Script Date: 2006-6-15 11:30:34 ******/
CREATE TABLE [dbo].[icqdisable_tb] (
	[uin] [int] NULL ,
	[message] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[icqmsgs_tb]    Script Date: 2006-6-15 11:30:34 ******/
CREATE TABLE [dbo].[icqmsgs_tb] (
	[touin] [int] NULL ,
	[fromuin] [int] NULL ,
	[message_date] [smalldatetime] NULL ,
	[message_size] [int] NULL ,
	[message_part] [int] NULL ,
	[message_type] [int] NULL ,
	[message_body] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[icqservermsg_tb]    Script Date: 2006-6-15 11:30:34 ******/
CREATE TABLE [dbo].[icqservermsg_tb] (
	[fromuin] [int] NULL ,
	[message_date] [smalldatetime] NULL ,
	[message_cat] [int] NULL ,
	[message_size] [int] NULL ,
	[message_part] [int] NULL ,
	[message_type] [int] NULL ,
	[message_body] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[icqusers_tb]    Script Date: 2006-6-15 11:30:35 ******/
CREATE TABLE [dbo].[icqusers_tb] (
	[uin] [int] NOT NULL ,
	[ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[canbroadcast] [int] NULL ,
	[mustchangepass] [int] NULL ,
	[disabled] [int] NULL ,
	[lastlogin] [smalldatetime] NULL ,
	[createdate] [smalldatetime] NULL ,
	[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[nickname] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[picid] [tinyint] NULL ,
	[name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[authorize] [int] NULL ,
	[gender] [int] NULL ,
	[age] [int] NULL ,
	[address] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[department] [int] NULL ,
	[office_phone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[zip] [int] NULL ,
	[notes] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[home_phone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[notes_update] [int] NULL ,
	[mobile_phone] [nchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[regip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[icqusers_tb] WITH NOCHECK ADD 
	CONSTRAINT [DF_icqusers_tb_disabled] DEFAULT (0) FOR [disabled],
	CONSTRAINT [DF_icqusers_tb_authorize] DEFAULT (0) FOR [authorize],
	CONSTRAINT [DF_icqusers_tb_gender] DEFAULT (0) FOR [gender],
	CONSTRAINT [DF_icqusers_tb_age] DEFAULT (0) FOR [age],
	CONSTRAINT [DF_icqusers_tb_department] DEFAULT (0) FOR [department]
GO