oblog4.6SQL 语句 -电脑资料
作者： 字体：[增加 减小] 类型：转载
代码如下:
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[I
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
