/****** Object:  Database AsaiMH    Script Date: 2010-5-26 11:43:01 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'AsaiMH')
	DROP DATABASE [AsaiMH]
GO

/******
这里我们以本地SQL数据库建立为例
"
SqlSer = "(local)" 'Sql数据服务器名或地址,如"(local)"、"127.0.0.1"、"127.0.0.1:1433"、".\SQLEXPRESS"
SqlData = "AsaiMH" 'Sql连接数据库名,如"AsaiMH"
Sqluid = "asaimh" 'Sql数据服务器登陆用户名,如"AsaiMH"
Sqlpwd = "asaimh123" 'Sql数据服务器登陆密码,如"123456"
"
以上代码来自Include文件夹中的Conn.asp文件中的31-34行，数据库建成以后需要配置相应位置。
我们现在要来建立一个符合上面的SQL链接的SQL数据库。
1、打开"SQL企业管理器"，使用"SQL查询工具"打开网站根目录下的"DataBase"文件夹中的"AsaiMH.sql"文件，执行SQL建表，强烈建议使用SQL2008；
（注意：默认建立的数据库名为"AsaiMH"，数据库位置在"E:\AsaiMHSQL\AsaiMH_Data.MDF"，如果您熟悉SQL可以自行修改AsaiMH.sql文件后执行）
2、新建一个数据库"登录名"，即登录用户"asaimh"，密码设置为"asaimh123"，并将该用户指配给数据库"AsaiMH"，尽量赋予其所有管理权；
（为了SQL数据库兼容请使用全小写格式的字母或数字）
3、导入网站根目录下的"DataBase"文件夹中的"AsaiMHWEB.mdb"ACCESS数据库，导入时注意“映射”中，选中所有表列，设置其映射属性为，覆盖删除表、覆盖删除列，启用标识三项全选；
4、顺利导入数据库后打开Include文件夹中的Conn.asp文件，按照注释说明修改数据库连接字符串即可使用。
******/
CREATE DATABASE [AsaiMH]  ON (NAME = N'AsaiMH_Data', FILENAME = N'E:\AsaiMHSQL\AsaiMH_Data.MDF' , SIZE = 26, FILEGROWTH = 10%) LOG ON (NAME = N'AsaiMH_Log', FILENAME = N'E:\AsaiMHSQL\AsaiMH_Log.LDF' , SIZE = 120, FILEGROWTH = 10%)
 COLLATE Chinese_PRC_CI_AS
GO

exec sp_dboption N'AsaiMH', N'autoclose', N'false'
GO

exec sp_dboption N'AsaiMH', N'bulkcopy', N'false'
GO

exec sp_dboption N'AsaiMH', N'trunc. log', N'false'
GO

exec sp_dboption N'AsaiMH', N'torn page detection', N'true'
GO

exec sp_dboption N'AsaiMH', N'read only', N'false'
GO

exec sp_dboption N'AsaiMH', N'dbo use', N'false'
GO

exec sp_dboption N'AsaiMH', N'single', N'false'
GO

exec sp_dboption N'AsaiMH', N'autoshrink', N'false'
GO

exec sp_dboption N'AsaiMH', N'ANSI null default', N'false'
GO

exec sp_dboption N'AsaiMH', N'recursive triggers', N'false'
GO

exec sp_dboption N'AsaiMH', N'ANSI nulls', N'false'
GO

exec sp_dboption N'AsaiMH', N'concat null yields null', N'false'
GO

exec sp_dboption N'AsaiMH', N'cursor close on commit', N'false'
GO

exec sp_dboption N'AsaiMH', N'default to local cursor', N'false'
GO

exec sp_dboption N'AsaiMH', N'quoted identifier', N'false'
GO

exec sp_dboption N'AsaiMH', N'ANSI warnings', N'false'
GO

exec sp_dboption N'AsaiMH', N'auto create statistics', N'true'
GO

exec sp_dboption N'AsaiMH', N'auto update statistics', N'true'
GO

if( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) )
	exec sp_dboption N'AsaiMH', N'db chaining', N'false'
GO

use [AsaiMH]
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_UserGroup    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHInit_UserGroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHInit_UserGroup]
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_class    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbs_class]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHBbs_class]
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_Main    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbs_Main]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHBbs_Main]
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_Main2    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbs_Main2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHBbs_Main2]
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_Print    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbs_Print]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHBbs_Print]
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_View    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbs_View]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHBbs_View]
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_Channel    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHInit_Channel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHInit_Channel]
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_Info    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHInit_Info]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHInit_Info]
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_Menu    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHInit_Menu]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHInit_Menu]
GO

/****** Object:  Stored Procedure dbo.AsaiMHLoad_Channel    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHLoad_Channel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHLoad_Channel]
GO

/****** Object:  Stored Procedure dbo.AsaiMHUserIndex    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserIndex]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHUserIndex]
GO

/****** Object:  Stored Procedure dbo.AsaiMHUserLogin    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserLogin]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[AsaiMHUserLogin]
GO

/****** Object:  Table [dbo].[AsaiMHAds]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHAds]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHAds]
GO

/****** Object:  Table [dbo].[AsaiMHArticle]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHArticle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHArticle]
GO

/****** Object:  Table [dbo].[AsaiMHBbsAds]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbsAds]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBbsAds]
GO

/****** Object:  Table [dbo].[AsaiMHBbsData]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbsData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBbsData]
GO

/****** Object:  Table [dbo].[AsaiMHBbsEvent]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbsEvent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBbsEvent]
GO

/****** Object:  Table [dbo].[AsaiMHBbsClass]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbsClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBbsClass]
GO

/****** Object:  Table [dbo].[AsaiMHBbsTopic]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbsTopic]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBbsTopic]
GO

/****** Object:  Table [dbo].[AsaiMHBbsVote]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBbsVote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBbsVote]
GO

/****** Object:  Table [dbo].[AsaiMHBlog]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBlog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBlog]
GO

/****** Object:  Table [dbo].[AsaiMHBlogBook]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBlogBook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBlogBook]
GO

/****** Object:  Table [dbo].[AsaiMHBlogData]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBlogData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBlogData]
GO

/****** Object:  Table [dbo].[AsaiMHBlogSort]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBlogSort]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBlogSort]
GO

/****** Object:  Table [dbo].[AsaiMHBlogTags]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHBlogTags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHBlogTags]
GO

/****** Object:  Table [dbo].[AsaiMHCards]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHCards]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHCards]
GO

/****** Object:  Table [dbo].[AsaiMHCast]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHCast]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHCast]
GO

/****** Object:  Table [dbo].[AsaiMHChannel]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHChannel]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHChannel]
GO

/****** Object:  Table [dbo].[AsaiMHClass]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHClass]
GO

/****** Object:  Table [dbo].[AsaiMHConfigs]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHConfigs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHConfigs]
GO

/****** Object:  Table [dbo].[AsaiMHDown]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHDown]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHDown]
GO

/****** Object:  Table [dbo].[AsaiMHErr]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHErr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHErr]
GO

/****** Object:  Table [dbo].[AsaiMHEvent]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHEvent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHEvent]
GO

/****** Object:  Table [dbo].[AsaiMHFlea]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHFlea]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHFlea]
GO

/****** Object:  Table [dbo].[AsaiMHGuestbook]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHGuestbook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHGuestbook]
GO

/****** Object:  Table [dbo].[AsaiMHOk]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHOk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHOk]
GO

/****** Object:  Table [dbo].[AsaiMHOk_Reply]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHOk_reply]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHOk_reply]
GO

/****** Object:  Table [dbo].[AsaiMHIp_Address]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHIp_Address]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHIp_Address]
GO

/****** Object:  Table [dbo].[AsaiMHIpstop]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHIpstop]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHIpstop]
GO

/****** Object:  Table [dbo].[AsaiMHJs]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHJs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHJs]
GO

/****** Object:  Table [dbo].[AsaiMHKeyWord]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHKeyWord]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHKeyWord]
GO

/****** Object:  Table [dbo].[AsaiMHLinks]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHLinks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHLinks]
GO

/****** Object:  Table [dbo].[AsaiMHMenu]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMenu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMenu]
GO

/****** Object:  Table [dbo].[AsaiMHMovie]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMovie]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMovie]
GO

/****** Object:  Table [dbo].[AsaiMHMovie_Url]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMovie_Url]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMovie_Url]
GO

/****** Object:  Table [dbo].[AsaiMHMusicDisk]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMusicDisk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMusicDisk]
GO

/****** Object:  Table [dbo].[AsaiMHMusicFav]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMusicFav]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMusicFav]
GO

/****** Object:  Table [dbo].[AsaiMHMusicFree]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMusicFree]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMusicFree]
GO

/****** Object:  Table [dbo].[AsaiMHMusicMail]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMusicMail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMusicMail]
GO

/****** Object:  Table [dbo].[AsaiMHMusicSinger]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMusicSinger]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMusicSinger]
GO

/****** Object:  Table [dbo].[AsaiMHMusicSong]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHMusicSong]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHMusicSong]
GO

/****** Object:  Table [dbo].[AsaiMHNews]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHNews]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHNews]
GO

/****** Object:  Table [dbo].[AsaiMHNotes]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHNotes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHNotes]
GO

/****** Object:  Table [dbo].[AsaiMHNotesEmoney]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHNotesEmoney]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHNotesEmoney]
GO

/****** Object:  Table [dbo].[AsaiMHPages]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHPages]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHPages]
GO

/****** Object:  Table [dbo].[AsaiMHPhoto]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHPhoto]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHPhoto]
GO

/****** Object:  Table [dbo].[AsaiMHReview]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHReview]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHReview]
GO

/****** Object:  Table [dbo].[AsaiMHServer]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHServer]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHServer]
GO

/****** Object:  Table [dbo].[AsaiMHShop]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHShop]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHShop]
GO

/****** Object:  Table [dbo].[AsaiMHShopEmoneyNotes]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHShopEmoneyNotes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHShopEmoneyNotes]
GO

/****** Object:  Table [dbo].[AsaiMHShopOorders]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHShopOorders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHShopOorders]
GO

/****** Object:  Table [dbo].[AsaiMHShopOrders]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHShopOrders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHShopOrders]
GO

/****** Object:  Table [dbo].[AsaiMHSpecial]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHSpecial]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHSpecial]
GO

/****** Object:  Table [dbo].[AsaiMHSqlLog]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHSqlLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHSqlLog]
GO

/****** Object:  Table [dbo].[AsaiMHTemplate]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHTemplate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHTemplate]
GO

/****** Object:  Table [dbo].[AsaiMHUpload]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUpload]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUpload]
GO

/****** Object:  Table [dbo].[AsaiMHUserBookGroup]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserBookGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserBookGroup]
GO

/****** Object:  Table [dbo].[AsaiMHUserBookMark]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserBookMark]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserBookMark]
GO

/****** Object:  Table [dbo].[AsaiMHUserData]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserData]
GO

/****** Object:  Table [dbo].[AsaiMHUserFriend]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserFriend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserFriend]
GO

/****** Object:  Table [dbo].[AsaiMHUserGroup]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserGroup]
GO

/****** Object:  Table [dbo].[AsaiMHUserLogin]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserLogin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserLogin]
GO

/****** Object:  Table [dbo].[AsaiMHUserMail]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserMail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserMail]
GO

/****** Object:  Table [dbo].[AsaiMHUserSkin]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHUserSkin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHUserSkin]
GO

/****** Object:  Table [dbo].[AsaiMHVote]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AsaiMHVote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AsaiMHVote]
GO

/****** Object:  Table [dbo].[NC_NewsConfig]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NC_NewsConfig]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NC_NewsConfig]
GO

/****** Object:  Table [dbo].[NC_NewsItem]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NC_NewsItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NC_NewsItem]
GO

/****** Object:  Table [dbo].[NC_SoftConfig]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NC_SoftConfig]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NC_SoftConfig]
GO

/****** Object:  Table [dbo].[NC_SoftItem]    Script Date: 2010-5-26 11:43:03 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NC_SoftItem]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NC_SoftItem]
GO

/****** Object:  Login guoyansai    Script Date: 2010-5-26 11:43:01 ******/
if not exists (select * from master.dbo.syslogins where loginname = N'guoyansai')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'AsaiMH', @loginlang = N'简体中文'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'guoyansai', null, @logindb, @loginlang
END
GO

/****** Object:  User dbo    Script Date: 2010-5-26 11:43:01 ******/
/****** Object:  Table [dbo].[AsaiMHAds]    Script Date: 2010-5-26 11:43:04 ******/
CREATE TABLE [dbo].[AsaiMHAds] (
	[AID] [int] IDENTITY (1, 1) NOT NULL ,
	[AdName] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdLinkUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdIntro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdImgUrl] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ImgWidth] [int] NULL ,
	[ImgHeight] [int] NULL ,
	[IsFlash] [bit] NULL ,
	[ADType] [int] NULL ,
	[ADSetting] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CloseAds] [int] NULL ,
	[CodeNote] [int] NULL ,
	[IsTime] [bit] NULL ,
	[AdTime] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHArticle]    Script Date: 2010-5-26 11:43:04 ******/
CREATE TABLE [dbo].[AsaiMHArticle] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[IncludeInfo] [int] NULL ,
	[Subtitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Comto] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ispic] [bit] NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Author] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Counter] [int] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBbsAds]    Script Date: 2010-5-26 11:43:04 ******/
CREATE TABLE [dbo].[AsaiMHBbsAds] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Head] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tit] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tbb] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBbsData]    Script Date: 2010-5-26 11:43:04 ******/
CREATE TABLE [dbo].[AsaiMHBbsData] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[bbs_ID] [int] NULL ,
	[Reply_ID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ICon] [int] NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Ip] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sys] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserID] [int] NULL ,
	[Is_Topic] [bit] NULL ,
	[Is_Shield] [bit] NULL ,
	[Cod] [int] NULL ,
	[Rap] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBbsEvent]    Script Date: 2010-5-26 11:43:04 ******/
CREATE TABLE [dbo].[AsaiMHBbsEvent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[bbs_ID] [int] NULL ,
	[Topic_ID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[O_User] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Integral] [int] NULL ,
	[Strength] [int] NULL ,
	[Expression] [int] NULL ,
	[Remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBbsClass]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBbsClass] (
	[bbs_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Class_ID] [int] NULL ,
	[bbs_Order] [int] NULL ,
	[bbs_F] [int] NULL ,
	[bbs_N] [int] NULL ,
	[bbs_W] [bit] NULL ,
	[bbs_Star] [int] NULL ,
	[bbs_Parent] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Power] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Pic] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Type] [int] NULL ,
	[bbs_Hidden] [bit] NULL ,
	[bbs_Pro] [int] NULL ,
	[bbs_Topic_Num] [int] NULL ,
	[bbs_Data_Num] [int] NULL ,
	[bbs_New_Info] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_New_Num] [int] NULL ,
	[bbs_Config] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_User] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Rule] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbs_Special] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBbsTopic]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBbsTopic] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[bbs_ID] [int] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[TColor] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tbb] [bit] NULL ,
	[ICon] [int] NULL ,
	[Tim] [datetime] NULL ,
	[Counter] [int] NULL ,
	[Re_UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Re_Counter] [int] NULL ,
	[Re_Tim] [datetime] NULL ,
	[Istop] [int] NULL ,
	[Islock] [int] NULL ,
	[Isgood] [int] NULL ,
	[Isvote] [bit] NULL ,
	[Vote_Num] [int] NULL ,
	[UserID] [int] NULL ,
	[Order_ID] [int] NULL ,
	[Tip_Num] [int] NULL ,
	[Is_Html] [bit] NULL ,
	[Form_Id] [int] NULL ,
	[bbs_Data] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[T_Special_Num] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[T_Special_Data] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[T_IsSpecial] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[T_Special_Remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[FileType] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SpecialID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBbsVote]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBbsVote] (
	[V_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Reply_ID] [int] NULL ,
	[V_Name] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[V_Num] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[V_Type] [bit] NULL ,
	[V_Tim] [datetime] NULL ,
	[V_Day] [int] NULL ,
	[V_UserName] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBlog]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBlog] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BlogName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[Hits] [int] NULL ,
	[Tim] [datetime] NULL ,
	[Skin] [int] NULL ,
	[User_Skin_Main] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[User_Skin_ShowLog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Links] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Left_Cut] [int] NULL ,
	[Main_Cut] [int] NULL ,
	[List_Type] [int] NULL ,
	[Show_Num] [int] NULL ,
	[List_Friend] [int] NULL ,
	[List_Photo] [int] NULL ,
	[Left_Num] [int] NULL ,
	[List_Num] [int] NULL ,
	[Photo_Num] [int] NULL ,
	[Photo_Hnum] [int] NULL ,
	[Count1] [int] NULL ,
	[Count2] [int] NULL ,
	[IsGood] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBlogBook]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBlogBook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[BUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Home] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Reply] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Retim] [datetime] NULL ,
	[Secret] [bit] NULL ,
	[Hidden] [bit] NULL ,
	[IsUser] [bit] NULL ,
	[IsReply] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBlogData]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBlogData] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[CID] [int] NULL ,
	[SID] [int] NULL ,
	[Type] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Weather] [int] NULL ,
	[ICon] [int] NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tags] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Hidden] [bit] NULL ,
	[Count] [int] NULL ,
	[Year] [int] NULL ,
	[Month] [int] NULL ,
	[Day] [int] NULL ,
	[Reply] [int] NULL ,
	[Retim] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBlogSort]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBlogSort] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Type] [int] NULL ,
	[Sort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Orders] [int] NULL ,
	[Count] [int] NULL ,
	[ShowType] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHBlogTags]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHBlogTags] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Type] [int] NULL ,
	[Tags] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Num] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHCards]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHCards] (
	[C_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[C_Sort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[C_Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[C_Pass] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[C_Power] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[C_Emoney] [int] NULL ,
	[C_Integral] [int] NULL ,
	[C_Expression] [int] NULL ,
	[C_Strength] [int] NULL ,
	[C_Hidden] [int] NULL ,
	[C_Day] [int] NULL ,
	[C_Pay] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[C_Tim] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHCast]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHCast] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHChannel]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHChannel] (
	[ChannelIDs] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelPicUrl] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelRemark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelBold] [bit] NULL ,
	[ChannelOpenType] [bit] NULL ,
	[ChannelHidden] [bit] NULL ,
	[ChannelType] [int] NULL ,
	[LinkUrl] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelOrder] [int] NULL ,
	[ModuleType] [int] NULL ,
	[ChannelDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelTit] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelDataName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelListNum] [int] NULL ,
	[ShowName] [bit] NULL ,
	[ChannelSetup] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassDepth] [int] NULL ,
	[RssField] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelPut] [int] NULL ,
	[UploadType] [int] NULL ,
	[MaxFileSize] [int] NULL ,
	[PicWidth] [int] NULL ,
	[PicHeight] [int] NULL ,
	[UpFileType] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CuteNum] [int] NULL ,
	[LeftCuteNum] [int] NULL ,
	[ChannelCount] [int] NULL ,
	[ChannelHits] [int] NULL ,
	[ChannelOption] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelPreSet] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelPower] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelReward] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelDates] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FreeUserGroup] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PutFreeExempts] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BornClassRowNum] [int] NULL ,
	[UploadDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsCreateHtml] [bit] NULL ,
	[HtmlExtName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlPrefix] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlPath] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlForm] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsNewWindow] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHClass]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHClass] (
	[C_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassID] [int] NULL ,
	[ClassOrder] [int] NULL ,
	[ClassParent] [int] NULL ,
	[ClassChild] [int] NULL ,
	[ClassDepth] [int] NULL ,
	[ClassParentStr] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassChildStr] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassConfig] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelIDs] [int] NULL ,
	[ClassDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isUpdate] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHConfigs]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHConfigs] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Num_Reg] [int] NULL ,
	[New_UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Counter] [int] NULL ,
	[Max_Online] [int] NULL ,
	[Max_Tim] [datetime] NULL ,
	[Start_Tim] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Today_Tim] [datetime] NULL ,
	[Num_New] [int] NULL ,
	[Configs] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SuperAdmin] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CookiesName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AdminFolder] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UploadFolder] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BadWords] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[LockIP] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[UserLevel] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PerPay] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Medal] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Gbook] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[BbsData] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Payment] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IsCreatIndex] [bit] NULL ,
	[IndexFile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BbsConfig] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SqlInword] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[NoChkFiles] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[AdsFilter] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHDown]    Script Date: 2010-5-26 11:43:05 ******/
CREATE TABLE [dbo].[AsaiMHDown] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sizes] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Genre] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[Os] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Url] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Homepage] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Counter] [int] NULL ,
	[Types] [int] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ispic] [bit] NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL ,
	[NotDown] [bit] NULL ,
	[UseServer] [bit] NULL ,
	[Server_Id] [int] NULL ,
	[FileAddress] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHErr]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHErr] (
	[RID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[EID] [int] NULL ,
	[EUserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EWord] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[ETim] [datetime] NULL ,
	[Topic] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHEvent]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHEvent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[nName] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Ip] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sys] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHFlea]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHFlea] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[oName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[Types] [int] NULL ,
	[Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Price] [int] NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Counter] [int] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[oTim] [int] NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHGuestbook]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHGuestbook] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[nName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[Whe] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Qq] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ip] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sys] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[ICon] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Face] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Re_Icon] [int] NULL ,
	[Re_Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Re_Tim] [datetime] NULL ,
	[IsSecret] [bit] NULL ,
	[Hidden] [bit] NULL ,
	[IsReply] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHOk]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHOk] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Solves] [int] NULL ,
	[Jieuser] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Replys] [int] NULL ,
	[Reward] [int] NULL ,
	[Counter] [int] NULL ,
	[Tim] [datetime] NULL ,
	[Expired] [datetime] NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHOk_reply]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHOk_reply] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[R_id] [int] NULL ,
	[Vote] [int] NULL ,
	[Isdeal] [int] NULL ,
	[Uls] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cod] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHIp_Address]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHIp_Address] (
	[Ip1] [float] NULL ,
	[Ip2] [float] NULL ,
	[Country] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[City] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[local] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHIpstop]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHIpstop] (
	[S_ID] [int] IDENTITY (1, 1) NOT NULL ,
	[S_UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[S_Ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[S_Tim_Star] [datetime] NULL ,
	[S_Tim_End] [datetime] NULL ,
	[S_Dl_Num] [int] NULL ,
	[S_Style] [bit] NULL ,
	[S_Yj_Stop] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHJs]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHJs] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Label] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHKeyWord]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHKeyWord] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[KeyWord] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelIDs] [int] NULL ,
	[IsHot] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHLinks]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHLinks] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Orders] [int] NULL ,
	[Sort] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[nName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[WebMaster] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMenu]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHMenu] (
	[MenuID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[MenuName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuTit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuSort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuUrl] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuHidden] [bit] NULL ,
	[MenuLevel] [int] NULL ,
	[MenuDataName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuOrder] [int] NULL ,
	[MenuHelp] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuTitFir] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[MenuOpen] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMovie]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHMovie] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Url] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Counter] [int] NULL ,
	[Lang] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Role] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ViewType] [int] NULL ,
	[Star] [int] NULL ,
	[Genre] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[Types] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Whe] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ispic] [bit] NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL ,
	[Rekoe] [int] NULL ,
	[Server_Id] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMovie_Url]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHMovie_Url] (
	[F_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[F_Url] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[F_Name] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Id] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMusicDisk]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHMusicDisk] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[ClassID] [int] NULL ,
	[SpecialID] [int] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[N_ID] [int] NULL ,
	[Singer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Words] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[TColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Keyes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lang] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Hits] [int] NULL ,
	[IsTop] [bit] NULL ,
	[IsFocus] [bit] NULL ,
	[Hot] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[PCom] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PTim] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[Counter] [int] NULL ,
	[Cod] [int] NULL ,
	[IsPic] [bit] NULL ,
	[HtmlFileDate] [datetime] NULL ,
	[IsUpdate] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMusicFav]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHMusicFav] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [int] NULL ,
	[N_ID] [int] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[F_ID] [int] NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Singer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[F_Type] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Lang] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Company] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMusicFree]    Script Date: 2010-5-26 11:43:06 ******/
CREATE TABLE [dbo].[AsaiMHMusicFree] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserIp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[FreeType] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMusicMail]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHMusicMail] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[S_user] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[R_User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[M_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[M_ID] [int] NULL ,
	[Words] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Paynum] [float] NULL ,
	[Power] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[IsRead] [bit] NULL ,
	[Emoney] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMusicSinger]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHMusicSinger] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClassID] [int] NULL ,
	[S_ID] [int] NULL ,
	[IncludeInfo] [int] NULL ,
	[Abcd] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsPic] [bit] NULL ,
	[Sex] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cod] [bit] NULL ,
	[Bir] [datetime] NULL ,
	[Dir] [datetime] NULL ,
	[Ctell] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[keyes] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Comp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Isfocus] [bit] NULL ,
	[istop] [bit] NULL ,
	[isgood] [bit] NULL ,
	[TColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dnum] [int] NULL ,
	[snum] [int] NULL ,
	[Hidden] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHMusicSong]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHMusicSong] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ClassID] [int] NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[IncludeInfo] [int] NULL ,
	[Comto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[urltype] [int] NULL ,
	[keyes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[smi] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Singer] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[N_ID] [int] NULL ,
	[d_id] [int] NULL ,
	[cod] [int] NULL ,
	[Words] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[counter] [int] NULL ,
	[Hits] [int] NULL ,
	[power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[isgood] [bit] NULL ,
	[isfocus] [bit] NULL ,
	[istop] [int] NULL ,
	[Hidden] [bit] NULL ,
	[ispic] [bit] NULL ,
	[TColor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isUpdate] [bit] NULL ,
	[Server_Id] [int] NULL ,
	[genre] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHNews]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHNews] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[IncludeInfo] [int] NULL ,
	[Subtitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Comto] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ispic] [bit] NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Author] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Counter] [int] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHNotes]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHNotes] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[nsort] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[iid] [int] NULL ,
	[Emoney] [int] NULL ,
	[Tim] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHNotesEmoney]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHNotesEmoney] (
	[e_id] [int] IDENTITY (1, 1) NOT NULL ,
	[e_ordernum] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[e_userName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[e_amount] [float] NULL ,
	[e_emoney] [int] NULL ,
	[e_tim] [datetime] NULL ,
	[e_ispay] [bit] NULL ,
	[e_ptim] [datetime] NULL ,
	[e_payment] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHPages]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHPages] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Company] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FaRen] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Types] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Trade] [int] NULL ,
	[Contact] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sheng] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Shi] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Skin] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Counter] [int] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[oTim] [int] NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHPhoto]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHPhoto] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Power] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Url] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ViewType] [int] NULL ,
	[Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[Counter] [int] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[IsTop] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUpdate] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHReview]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHReview] (
	[Rid] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[Re_ID] [int] NULL ,
	[RUserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[REmail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RWord] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[RTim] [datetime] NULL ,
	[RType] [tinyint] NULL ,
	[RGrade] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReWord] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Retim] [datetime] NULL ,
	[Rip] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL  ,
	[RScore] [int] NULL
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHServer]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHServer] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[S_ID] [int] NULL ,
	[ChannelIDs] [int] NULL ,
	[S_Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[S_Url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsDisabled] [bit] NULL ,
	[S_ReadMe] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[S_Union] [int] NULL ,
	[S_UID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHShop]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHShop] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ChannelIDs] [int] NULL ,
	[SpecialID] [int] NULL ,
	[ClassID] [int] NULL ,
	[Name] [nvarchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
	[Serial] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Brand] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stock] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stocks] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[OutStocks] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[StocksName] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[ProductType] [int] NULL ,
	[Brief] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Price_Original] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Price_Market] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Ispic] [bit] NULL ,
	[Counter] [int] NULL ,
	[Buy_Counter] [int] NULL ,
	[Hidden] [bit] NULL ,
	[IsTop] [int] NULL ,
	[IsGood] [bit] NULL ,
	[Isfocus] [bit] NULL ,
	[Tim] [datetime] NULL ,
	[Keyes] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Price] [float] NULL ,
	[DisCount] [int] NULL ,
	[Is_Emoney] [bit] NULL ,
	[Emoney] [int] NULL ,
	[Amount] [int] NULL ,
	[Con_Emoney] [int] NULL ,
	[Con_Integral] [int] NULL ,
	[Con_Expression] [int] NULL ,
	[Con_Strength] [int] NULL ,
	[Cod] [int] NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HtmlFileDate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isUpdate] [bit] NULL ,
	[NotGoods] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHShopEmoneyNotes]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHShopEmoneyNotes] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ordernum] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[pid] [int] NULL ,
	[serial] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Emoney] [int] NULL ,
	[Num] [int] NULL ,
	[emoneys] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[nName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[code] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[types] [int] NULL ,
	[dis_tim] [datetime] NULL ,
	[dis_remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[carry] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[carry_price] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHShopOorders]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHShopOorders] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[oid] [int] NULL ,
	[pid] [int] NULL ,
	[serial] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[price] [float] NULL ,
	[Num] [int] NULL ,
	[discount] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHShopOrders]    Script Date: 2010-5-26 11:43:07 ******/
CREATE TABLE [dbo].[AsaiMHShopOrders] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUser] [bit] NULL ,
	[ordernum] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[nName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[code] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[payment] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[types] [int] NULL ,
	[dis_tim] [datetime] NULL ,
	[dis_remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[prices] [float] NULL ,
	[carry] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[carry_price] [int] NULL ,
	[ispayment] [bit] NULL ,
	[ispay] [bit] NULL ,
	[pay_tim] [datetime] NULL ,
	[iscon] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHSpecial]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHSpecial] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Topic] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelIDs] [int] NULL ,
	[Tim] [datetime] NULL ,
	[Hidden] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHSqlLog]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHSqlLog] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserID] [int] NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ScriptName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[S_Info] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[IP] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[A_Time] [smalldatetime] NULL ,
	[Type] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHTemplate]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHTemplate] (
	[t_id] [int] IDENTITY (1, 1) NOT NULL ,
	[t_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[t_dir] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[t_cid] [int] NULL ,
	[t_sid] [int] NULL ,
	[t_css] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[t_main] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[t_config] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[isdefault] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUpload]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUpload] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserIP] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpFileName] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpFileType] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpFileUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpFileSize] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[UpFileTime] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserBookGroup]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserBookGroup] (
	[g_id] [int] IDENTITY (1, 1) NOT NULL ,
	[g_sort] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[g_Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserBookMark]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserBookMark] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[g_id] [int] NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserData]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserData] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[nName] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[passwd] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [bit] NULL ,
	[birthday] [datetime] NULL ,
	[Whe] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Qq] [int] NULL ,
	[Email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Face] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[power] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [bit] NULL ,
	[bbs_counter] [int] NULL ,
	[bbs_del] [int] NULL ,
	[counter] [int] NULL ,
	[integral] [int] NULL ,
	[Emoney] [int] NULL ,
	[login_num] [int] NULL ,
	[last_tim] [datetime] NULL ,
	[last_ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[popedom] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[face_w] [int] NULL ,
	[face_h] [int] NULL ,
	[msn] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[estate] [bit] NULL ,
	[abate] [bit] NULL ,
	[otim] [datetime] NULL ,
	[tmp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[u_ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[login_msg] [int] NULL ,
	[onlinetime] [int] NULL ,
	[medal] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Strength] [int] NULL ,
	[Expression] [int] NULL ,
	[ok_counter] [int] NULL ,
	[ok_helpnum] [int] NULL ,
	[ok_reply] [int] NULL ,
	[m_level] [int] NULL ,
	[islock] [bit] NULL ,
	[ispb] [bit] NULL ,
	[isopen] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserFriend]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserFriend] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[username1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[username2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserGroup]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserGroup] (
	[GroupID] [int] IDENTITY (1, 1) NOT NULL ,
	[GroupPower] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GroupName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GroupGrade] [int] NULL ,
	[GroupType] [int] NULL ,
	[GroupOrder] [int] NULL ,
	[GroupConfig] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FontColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[GlowColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserLogin]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserLogin] (
	[l_id] [int] IDENTITY (1, 1) NOT NULL ,
	[l_userName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[l_type] [int] NULL ,
	[l_where] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[l_tim_login] [datetime] NULL ,
	[l_tim_end] [datetime] NULL ,
	[l_ip] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[l_sys] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[l_power] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[l_bbs_id] [int] NULL ,
	[l_login_id] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserMail]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserMail] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[send_u] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[accept_u] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Word] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tim] [datetime] NULL ,
	[types] [tinyint] NULL ,
	[isread] [bit] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHUserSkin]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHUserSkin] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[userskinName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[skinmain] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[skinshowlog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[skinauthor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[skinauthorurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[isdefault] [bit] NULL ,
	[skinpic] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[ispass] [bit] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[AsaiMHVote]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[AsaiMHVote] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[vid] [int] NULL ,
	[vtype] [int] NULL ,
	[vName] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[vurl] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[TColor] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[counter] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[NC_NewsConfig]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[NC_NewsConfig] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[stopGather] [tinyint] NULL ,
	[RepeatDeal] [tinyint] NULL ,
	[MaxPicSize] [int] NULL ,
	[AllowPicExt] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[setInterval] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[NC_NewsItem]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[NC_NewsItem] (
	[ItemID] [int] IDENTITY (1, 1) NOT NULL ,
	[ItemName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteUrl] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelID] [int] NULL ,
	[ClassID] [int] NULL ,
	[SpecialID] [int] NULL ,
	[StopItem] [tinyint] NULL ,
	[Encoding] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsDown] [tinyint] NULL ,
	[AutoClass] [tinyint] NULL ,
	[PathForm] [smallint] NULL ,
	[IsNowTime] [tinyint] NULL ,
	[AllHits] [int] NULL ,
	[star] [int] NULL ,
	[RemoveCode] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[lastime] [smalldatetime] NULL ,
	[RemoteListUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[PaginalList] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsPagination] [tinyint] NULL ,
	[startid] [int] NULL ,
	[lastid] [int] NULL ,
	[FindListCode] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FindInfoCode] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[RetuneClass] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IsNextPage] [tinyint] NULL ,
	[NamedDemourl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[strReplace] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[power] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[emoney] [int] NULL ,
	[isgood] [bit] NULL ,
	[istop] [int] NULL ,
	[Isfocus] [bit] NULL ,
	[hidden] [bit] NULL ,
	[CollNum] [int] NULL ,
	[CollFan] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[NC_SoftConfig]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[NC_SoftConfig] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[UseDownload] [int] NULL ,
	[RepeatDeal] [tinyint] NULL ,
	[isProgress] [tinyint] NULL ,
	[TrueAddress] [tinyint] NULL ,
	[setInterval] [int] NULL ,
	[MaxDownSize] [int] NULL ,
	[AllowDownExt] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[FilePrefix] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FileSuffix] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isZipFile] [tinyint] NULL ,
	[ZipMode] [tinyint] NULL ,
	[ZipTimeout] [int] NULL ,
	[MaxZipsize] [int] NULL ,
	[AllowFileExt] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[WinRarPath] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[DownFilePath] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReadmePath] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReadmeFile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[RarNoteFile] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[DownZipKey] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[NC_SoftItem]    Script Date: 2010-5-26 11:43:08 ******/
CREATE TABLE [dbo].[NC_SoftItem] (
	[ItemID] [int] IDENTITY (1, 1) NOT NULL ,
	[ItemName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SiteUrl] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[ChannelID] [int] NULL ,
	[ClassID] [int] NULL ,
	[SpecialID] [int] NULL ,
	[StopItem] [tinyint] NULL ,
	[Encoding] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsDown] [tinyint] NULL ,
	[downid] [int] NULL ,
	[MaxAddress] [int] NULL ,
	[AutoClass] [tinyint] NULL ,
	[PathForm] [smallint] NULL ,
	[SaveFilePath] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[AutoRename] [tinyint] NULL ,
	[IsNowTime] [tinyint] NULL ,
	[AllHits] [int] NULL ,
	[star] [int] NULL ,
	[RemoveCode] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[lastime] [smalldatetime] NULL ,
	[RemoteListUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[PaginalList] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsPagination] [tinyint] NULL ,
	[startid] [int] NULL ,
	[lastid] [int] NULL ,
	[FindListCode] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FindInfoCode] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[downpage] [tinyint] NULL ,
	[RetuneClass] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[RemoveFile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[strLeachName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[NamedDemourl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[strReplace] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHAds] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHAds] PRIMARY KEY  CLUSTERED 
	(
		[AID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHArticle] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHArticle] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBbsAds] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBbsAds] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBbsData] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBbsData] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBbsEvent] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBbsEvent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBbsClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBbsClass] PRIMARY KEY  CLUSTERED 
	(
		[bbs_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBbsTopic] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBbsTopic] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBbsVote] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBbsVote] PRIMARY KEY  CLUSTERED 
	(
		[V_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBlog] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBlog] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBlogBook] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBlogBook] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBlogData] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBlogData] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBlogSort] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBlogSort] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHBlogTags] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHBlogTags] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHCards] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHCards] PRIMARY KEY  CLUSTERED 
	(
		[C_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHCast] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHCast] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHChannel] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHChannel] PRIMARY KEY  CLUSTERED 
	(
		[ChannelIDs]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHClass] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHClass] PRIMARY KEY  CLUSTERED 
	(
		[C_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHConfigs] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHConfigs] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHDown] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHDown] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHErr] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHErr] PRIMARY KEY  CLUSTERED 
	(
		[RID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHEvent] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHEvent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHFlea] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHFlea] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHGuestbook] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHGuestbook] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHOk] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHOk] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHOk_reply] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHOk_reply] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHIpstop] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHIpstop] PRIMARY KEY  CLUSTERED 
	(
		[S_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHJs] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHJs] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHKeyWord] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHKeyWord] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHLinks] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHLinks] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMenu] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMenu] PRIMARY KEY  CLUSTERED 
	(
		[MenuID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMovie] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMovie] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMovie_Url] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMovie_Url] PRIMARY KEY  CLUSTERED 
	(
		[F_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMusicDisk] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMusicDisk] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMusicFav] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMusicFav] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMusicFree] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMusicFree] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMusicMail] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMusicMail] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMusicSinger] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMusicSinger] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHMusicSong] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHMusicSong] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHNews] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHNews] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHNotes] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHNotes] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHNotesEmoney] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHNotesEmoney] PRIMARY KEY  CLUSTERED 
	(
		[e_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHPages] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHPages] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHPhoto] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHPhoto] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHReview] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHReview] PRIMARY KEY  CLUSTERED 
	(
		[Rid]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHServer] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHServer] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHShop] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHShop] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHShopEmoneyNotes] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHShopEmoneyNotes] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHShopOorders] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHShopOorders] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHShopOrders] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHShopOrders] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHSpecial] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHSpecial] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHSqlLog] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHSqlLog] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHTemplate] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHTemplate] PRIMARY KEY  CLUSTERED 
	(
		[t_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUpload] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUpload] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserBookGroup] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserBookGroup] PRIMARY KEY  CLUSTERED 
	(
		[g_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserBookMark] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserBookMark] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserData] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserData] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserFriend] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserFriend] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserGroup] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserGroup] PRIMARY KEY  CLUSTERED 
	(
		[GroupID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserLogin] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserLogin] PRIMARY KEY  CLUSTERED 
	(
		[l_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserMail] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserMail] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHUserSkin] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHUserSkin] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHVote] WITH NOCHECK ADD 
	CONSTRAINT [PK_AsaiMHVote] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[NC_NewsConfig] WITH NOCHECK ADD 
	CONSTRAINT [PK_NC_NewsConfig] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[NC_NewsItem] WITH NOCHECK ADD 
	CONSTRAINT [PK_NC_NewsItem] PRIMARY KEY  CLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[NC_SoftConfig] WITH NOCHECK ADD 
	CONSTRAINT [PK_NC_SoftConfig] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[NC_SoftItem] WITH NOCHECK ADD 
	CONSTRAINT [PK_NC_SoftItem] PRIMARY KEY  CLUSTERED 
	(
		[ItemID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[AsaiMHAds] ADD 
	CONSTRAINT [DF__AsaiMHAds__ImgWidth__76CBA758] DEFAULT (0) FOR [ImgWidth],
	CONSTRAINT [DF__AsaiMHAds__ImgHeigh__77BFCB91] DEFAULT (0) FOR [ImgHeight],
	CONSTRAINT [DF__AsaiMHAds__IsFlash__78B3EFCA] DEFAULT (0) FOR [IsFlash],
	CONSTRAINT [DF__AsaiMHAds__ADType__79A81403] DEFAULT (0) FOR [ADType],
	CONSTRAINT [DF__AsaiMHAds__CloseAds__7A9C383C] DEFAULT (0) FOR [CloseAds],
	CONSTRAINT [DF__AsaiMHAds__CodeNote__7B905C75] DEFAULT (0) FOR [CodeNote],
	CONSTRAINT [DF__AsaiMHAds__IsTime__7C8480AE] DEFAULT (0) FOR [IsTime]
GO

 CREATE  INDEX [AID] ON [dbo].[AsaiMHAds]([AID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHArticle] ADD 
	CONSTRAINT [DF__AsaiMHArticl__IsTop__7F60ED59] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHArticle__Cod__00551192] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHArticle]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHArticle]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHArticle]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Keyes] ON [dbo].[AsaiMHArticle]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHArticle]([SpecialID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBbsAds]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBbsData] ADD 
	CONSTRAINT [DF__AsaiMHBbsDat__bbs__0519C6AF] DEFAULT (0) FOR [bbs_ID],
	CONSTRAINT [DF__AsaiMHBbsDat__Reply__060DEAE8] DEFAULT (0) FOR [Reply_ID],
	CONSTRAINT [DF__AsaiMHBbsData__ICon__07020F21] DEFAULT (0) FOR [ICon]
GO

 CREATE  INDEX [reply_id] ON [dbo].[AsaiMHBbsData]([Reply_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [search] ON [dbo].[AsaiMHBbsData]([bbs_ID], [Tim], [Topic], [ID]) ON [PRIMARY]
GO

 CREATE  INDEX [UserID] ON [dbo].[AsaiMHBbsData]([UserID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBbsEvent] ADD 
	CONSTRAINT [DF__AsaiMHBbsEve__Emone__09DE7BCC] DEFAULT (0) FOR [Emoney],
	CONSTRAINT [DF__AsaiMHBbsEve__Integ__0AD2A005] DEFAULT (0) FOR [Integral],
	CONSTRAINT [DF__AsaiMHBbsEve__Stren__0BC6C43E] DEFAULT (0) FOR [Strength],
	CONSTRAINT [DF__AsaiMHBbsEve__Expre__0CBAE877] DEFAULT (0) FOR [Expression]
GO

 CREATE  INDEX [bbs_ID] ON [dbo].[AsaiMHBbsEvent]([bbs_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBbsEvent]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Topic_ID] ON [dbo].[AsaiMHBbsEvent]([Topic_ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBbsClass] ADD 
	CONSTRAINT [DF__AsaiMHBbsFor__Class__0F975522] DEFAULT (0) FOR [Class_ID],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__108B795B] DEFAULT (0) FOR [bbs_Order],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__117F9D94] DEFAULT (0) FOR [bbs_F],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__1273C1CD] DEFAULT (0) FOR [bbs_N],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__1367E606] DEFAULT (0) FOR [bbs_Type],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__145C0A3F] DEFAULT (0) FOR [bbs_Pro],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__15502E78] DEFAULT (0) FOR [bbs_Topic_Num],
	CONSTRAINT [DF__AsaiMHBbsFor__bbs__164452B1] DEFAULT (0) FOR [bbs_Data_Num]
GO

 CREATE  INDEX [class_id] ON [dbo].[AsaiMHBbsClass]([Class_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [bbs_id1] ON [dbo].[AsaiMHBbsClass]([bbs_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [bbs_topic_num] ON [dbo].[AsaiMHBbsClass]([bbs_Topic_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [SID] ON [dbo].[AsaiMHBbsClass]([bbs_Data_Num]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBbsTopic] ADD 
	CONSTRAINT [DF__AsaiMHBbsTop__bbs__1920BF5C] DEFAULT (0) FOR [bbs_ID],
	CONSTRAINT [DF__AsaiMHBbsTopi__ICon__1A14E395] DEFAULT (0) FOR [ICon],
	CONSTRAINT [DF__AsaiMHBbsTop__Count__1B0907CE] DEFAULT (0) FOR [Counter],
	CONSTRAINT [DF__AsaiMHBbsTop__Re_Co__1BFD2C07] DEFAULT (0) FOR [Re_Counter],
	CONSTRAINT [DF__AsaiMHBbsTop__Istop__1CF15040] DEFAULT (0) FOR [Istop],
	CONSTRAINT [DF__AsaiMHBbsTop__Isloc__1DE57479] DEFAULT (0) FOR [Islock],
	CONSTRAINT [DF__AsaiMHBbsTop__Isgoo__1ED998B2] DEFAULT (0) FOR [Isgood],
	CONSTRAINT [DF__AsaiMHBbsTop__Speci__1FCDBCEB] DEFAULT (0) FOR [SpecialID]
GO

 CREATE  INDEX [Form_Id] ON [dbo].[AsaiMHBbsTopic]([Form_Id]) ON [PRIMARY]
GO

 CREATE  INDEX [List_1] ON [dbo].[AsaiMHBbsTopic]([bbs_ID], [Istop], [Re_Tim]) ON [PRIMARY]
GO

 CREATE  INDEX [order_id] ON [dbo].[AsaiMHBbsTopic]([Order_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHBbsTopic]([SpecialID]) ON [PRIMARY]
GO

 CREATE  INDEX [T_Special_Num] ON [dbo].[AsaiMHBbsTopic]([T_Special_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [Tip_Num] ON [dbo].[AsaiMHBbsTopic]([Tip_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [UserID] ON [dbo].[AsaiMHBbsTopic]([UserID]) ON [PRIMARY]
GO

 CREATE  INDEX [Vote_Num] ON [dbo].[AsaiMHBbsTopic]([Vote_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [reply_id] ON [dbo].[AsaiMHBbsVote]([Reply_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [v_id] ON [dbo].[AsaiMHBbsVote]([V_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [v_num] ON [dbo].[AsaiMHBbsVote]([V_Num]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBlog] ADD 
	CONSTRAINT [DF__AsaiMHBlog__IsGood__239E4DCF] DEFAULT (0) FOR [IsGood]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBlog]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [left_num] ON [dbo].[AsaiMHBlog]([Left_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [list_num] ON [dbo].[AsaiMHBlog]([List_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [photo_num] ON [dbo].[AsaiMHBlog]([Photo_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [photo_num1] ON [dbo].[AsaiMHBlog]([Photo_Hnum]) ON [PRIMARY]
GO

 CREATE  INDEX [show_num] ON [dbo].[AsaiMHBlog]([Show_Num]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBlogBook] ADD 
	CONSTRAINT [DF__AsaiMHBlogBo__Secre__267ABA7A] DEFAULT (0) FOR [Secret],
	CONSTRAINT [DF__AsaiMHBlogBo__Hidde__276EDEB3] DEFAULT (0) FOR [Hidden],
	CONSTRAINT [DF__AsaiMHBlogBo__IsUse__286302EC] DEFAULT (0) FOR [IsUser],
	CONSTRAINT [DF__AsaiMHBlogBo__IsRep__29572725] DEFAULT (0) FOR [IsReply]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBlogBook]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBlogData] ADD 
	CONSTRAINT [DF__AsaiMHBlogData__SID__2B3F6F97] DEFAULT (0) FOR [SID]
GO

 CREATE  INDEX [CID] ON [dbo].[AsaiMHBlogData]([CID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBlogData]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [mid] ON [dbo].[AsaiMHBlogData]([SID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBlogSort] ADD 
	CONSTRAINT [DF__AsaiMHBlogSor__Type__2D27B809] DEFAULT (0) FOR [Type]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBlogSort]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHBlogTags] ADD 
	CONSTRAINT [DF__AsaiMHBlogTag__Type__2F10007B] DEFAULT (0) FOR [Type]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHBlogTags]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Num] ON [dbo].[AsaiMHBlogTags]([Num]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHCards] ADD 
	CONSTRAINT [DF__AsaiMHCards__C_Inte__30F848ED] DEFAULT (0) FOR [C_Integral],
	CONSTRAINT [DF__AsaiMHCards__C_Expr__31EC6D26] DEFAULT (0) FOR [C_Expression],
	CONSTRAINT [DF__AsaiMHCards__C_Stre__32E0915F] DEFAULT (0) FOR [C_Strength],
	CONSTRAINT [DF__AsaiMHCards__C_Day__33D4B598] DEFAULT (0) FOR [C_Day]
GO

 CREATE  INDEX [C_ID] ON [dbo].[AsaiMHCards]([C_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHCast]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHChannel] ADD 
	CONSTRAINT [DF__AsaiMHChanne__Chann__38996AB5] DEFAULT (0) FOR [ChannelOrder],
	CONSTRAINT [DF__AsaiMHChanne__Chann__398D8EEE] DEFAULT (0) FOR [ChannelListNum],
	CONSTRAINT [DF__AsaiMHChanne__Chann__3A81B327] DEFAULT ('00000000000000000000') FOR [ChannelSetup],
	CONSTRAINT [DF__AsaiMHChanne__Class__3B75D760] DEFAULT (0) FOR [ClassDepth],
	CONSTRAINT [DF__AsaiMHChanne__Chann__3C69FB99] DEFAULT (0) FOR [ChannelPut],
	CONSTRAINT [DF__AsaiMHChanne__Uploa__3D5E1FD2] DEFAULT (0) FOR [UploadType],
	CONSTRAINT [DF__AsaiMHChanne__PicWi__3E52440B] DEFAULT (0) FOR [PicWidth],
	CONSTRAINT [DF__AsaiMHChanne__PicHe__3F466844] DEFAULT (0) FOR [PicHeight],
	CONSTRAINT [DF__AsaiMHChanne__CuteN__403A8C7D] DEFAULT (20) FOR [CuteNum],
	CONSTRAINT [DF__AsaiMHChanne__LeftC__412EB0B6] DEFAULT (15) FOR [LeftCuteNum],
	CONSTRAINT [DF__AsaiMHChanne__Chann__4222D4EF] DEFAULT (0) FOR [ChannelCount],
	CONSTRAINT [DF__AsaiMHChanne__Chann__4316F928] DEFAULT (0) FOR [ChannelHits],
	CONSTRAINT [DF__AsaiMHChanne__BornC__440B1D61] DEFAULT (0) FOR [BornClassRowNum],
	CONSTRAINT [DF__AsaiMHChanne__IsCre__44FF419A] DEFAULT (0) FOR [IsCreateHtml]
GO

 CREATE  INDEX [ChannelListNum] ON [dbo].[AsaiMHChannel]([ChannelListNum]) ON [PRIMARY]
GO

 CREATE  INDEX [CuteNum] ON [dbo].[AsaiMHChannel]([CuteNum]) ON [PRIMARY]
GO

 CREATE  INDEX [Disabled] ON [dbo].[AsaiMHChannel]([ChannelHidden]) ON [PRIMARY]
GO

 CREATE  INDEX [LeftCuteNum] ON [dbo].[AsaiMHChannel]([LeftCuteNum]) ON [PRIMARY]
GO

 CREATE  INDEX [UploadDayNum] ON [dbo].[AsaiMHChannel]([PicWidth]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHClass] ADD 
	CONSTRAINT [DF__AsaiMHClass__ClassI__47DBAE45] DEFAULT (0) FOR [ClassID],
	CONSTRAINT [DF__AsaiMHClass__ClassO__48CFD27E] DEFAULT (0) FOR [ClassOrder],
	CONSTRAINT [DF__AsaiMHClass__ClassP__49C3F6B7] DEFAULT (0) FOR [ClassParent],
	CONSTRAINT [DF__AsaiMHClass__ClassC__4AB81AF0] DEFAULT (0) FOR [ClassChild],
	CONSTRAINT [DF__AsaiMHClass__ClassC__4BAC3F29] DEFAULT ('0,0,0,0,0,0,0,0,0,0') FOR [ClassConfig],
	CONSTRAINT [DF__AsaiMHClass__Channe__4CA06362] DEFAULT (0) FOR [ChannelIDs]
GO

 CREATE  INDEX [C_ID] ON [dbo].[AsaiMHClass]([C_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHClass]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [class_id] ON [dbo].[AsaiMHClass]([ClassID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHConfigs] ADD 
	CONSTRAINT [DF__AsaiMHConfig__Count__4F7CD00D] DEFAULT (0) FOR [Counter],
	CONSTRAINT [DF__AsaiMHConfig__Max_O__5070F446] DEFAULT (0) FOR [Max_Online],
	CONSTRAINT [DF__AsaiMHConfig__Confi__5165187F] DEFAULT (',|||,') FOR [Configs]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHConfigs]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHDown] ADD 
	CONSTRAINT [DF__AsaiMHDown__Emoney__534D60F1] DEFAULT (0) FOR [Emoney],
	CONSTRAINT [DF__AsaiMHDown__IsTop__5441852A] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHDown__Cod__5535A963] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHDown]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHDown]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [keyes] ON [dbo].[AsaiMHDown]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [S_ID] ON [dbo].[AsaiMHDown]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHDown]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHErr] ADD 
	CONSTRAINT [DF__AsaiMHErr__EID__5812160E] DEFAULT (0) FOR [EID]
GO

 CREATE  INDEX [re_id] ON [dbo].[AsaiMHErr]([EID]) ON [PRIMARY]
GO

 CREATE  INDEX [RID] ON [dbo].[AsaiMHErr]([RID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHEvent]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHFlea] ADD 
	CONSTRAINT [DF__AsaiMHFlea__IsTop__5CD6CB2B] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHFlea__Cod__5DCAEF64] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHFlea]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHFlea]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHFlea]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Keyes] ON [dbo].[AsaiMHFlea]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHFlea]([SpecialID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHGuestbook]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHOk] ADD 
	CONSTRAINT [DF__AsaiMHOk__Solves__628FA481] DEFAULT (0) FOR [Solves],
	CONSTRAINT [DF__AsaiMHOk__Replys__6383C8BA] DEFAULT (0) FOR [Replys],
	CONSTRAINT [DF__AsaiMHOk__Reward__6477ECF3] DEFAULT (0) FOR [Reward],
	CONSTRAINT [DF__AsaiMHOk__IsTop__656C112C] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHOk__Cod__66603565] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHOk]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHOk]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHOk]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHOk]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHOk_reply] ADD 
	CONSTRAINT [DF__AsaiMHOk_Re__R_id__693CA210] DEFAULT (0) FOR [R_id],
	CONSTRAINT [DF__AsaiMHOk_Re__Vote__6A30C649] DEFAULT (0) FOR [Vote],
	CONSTRAINT [DF__AsaiMHOk_R__Isdea__6B24EA82] DEFAULT (0) FOR [Isdeal],
	CONSTRAINT [DF__AsaiMHOk_Rep__Cod__6C190EBB] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHOk_reply]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHOk_reply]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [R_id] ON [dbo].[AsaiMHOk_reply]([R_id]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHIpstop] ADD 
	CONSTRAINT [DF__AsaiMHIpstop__S_Dl___6EF57B66] DEFAULT (0) FOR [S_Dl_Num]
GO

 CREATE  INDEX [S_dl_num] ON [dbo].[AsaiMHIpstop]([S_Dl_Num]) ON [PRIMARY]
GO

 CREATE  INDEX [S_ID] ON [dbo].[AsaiMHIpstop]([S_ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHKeyWord] ADD 
	CONSTRAINT [DF__AsaiMHKeyWor__Chann__72C60C4A] DEFAULT (0) FOR [ChannelIDs]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHKeyWord]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHLinks]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMenu] ADD 
	CONSTRAINT [DF__AsaiMHMenu__MenuOrd__778AC167] DEFAULT (0) FOR [MenuOrder]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHMenu]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [m_id] ON [dbo].[AsaiMHMenu]([MenuID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMovie] ADD 
	CONSTRAINT [DF__AsaiMHMovie__Emoney__7A672E12] DEFAULT (0) FOR [Emoney],
	CONSTRAINT [DF__AsaiMHMovie__ViewTy__7B5B524B] DEFAULT (0) FOR [ViewType],
	CONSTRAINT [DF__AsaiMHMovie__Star__7C4F7684] DEFAULT (0) FOR [Star],
	CONSTRAINT [DF__AsaiMHMovie__IsTop__7D439ABD] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHMovie__Cod__7E37BEF6] DEFAULT (0) FOR [Cod],
	CONSTRAINT [DF__AsaiMHMovie__Server__7F2BE32F] DEFAULT (0) FOR [Server_Id]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHMovie]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHMovie]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [keyes] ON [dbo].[AsaiMHMovie]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [S_ID] ON [dbo].[AsaiMHMovie]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [Server_Id] ON [dbo].[AsaiMHMovie]([Server_Id]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHMovie]([SpecialID]) ON [PRIMARY]
GO

 CREATE  INDEX [viewtype] ON [dbo].[AsaiMHMovie]([ViewType]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMusicDisk] ADD 
	CONSTRAINT [DF__AsaiMHMusicD__Chann__02FC7413] DEFAULT (0) FOR [ChannelIDs],
	CONSTRAINT [DF__AsaiMHMusicD__Class__03F0984C] DEFAULT (0) FOR [ClassID],
	CONSTRAINT [DF__AsaiMHMusicD__Speci__04E4BC85] DEFAULT (0) FOR [SpecialID],
	CONSTRAINT [DF__AsaiMHMusicDi__N_ID__05D8E0BE] DEFAULT (0) FOR [N_ID],
	CONSTRAINT [DF__AsaiMHMusicDis__Tim__06CD04F7] DEFAULT (getdate()) FOR [Tim],
	CONSTRAINT [DF__AsaiMHMusicDi__Hits__07C12930] DEFAULT (0) FOR [Hits],
	CONSTRAINT [DF__AsaiMHMusicDis__Cod__08B54D69] DEFAULT (0) FOR [Cod]
GO

 CREATE  UNIQUE  INDEX [Specialid] ON [dbo].[AsaiMHMusicDisk]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHMusicDisk]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [keyes] ON [dbo].[AsaiMHMusicDisk]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [singerid] ON [dbo].[AsaiMHMusicDisk]([N_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID1] ON [dbo].[AsaiMHMusicDisk]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMusicFav] ADD 
	CONSTRAINT [DF__AsaiMHMusicF__Class__0B91BA14] DEFAULT (0) FOR [ClassID],
	CONSTRAINT [DF__AsaiMHMusicFa__N_ID__0C85DE4D] DEFAULT (0) FOR [N_ID],
	CONSTRAINT [DF__AsaiMHMusicFa__F_ID__0D7A0286] DEFAULT (0) FOR [F_ID]
GO

 CREATE  UNIQUE  INDEX [ID] ON [dbo].[AsaiMHMusicFav]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [C_ID] ON [dbo].[AsaiMHMusicFav]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [Musicid] ON [dbo].[AsaiMHMusicFav]([F_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [N_ID] ON [dbo].[AsaiMHMusicFav]([N_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHMusicFree]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [nameid] ON [dbo].[AsaiMHMusicFree]([UserIp]) ON [PRIMARY]
GO

 CREATE  INDEX [Url] ON [dbo].[AsaiMHMusicFree]([UserName]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMusicMail] ADD 
	CONSTRAINT [DF__AsaiMHMusicMa__M_ID__123EB7A3] DEFAULT (0) FOR [M_ID],
	CONSTRAINT [DF__AsaiMHMusicM__Paynu__1332DBDC] DEFAULT (0) FOR [Paynum],
	CONSTRAINT [DF__AsaiMHMusicMai__Tim__14270015] DEFAULT (getdate()) FOR [Tim],
	CONSTRAINT [DF__AsaiMHMusicM__IsRea__151B244E] DEFAULT (1) FOR [IsRead]
GO

 CREATE  INDEX [ForID] ON [dbo].[AsaiMHMusicMail]([R_User]) ON [PRIMARY]
GO

 CREATE  INDEX [From_id] ON [dbo].[AsaiMHMusicMail]([S_user]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHMusicMail]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [MusicID] ON [dbo].[AsaiMHMusicMail]([M_Name]) ON [PRIMARY]
GO

 CREATE  INDEX [MusicId1] ON [dbo].[AsaiMHMusicMail]([M_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [paynum] ON [dbo].[AsaiMHMusicMail]([Paynum]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMusicSinger] ADD 
	CONSTRAINT [DF__AsaiMHMusicS__Chann__17F790F9] DEFAULT (0) FOR [ChannelIDs],
	CONSTRAINT [DF__AsaiMHMusicS__Speci__18EBB532] DEFAULT (0) FOR [SpecialID],
	CONSTRAINT [DF__AsaiMHMusicS__Class__19DFD96B] DEFAULT (0) FOR [ClassID],
	CONSTRAINT [DF__AsaiMHMusicSi__S_ID__1AD3FDA4] DEFAULT (0) FOR [S_ID],
	CONSTRAINT [DF__AsaiMHMusicS__Inclu__1BC821DD] DEFAULT (0) FOR [IncludeInfo],
	CONSTRAINT [DF__AsaiMHMusicSin__Tim__1CBC4616] DEFAULT (getdate()) FOR [Tim],
	CONSTRAINT [DF__AsaiMHMusicSi__dnum__1DB06A4F] DEFAULT (0) FOR [dnum],
	CONSTRAINT [DF__AsaiMHMusicSi__snum__1EA48E88] DEFAULT (0) FOR [snum]
GO

 CREATE  UNIQUE  INDEX [Nclassid] ON [dbo].[AsaiMHMusicSinger]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHMusicSinger]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [disknum] ON [dbo].[AsaiMHMusicSinger]([dnum]) ON [PRIMARY]
GO

 CREATE  INDEX [musicnum] ON [dbo].[AsaiMHMusicSinger]([snum]) ON [PRIMARY]
GO

 CREATE  INDEX [SClassID] ON [dbo].[AsaiMHMusicSinger]([S_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHMusicSinger]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHMusicSong] ADD 
	CONSTRAINT [DF__AsaiMHMusicS__Class__2180FB33] DEFAULT (0) FOR [ClassID],
	CONSTRAINT [DF__AsaiMHMusicS__Chann__22751F6C] DEFAULT (0) FOR [ChannelIDs],
	CONSTRAINT [DF__AsaiMHMusicS__Speci__236943A5] DEFAULT (0) FOR [SpecialID],
	CONSTRAINT [DF__AsaiMHMusicS__Inclu__245D67DE] DEFAULT (0) FOR [IncludeInfo],
	CONSTRAINT [DF__AsaiMHMusicS__urlty__25518C17] DEFAULT (0) FOR [urltype],
	CONSTRAINT [DF__AsaiMHMusicSo__N_ID__2645B050] DEFAULT (0) FOR [N_ID],
	CONSTRAINT [DF__AsaiMHMusicSo__d_id__2739D489] DEFAULT (0) FOR [d_id],
	CONSTRAINT [DF__AsaiMHMusicSon__cod__282DF8C2] DEFAULT (0) FOR [cod],
	CONSTRAINT [DF__AsaiMHMusicS__count__29221CFB] DEFAULT (0) FOR [counter],
	CONSTRAINT [DF__AsaiMHMusicSo__Hits__2A164134] DEFAULT (0) FOR [Hits],
	CONSTRAINT [DF__AsaiMHMusicS__Emone__2B0A656D] DEFAULT (0) FOR [Emoney],
	CONSTRAINT [DF__AsaiMHMusicS__istop__2BFE89A6] DEFAULT (0) FOR [istop],
	CONSTRAINT [DF__AsaiMHMusicS__Serve__2CF2ADDF] DEFAULT (0) FOR [Server_Id]
GO

 CREATE  UNIQUE  INDEX [ID] ON [dbo].[AsaiMHMusicSong]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID1] ON [dbo].[AsaiMHMusicSong]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [Hits] ON [dbo].[AsaiMHMusicSong]([Hits]) ON [PRIMARY]
GO

 CREATE  INDEX [keyes] ON [dbo].[AsaiMHMusicSong]([keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [Nclassid] ON [dbo].[AsaiMHMusicSong]([N_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [server_id] ON [dbo].[AsaiMHMusicSong]([Server_Id]) ON [PRIMARY]
GO

 CREATE  INDEX [Specialid] ON [dbo].[AsaiMHMusicSong]([d_id]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID1] ON [dbo].[AsaiMHMusicSong]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHNews] ADD 
	CONSTRAINT [DF__AsaiMHNews__IsTop__2FCF1A8A] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHNews__Cod__30C33EC3] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHNews]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHNews]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHNews]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Keyes] ON [dbo].[AsaiMHNews]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHNews]([SpecialID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHNotes]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [iid] ON [dbo].[AsaiMHNotes]([iid]) ON [PRIMARY]
GO

 CREATE  INDEX [e_id] ON [dbo].[AsaiMHNotesEmoney]([e_id]) ON [PRIMARY]
GO

 CREATE  INDEX [e_ordernum] ON [dbo].[AsaiMHNotesEmoney]([e_ordernum]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHPages] ADD 
	CONSTRAINT [DF__AsaiMHPages__IsTop__3864608B] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHPages__Cod__395884C4] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHPages]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHPages]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHPages]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Keyes] ON [dbo].[AsaiMHPages]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHPages]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHPhoto] ADD 
	CONSTRAINT [DF__AsaiMHPhoto__Emoney__3C34F16F] DEFAULT (0) FOR [Emoney],
	CONSTRAINT [DF__AsaiMHPhoto__ViewTy__3D2915A8] DEFAULT (0) FOR [ViewType],
	CONSTRAINT [DF__AsaiMHPhoto__IsTop__3E1D39E1] DEFAULT (0) FOR [IsTop],
	CONSTRAINT [DF__AsaiMHPhoto__Cod__3F115E1A] DEFAULT (0) FOR [Cod]
GO

 CREATE  INDEX [ClassID] ON [dbo].[AsaiMHPhoto]([ClassID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHPhoto]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [keyes] ON [dbo].[AsaiMHPhoto]([Keyes]) ON [PRIMARY]
GO

 CREATE  INDEX [S_ID] ON [dbo].[AsaiMHPhoto]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHPhoto]([SpecialID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHReview] ADD 
	CONSTRAINT [DF__AsaiMHReview__Chann__41EDCAC5] DEFAULT (0) FOR [ChannelIDs],
	CONSTRAINT [DF__AsaiMHReview__Re_ID__42E1EEFE] DEFAULT (0) FOR [Re_ID],
	CONSTRAINT [DF__AsaiMHReview__RType__43D61337] DEFAULT (0) FOR [RType],
	CONSTRAINT [DF__AsaiMHReview__RGrad__44CA3770] DEFAULT (0) FOR [RGrade]
GO

 CREATE  INDEX [re_id] ON [dbo].[AsaiMHReview]([Re_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Rid] ON [dbo].[AsaiMHReview]([Rid]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHServer] ADD 
	CONSTRAINT [DF__AsaiMHServer__Chann__47A6A41B] DEFAULT (0) FOR [ChannelIDs],
	CONSTRAINT [DF__AsaiMHServer__S_Uni__489AC854] DEFAULT (0) FOR [S_Union]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHServer]([ChannelIDs]) ON [PRIMARY]
GO

 CREATE  INDEX [S_ID] ON [dbo].[AsaiMHServer]([S_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ss_id] ON [dbo].[AsaiMHServer]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHShop] ADD 
	CONSTRAINT [DF__AsaiMHShop__IsTop__4B7734FF] DEFAULT (0) FOR [IsTop]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHShop]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [SpecialID] ON [dbo].[AsaiMHShop]([SpecialID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHShopEmoneyNotes]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHShopOorders]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Num] ON [dbo].[AsaiMHShopOorders]([Num]) ON [PRIMARY]
GO

 CREATE  INDEX [oid] ON [dbo].[AsaiMHShopOorders]([oid]) ON [PRIMARY]
GO

 CREATE  INDEX [pid] ON [dbo].[AsaiMHShopOorders]([pid]) ON [PRIMARY]
GO

 CREATE  INDEX [code] ON [dbo].[AsaiMHShopOrders]([code]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHShopOrders]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [ordernum] ON [dbo].[AsaiMHShopOrders]([ordernum]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHSpecial] ADD 
	CONSTRAINT [DF__AsaiMHSpecia__Chann__531856C7] DEFAULT (0) FOR [ChannelIDs]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHSpecial]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHSqlLog] ADD 
	CONSTRAINT [DF_AsaiMHSqlLog_A_Time] DEFAULT (getdate()) FOR [A_Time]
GO

ALTER TABLE [dbo].[AsaiMHTemplate] ADD 
	CONSTRAINT [DF__AsaiMHTempla__t_cid__57DD0BE4] DEFAULT (0) FOR [t_cid],
	CONSTRAINT [DF__AsaiMHTempla__t_sid__58D1301D] DEFAULT (0) FOR [t_sid],
	CONSTRAINT [DF__AsaiMHTempla__t_mai__59C55456] DEFAULT ('|||@@@|||@@@|||') FOR [t_main],
	CONSTRAINT [DF__AsaiMHTempla__t_con__5AB9788F] DEFAULT ('|||@@@|||@@@|||') FOR [t_config]
GO

 CREATE  INDEX [ChannelID] ON [dbo].[AsaiMHTemplate]([t_cid]) ON [PRIMARY]
GO

 CREATE  INDEX [t_id] ON [dbo].[AsaiMHTemplate]([t_id]) ON [PRIMARY]
GO

 CREATE  INDEX [t_sid] ON [dbo].[AsaiMHTemplate]([t_sid]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHUpload]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [g_id] ON [dbo].[AsaiMHUserBookGroup]([g_id]) ON [PRIMARY]
GO

 CREATE  INDEX [g_id] ON [dbo].[AsaiMHUserBookMark]([g_id]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHUserBookMark]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHUserData] ADD 
	CONSTRAINT [DF__AsaiMHUserData__Qq__634EBE90] DEFAULT (0) FOR [Qq],
	CONSTRAINT [DF__AsaiMHUserDa__bbs_c__6442E2C9] DEFAULT (0) FOR [bbs_counter],
	CONSTRAINT [DF__AsaiMHUserDa__bbs_d__65370702] DEFAULT (0) FOR [bbs_del],
	CONSTRAINT [DF__AsaiMHUserDa__count__662B2B3B] DEFAULT (0) FOR [counter],
	CONSTRAINT [DF__AsaiMHUserDa__integ__671F4F74] DEFAULT (0) FOR [integral],
	CONSTRAINT [DF__AsaiMHUserDa__Emone__681373AD] DEFAULT (0) FOR [Emoney],
	CONSTRAINT [DF__AsaiMHUserDa__login__690797E6] DEFAULT (0) FOR [login_num],
	CONSTRAINT [DF__AsaiMHUserDa__login__69FBBC1F] DEFAULT (0) FOR [login_msg],
	CONSTRAINT [DF__AsaiMHUserDa__onlin__6AEFE058] DEFAULT (0) FOR [onlinetime],
	CONSTRAINT [DF__AsaiMHUserDa__Ok___6BE40491] DEFAULT (0) FOR [ok_counter],
	CONSTRAINT [DF__AsaiMHUserDa__Ok___6CD828CA] DEFAULT (0) FOR [ok_helpnum],
	CONSTRAINT [DF__AsaiMHUserDa__Ok___6DCC4D03] DEFAULT (0) FOR [ok_reply],
	CONSTRAINT [DF__AsaiMHUserDa__isloc__6EC0713C] DEFAULT (0) FOR [islock],
	CONSTRAINT [DF__AsaiMHUserDat__ispb__6FB49575] DEFAULT (0) FOR [ispb],
	CONSTRAINT [DF__AsaiMHUserDa__isope__70A8B9AE] DEFAULT (0) FOR [isopen]
GO

 CREATE  INDEX [ok_helpnum] ON [dbo].[AsaiMHUserData]([ok_helpnum]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHUserData]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [login_num] ON [dbo].[AsaiMHUserData]([login_num]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHUserFriend]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [GroupID] ON [dbo].[AsaiMHUserGroup]([GroupID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHUserLogin] ADD 
	CONSTRAINT [DF__AsaiMHUserLo__l_typ__7755B73D] DEFAULT (0) FOR [l_type],
	CONSTRAINT [DF__AsaiMHUserLo__l_log__7849DB76] DEFAULT (0) FOR [l_login_id]
GO

 CREATE  INDEX [l_id] ON [dbo].[AsaiMHUserLogin]([l_id]) ON [PRIMARY]
GO

 CREATE  INDEX [l_login_id] ON [dbo].[AsaiMHUserLogin]([l_login_id]) ON [PRIMARY]
GO

 CREATE  INDEX [l_tim_end] ON [dbo].[AsaiMHUserLogin]([l_tim_end]) ON [PRIMARY]
GO

 CREATE  INDEX [l_tim_login] ON [dbo].[AsaiMHUserLogin]([l_tim_login]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHUserMail]([ID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AsaiMHUserSkin] ADD 
	CONSTRAINT [DF__AsaiMHUserSk__isdef__7D0E9093] DEFAULT (0) FOR [isdefault],
	CONSTRAINT [DF__AsaiMHUserSk__ispas__7E02B4CC] DEFAULT (0) FOR [ispass]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHUserSkin]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [isdefault] ON [dbo].[AsaiMHUserSkin]([isdefault]) ON [PRIMARY]
GO

 CREATE  INDEX [ispass] ON [dbo].[AsaiMHUserSkin]([ispass]) ON [PRIMARY]
GO

 CREATE  INDEX [ID] ON [dbo].[AsaiMHVote]([ID]) ON [PRIMARY]
GO

 CREATE  INDEX [vid] ON [dbo].[AsaiMHVote]([vid]) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_class    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHBbs_class] ******/

CREATE procedure [dbo].[AsaiMHBbs_class]
AS
Select Class_ID,bbs_ID,bbs_Name,bbs_F,bbs_N,bbs_W,bbs_Star,bbs_Parent,bbs_Power,bbs_Type,bbs_Pro,bbs_User,bbs_Config,bbs_New_Num,bbs_Special,bbs_Rule from AsaiMHBbsClass Where bbs_Hidden=0 Order By Class_ID,bbs_Order,bbs_Star


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_Main    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHBbs_Main] ******/

CREATE procedure [dbo].[AsaiMHBbs_Main]
AS
select bbs_id,bbs_n,bbs_w,bbs_name,bbs_type,bbs_pro,bbs_new_info,bbs_new_num,bbs_topic_num,bbs_data_num,bbs_power,bbs_remark,bbs_pic,bbs_user,bbs_config,class_id from AsaiMHBbsClass where bbs_hidden=0 and bbs_star<2 order by class_id,bbs_order,bbs_star


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_Main2    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHBbs_Main2] ******/

CREATE procedure [dbo].[AsaiMHBbs_Main2]
@Bbsid int
AS
select bbs_id,bbs_n,bbs_w,bbs_name,bbs_type,bbs_pro,bbs_new_info,bbs_new_num,bbs_topic_num,bbs_data_num,bbs_power,bbs_remark,bbs_pic,bbs_user,bbs_config,class_id from AsaiMHBbsClass where bbs_f=@Bbsid and bbs_hidden=0 order by bbs_order,bbs_id


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_Print    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHBbs_Print] ******/

CREATE procedure [dbo].[AsaiMHBbs_Print]
@viewid int,
@bbs_database varchar(50)
AS
exec('select d.id,d.username,d.topic,d.word,d.tim,d.is_shield,u.ispb from '+@bbs_database+' d,AsaiMHUserData u where u.id=d.userid and d.reply_id='+@viewid+' order by d.id')


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHBbs_View    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHBbs_View] ******/

CREATE procedure [dbo].[AsaiMHBbs_View]
@viewid int,
@bbs_database varchar(50)
AS
exec('select d.id,d.topic,d.icon,d.word,d.tim,d.ip,d.sys,u.username,u.nname,u.sex,u.whe,u.qq,u.email,u.url,u.face,u.face_w,u.face_h,u.tim as u_tim,u.remark,u.emoney,u.integral,u.power,u.last_tim,u.bbs_counter,u.ispb,u.onlinetime,u.medal,d.is_shield,u.strength,u.expression,d.rap,u.id,u.login_num,u.Birthday,d.cod From '+@bbs_database+' d,AsaiMHUserData u where u.id=d.userid and d.reply_id='+@viewid+' order by d.id')


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_Channel    Script Date: 2010-5-26 11:43:09 ******/



--=========================================================================
--AsaiMH 3.5 Sp3 SQL 存储过程
--=========================================================================
/****** 对象:  StoredProcedure [dbo].[AsaiMHInit_Channel] ******/

CREATE procedure [dbo].[AsaiMHInit_Channel]
AS
Select ChannelIDs,ChannelName,ChannelPicUrl,ChannelRemark,ChannelColor,ChannelBold,ChannelOpenType,ChannelHidden,ChannelType,LinkUrl,ChannelOrder,ModuleType,ChannelDir,ChannelTit,ChannelDataName,ChannelUnit,ChannelListNum,ShowName,ChannelSetup,ClassDepth,RssField,ChannelPut,UploadType,MaxFileSize,PicWidth,PicHeight,UpFileType,CuteNum,LeftCuteNum,ChannelCount,ChannelHits,ChannelOption,ChannelPreSet,UploadDir,IsCreateHtml,HtmlExtName,HtmlPrefix,HtmlPath,HtmlForm,IsNewWindow From [AsaiMHChannel] Where ChannelHidden=0 Order By ChannelOrder,ChannelIDs


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_Info    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHInit_Info] ******/

CREATE procedure [dbo].[AsaiMHInit_Info]
AS
Select Num_Reg,New_Username,Counter,Max_Online,Max_Tim,Start_Tim,Today_Tim,Num_New,Configs,SuperAdmin,CookiesName,AdminFolder,UploadFolder,BadWords,LockIP,UserLevel,PerPay,Medal,Gbook,BbsData,Payment,IsCreatIndex,IndexFile,BbsConfig,SqlInword,NoChkFiles,AdsFilter from AsaiMHConfigs Where ID=1


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_Menu    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHInit_Menu] ******/

CREATE procedure [dbo].[AsaiMHInit_Menu]
AS
Select MenuID,ChannelIDs,MenuName,MenuTit,MenuSort,MenuUrl,MenuHidden,MenuLevel,MenuDataName,MenuOrder,MenuHelp,MenuTitFir,MenuOpen From [AsaiMHMenu] Order By ChannelIDs,MenuOrder,MenuID


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHLoad_Channel    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHLoad_Channel] ******/

CREATE procedure [dbo].[AsaiMHLoad_Channel]
@ChannelID Int
AS
SELECT ChannelName,ChannelDir,ChannelTit,ChannelDataName,ModuleType,HtmlPath,HtmlForm,IsCreateHtml,HtmlExtName,HtmlPrefix FROM [AsaiMHChannel] WHERE  ChannelIDs=@ChannelID


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHUserIndex    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHUserIndex] ******/

CREATE procedure [dbo].[AsaiMHUserIndex]
@username varchar(50),
@usertime varchar(50)
AS
select count(*) from AsaiMHBbsData where username=@username and bbs_id<>999999999 and tim>=@usertime


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHUserLogin    Script Date: 2010-5-26 11:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHUserLogin] ******/

CREATE procedure [dbo].[AsaiMHUserLogin]
@username varchar(50),
@userpass varchar(50)
AS
select top 1 id,username,power,m_level,emoney,integral,last_tim,face,face_w,face_h,bbs_counter,onlinetime,login_msg,email,whe,phone,strength,expression,ok_counter,ok_helpnum,ok_reply,estate,islock,ispb,otim from AsaiMHUserData where hidden=1 and username=@username and password=@userpass


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.AsaiMHInit_UserGroup    Script Date: 2010-5-26 18:43:09 ******/

/****** 对象:  StoredProcedure [dbo].[AsaiMHInit_UserGroup] ******/

CREATE procedure [dbo].[AsaiMHInit_UserGroup]
AS
Select GroupPower,GroupName,GroupType,GroupGrade,GroupConfig,FontColor,GlowColor From [AsaiMHUserGroup] Order By GroupOrder


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

