oblog4.6SQL 语句 -电脑资料

时间:2011-01-03 06:13:23
染雾
分享
WORD下载 PDF下载 投诉

作者: 字体:[增加 减小] 类型:转载

代码如下:

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[ob_calendar]‘)andOBJECTPROPERTY(id,N‘IsProcedure‘)=1)

dropprocedure[dbo].[ob_calendar]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[Oblog_Verifiydata]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[Oblog_Verifiydata]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oBlog_usertags]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oBlog_usertags]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_Album]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_Album]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_AlbumComment]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_AlbumComment]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_Special]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_Special]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_SpecialList]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_SpecialList]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_admin]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_admin]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_argue]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_argue]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_arguelist]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_arguelist]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_blogstar]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_blogstar]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_blogteam]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_blogteam]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_calendar]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_calendar]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_comment]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_comment]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_config]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_config]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_digg]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_digg]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_friend]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_friend]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_friendurl]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_friendurl]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_groups]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_groups]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_log]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_log]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_logclass]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_logclass]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_logvotes]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_logvotes]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_message]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_message]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_myurl]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_myurl]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_notdownload]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_notdownload]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_obcodes]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_obcodes]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_pm]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_pm]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_roles]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_roles]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_setup]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_setup]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_skinclass]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_skinclass]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_subject]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_subject]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_syslog]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_syslog]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_sysskin]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_sysskin]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_tags]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_tags]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_team]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_team]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_teampost]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_teampost]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_teamskin]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_teamskin]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_teamusers]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_teamusers]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_trackback]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_trackback]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_upfile]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_upfile]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_url]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_url]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_user]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_user]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_userclass]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_userclass]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_userdigg]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_userdigg]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_userdir]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_userdir]

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N‘[dbo].[oblog_userskin]‘)andOBJECTPROPERTY(id,N‘IsUserTable‘)=1)

droptable[dbo].[oblog_userskin]

GO

CREATETABLE[dbo].[Oblog_Verifiydata](

[id][int]IDENTITY(1,1)NOTNULL,

[ask][varchar](50)COLLATEChinese_PRC_CI_ASNULL,

[answer][varchar](50)COLLATEChinese_PRC_CI_ASNULL,

[addtime][smalldatetime]NULL,

[isP][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oBlog_usertags](

[UserTagid][int]IDENTITY(1,1)NOTNULL,

[TagId][int]NULL,

[Userid][int]NULL,

[logid][int]NULL,

[iNum][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_Album](

[photoID][int]IDENTITY(1,1)NOTNULL,

[userID][int]NULL,

[photo_Name][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[photo_path][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[photo_size][int]NULL,

[photo_Title][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[photo_Readme][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[TeamID][int]NULL,

[isBigHead][int]NULL,

[isHide][int]NULL,

[sysClassId][int]NULL,

[userClassId][int]NULL,

[photo_width][int]NULL,

[photo_height][int]NULL,

[addtime][smalldatetime]NULL,

[fileID][int]NULL,

[commentnum][int]NULL,

[isencomment][int]NULL,

[views][int]NULL,

[Is_Album_default][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_AlbumComment](

[mainid][int]NULL,

[comment][ntext]COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[comment_user][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[commenttopic][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[userid][int]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[homepage][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isguest][int]NULL,

[iState][int]NULL,

[isdel][int]NULL,

[teamid][int]NULL,

[commentid][int]IDENTITY(1,1)NOTNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_Special](

[specialid][int]IDENTITY(1,1)NOTNULL,

[s_name][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[s_ico][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[s_count][int]NULL,

[s_abstract][ntext]COLLATEChinese_PRC_CI_ASNULL,

[s_creater][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[s_addtime][datetime]NULL,

[isActive][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_SpecialList](

[id][int]IDENTITY(1,1)NOTNULL,

[SpecialId][int]NULL,

[UserId][int]NULL,

[author][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[logid][int]NULL,

[topic][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[abstract][ntext]COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[ispass][int]NULL,

[istop][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_admin](

[id][int]IDENTITY(1,1)NOTNULL,

[username][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[password][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[lastloginip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[lastlogintime][datetime]NULL,

[logintimes][int]NULL,

[roleid][int]NULL,

[userid][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_argue](

[argueid][int]IDENTITY(1,1)NOTNULL,

[a_ico][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[topic][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[abstract][ntext]COLLATEChinese_PRC_CI_ASNULL,

[content][ntext]COLLATEChinese_PRC_CI_ASNULL,

[action1][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[action2][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[ico1][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[ico2][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[userid][int]NULL,

[idays][int]NULL,

[istate][int]NULL,

[finishtime][datetime]NULL,

[finish_content][ntext]COLLATEChinese_PRC_CI_ASNULL,

[users][int]NULL,

[pass_manager][int]NULL,

[pass_time][datetime]NULL,

[over_manager][int]NULL,

[over_time][datetime]NULL,

[over_contet][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[over_score][int]NULL,

[system_overivew][ntext]COLLATEChinese_PRC_CI_ASNULL,

[actions][int]NULL,

[actions1][int]NULL,

[actions2][int]NULL,

[actions3][int]NULL,

[istop][int]NULL,

[username][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_arguelist](

[id][int]IDENTITY(1,1)NOTNULL,

[argueid][int]NULL,

[userid][int]NULL,

[author][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[content][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[action][int]NULL,

[addtime][datetime]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[rejoin][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_blogstar](

[ID][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[userurl][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[picurl][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[info][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[blogname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[ispass][int]NULL,

[username][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[usernickname][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_blogteam](

[ID][int]IDENTITY(1,1)NOTNULL,

[mainuserid][int]NULL,

[otheruserid][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_calendar](

[ID][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[calendar_month][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_comment](

[commentid][int]IDENTITY(1,1)NOTNULL,

[mainid][int]NULL,

[comment][ntext]COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[comment_user][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[commenttopic][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[userid][int]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[homepage][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isguest][int]NULL,

[iState][int]NULL,

[ubbedit][int]NULL,

[isdel][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_config](

[id][int]NOTNULL,

[ob_value][ntext]COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_digg](

[did][int]IDENTITY(1,1)NOTNULL,

[userID][int]NULL,

[diggid][int]NULL,

[addtime][smalldatetime]NULL,

[logid][int]NULL,

[addip][varchar](50)COLLATEChinese_PRC_CI_ASNULL,

[isguest][int]NULL,

[authorid][int]NULL,

[username][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[diggtype][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_friend](

[id][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[friendid][int]NULL,

[addtime][datetime]NULL,

[isblack][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_friendurl](

[urlid][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[urlname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[ordernum][int]NULL,

[urlType][int]NULL,

[url][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[logo][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_groups](

[groupid][int]IDENTITY(1,1)NOTNULL,

[g_name][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_level][int]NULL,

[g_points][int]NULL,

[g_autoupdate][int]NULL,

[g_style][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_seconddomain][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_domain][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_obcodes][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_classes][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_post_day][int]NULL,

[g_post_chk][int]NULL,

[g_post_script][int]NULL,

[g_skins][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_skin_edit][int]NULL,

[g_skin_script][int]NULL,

[g_qq_number][int]NULL,

[g_mod_address][int]NULL,

[g_mod_zhai][int]NULL,

[g_mod_argue][int]NULL,

[g_mod_note][int]NULL,

[g_mod_meet][int]NULL,

[g_up_types][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[g_up_size][int]NULL,

[g_up_space][int]NULL,

[g_up_watermark][int]NULL,

[g_is_password][int]NULL,

[g_pm_numbers][int]NULL,

[g_ad_sys][int]NULL,

[g_ad_user][int]NULL,

[g_members][int]NULL,

[is_code_addblog][int]NULL,

[oneday_update][int]NULL,

[in_group][int]NULL,

[g_mailpost][int]NULL,

[g_download][int]NULL,

[g_getpwd][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_log](

[logid][int]IDENTITY(1,1)NOTNULL,

[topic][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[logtext][ntext]COLLATEChinese_PRC_CI_ASNULL,

[userid][int]NULL,

[authorid][int]NULL,

[author][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[truetime][datetime]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[iis][int]NULL,

[face][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[commentnum][int]NULL,

[classid][int]NULL,

[subjectid][int]NULL,

[showword][int]NULL,

[ishide][int]NULL,

[ispassword][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[trackbacknum][int]NULL,

[passcheck][int]NULL,

[istop][int]NULL,

[isbest][int]NULL,

[isencomment][int]NULL,

[blog_password][int]NULL,

[tbUrl][ntext]COLLATEChinese_PRC_CI_ASNULL,

[logfile][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isdraft][int]NULL,

[issave][int]NULL,

[subjectfile][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[logTags][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[logTagsId][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[logType][int]NULL,

[Abstract][ntext]COLLATEChinese_PRC_CI_ASNULL,

[Abstract_auto][int]NULL,

[EditorType][int]NULL,

[filename][nvarchar](30)COLLATEChinese_PRC_CI_ASNULL,

[logPics][ntext]COLLATEChinese_PRC_CI_ASNULL,

[specialid][int]NULL,

[scores][int]NULL,

[vote0][int]NULL,

[vote1][int]NULL,

[isTrouble][int]NULL,

[isdel][int]NULL,

[isNeedLogin][int]NULL,

[ViewScores][int]NULL,

[IsSpecial][int]NULL,

[diggNum][int]NULL,

[ViewGroupId][int]NULL,

[is_log_default_hidden][int]NULL,

[tbcode][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_logclass](

[classid][int]IDENTITY(1,1)NOTNULL,

[id][int]NULL,

[classname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[classlognum][int]NULL,

[ordernum][int]NULL,

[orderid][int]NULL,

[parentid][int]NULL,

[parentpath][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[depth][int]NULL,

[rootid][int]NULL,

[child][int]NULL,

[readme][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[previd][int]NULL,

[nextid][int]NULL,

[idType][int]NOTNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_logvotes](

[id][int]IDENTITY(1,1)NOTNULL,

[logid][int]NULL,

[vote][int]NULL,

[userid][int]NULL,

[addtime][datetime]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_message](

[messageid][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[messagetopic][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[message][ntext]COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[message_user][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[homepage][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isguest][int]NULL,

[issave][int]NULL,

[messagefile][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[iState][int]NULL,

[ubbedit][int]NULL,

[isdel][int]NULL,

[ishide][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_myurl](

[id][int]IDENTITY(1,1)NOTNULL,

[urlid][int]NULL,

[userid][int]NULL,

[classid][int]NULL,

[subjectid][int]NULL,

[tags][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[memo][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isprivate][int]NULL,

[addtime][datetime]NULL,

[encodeing][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[url][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[title][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isupdate][int]NULL,

[mainuserid][int]NULL,

[lastupdatetime][datetime]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_notdownload](

[notdown][binary](1)NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_obcodes](

[obcode][nvarchar](32)COLLATEChinese_PRC_CI_ASNOTNULL,

[creatuser][int]NULL,

[useuser][int]NULL,

[iType][int]NULL,

[iState][int]NULL,

[CreateTime][datetime]NULL,

[UseTime][datetime]NULL,

[CreatIp][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[UseIp][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_pm](

[id][int]IDENTITY(1,1)NOTNULL,

[sender][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[incept][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[topic][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,

[content][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isreaded][int]NULL,

[addtime][datetime]NULL,

[delR][int]NOTNULL,

[delS][int]NOTNULL,

[isguest][int]NULL,

[pid][int]NULL,

[isSys][int]NULL,

[groups][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[readers][ntext]COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_roles](

[roleid][int]IDENTITY(1,1)NOTNULL,

[r_name][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,

[r_skin_sys][int]NULL,

[r_skin_qq][int]NULL,

[r_skin_user][int]NULL,

[r_groups][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[r_classes1][ntext]COLLATEChinese_PRC_CI_ASNULL,

[r_classes2][ntext]COLLATEChinese_PRC_CI_ASNULL,

[r_user_reg][int]NULL,

[r_user_name][int]NULL,

[r_user_admin][int]NULL,

[r_user_group][int]NULL,

[r_user_update][int]NULL,

[r_user_news][int]NULL,

[r_second_domain][int]NULL,

[r_mod_script][int]NULL,

[r_mod_argue][int]NULL,

[r_mod_meet][int]NULL,

[r_mod_special][int]NULL,

[r_site_news][int]NULL,

[r_blogstar][int]NULL,

[r_words][int]NULL,

[r_IP][int]NULL,

[r_site_count][int]NULL,

[r_user_blog][int]NULL,

[r_user_rblog][int]NULL,

[r_user_cmt][int]NULL,

[r_user_msg][int]NULL,

[r_user_tag][int]NULL,

[r_group_user][int]NULL,

[r_group_blog][int]NULL,

[r_user_upfiles][int]NULL,

[r_list_upfiles][int]NULL,

[r_user_all][int]NULL,

[r_user_add][int]NULL,

[r_album_comment][int]NULL,

[r_user_digg][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_setup](

[ID][int]IDENTITY(1,1)NOTNULL,

[log_count][int]NULL,

[comment_count][int]NULL,

[message_count][int]NULL,

[user_count][int]NULL,

[site_placard][ntext]COLLATEChinese_PRC_CI_ASNULL,

[site_friends][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_placard][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_dir][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[reg_text][ntext]COLLATEChinese_PRC_CI_ASNULL,

[log_count_Yesterday][int]NULL,

[log_Yesterday][smalldatetime]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_skinclass](

[classid][int]IDENTITY(1,1)NOTNULL,

[classname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[iCount][int]NULL,

[iType][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_subject](

[subjectid][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[subjectname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[subjectlognum][int]NULL,

[ordernum][int]NULL,

[subjectType][int]NULL,

[ishide][int]NULL,

[addtime][smalldatetime]NULL,

[views][int]NULL,

[photo_path][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_syslog](

[id][int]IDENTITY(1,1)NOTNULL,

[username][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[addip][nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[desc][ntext]COLLATEChinese_PRC_CI_ASNULL,

[itype][int]NULL,

[QueryStrings][text]COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_sysskin](

[id][int]IDENTITY(1,1)NOTNULL,

[sysskinname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[skinMain][ntext]COLLATEChinese_PRC_CI_ASNULL,

[skinShowlog][ntext]COLLATEChinese_PRC_CI_ASNULL,

[skinauthor][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[isdefault][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_tags](

[TagId][int]IDENTITY(1,1)NOTNULL,

[Name][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[iClass][int]NULL,

[iNum][int]NULL,

[iType][int]NULL,

[iState][int]NULL,

[LastUpdate][datetime]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_team](

[teamid][int]IDENTITY(1,1)NOTNULL,

[t_name][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[t_ico][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[t_links][ntext]COLLATEChinese_PRC_CI_ASNULL,

[t_tags][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[createtime][datetime]NULL,

[createrid][int]NULL,

[creatername][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[managerid][int]NULL,

[managername][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[lastupdatetime][datetime]NULL,

[intro][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[defaultskin][int]NULL,

[isbest][int]NULL,

[istate][int]NULL,

[announce][ntext]COLLATEChinese_PRC_CI_ASNULL,

[totalvisit][int]NULL,

[links][ntext]COLLATEChinese_PRC_CI_ASNULL,

[

teamscore][int]NULL,

[icount0][int]NULL,

[icount1][int]NULL,

[icount2][int]NULL,

[joinlimit][int]NULL,

[joinscores][int]NULL,

[otherpost][int]NULL,

[isdel][int]NULL,

[classid][int]NULL,

[t_domain][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[t_domainroot][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[viewpassword][varchar](50)COLLATEChinese_PRC_CI_ASNULL,

[hideurl][int]NULL,

[viewlimit][int]NULL,

[user_skin_main][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_skin_showlog][ntext]COLLATEChinese_PRC_CI_ASNULL,

[bak_skin1][ntext]COLLATEChinese_PRC_CI_ASNULL,

[bak_skin2][ntext]COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_teampost](

[postid][int]IDENTITY(1,1)NOTNULL,

[parentid][int]NULL,

[idepth][int]NULL,

[teamid][int]NOTNULL,

[logid][int]NULL,

[userid][int]NULL,

[author][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,

[email][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[url][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[topic][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[content][ntext]COLLATEChinese_PRC_CI_ASNULL,

[istop][int]NULL,

[isbest][int]NULL,

[ispass][int]NULL,

[subjectid][int]NULL,

[addtime][datetime]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[lastupdate][datetime]NULL,

[views][int]NULL,

[replys][int]NULL,

[scores][int]NULL,

[tags][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[user_ico][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[isdel][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_teamskin](

[userskinname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[skinmain][ntext]COLLATEChinese_PRC_CI_ASNULL,

[skinshowlog][ntext]COLLATEChinese_PRC_CI_ASNULL,

[skinauthor][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[skinauthorurl][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isdefault][int]NULL,

[skinpic][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[ispass][int]NULL,

[classid][int]NULL,

[id][int]IDENTITY(1,1)NOTNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_teamusers](

[ID][int]IDENTITY(1,1)NOTNULL,

[teamid][int]NULL,

[userid][int]NULL,

[state][int]NULL,

[info][nvarchar](200)COLLATEChinese_PRC_CI_ASNULL,

[icount][int]NULL,

[addtime][datetime]NULL,

[post_all][int]NULL,

[post_logs][int]NULL,

[post_posts][int]NULL,

[post_replys][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_trackback](

[ID][int]IDENTITY(1,1)NOTNULL,

[blog_name][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[userid][int]NULL,

[logid][int]NULL,

[topic][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[tbuser][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[addtime][datetime]NULL,

[Excerpt][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[url][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[tb_url][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[IP][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[VisitorUrl][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_upfile](

[fileid][int]IDENTITY(1,1)NOTNULL,

[userid][int]NULL,

[logid][int]NULL,

[file_name][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[file_path][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[file_ext][nvarchar](10)COLLATEChinese_PRC_CI_ASNULL,

[file_size][int]NULL,

[file_readme][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[isphoto][smallint]NULL,

[addtime][datetime]NULL,

[file_remark][ntext]COLLATEChinese_PRC_CI_ASNULL,

[issave][int]NULL,

[isPower][int]NULL,

[photofile][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[photoExif][ntext]COLLATEChinese_PRC_CI_ASNULL,

[sysClassId][int]NULL,

[userClassId][int]NULL,

[photo_width][int]NULL,

[photo_height][int]NULL,

[viewNum][int]NULL,

[isdel][int]NULL,

[isBigHead][int]NULL,

[file_showname][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[filetype][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_url](

[urlid][int]IDENTITY(1,1)NOTNULL,

[url][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[title][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,

[icount][int]NULL,

[vcount][int]NULL,

[lasttime][datetime]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_user](

[userid][int]IDENTITY(1,1)NOTNULL,

[username][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_domain][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_domainroot][nvarchar](20)COLLATEChinese_PRC_CI_ASNULL,

[user_dir][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_folder][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[useremail][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,

[password][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[nickname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[truename][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[sex][int]NULL,

[adddate][datetime]NULL,

[province][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[city][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[address][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[qq][nvarchar](26)COLLATEChinese_PRC_CI_ASNULL,

[tel][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,

[lastloginip][nvarchar](26)COLLATEChinese_PRC_CI_ASNULL,

[lastlogintime][datetime]NULL,

[logintimes][int]NULL,

[lockuser][int]NULL,

[blogname][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[birthday][datetime]NULL,

[question][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[answer][nvarchar](65)COLLATEChinese_PRC_CI_ASNULL,

[msn][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[homepage][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[job][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_isbest][int]NULL,

[siteinfo][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[custom_domain][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_skin_main][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_skin_showlog][ntext]COLLATEChinese_PRC_CI_ASNULL,

[default_skin][int]NULL,

[log_count][int]NULL,

[user_level][int]NULL,

[user_placard][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_links][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_showlog_num][int]NULL,

[hideurl][int]NULL,

[user_shownewlog_num][int]NULL,

[user_shownewcomment_num][int]NULL,

[user_shownewmessage_num][int]NULL,

[user_siterefu_num][int]NULL,

[comment_count][int]NULL,

[message_count][int]NULL,

[blog_password][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_upfiles_max][int]NULL,

[user_classid][int]NULL,

[user_upfiles_size][int]NULL,

[user_upfiles_num][int]NULL,

[user_showlogword_num][int]NULL,

[en_blogteam][int]NULL,

[comment_isasc][int]NULL,

[defaultskin][int]NULL,

[bak_skin1][ntext]COLLATEChinese_PRC_CI_ASNULL,

[bak_skin2][ntext]COLLATEChinese_PRC_CI_ASNULL,

[isubbedit][int]NULL,

[vipdate][datetime]NULL,

[user_icon1][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[user_icon2][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[user_info][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_css][ntext]COLLATEChinese_PRC_CI_ASNULL,

[user_cookie][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[user_photorow_num][int]NULL,

[regip][nvarchar](26)COLLATEChinese_PRC_CI_ASNULL,

[newbie][int]NULL,

[user_group][int]NULL,

[scores][int]NULL,

[roleid][int]NULL,

[lastcomment][datetime]NULL,

[lastmessage][datetime]NULL,

[lastlogin][datetime]NULL,

[lastcode][datetime]NULL,

[emailValid][int]NULL,

[isTrouble][int]NULL,

[sub_num][int]NULL,

[isdel][int]NULL,

[indexlist][int]NULL,

[TruePassword][nvarchar](65)COLLATEChinese_PRC_CI_ASNULL,

[passport_email][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[passport_password][varchar](50)COLLATEChinese_PRC_CI_ASNULL,

[PlayerType][int]NULL,

[passport_userid][int]NULL,

[updateblognum][int]NULL,

[diggs][int]NULL,

[isdigg][int]NULL,

[updateblogDate][smalldatetime]NULL,

[is_log_default_hidden][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_userclass](

[classid][int]IDENTITY(1,1)NOTNULL,

[id][int]NULL,

[classname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[classlognum][int]NULL,

[ordernum][int]NULL,

[orderid][int]NULL,

[parentid][int]NULL,

[parentpath][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[depth][int]NULL,

[rootid][int]NULL,

[child][int]NULL,

[readme][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[previd][int]NULL,

[nextid][int]NULL,

[idType][int]NOTNULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_userdigg](

[diggID][int]IDENTITY(1,1)NOTNULL,

[diggtitle][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[diggurl][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[diggnum][int]NULL,

[diggdes][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[authorid][int]NULL,

[classid][int]NULL,

[addtime][smalldatetime]NULL,

[logid][int]NULL,

[author][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[lastdiggtime][smalldatetime]NULL,

[addip][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[iState][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_userdir](

[ID][int]IDENTITY(1,1)NOTNULL,

[userdir][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[dirdomain][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[is_default][int]NULL

)ON[PRIMARY]

GO

CREATETABLE[dbo].[oblog_userskin](

[id][int]IDENTITY(1,1)NOTNULL,

[userskinname][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[skinmain][ntext]COLLATEChinese_PRC_CI_ASNULL,

[skinshowlog][ntext]COLLATEChinese_PRC_CI_ASNULL,

[skinauthor][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,

[skinauthorurl][nvarchar](255)COLLATEChinese_PRC_CI_ASNULL,

[isdefault][int]NULL,

[skinpic][nvarchar](250)COLLATEChinese_PRC_CI_ASNULL,

[ispass][int]NULL,

[classid][int]NULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

GO

ALTERTABLE[dbo].[Oblog_Verifiydata]WITHNOCHECKADD

CONSTRAINT[PK_Oblog_Verifiydata]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oBlog_usertags]WITHNOCHECKADD

CONSTRAINT[PK_oBlog_usertags]PRIMARYKEYCLUSTERED

(

[UserTagid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_Album]WITHNOCHECKADD

CONSTRAINT[PK_oblog_Album]PRIMARYKEYCLUSTERED

(

[photoID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_AlbumComment]WITHNOCHECKADD

CONSTRAINT[PK_oblog_AlbumComment]PRIMARYKEYCLUSTERED

(

[commentid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_Special]WITHNOCHECKADD

CONSTRAINT[PK_oblog_Special]PRIMARYKEYCLUSTERED

(

[specialid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_admin]WITHNOCHECKADD

CONSTRAINT[PK_oblog_admin]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_argue]WITHNOCHECKADD

CONSTRAINT[PK_oblog_argue]PRIMARYKEYCLUSTERED

(

[argueid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_arguelist]WITHNOCHECKADD

CONSTRAINT[PK_oblog_arguelist]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_blogstar]WITHNOCHECKADD

CONSTRAINT[PK_oblog_blogstar]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_blogteam]WITHNOCHECKADD

CONSTRAINT[PK_oblog_blogteam]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_calendar]WITHNOCHECKADD

CONSTRAINT[PK_oblog_calendar]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_comment]WITHNOCHECKADD

CONSTRAINT[PK_oblog_comment]PRIMARYKEYCLUSTERED

(

[commentid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_config]WITHNOCHECKADD

CONSTRAINT[PK_oblog_config]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_digg]WITHNOCHECKADD

CONSTRAINT[PK_oblog_digg]PRIMARYKEYCLUSTERED

(

[did]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_friend]WITHNOCHECKADD

CONSTRAINT[PK_oblog_friend]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_friendurl]WITHNOCHECKADD

CONSTRAINT[PK_oblog_friendurl]PRIMARYKEYCLUSTERED

(

[urlid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_log]WITHNOCHECKADD

CONSTRAINT[PK_oblog_log]PRIMARYKEYCLUSTERED

(

[logid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_logclass]WITHNOCHECKADD

CONSTRAINT[PK_oblog_logclass]PRIMARYKEYCLUSTERED

(

[classid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_logvotes]WITHNOCHECKADD

CONSTRAINT[PK_oblog_logvotes]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_obcodes]WITHNOCHECKADD

CONSTRAINT[PK_oblog_obcodes]PRIMARYKEYCLUSTERED

(

[obcode]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_pm]WITHNOCHECKADD

CONSTRAINT[PK_oblog_pm]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_roles]WITHNOCHECKADD

CONSTRAINT[PK_oblog_roles]PRIMARYKEYCLUSTERED

(

[roleid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_setup]WITHNOCHECKADD

CONSTRAINT[PK_oblog_setup]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_skinclass]WITHNOCHECKADD

CONSTRAINT[PK_oblog_skinclass]PRIMARYKEYCLUSTERED

(

[classid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_subject]WITHNOCHECKADD

CONSTRAINT[PK_oblog_subject]PRIMARYKEYCLUSTERED

(

[subjectid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_syslog]WITHNOCHECKADD

CONSTRAINT[PK_oblog_syslog]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_tags]WITHNOCHECKADD

CONSTRAINT[PK_oblog_tags]PRIMARYKEYCLUSTERED

(

[TagId]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_team]WITHNOCHECKADD

CONSTRAINT[PK_oblog_team]PRIMARYKEYCLUSTERED

(

[teamid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_teampost]WITHNOCHECKADD

CONSTRAINT[PK_oblog_teampost]PRIMARYKEYCLUSTERED

(

[postid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_teamskin]WITHNOCHECKADD

CONSTRAINT[PK_oblog_teamskin]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_teamusers]WITHNOCHECKADD

CONSTRAINT[PK_oblog_teamusers]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_trackback]WITHNOCHECKADD

CONSTRAINT[PK_oblog_trackback]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_upfile]WITHNOCHECKADD

CONSTRAINT[PK_oblog_upfile]PRIMARYKEYCLUSTERED

(

[fileid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_url]WITHNOCHECKADD

CONSTRAINT[PK_oblog_url]PRIMARYKEYCLUSTERED

(

[urlid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_user]WITHNOCHECKADD

CONSTRAINT[PK_oblog_user]PRIMARYKEYCLUSTERED

(

[userid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userclass]WITHNOCHECKADD

CONSTRAINT[PK_oblog_userclass]PRIMARYKEYCLUSTERED

(

[classid]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userdigg]WITHNOCHECKADD

CONSTRAINT[PK_oblog_userdigg]PRIMARYKEYCLUSTERED

(

[diggID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userdir]WITHNOCHECKADD

CONSTRAINT[PK_oblog_userdir]PRIMARYKEYCLUSTERED

(

[ID]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userskin]WITHNOCHECKADD

CONSTRAINT[PK_oblog_userskin]PRIMARYKEYCLUSTERED

(

[id]

)ON[PRIMARY]

GO

ALTERTABLE[dbo].[Oblog_Verifiydata]ADD

CONSTRAINT[DF__Oblog_Ver__addti__2E70E1FD]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__Oblog_Verif__isP__2F650636]DEFAULT(0)FOR[isP]

GO

ALTERTABLE[dbo].[oBlog_usertags]ADD

CONSTRAINT[DF__oBlog_use__TagId__1209AD79]DEFAULT(0)FOR[TagId],

CONSTRAINT[DF__oBlog_use__Useri__12FDD1B2]DEFAULT(0)FOR[Userid],

CONSTRAINT[DF__oBlog_use__logid__13F1F5EB]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oBlog_user__iNum__14E61A24]DEFAULT(0)FOR[iNum]

GO

CREATEINDEX[Index_usertags_logId]ON[dbo].[oBlog_usertags]([logid])ON[PRIMARY]

GO

CREATEINDEX[Index_usertags_tagid]ON[dbo].[oBlog_usertags]([TagId])ON[PRIMARY]

GO

CREATEINDEX[Index_usertags_UserId]ON[dbo].[oBlog_usertags]([Userid])ON[PRIMARY]

GO

CREATEINDEX[iNum]ON[dbo].[oBlog_usertags]([iNum])ON[PRIMARY]

GO

CREATEINDEX[logid]ON[dbo].[oBlog_usertags]([logid])ON[PRIMARY]

GO

CREATEINDEX[TagId]ON[dbo].[oBlog_usertags]([TagId])ON[PRIMARY]

GO

CREATEINDEX[Userid]ON[dbo].[oBlog_usertags]([Userid])ON[PRIMARY]

GO

CREATEINDEX[UserTagid]ON[dbo].[oBlog_usertags]([UserTagid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_Album]ADD

CONSTRAINT[DF__oblog_Alb__userI__3CF40B7E]DEFAULT(0)FOR[userID],

CONSTRAINT[DF__oblog_Alb__photo__3DE82FB7]DEFAULT(0)FOR[photo_size],

CONSTRAINT[DF__oblog_Alb__TeamI__3EDC53F0]DEFAULT(0)FOR[TeamID],

CONSTRAINT[DF__oblog_Alb__isBig__3FD07829]DEFAULT(0)FOR[isBigHead],

CONSTRAINT[DF__oblog_Alb__isHid__40C49C62]DEFAULT(0)FOR[isHide],

CONSTRAINT[DF__oblog_Alb__sysCl__41B8C09B]DEFAULT(0)FOR[sysClassId],

CONSTRAINT[DF__oblog_Alb__userC__42ACE4D4]DEFAULT(0)FOR[userClassId],

CONSTRAINT[DF__oblog_Alb__photo__43A1090D]DEFAULT(0)FOR[photo_width],

CONSTRAINT[DF__oblog_Alb__photo__44952D46]DEFAULT(0)FOR[photo_height],

CONSTRAINT[DF__oblog_Alb__addti__4589517F]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_Alb__fileI__467D75B8]DEFAULT(0)FOR[fileID],

CONSTRAINT[DF__oblog_Alb__comme__477199F1]DEFAULT(0)FOR[commentnum],

CONSTRAINT[DF__oblog_Alb__isenc__4865BE2A]DEFAULT(0)FOR[isencomment],

CONSTRAINT[DF__oblog_Alb__views__4959E263]DEFAULT(0)FOR[views],

CONSTRAINT[DF__oblog_Alb__Is_Al__324172E1]DEFAULT(0)FOR[Is_Album_default]

GO

CREATEINDEX[Index_Album_userID]ON[dbo].[oblog_Album]([userID])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_TeamID]ON[dbo].[oblog_Album]([TeamID])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_sysClassId]ON[dbo].[oblog_Album]([sysClassId])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_userClassId]ON[dbo].[oblog_Album]([userClassId])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_fileID]ON[dbo].[oblog_Album]([fileID])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_commentnum]ON[dbo].[oblog_Album]([commentnum])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_isencomment]ON[dbo].[oblog_Album]([isencomment])ON[PRIMARY]

GO

CREATEINDEX[Index_Album_views]ON[dbo].[oblog_Album]([views])ON[PRIMARY]

GO

CREATEINDEX[Index_log_Is_Album_default]ON[dbo].[oblog_Album]([Is_Album_default])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_AlbumComment]ADD

CONSTRAINT[DF__oblog_Alb__maini__4D2A7347]DEFAULT(0)FOR[mainid],

CONSTRAINT[DF__oblog_Alb__addti__4E1E9780]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_Alb__useri__4F12BBB9]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_Alb__isgue__5006DFF2]DEFAULT(0)FOR[isguest],

CONSTRAINT[DF__oblog_Alb__iStat__50FB042B]DEFAULT(0)FOR[iState],

CONSTRAINT[DF__oblog_Alb__isdel__51EF2864]DEFAULT(0)FOR[isdel],

CONSTRAINT[DF__oblog_Alb__teami__4B422AD5]DEFAULT(0)FOR[teamid]

GO

CREATEINDEX[Index_AlbumComment_mainid]ON[dbo].[oblog_AlbumComment]([mainid])ON[PRIMARY]

GO

CREATEINDEX[Index_AlbumComment_userid]ON[dbo].[oblog_AlbumComment]([userid])ON[PRIMARY]

GO

CREATEINDEX[Index_AlbumComment_teamid]ON[dbo].[oblog_AlbumComment]([teamid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_Special]ADD

CONSTRAINT[DF__oblog_Spe__s_cou__1DB06A4F]DEFAULT(0)FOR[s_count],

CONSTRAINT[DF__oblog_Spe__isAct__1EA48E88]DEFAULT(0)FOR[isActive]

GO

ALTERTABLE[dbo].[oblog_SpecialList]ADD

CONSTRAINT[DF__oblog_Spe__Speci__208CD6FA]DEFAULT(0)FOR[SpecialId],

CONSTRAINT[DF__oblog_Spe__UserI__2180FB33]DEFAULT(0)FOR[UserId],

CONSTRAINT[DF__oblog_Spe__logid__22751F6C]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_Spe__ispas__236943A5]DEFAULT(0)FOR[ispass],

CONSTRAINT[DF__oblog_Spe__istop__245D67DE]DEFAULT(0)FOR[istop]

GO

ALTERTABLE[dbo].[oblog_admin]ADD

CONSTRAINT[DF__oblog_adm__login__76CBA758]DEFAULT(0)FOR[logintimes],

CONSTRAINT[DF__oblog_adm__rolei__77BFCB91]DEFAULT((-1))FOR[roleid],

CONSTRAINT[DF__oblog_adm__useri__78B3EFCA]DEFAULT(0)FOR[userid]

GO

CREATEINDEX[id]ON[dbo].[oblog_admin]([id])ON[PRIMARY]

GO

CREATEINDEX[pid]ON[dbo].[oblog_admin]([username])ON[PRIMARY]

GO

CREATEINDEX[roleid]ON[dbo].[oblog_admin]([roleid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_argue]ADD

CONSTRAINT[DF__oblog_arg__useri__7A9C383C]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_arg__idays__7B905C75]DEFAULT(0)FOR[idays],

CONSTRAINT[DF__oblog_arg__istat__7C8480AE]DEFAULT(0)FOR[istate],

CONSTRAINT[DF__oblog_arg__users__7D78A4E7]DEFAULT(0)FOR[users],

CONSTRAINT[DF__oblog_arg__pass___7E6CC920]DEFAULT(0)FOR[pass_manager],

CONSTRAINT[DF__oblog_arg__over___7F60ED59]DEFAULT(0)FOR[over_manager],

CONSTRAINT[DF__oblog_arg__over___00551192]DEFAULT(0)FOR[over_score],

CONSTRAINT[DF__oblog_arg__actio__014935CB]DEFAULT(0)FOR[actions],

CONSTRAINT[DF__oblog_arg__actio__023D5A04]DEFAULT(0)FOR[actions1],

CONSTRAINT[DF__oblog_arg__actio__03317E3D]DEFAULT(0)FOR[actions2],

CONSTRAINT[DF__oblog_arg__actio__0425A276]DEFAULT(0)FOR[actions3],

CONSTRAINT[DF__oblog_arg__istop__0519C6AF]DEFAULT(0)FOR[istop]

GO

CREATEINDEX[argueid]ON[dbo].[oblog_argue]([argueid])ON[PRIMARY]

GO

CREATEINDEX[idays]ON[dbo].[oblog_argue]([idays])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_argue]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_arguelist]ADD

CONSTRAINT[DF__oblog_arg__argue__07020F21]DEFAULT(0)FOR[argueid],

CONSTRAINT[DF__oblog_arg__useri__07F6335A]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_arg__actio__08EA5793]DEFAULT(0)FOR[action],

CONSTRAINT[DF__oblog_arg__rejoi__09DE7BCC]DEFAULT(0)FOR[rejoin]

GO

CREATEINDEX[argueid]ON[dbo].[oblog_arguelist]([argueid])ON[PRIMARY]

GO

CREATEINDEX[id]ON[dbo].[oblog_arguelist]([id])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_arguelist]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_blogstar]ADD

CONSTRAINT[DF__oblog_blo__useri__0BC6C43E]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_blo__addti__0CBAE877]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_blo__ispas__0DAF0CB0]DEFAULT(0)FOR[ispass]

GO

CREATEINDEX[ispass]ON[dbo].[oblog_blogstar]([ispass])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_blogteam]ADD

CONSTRAINT[DF__oblog_blo__mainu__0F975522]DEFAULT(0)FOR[mainuserid],

CONSTRAINT[DF__oblog_blo__other__108B795B]DEFAULT(0)FOR[otheruserid]

GO

CREATEINDEX[mainuserid]ON[dbo].[oblog_blogteam]([mainuserid])ON[PRIMARY]

GO

CREATEINDEX[otheruserid]ON[dbo].[oblog_blogteam]([otheruserid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_calendar]ADD

CONSTRAINT[DF__oblog_cal__useri__1273C1CD]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_cal__calen__1367E606]DEFAULT(0)FOR[calendar_month]

GO

CREATEINDEX[userid]ON[dbo].[oblog_calendar]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_comment]ADD

CONSTRAINT[DF__oblog_com__maini__15502E78]DEFAULT(0)FOR[mainid],

CONSTRAINT[DF__oblog_com__useri__164452B1]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_com__isgue__173876EA]DEFAULT(0)FOR[isguest],

CONSTRAINT[DF__oblog_com__iStat__182C9B23]DEFAULT(0)FOR[iState],

CONSTRAINT[DF__oblog_com__ubbed__1920BF5C]DEFAULT(0)FOR[ubbedit],

CONSTRAINT[DF__oblog_com__isdel__1A14E395]DEFAULT(0)FOR[isdel]

GO

CREATEINDEX[commentid]ON[dbo].[oblog_comment]([commentid])ON[PRIMARY]

GO

CREATEINDEX[mainid]ON[dbo].[oblog_comment]([mainid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_comment]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_config]ADD

CONSTRAINT[DF__oblog_config__id__1BFD2C07]DEFAULT(0)FOR[id]

GO

CREATEINDEX[id]ON[dbo].[oblog_config]([id])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_digg]ADD

CONSTRAINT[DF__oblog_dig__userI__54CB950F]DEFAULT(0)FOR[userID],

CONSTRAINT[DF__oblog_dig__diggi__55BFB948]DEFAULT(0)FOR[diggid],

CONSTRAINT[DF__oblog_dig__addti__56B3DD81]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_dig__logid__57A801BA]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_dig__isgue__589C25F3]DEFAULT(0)FOR[isguest],

CONSTRAINT[DF__oblog_dig__autho__59904A2C]DEFAULT(0)FOR[authorid],

CONSTRAINT[DF__oblog_dig__diggt__5A846E65]DEFAULT((-1))FOR[diggtype]

GO

CREATEINDEX[Index_digg_userID]ON[dbo].[oblog_digg]([userID])ON[PRIMARY]

GO

CREATEINDEX[Index_digg_diggid]ON[dbo].[oblog_digg]([diggid])ON[PRIMARY]

GO

CREATEINDEX[Index_digg_logid]ON[dbo].[oblog_digg]([logid])ON[PRIMARY]

GO

CREATEINDEX[Index_digg_authorid]ON[dbo].[oblog_digg]([authorid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_friend]ADD

CONSTRAINT[DF__oblog_fri__useri__1DE57479]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_fri__frien__1ED998B2]DEFAULT(0)FOR[friendid],

CONSTRAINT[DF__oblog_fri__addti__1FCDBCEB]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_fri__isbla__20C1E124]DEFAULT(0)FOR[isblack]

GO

CREATEINDEX[firendid]ON[dbo].[oblog_friend]([id])ON[PRIMARY]

GO

CREATEINDEX[friendid]ON[dbo].[oblog_friend]([friendid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_friend]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_friendurl]ADD

CONSTRAINT[DF__oblog_fri__useri__22AA2996]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_fri__order__239E4DCF]DEFAULT(0)FOR[ordernum],

CONSTRAINT[DF__oblog_fri__urlTy__24927208]DEFAULT(0)FOR[urlType]

GO

CREATEINDEX[ordernum]ON[dbo].[oblog_friendurl]([ordernum])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_friendurl]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_groups]ADD

CONSTRAINT[DF__oblog_gro__g_lev__267ABA7A]DEFAULT(0)FOR[g_level],

CONSTRAINT[DF__oblog_gro__g_poi__276EDEB3]DEFAULT(0)FOR[g_points],

CONSTRAINT[DF__oblog_gro__g_aut__286302EC]DEFAULT(0)FOR[g_autoupdate],

CONSTRAINT[DF__oblog_gro__g_pos__29572725]DEFAULT(0)FOR[g_post_day],

CONSTRAINT[DF__oblog_gro__g_pos__2A4B4B5E]DEFAULT(0)FOR[g_post_chk],

CONSTRAINT[DF__oblog_gro__g_pos__2B3F6F97]DEFAULT(0)FOR[g_post_script],

CONSTRAINT[DF__oblog_gro__g_ski__2C3393D0]DEFAULT(0)FOR[g_skin_edit],

CONSTRAINT[DF__oblog_gro__g_ski__2D27B809]DEFAULT(0)FOR[g_skin_script],

CONSTRAINT[DF__oblog_gro__g_qq___2E1BDC42]DEFAULT(0)FOR[g_qq_number],

CONSTRAINT[DF__oblog_gro__g_mod__2F10007B]DEFAULT(0)FOR[g_mod_address],

CONSTRAINT[DF__oblog_gro__g_mod__300424B4]DEFAULT(0)FOR[g_mod_zhai],

CONSTRAINT[DF__oblog_gro__g_mod__30F848ED]DEFAULT(0)FOR[g_mod_argue],

CONSTRAINT[DF__oblog_gro__g_mod__31EC6D26]DEFAULT(0)FOR[g_mod_note],

CONSTRAINT[DF__oblog_gro__g_mod__32E0915F]DEFAULT(0)FOR[g_mod_meet],

CONSTRAINT[DF__oblog_gro__g_up___33D4B598]DEFAULT(0)FOR[g_up_size],

CONSTRAINT[DF__oblog_gro__g_up___34C8D9D1]DEFAULT(0)FOR[g_up_space],

CONSTRAINT[DF__oblog_gro__g_up___35BCFE0A]DEFAULT(0)FOR[g_up_watermark],

CONSTRAINT[DF__oblog_gro__g_is___36B12243]DEFAULT(0)FOR[g_is_password],

CONSTRAINT[DF__oblog_gro__g_pm___37A5467C]DEFAULT(0)FOR[g_pm_numbers],

CONSTRAINT[DF__oblog_gro__g_ad___38996AB5]DEFAULT(0)FOR[g_ad_sys],

CONSTRAINT[DF__oblog_gro__g_ad___398D8EEE]DEFAULT(0)FOR[g_ad_user],

CONSTRAINT[DF__oblog_gro__g_mem__3A81B327]DEFAULT(0)FOR[g_members],

CONSTRAINT[DF__oblog_gro__is_co__3B75D760]DEFAULT(0)FOR[is_code_addblog],

CONSTRAINT[DF__oblog_gro__oneda__3C69FB99]DEFAULT(0)FOR[oneday_update],

CONSTRAINT[DF__oblog_gro__in_gr__3D5E1FD2]DEFAULT(0)FOR[in_group],

CONSTRAINT[DF__oblog_gro__g_mai__68D28DBC]DEFAULT(0)FOR[g_mailpost],

CONSTRAINT[DF__oblog_gro__g_dow__69C6B1F5]DEFAULT(0)FOR[g_download],

CONSTRAINT[DF__oblog_gro__g_get__6ABAD62E]DEFAULT(0)FOR[g_getpwd]

GO

CREATEINDEX[groupid]ON[dbo].[oblog_groups]([groupid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_log]ADD

CONSTRAINT[DF__oblog_log__useri__3F466844]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_log__autho__403A8C7D]DEFAULT(0)FOR[authorid],

CONSTRAINT[DF__oblog_log__truet__412EB0B6]DEFAULT(getdate())FOR[truetime],

CONSTRAINT[DF__oblog_log__iis__4222D4EF]DEFAULT(0)FOR[iis],

CONSTRAINT[DF__oblog_log__comme__4316F928]DEFAULT(0)FOR[commentnum],

CONSTRAINT[DF__oblog_log__class__440B1D61]DEFAULT(0)FOR[classid],

CONSTRAINT[DF__oblog_log__subje__44FF419A]DEFAULT(0)FOR[subjectid],

CONSTRAINT[DF__oblog_log__showw__45F365D3]DEFAULT(0)FOR[showword],

CONSTRAINT[DF__oblog_log__ishid__46E78A0C]DEFAULT(0)FOR[ishide],

CONSTRAINT[DF__oblog_log__track__47DBAE45]DEFAULT(0)FOR[trackbacknum],

CONSTRAINT[DF__oblog_log__passc__48CFD27E]DEFAULT(0)FOR[passcheck],

CONSTRAINT[DF__oblog_log__istop__49C3F6B7]DEFAULT(0)FOR[istop],

CONSTRAINT[DF__oblog_log__isbes__4AB81AF0]DEFAULT(0)FOR[isbest],

CONSTRAINT[DF__oblog_log__isenc__4BAC3F29]DEFAULT(1)FOR[isencomment],

CONSTRAINT[DF__oblog_log__blog___4CA06362]DEFAULT(0)FOR[blog_password],

CONSTRAINT[DF__oblog_log__isdra__4D94879B]DEFAULT(0)FOR[isdraft],

CONSTRAINT[DF__oblog_log__issav__4E88ABD4]DEFAULT(0)FOR[issave],

CONSTRAINT[DF__oblog_log__logTy__4F7CD00D]DEFAULT(0)FOR[logType],

CONSTRAINT[DF__oblog_log__Abstr__5070F446]DEFAULT(0)FOR[Abstract_auto],

CONSTRAINT[DF__oblog_log__Edito__5165187F]DEFAULT(0)FOR[EditorType],

CONSTRAINT[DF__oblog_log__speci__52593CB8]DEFAULT(0)FOR[specialid],

CONSTRAINT[DF__oblog_log__score__534D60F1]DEFAULT(0)FOR[scores],

CONSTRAINT[DF__oblog_log__vote0__5441852A]DEFAULT(0)FOR[vote0],

CONSTRAINT[DF__oblog_log__vote1__5535A963]DEFAULT(0)FOR[vote1],

CONSTRAINT[DF__oblog_log__isTro__5629CD9C]DEFAULT(0)FOR[isTrouble],

CONSTRAINT[DF__oblog_log__isdel__571DF1D5]DEFAULT(0)FOR[isdel],

CONSTRAINT[DF__oblog_log__isNee__6BAEFA67]DEFAULT(0)FOR[isNeedLogin],

CONSTRAINT[DF__oblog_log__ViewS__6CA31EA0]DEFAULT(0)FOR[ViewScores],

CONSTRAINT[DF__oblog_log__IsSpe__6D9742D9]DEFAULT(0)FOR[IsSpecial],

CONSTRAINT[DF__oblog_log__diggN__6E8B6712]DEFAULT(0)FOR[diggNum],

CONSTRAINT[DF__oblog_log__ViewG__6F7F8B4B]DEFAULT(0)FOR[ViewGroupId],

CONSTRAINT[DF__oblog_log__is_lo__30592A6F]DEFAULT(0)FOR[is_log_default_hidden]

GO

CREATEINDEX[addtime]ON[dbo].[oblog_log]([addtime])ON[PRIMARY]

GO

CREATEINDEX[authorid]ON[dbo].[oblog_log]([authorid])ON[PRIMARY]

GO

CREATEINDEX[classid]ON[dbo].[oblog_log]([classid])ON[PRIMARY]

GO

CREATEINDEX[isbest]ON[dbo].[oblog_log]([isbest])ON[PRIMARY]

GO

CREATEINDEX[isdraft]ON[dbo].[oblog_log]([isdraft])ON[PRIMARY]

GO

CREATEINDEX[ishide]ON[dbo].[oblog_log]([ishide])ON[PRIMARY]

GO

CREATEINDEX[istop]ON[dbo].[oblog_log]([istop])ON[PRIMARY]

GO

CREATEINDEX[logid]ON[dbo].[oblog_log]([logid])ON[PRIMARY]

GO

CREATEINDEX[logTagsId]ON[dbo].[oblog_log]([logTagsId])ON[PRIMARY]

GO

CREATEINDEX[passcheck]ON[dbo].[oblog_log]([passcheck])ON[PRIMARY]

GO

CREATEINDEX[specialid]ON[dbo].[oblog_log]([specialid])ON[PRIMARY]

GO

CREATEINDEX[subjectid]ON[dbo].[oblog_log]([subjectid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_log]([userid])ON[PRIMARY]

GO

CREATEINDEX[Index_log_classid]ON[dbo].[oblog_log]([IsSpecial])ON[PRIMARY]

GO

CREATEINDEX[Index_log_diggNum]ON[dbo].[oblog_log]([diggNum])ON[PRIMARY]

GO

CREATEINDEX[Index_log_ViewGroupId]ON[dbo].[oblog_log]([ViewGroupId])ON[PRIMARY]

GO

CREATEINDEX[Index_log_is_log_default_hidden]ON[dbo].[oblog_log]([is_log_default_hidden])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_logclass]ADD

CONSTRAINT[DF__oblog_logcla__id__59063A47]DEFAULT(0)FOR[id],

CONSTRAINT[DF__oblog_log__class__59FA5E80]DEFAULT(0)FOR[classlognum],

CONSTRAINT[DF__oblog_log__order__5AEE82B9]DEFAULT(0)FOR[ordernum],

CONSTRAINT[DF__oblog_log__order__5BE2A6F2]DEFAULT(0)FOR[orderid],

CONSTRAINT[DF__oblog_log__paren__5CD6CB2B]DEFAULT(0)FOR[parentid],

CONSTRAINT[DF__oblog_log__depth__5DCAEF64]DEFAULT(0)FOR[depth],

CONSTRAINT[DF__oblog_log__rooti__5EBF139D]DEFAULT(0)FOR[rootid],

CONSTRAINT[DF__oblog_log__child__5FB337D6]DEFAULT(0)FOR[child],

CONSTRAINT[DF__oblog_log__previ__60A75C0F]DEFAULT(0)FOR[previd],

CONSTRAINT[DF__oblog_log__nexti__619B8048]DEFAULT(0)FOR[nextid],

CONSTRAINT[DF__oblog_log__idTyp__628FA481]DEFAULT(0)FOR[idType]

GO

CREATEUNIQUEINDEX[id]ON[dbo].[oblog_logclass]([id])ON[PRIMARY]

GO

CREATEINDEX[classid]ON[dbo].[oblog_logclass]([classid])ON[PRIMARY]

GO

CREATEINDEX[classlognum]ON[dbo].[oblog_logclass]([classlognum])ON[PRIMARY]

GO

CREATEINDEX[idType]ON[dbo].[oblog_logclass]([idType])ON[PRIMARY]

GO

CREATEINDEX[nextid]ON[dbo].[oblog_logclass]([nextid])ON[PRIMARY]

GO

CREATEINDEX[orderid]ON[dbo].[oblog_logclass]([orderid])ON[PRIMARY]

GO

CREATEINDEX[ordernum]ON[dbo].[oblog_logclass]([ordernum])ON[PRIMARY]

GO

CREATEINDEX[ParentID]ON[dbo].[oblog_logclass]([parentid])ON[PRIMARY]

GO

CREATEINDEX[previd]ON[dbo].[oblog_logclass]([previd])ON[PRIMARY]

GO

CREATEINDEX[rootid]ON[dbo].[oblog_logclass]([rootid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_logvotes]ADD

CONSTRAINT[DF__oblog_log__logid__6477ECF3]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_logv__vote__656C112C]DEFAULT(0)FOR[vote],

CONSTRAINT[DF__oblog_log__useri__66603565]DEFAULT(0)FOR[userid]

GO

CREATEINDEX[id]ON[dbo].[oblog_logvotes]([id])ON[PRIMARY]

GO

CREATEINDEX[logid]ON[dbo].[oblog_logvotes]([logid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_logvotes]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_message]ADD

CONSTRAINT[DF__oblog_mes__useri__68487DD7]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_mes__addti__693CA210]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_mes__isgue__6A30C649]DEFAULT(0)FOR[isguest],

CONSTRAINT[DF__oblog_mes__issav__6B24EA82]DEFAULT(0)FOR[issave],

CONSTRAINT[DF__oblog_mes__iStat__6C190EBB]DEFAULT(0)FOR[iState],

CONSTRAINT[DF__oblog_mes__ubbed__6D0D32F4]DEFAULT(0)FOR[ubbedit],

CONSTRAINT[DF__oblog_mes__isdel__6E01572D]DEFAULT(0)FOR[isdel],

CONSTRAINT[DF__oblog_mes__ishid__6EF57B66]DEFAULT(0)FOR[ishide]

GO

CREATEINDEX[userid]ON[dbo].[oblog_message]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_myurl]ADD

CONSTRAINT[DF__oblog_myu__urlid__70DDC3D8]DEFAULT(0)FOR[urlid],

CONSTRAINT[DF__oblog_myu__useri__71D1E811]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_myu__class__72C60C4A]DEFAULT(0)FOR[classid],

CONSTRAINT[DF__oblog_myu__subje__73BA3083]DEFAULT(0)FOR[subjectid],

CONSTRAINT[DF__oblog_myu__ispri__74AE54BC]DEFAULT(0)FOR[isprivate],

CONSTRAINT[DF__oblog_myu__isupd__75A278F5]DEFAULT(0)FOR[isupdate],

CONSTRAINT[DF__oblog_myu__mainu__76969D2E]DEFAULT(0)FOR[mainuserid]

GO

CREATEINDEX[id]ON[dbo].[oblog_myurl]([id])ON[PRIMARY]

GO

CREATEINDEX[urlid]ON[dbo].[oblog_myurl]([urlid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_myurl]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_obcodes]ADD

CONSTRAINT[DF__oblog_obc__creat__797309D9]DEFAULT(0)FOR[creatuser],

CONSTRAINT[DF__oblog_obc__useus__7A672E12]DEFAULT(0)FOR[useuser],

CONSTRAINT[DF__oblog_obc__iType__7B5B524B]DEFAULT(0)FOR[iType],

CONSTRAINT[DF__oblog_obc__iStat__7C4F7684]DEFAULT(0)FOR[iState]

GO

CREATEINDEX[obcode]ON[dbo].[oblog_obcodes]([obcode])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_pm]ADD

CONSTRAINT[DF__oblog_pm__isread__7E37BEF6]DEFAULT(0)FOR[isreaded],

CONSTRAINT[DF__oblog_pm__addtim__7F2BE32F]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_pm__delR__00200768]DEFAULT(0)FOR[delR],

CONSTRAINT[DF__oblog_pm__delS__01142BA1]DEFAULT(0)FOR[delS],

CONSTRAINT[DF__oblog_pm__isgues__02084FDA]DEFAULT(0)FOR[isguest],

CONSTRAINT[DF__oblog_pm__pid__02FC7413]DEFAULT(0)FOR[pid],

CONSTRAINT[DF__oblog_pm__isSys__03F0984C]DEFAULT(0)FOR[isSys]

GO

CREATEINDEX[pid]ON[dbo].[oblog_pm]([pid])ON[PRIMARY]

GO

CREATEINDEX[sender]ON[dbo].[oblog_pm]([sender],[incept],[isreaded],[delR],[delS])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_roles]ADD

CONSTRAINT[DF__oblog_rol__r_ski__05D8E0BE]DEFAULT(0)FOR[r_skin_sys],

CONSTRAINT[DF__oblog_rol__r_ski__06CD04F7]DEFAULT(0)FOR[r_skin_qq],

CONSTRAINT[DF__oblog_rol__r_ski__07C12930]DEFAULT(0)FOR[r_skin_user],

CONSTRAINT[DF__oblog_rol__r_use__08B54D69]DEFAULT(0)FOR[r_user_reg],

CONSTRAINT[DF__oblog_rol__r_use__09A971A2]DEFAULT(0)FOR[r_user_name],

CONSTRAINT[DF__oblog_rol__r_use__0A9D95DB]DEFAULT(0)FOR[r_user_admin],

CONSTRAINT[DF__oblog_rol__r_use__0B91BA14]DEFAULT(0)FOR[r_user_group],

CONSTRAINT[DF__oblog_rol__r_use__0C85DE4D]DEFAULT(0)FOR[r_user_update],

CONSTRAINT[DF__oblog_rol__r_use__0D7A0286]DEFAULT(0)FOR[r_user_news],

CONSTRAINT[DF__oblog_rol__r_sec__0E6E26BF]DEFAULT(0)FOR[r_second_domain],

CONSTRAINT[DF__oblog_rol__r_mod__0F624AF8]DEFAULT(0)FOR[r_mod_script],

CONSTRAINT[DF__oblog_rol__r_mod__10566F31]DEFAULT(0)FOR[r_mod_argue],

CONSTRAINT[DF__oblog_rol__r_mod__114A936A]DEFAULT(0)FOR[r_mod_meet],

CONSTRAINT[DF__oblog_rol__r_mod__123EB7A3]DEFAULT(0)FOR[r_mod_special],

CONSTRAINT[DF__oblog_rol__r_sit__1332DBDC]DEFAULT(0)FOR[r_site_news],

CONSTRAINT[DF__oblog_rol__r_blo__14270015]DEFAULT(0)FOR[r_blogstar],

CONSTRAINT[DF__oblog_rol__r_wor__7073AF84]DEFAULT(0)FOR[r_words],

CONSTRAINT[DF__oblog_role__r_IP__7167D3BD]DEFAULT(0)FOR[r_IP],

CONSTRAINT[DF__oblog_rol__r_sit__725BF7F6]DEFAULT(0)FOR[r_site_count],

CONSTRAINT[DF__oblog_rol__r_use__73501C2F]DEFAULT(0)FOR[r_user_blog],

CONSTRAINT[DF__oblog_rol__r_use__74444068]DEFAULT(0)FOR[r_user_rblog],

CONSTRAINT[DF__oblog_rol__r_use__753864A1]DEFAULT(0)FOR[r_user_cmt],

CONSTRAINT[DF__oblog_rol__r_use__762C88DA]DEFAULT(0)FOR[r_user_msg],

CONSTRAINT[DF__oblog_rol__r_use__7720AD13]DEFAULT(0)FOR[r_user_tag],

CONSTRAINT[DF__oblog_rol__r_gro__7814D14C]DEFAULT(0)FOR[r_group_user],

CONSTRAINT[DF__oblog_rol__r_gro__7908F585]DEFAULT(0)FOR[r_group_blog],

CONSTRAINT[DF__oblog_rol__r_use__79FD19BE]DEFAULT(0)FOR[r_user_upfiles],

CONSTRAINT[DF__oblog_rol__r_lis__7AF13DF7]DEFAULT(0)FOR[r_list_upfiles],

CONSTRAINT[DF__oblog_rol__r_use__7BE56230]DEFAULT(0)FOR[r_user_all],

CONSTRAINT[DF__oblog_rol__r_use__7CD98669]DEFAULT(0)FOR[r_user_add],

CONSTRAINT[DF__oblog_rol__r_alb__7DCDAAA2]DEFAULT(0)FOR[r_album_comment],

CONSTRAINT[DF__oblog_rol__r_use__7EC1CEDB]DEFAULT(0)FOR[r_user_digg]

GO

CREATEINDEX[roleid]ON[dbo].[oblog_roles]([roleid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_setup]ADD

CONSTRAINT[DF__oblog_set__log_c__160F4887]DEFAULT(0)FOR[log_count],

CONSTRAINT[DF__oblog_set__comme__17036CC0]DEFAULT(0)FOR[comment_count],

CONSTRAINT[DF__oblog_set__messa__17F790F9]DEFAULT(0)FOR[message_count],

CONSTRAINT[DF__oblog_set__user___18EBB532]DEFAULT(0)FOR[user_count],

CONSTRAINT[DF__oblog_set__log_c__7FB5F314]DEFAULT(0)FOR[log_count_Yesterday],

CONSTRAINT[DF__oblog_set__log_Y__00AA174D]DEFAULT(getdate())FOR[log_Yesterday]

GO

CREATEINDEX[show_blogupdate_num]ON[dbo].[oblog_setup]([comment_count])ON[PRIMARY]

GO

CREATEINDEX[siterefu_num]ON[dbo].[oblog_setup]([user_count])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_skinclass]ADD

CONSTRAINT[DF__oblog_ski__iCoun__1AD3FDA4]DEFAULT(0)FOR[iCount],

CONSTRAINT[DF__oblog_ski__iType__1BC821DD]DEFAULT(0)FOR[iType]

GO

CREATEINDEX[classid]ON[dbo].[oblog_skinclass]([classid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_subject]ADD

CONSTRAINT[DF__oblog_sub__useri__2645B050]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_sub__subje__2739D489]DEFAULT(0)FOR[subjectlognum],

CONSTRAINT[DF__oblog_sub__order__282DF8C2]DEFAULT(0)FOR[ordernum],

CONSTRAINT[DF__oblog_sub__subje__29221CFB]DEFAULT(0)FOR[subjectType],

CONSTRAINT[DF__oblog_sub__ishid__019E3B86]DEFAULT(0)FOR[ishide],

CONSTRAINT[DF__oblog_sub__addti__02925FBF]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_sub__views__038683F8]DEFAULT(0)FOR[views]

GO

CREATEINDEX[ordernum]ON[dbo].[oblog_subject]([ordernum])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_subject]([userid])ON[PRIMARY]

GO

CREATEINDEX[Index_subject_subjectType]ON[dbo].[oblog_subject]([subjectType])ON[PRIMARY]

GO

CREATEINDEX[Index_subject_ishide]ON[dbo].[oblog_subject]([ishide])ON[PRIMARY]

GO

CREATEINDEX[Index_subject_views]ON[dbo].[oblog_subject]([views])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_syslog]ADD

CONSTRAINT[DF__oblog_sys__itype__2B0A656D]DEFAULT(0)FOR[itype]

GO

CREATEINDEX[id]ON[dbo].[oblog_syslog]([id])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_sysskin]ADD

CONSTRAINT[DF__oblog_sys__isdef__2CF2ADDF]DEFAULT(0)FOR[isdefault]

GO

CREATEINDEX[id]ON[dbo].[oblog_sysskin]([id])ON[PRIMARY]

GO

CREATEINDEX[isdefault]ON[dbo].[oblog_sysskin]([isdefault])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_tags]ADD

CONSTRAINT[DF__oblog_tag__iClas__2EDAF651]DEFAULT(0)FOR[iClass],

CONSTRAINT[DF__oblog_tags__iNum__2FCF1A8A]DEFAULT(0)FOR[iNum],

CONSTRAINT[DF__oblog_tag__iType__30C33EC3]DEFAULT(0)FOR[iType],

CONSTRAINT[DF__oblog_tag__iStat__31B762FC]DEFAULT(1)FOR[iState]

GO

CREATEINDEX[Index_tags_tagid]ON[dbo].[oblog_tags]([TagId])ON[PRIMARY]

GO

CREATEINDEX[iNum]ON[dbo].[oblog_tags]([iNum])ON[PRIMARY]

GO

CREATEINDEX[TagId]ON[dbo].[oblog_tags]([TagId])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_team]ADD

CONSTRAINT[DF__oblog_tea__creat__339FAB6E]DEFAULT(0)FOR[createrid],

CONSTRAINT[DF__oblog_tea__icoun__3493CFA7]DEFAULT(0)FOR[icount0],

CONSTRAINT[DF__oblog_tea__icoun__3587F3E0]DEFAULT(0)FOR[icount1],

CONSTRAINT[DF__oblog_tea__icoun__367C1819]DEFAULT(0)FOR[icount2],

CONSTRAINT[DF__oblog_tea__joinl__37703C52]DEFAULT(0)FOR[joinlimit],

CONSTRAINT[DF__oblog_tea__joins__3864608B]DEFAULT(0)FOR[joinscores],

CONSTRAINT[DF__oblog_tea__other__395884C4]DEFAULT(0)FOR[otherpost],

CONSTRAINT[DF__oblog_tea__isdel__3A4CA8FD]DEFAULT(0)FOR[isdel],

CONSTRAINT[DF__oblog_tea__class__3B40CD36]DEFAULT(0)FOR[classid],

CONSTRAINT[DF__oblog_tea__hideu__373B3228]DEFAULT(0)FOR[hideurl],

CONSTRAINT[DF__oblog_tea__viewl__382F5661]DEFAULT(0)FOR[viewlimit]

GO

CREATEINDEX[classid]ON[dbo].[oblog_team]([classid])ON[PRIMARY]

GO

CREATEINDEX[createrid]ON[dbo].[oblog_team]([createrid])ON[PRIMARY]

GO

CREATEINDEX[teamid]ON[dbo].[oblog_team]([teamid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_teampost]ADD

CONSTRAINT[DF__oblog_tea__paren__3D2915A8]DEFAULT(0)FOR[parentid],

CONSTRAINT[DF__oblog_tea__idept__3E1D39E1]DEFAULT(0)FOR[idepth],

CONSTRAINT[DF__oblog_tea__logid__3F115E1A]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_tea__useri__40058253]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_tea__ispas__39237A9A]DEFAULT(0)FOR[ispass],

CONSTRAINT[DF__oblog_tea__views__40F9A68C]DEFAULT(0)FOR[views],

CONSTRAINT[DF__oblog_tea__reply__41EDCAC5]DEFAULT(0)FOR[replys],

CONSTRAINT[DF__oblog_tea__score__42E1EEFE]DEFAULT(0)FOR[scores],

CONSTRAINT[DF__oblog_tea__isdel__43D61337]DEFAULT(0)FOR[isdel]

GO

CREATEINDEX[parentid]ON[dbo].[oblog_teampost]([parentid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_teampost]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_teamskin]ADD

CONSTRAINT[DF__oblog_tea__isdef__65F62111]DEFAULT(0)FOR[isdefault],

CONSTRAINT[DF__oblog_tea__ispas__66EA454A]DEFAULT(0)FOR[ispass],

CONSTRAINT[DF__oblog_tea__class__67DE6983]DEFAULT(0)FOR[classid]

GO

CREATEINDEX[Index_teamskin_classid]ON[dbo].[oblog_teamskin]([classid])ON[PRIMARY]

GO

CREATEINDEX[Index_teamskin_isdefault]ON[dbo].[oblog_teamskin]([isdefault])ON[PRIMARY]

GO

CREATEINDEX[Index_teamskin_ispass]ON[dbo].[oblog_teamskin]([ispass])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_teamusers]ADD

CONSTRAINT[DF__oblog_tea__post___45BE5BA9]DEFAULT(0)FOR[post_all],

CONSTRAINT[DF__oblog_tea__post___46B27FE2]DEFAULT(0)FOR[post_logs],

CONSTRAINT[DF__oblog_tea__post___47A6A41B]DEFAULT(0)FOR[post_posts],

CONSTRAINT[DF__oblog_tea__post___489AC854]DEFAULT(0)FOR[post_replys]

GO

CREATEINDEX[ID]ON[dbo].[oblog_teamusers]([ID])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_trackback]ADD

CONSTRAINT[DF__oblog_tra__useri__4A8310C6]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_tra__logid__4B7734FF]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_tra__addti__4C6B5938]DEFAULT(getdate())FOR[addtime]

GO

CREATEINDEX[blogid]ON[dbo].[oblog_trackback]([logid])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_trackback]([userid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_upfile]ADD

CONSTRAINT[DF__oblog_upf__useri__4E53A1AA]DEFAULT(0)FOR[userid],

CONSTRAINT[DF__oblog_upf__logid__4F47C5E3]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_upf__file___503BEA1C]DEFAULT(0)FOR[file_size],

CONSTRAINT[DF__oblog_upf__ispho__51300E55]DEFAULT(0)FOR[isphoto],

CONSTRAINT[DF__oblog_upf__addti__5224328E]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_upf__issav__531856C7]DEFAULT(0)FOR[issave],

CONSTRAINT[DF__oblog_upf__isPow__540C7B00]DEFAULT(0)FOR[isPower],

CONSTRAINT[DF__oblog_upf__sysCl__55009F39]DEFAULT(0)FOR[sysClassId],

CONSTRAINT[DF__oblog_upf__userC__55F4C372]DEFAULT(0)FOR[userClassId],

CONSTRAINT[DF__oblog_upf__photo__56E8E7AB]DEFAULT(0)FOR[photo_width],

CONSTRAINT[DF__oblog_upf__photo__57DD0BE4]DEFAULT(0)FOR[photo_height],

CONSTRAINT[DF__oblog_upf__viewN__58D1301D]DEFAULT(0)FOR[viewNum],

CONSTRAINT[DF__oblog_upf__isdel__59C55456]DEFAULT(0)FOR[isdel],

CONSTRAINT[DF__oblog_upf__isBig__5AB9788F]DEFAULT(0)FOR[isBigHead],

CONSTRAINT[DF__oblog_upf__filet__3A179ED3]DEFAULT(0)FOR[filetype]

GO

CREATEINDEX[logid]ON[dbo].[oblog_upfile]([logid])ON[PRIMARY]

GO

CREATEINDEX[sysClassid]ON[dbo].[oblog_upfile]([sysClassId])ON[PRIMARY]

GO

CREATEINDEX[userClassId]ON[dbo].[oblog_upfile]([userClassId])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_upfile]([userid],[isphoto],[issave])ON[PRIMARY]

GO

CREATEINDEX[viewNum]ON[dbo].[oblog_upfile]([viewNum])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_url]ADD

CONSTRAINT[DF__oblog_url__icoun__5CA1C101]DEFAULT(1)FOR[icount],

CONSTRAINT[DF__oblog_url__vcoun__5D95E53A]DEFAULT(0)FOR[vcount]

GO

CREATEINDEX[urlid]ON[dbo].[oblog_url]([urlid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_user]ADD

CONSTRAINT[DF__oblog_user__sex__5F7E2DAC]DEFAULT(1)FOR[sex],

CONSTRAINT[DF__oblog_use__login__607251E5]DEFAULT(0)FOR[logintimes],

CONSTRAINT[DF__oblog_use__locku__6166761E]DEFAULT(0)FOR[lockuser],

CONSTRAINT[DF__oblog_use__user___625A9A57]DEFAULT(0)FOR[user_isbest],

CONSTRAINT[DF__oblog_use__defau__634EBE90]DEFAULT(0)FOR[default_skin],

CONSTRAINT[DF__oblog_use__log_c__6442E2C9]DEFAULT(0)FOR[log_count],

CONSTRAINT[DF__oblog_use__user___65370702]DEFAULT(0)FOR[user_level],

CONSTRAINT[DF__oblog_use__user___662B2B3B]DEFAULT(10)FOR[user_showlog_num],

CONSTRAINT[DF__oblog_use__hideu__671F4F74]DEFAULT(10)FOR[hideurl],

CONSTRAINT[DF__oblog_use__user___681373AD]DEFAULT(10)FOR[user_shownewlog_num],

CONSTRAINT[DF__oblog_use__user___690797E6]DEFAULT(10)FOR[user_shownewcomment_num],

CONSTRAINT[DF__oblog_use__user___69FBBC1F]DEFAULT(10)FOR[user_shownewmessage_num],

CONSTRAINT[DF__oblog_use__user___6AEFE058]DEFAULT(0)FOR[user_siterefu_num],

CONSTRAINT[DF__oblog_use__comme__6BE40491]DEFAULT(0)FOR[comment_count],

CONSTRAINT[DF__oblog_use__messa__6CD828CA]DEFAULT(0)FOR[message_count],

CONSTRAINT[DF__oblog_use__user___6DCC4D03]DEFAULT(0)FOR[user_upfiles_max],

CONSTRAINT[DF__oblog_use__user___6EC0713C]DEFAULT(0)FOR[user_classid],

CONSTRAINT[DF__oblog_use__user___6FB49575]DEFAULT(0)FOR[user_upfiles_size],

CONSTRAINT[DF__oblog_use__user___70A8B9AE]DEFAULT(0)FOR[user_upfiles_num],

CONSTRAINT[DF__oblog_use__user___719CDDE7]DEFAULT(500)FOR[user_showlogword_num],

CONSTRAINT[DF__oblog_use__en_bl__72910220]DEFAULT(1)FOR[en_blogteam],

CONSTRAINT[DF__oblog_use__comme__73852659]DEFAULT(0)FOR[comment_isasc],

CONSTRAINT[DF__oblog_use__defau__74794A92]DEFAULT(0)FOR[defaultskin],

CONSTRAINT[DF__oblog_use__isubb__756D6ECB]DEFAULT(0)FOR[isubbedit],

CONSTRAINT[DF__oblog_use__user___76619304]DEFAULT(4)FOR[user_photorow_num],

CONSTRAINT[DF__oblog_use__newbi__7755B73D]DEFAULT(0)FOR[newbie],

CONSTRAINT[DF__oblog_use__user___7849DB76]DEFAULT(0)FOR[user_group],

CONSTRAINT[DF__oblog_use__score__793DFFAF]DEFAULT(0)FOR[scores],

CONSTRAINT[DF__oblog_use__rolei__7A3223E8]DEFAULT(0)FOR[roleid],

CONSTRAINT[DF__oblog_use__email__7B264821]DEFAULT(0)FOR[emailValid],

CONSTRAINT[DF__oblog_use__isTro__7C1A6C5A]DEFAULT(0)FOR[isTrouble],

CONSTRAINT[DF__oblog_use__sub_n__7D0E9093]DEFAULT(0)FOR[sub_num],

CONSTRAINT[DF__oblog_use__isdel__7E02B4CC]DEFAULT(0)FOR[isdel],

CONSTRAINT[DF__oblog_use__index__7EF6D905]DEFAULT(0)FOR[indexlist],

CONSTRAINT[DF__oblog_use__Playe__047AA831]DEFAULT(0)FOR[PlayerType],

CONSTRAINT[DF__oblog_use__passp__056ECC6A]DEFAULT(0)FOR[passport_userid],

CONSTRAINT[DF__oblog_use__updat__0662F0A3]DEFAULT(0)FOR[updateblognum],

CONSTRAINT[DF__oblog_use__diggs__075714DC]DEFAULT(0)FOR[diggs],

CONSTRAINT[DF__oblog_use__isdig__084B3915]DEFAULT(0)FOR[isdigg],

CONSTRAINT[DF__oblog_use__updat__093F5D4E]DEFAULT(getdate())FOR[updateblogDate],

CONSTRAINT[DF__oblog_Use__is_lo__314D4EA8]DEFAULT(0)FOR[is_log_default_hidden]

GO

CREATEINDEX[emailValid]ON[dbo].[oblog_user]([emailValid])ON[PRIMARY]

GO

CREATEINDEX[lastcode]ON[dbo].[oblog_user]([lastcode])ON[PRIMARY]

GO

CREATEINDEX[roleid]ON[dbo].[oblog_user]([roleid])ON[PRIMARY]

GO

CREATEINDEX[sub_num]ON[dbo].[oblog_user]([sub_num])ON[PRIMARY]

GO

CREATEINDEX[user_domain]ON[dbo].[oblog_user]([user_domain]DESC)ON[PRIMARY]

GO

CREATEINDEX[user_domainroot]ON[dbo].[oblog_user]([user_domainroot],[lockuser],[user_classid],[user_level],[username])ON[PRIMARY]

GO

CREATEINDEX[user_photorow_num]ON[dbo].[oblog_user]([user_photorow_num])ON[PRIMARY]

GO

CREATEINDEX[userid]ON[dbo].[oblog_user]([userid])ON[PRIMARY]

GO

CREATEINDEX[Index_user_diggs]ON[dbo].[oblog_user]([diggs])ON[PRIMARY]

GO

CREATEINDEX[Index_user_passport_userid]ON[dbo].[oblog_user]([passport_userid])ON[PRIMARY]

GO

CREATEINDEX[Index_log_is_log_default_hidden]ON[dbo].[oblog_user]([is_log_default_hidden])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userclass]ADD

CONSTRAINT[DF__oblog_usercl__id__00DF2177]DEFAULT(0)FOR[id],

CONSTRAINT[DF__oblog_use__class__01D345B0]DEFAULT(0)FOR[classlognum],

CONSTRAINT[DF__oblog_use__order__02C769E9]DEFAULT(0)FOR[ordernum],

CONSTRAINT[DF__oblog_use__order__03BB8E22]DEFAULT(0)FOR[orderid],

CONSTRAINT[DF__oblog_use__paren__04AFB25B]DEFAULT(0)FOR[parentid],

CONSTRAINT[DF__oblog_use__depth__05A3D694]DEFAULT(0)FOR[depth],

CONSTRAINT[DF__oblog_use__rooti__0697FACD]DEFAULT(0)FOR[rootid],

CONSTRAINT[DF__oblog_use__child__078C1F06]DEFAULT(0)FOR[child],

CONSTRAINT[DF__oblog_use__previ__0880433F]DEFAULT(0)FOR[previd],

CONSTRAINT[DF__oblog_use__nexti__09746778]DEFAULT(0)FOR[nextid],

CONSTRAINT[DF__oblog_use__idTyp__0A688BB1]DEFAULT(0)FOR[idType]

GO

CREATEUNIQUEINDEX[id]ON[dbo].[oblog_userclass]([id])ON[PRIMARY]

GO

CREATEINDEX[classid]ON[dbo].[oblog_userclass]([classid])ON[PRIMARY]

GO

CREATEINDEX[classlognum]ON[dbo].[oblog_userclass]([classlognum])ON[PRIMARY]

GO

CREATEINDEX[idType]ON[dbo].[oblog_userclass]([idType])ON[PRIMARY]

GO

CREATEINDEX[nextid]ON[dbo].[oblog_userclass]([nextid])ON[PRIMARY]

GO

CREATEINDEX[orderid]ON[dbo].[oblog_userclass]([orderid])ON[PRIMARY]

GO

CREATEINDEX[ordernum]ON[dbo].[oblog_userclass]([ordernum])ON[PRIMARY]

GO

CREATEINDEX[ParentID]ON[dbo].[oblog_userclass]([parentid])ON[PRIMARY]

GO

CREATEINDEX[previd]ON[dbo].[oblog_userclass]([previd])ON[PRIMARY]

GO

CREATEINDEX[rootid]ON[dbo].[oblog_userclass]([rootid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userdigg]ADD

CONSTRAINT[DF__oblog_use__diggn__5D60DB10]DEFAULT(0)FOR[diggnum],

CONSTRAINT[DF__oblog_use__autho__5E54FF49]DEFAULT(0)FOR[authorid],

CONSTRAINT[DF__oblog_use__class__5F492382]DEFAULT(0)FOR[classid],

CONSTRAINT[DF__oblog_use__addti__603D47BB]DEFAULT(getdate())FOR[addtime],

CONSTRAINT[DF__oblog_use__logid__61316BF4]DEFAULT(0)FOR[logid],

CONSTRAINT[DF__oblog_use__lastd__6225902D]DEFAULT(getdate())FOR[lastdiggtime],

CONSTRAINT[DF__oblog_use__iStat__6319B466]DEFAULT(0)FOR[iState]

GO

CREATEINDEX[Index_userdigg_diggnum]ON[dbo].[oblog_userdigg]([diggnum])ON[PRIMARY]

GO

CREATEINDEX[Index_userdigg_logid]ON[dbo].[oblog_userdigg]([logid])ON[PRIMARY]

GO

CREATEINDEX[Index_userdigg_authorid]ON[dbo].[oblog_userdigg]([authorid])ON[PRIMARY]

GO

CREATEINDEX[Index_userdigg_classid]ON[dbo].[oblog_userdigg]([classid])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userdir]ADD

CONSTRAINT[DF__oblog_use__is_de__0C50D423]DEFAULT(0)FOR[is_default]

GO

CREATEINDEX[ID]ON[dbo].[oblog_userdir]([ID])ON[PRIMARY]

GO

CREATEINDEX[is_default]ON[dbo].[oblog_userdir]([is_default])ON[PRIMARY]

GO

ALTERTABLE[dbo].[oblog_userskin]ADD

CONSTRAINT[DF__oblog_use__isdef__0E391C95]DEFAULT(0)FOR[isdefault],

CONSTRAINT[DF__oblog_use__ispas__0F2D40CE]DEFAULT(0)FOR[ispass],

CONSTRAINT[DF__oblog_use__class__10216507]DEFAULT(0)FOR[classid]

GO

CREATEINDEX[classid]ON[dbo].[oblog_userskin]([classid])ON[PRIMARY]

GO

CREATEINDEX[id]ON[dbo].[oblog_userskin]([id])ON[PRIMARY]

GO

CREATEINDEX[isdefault]ON[dbo].[oblog_userskin]([isdefault])ON[PRIMARY]

GO

CREATEINDEX[ispass]ON[dbo].[oblog_userskin]([ispass])ON[PRIMARY]

GO

SETQUOTED_IDENTIFIERON

GO

SETANSI_NULLSOFF

GO

CREATEPROCEDURE[ob_calendar]

@logdatesmalldatetime,

@useridint

AS

SELECTaddtime,logfile

FROMoblog_log

WHEREdatediff(n,@logdate,addtime)>0anduserid=@userid

GO

SETQUOTED_IDENTIFIEROFF

GO

SETANSI_NULLSON

GO

oblog4.6SQL 语句 -电脑资料

手机扫码分享

Top