if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ob_calendar]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ob_calendar]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Oblog_Verifiydata]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Oblog_Verifiydata]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oBlog_usertags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oBlog_usertags]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_Album]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_Album]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_AlbumComment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_AlbumComment]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_Special]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_Special]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_SpecialList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_SpecialList]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_admin]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_argue]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_argue]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_arguelist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_arguelist]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_blogstar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_blogstar]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_blogteam]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_blogteam]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_calendar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_calendar]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_comment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_comment]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_config]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_digg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_digg]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_friend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_friend]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_friendurl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_friendurl]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_groups]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_log]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_logclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_logclass]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_logvotes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_logvotes]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_message]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_myurl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_myurl]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_notdownload]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_notdownload]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_obcodes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_obcodes]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_pm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_pm]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_roles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_roles]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_setup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_setup]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_skinclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_skinclass]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_subject]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_subject]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_syslog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_syslog]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_sysskin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_sysskin]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_tags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_tags]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_team]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_team]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_teampost]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_teampost]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_teamskin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_teamskin]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_teamusers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_teamusers]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_trackback]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_trackback]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_upfile]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_upfile]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_url]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_url]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_user]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_userclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_userclass]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_userdigg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_userdigg]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_userdir]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_userdir]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[oblog_userskin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[oblog_userskin]
GO
CREATE TABLE [dbo].[Oblog_Verifiydata] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[ask] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[answer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [smalldatetime] NULL ,
[isP] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oBlog_usertags] (
[UserTagid] [int] IDENTITY (1, 1) NOT NULL ,
[TagId] [int] NULL ,
[Userid] [int] NULL ,
[logid] [int] NULL ,
[iNum] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_Album] (
[photoID] [int] IDENTITY (1, 1) NOT NULL ,
[userID] [int] NULL ,
[photo_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[photo_path] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[photo_size] [int] NULL ,
[photo_Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[photo_Readme] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[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
CREATE TABLE [dbo].[oblog_AlbumComment] (
[mainid] [int] NULL ,
[comment] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[comment_user] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[commenttopic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[userid] [int] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[homepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isguest] [int] NULL ,
[iState] [int] NULL ,
[isdel] [int] NULL ,
[teamid] [int] NULL ,
[commentid] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_Special] (
[specialid] [int] IDENTITY (1, 1) NOT NULL ,
[s_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[s_ico] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[s_count] [int] NULL ,
[s_abstract] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[s_creater] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[s_addtime] [datetime] NULL ,
[isActive] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_SpecialList] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[SpecialId] [int] NULL ,
[UserId] [int] NULL ,
[author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[logid] [int] NULL ,
[topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[abstract] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[ispass] [int] NULL ,
[istop] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_admin] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lastloginip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lastlogintime] [datetime] NULL ,
[logintimes] [int] NULL ,
[roleid] [int] NULL ,
[userid] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_argue] (
[argueid] [int] IDENTITY (1, 1) NOT NULL ,
[a_ico] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[topic] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[abstract] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[action1] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[action2] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[ico1] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[ico2] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[userid] [int] NULL ,
[idays] [int] NULL ,
[istate] [int] NULL ,
[finishtime] [datetime] NULL ,
[finish_content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[users] [int] NULL ,
[pass_manager] [int] NULL ,
[pass_time] [datetime] NULL ,
[over_manager] [int] NULL ,
[over_time] [datetime] NULL ,
[over_contet] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[over_score] [int] NULL ,
[system_overivew] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[actions] [int] NULL ,
[actions1] [int] NULL ,
[actions2] [int] NULL ,
[actions3] [int] NULL ,
[istop] [int] NULL ,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_arguelist] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[argueid] [int] NULL ,
[userid] [int] NULL ,
[author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[content] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[action] [int] NULL ,
[addtime] [datetime] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[rejoin] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_blogstar] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[userurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[picurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[info] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[blogname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ispass] [int] NULL ,
[username] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[usernickname] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_blogteam] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[mainuserid] [int] NULL ,
[otheruserid] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_calendar] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[calendar_month] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_comment] (
[commentid] [int] IDENTITY (1, 1) NOT NULL ,
[mainid] [int] NULL ,
[comment] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[comment_user] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[commenttopic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[userid] [int] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[homepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isguest] [int] NULL ,
[iState] [int] NULL ,
[ubbedit] [int] NULL ,
[isdel] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_config] (
[id] [int] NOT NULL ,
[ob_value] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_digg] (
[did] [int] IDENTITY (1, 1) NOT NULL ,
[userID] [int] NULL ,
[diggid] [int] NULL ,
[addtime] [smalldatetime] NULL ,
[logid] [int] NULL ,
[addip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isguest] [int] NULL ,
[authorid] [int] NULL ,
[username] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[diggtype] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_friend] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[friendid] [int] NULL ,
[addtime] [datetime] NULL ,
[isblack] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_friendurl] (
[urlid] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[urlname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ordernum] [int] NULL ,
[urlType] [int] NULL ,
[url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[logo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_groups] (
[groupid] [int] IDENTITY (1, 1) NOT NULL ,
[g_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[g_level] [int] NULL ,
[g_points] [int] NULL ,
[g_autoupdate] [int] NULL ,
[g_style] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[g_seconddomain] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[g_domain] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[g_obcodes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[g_classes] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[g_post_day] [int] NULL ,
[g_post_chk] [int] NULL ,
[g_post_script] [int] NULL ,
[g_skins] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[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) COLLATE Chinese_PRC_CI_AS NULL ,
[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
CREATE TABLE [dbo].[oblog_log] (
[logid] [int] IDENTITY (1, 1) NOT NULL ,
[topic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[logtext] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[userid] [int] NULL ,
[authorid] [int] NULL ,
[author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[truetime] [datetime] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[iis] [int] NULL ,
[face] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[commentnum] [int] NULL ,
[classid] [int] NULL ,
[subjectid] [int] NULL ,
[showword] [int] NULL ,
[ishide] [int] NULL ,
[ispassword] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[trackbacknum] [int] NULL ,
[passcheck] [int] NULL ,
[istop] [int] NULL ,
[isbest] [int] NULL ,
[isencomment] [int] NULL ,
[blog_password] [int] NULL ,
[tbUrl] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[logfile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isdraft] [int] NULL ,
[issave] [int] NULL ,
[subjectfile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[logTags] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[logTagsId] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[logType] [int] NULL ,
[Abstract] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[Abstract_auto] [int] NULL ,
[EditorType] [int] NULL ,
[filename] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[logPics] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[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) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_logclass] (
[classid] [int] IDENTITY (1, 1) NOT NULL ,
[id] [int] NULL ,
[classname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[classlognum] [int] NULL ,
[ordernum] [int] NULL ,
[orderid] [int] NULL ,
[parentid] [int] NULL ,
[parentpath] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[depth] [int] NULL ,
[rootid] [int] NULL ,
[child] [int] NULL ,
[readme] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[previd] [int] NULL ,
[nextid] [int] NULL ,
[idType] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_logvotes] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[logid] [int] NULL ,
[vote] [int] NULL ,
[userid] [int] NULL ,
[addtime] [datetime] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_message] (
[messageid] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[messagetopic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[message] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[message_user] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[homepage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isguest] [int] NULL ,
[issave] [int] NULL ,
[messagefile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[iState] [int] NULL ,
[ubbedit] [int] NULL ,
[isdel] [int] NULL ,
[ishide] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_myurl] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[urlid] [int] NULL ,
[userid] [int] NULL ,
[classid] [int] NULL ,
[subjectid] [int] NULL ,
[tags] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[memo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isprivate] [int] NULL ,
[addtime] [datetime] NULL ,
[encodeing] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isupdate] [int] NULL ,
[mainuserid] [int] NULL ,
[lastupdatetime] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_notdownload] (
[notdown] [binary] (1) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_obcodes] (
[obcode] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[creatuser] [int] NULL ,
[useuser] [int] NULL ,
[iType] [int] NULL ,
[iState] [int] NULL ,
[CreateTime] [datetime] NULL ,
[UseTime] [datetime] NULL ,
[CreatIp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[UseIp] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_pm] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[sender] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[incept] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[topic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[content] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isreaded] [int] NULL ,
[addtime] [datetime] NULL ,
[delR] [int] NOT NULL ,
[delS] [int] NOT NULL ,
[isguest] [int] NULL ,
[pid] [int] NULL ,
[isSys] [int] NULL ,
[groups] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[readers] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_roles] (
[roleid] [int] IDENTITY (1, 1) NOT NULL ,
[r_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[r_skin_sys] [int] NULL ,
[r_skin_qq] [int] NULL ,
[r_skin_user] [int] NULL ,
[r_groups] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[r_classes1] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[r_classes2] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[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
CREATE TABLE [dbo].[oblog_setup] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[log_count] [int] NULL ,
[comment_count] [int] NULL ,
[message_count] [int] NULL ,
[user_count] [int] NULL ,
[site_placard] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[site_friends] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_placard] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_dir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[reg_text] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[log_count_Yesterday] [int] NULL ,
[log_Yesterday] [smalldatetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_skinclass] (
[classid] [int] IDENTITY (1, 1) NOT NULL ,
[classname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[iCount] [int] NULL ,
[iType] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_subject] (
[subjectid] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[subjectname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[subjectlognum] [int] NULL ,
[ordernum] [int] NULL ,
[subjectType] [int] NULL ,
[ishide] [int] NULL ,
[addtime] [smalldatetime] NULL ,
[views] [int] NULL ,
[photo_path] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_syslog] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[addip] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[desc] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[itype] [int] NULL ,
[QueryStrings] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_sysskin] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[sysskinname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[skinMain] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[skinShowlog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[skinauthor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isdefault] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_tags] (
[TagId] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[iClass] [int] NULL ,
[iNum] [int] NULL ,
[iType] [int] NULL ,
[iState] [int] NULL ,
[LastUpdate] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_team] (
[teamid] [int] IDENTITY (1, 1) NOT NULL ,
[t_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[t_ico] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[t_links] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[t_tags] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[createtime] [datetime] NULL ,
[createrid] [int] NULL ,
[creatername] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[managerid] [int] NULL ,
[managername] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lastupdatetime] [datetime] NULL ,
[intro] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[defaultskin] [int] NULL ,
[isbest] [int] NULL ,
[istate] [int] NULL ,
[announce] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[totalvisit] [int] NULL ,
[links] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[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) COLLATE Chinese_PRC_CI_AS NULL ,
[t_domainroot] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[viewpassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hideurl] [int] NULL ,
[viewlimit] [int] NULL ,
[user_skin_main] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_skin_showlog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[bak_skin1] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[bak_skin2] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_teampost] (
[postid] [int] IDENTITY (1, 1) NOT NULL ,
[parentid] [int] NULL ,
[idepth] [int] NULL ,
[teamid] [int] NOT NULL ,
[logid] [int] NULL ,
[userid] [int] NULL ,
[author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[url] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[topic] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[istop] [int] NULL ,
[isbest] [int] NULL ,
[ispass] [int] NULL ,
[subjectid] [int] NULL ,
[addtime] [datetime] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lastupdate] [datetime] NULL ,
[views] [int] NULL ,
[replys] [int] NULL ,
[scores] [int] NULL ,
[tags] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[user_ico] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[isdel] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_teamskin] (
[userskinname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[skinmain] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[skinshowlog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[skinauthor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[skinauthorurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isdefault] [int] NULL ,
[skinpic] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[ispass] [int] NULL ,
[classid] [int] NULL ,
[id] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_teamusers] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[teamid] [int] NULL ,
[userid] [int] NULL ,
[state] [int] NULL ,
[info] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[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
CREATE TABLE [dbo].[oblog_trackback] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[blog_name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[userid] [int] NULL ,
[logid] [int] NULL ,
[topic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[tbuser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[addtime] [datetime] NULL ,
[Excerpt] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[tb_url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[IP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[VisitorUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_upfile] (
[fileid] [int] IDENTITY (1, 1) NOT NULL ,
[userid] [int] NULL ,
[logid] [int] NULL ,
[file_name] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[file_path] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[file_ext] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[file_size] [int] NULL ,
[file_readme] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[isphoto] [smallint] NULL ,
[addtime] [datetime] NULL ,
[file_remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[issave] [int] NULL ,
[isPower] [int] NULL ,
[photofile] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[photoExif] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[sysClassId] [int] NULL ,
[userClassId] [int] NULL ,
[photo_width] [int] NULL ,
[photo_height] [int] NULL ,
[viewNum] [int] NULL ,
[isdel] [int] NULL ,
[isBigHe
