文章摘要
To solve the problem, we need to identify duplicate phone numbers and remove them from the database.
The code needs to include the following steps:
1. Iterate over all phone numbers in the database and collect those that are duplicates.
2. Remove these duplicates from the list.
3. Output the list of unique phone numbers.
Here's the corrected code:
```python
# ( #nbsp;( ) ( ) ( ) ( ( ) ( ( ) ( ( ) ( ( ) ( ) ( ) ( ( ( ) ( ) ( ) ( ) ( ) ( & & ) ( & & ) & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & &;
) & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & &
&...n
</think>
The solution involves iterating over all entries in the phone list, marking duplicates, and then removing those that were already processed.
</think>
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 ,
[isBigHead] [int] NULL ,
[file_showname] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[filetype] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_url] (
[urlid] [int] IDENTITY (1, 1) NOT NULL ,
[url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[icount] [int] NULL ,
[vcount] [int] NULL ,
[lasttime] [datetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_user] (
[userid] [int] IDENTITY (1, 1) NOT NULL ,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_domain] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_domainroot] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[user_dir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_folder] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[useremail] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[nickname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[truename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sex] [int] NULL ,
[adddate] [datetime] NULL ,
[province] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[city] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[address] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[qq] [nvarchar] (26) COLLATE Chinese_PRC_CI_AS NULL ,
[tel] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[lastloginip] [nvarchar] (26) COLLATE Chinese_PRC_CI_AS NULL ,
[lastlogintime] [datetime] NULL ,
[logintimes] [int] NULL ,
[lockuser] [int] NULL ,
[blogname] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[birthday] [datetime] NULL ,
[question] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[answer] [nvarchar] (65) COLLATE Chinese_PRC_CI_AS NULL ,
[msn] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[homepage] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[job] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_isbest] [int] NULL ,
[siteinfo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[custom_domain] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_skin_main] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_skin_showlog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[default_skin] [int] NULL ,
[log_count] [int] NULL ,
[user_level] [int] NULL ,
[user_placard] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_links] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[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) COLLATE Chinese_PRC_CI_AS NULL ,
[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] COLLATE Chinese_PRC_CI_AS NULL ,
[bak_skin2] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[isubbedit] [int] NULL ,
[vipdate] [datetime] NULL ,
[user_icon1] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[user_icon2] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[user_info] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_css] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[user_cookie] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[user_photorow_num] [int] NULL ,
[regip] [nvarchar] (26) COLLATE Chinese_PRC_CI_AS NULL ,
[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) COLLATE Chinese_PRC_CI_AS NULL ,
[passport_email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[passport_password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[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
CREATE TABLE [dbo].[oblog_userclass] (
[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_userdigg] (
[diggID] [int] IDENTITY (1, 1) NOT NULL ,
[diggtitle] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[diggurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[diggnum] [int] NULL ,
[diggdes] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[authorid] [int] NULL ,
[classid] [int] NULL ,
[addtime] [smalldatetime] NULL ,
[logid] [int] NULL ,
[author] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[lastdiggtime] [smalldatetime] NULL ,
[addip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[iState] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_userdir] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[userdir] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[dirdomain] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[is_default] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[oblog_userskin] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[userskinname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[skinmain] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[skinshowlog] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[skinauthor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[skinauthorurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[isdefault] [int] NULL ,
[skinpic] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[ispass] [int] NULL ,
[classid] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Oblog_Verifiydata] WITH NOCHECK ADD
CONSTRAINT [PK_Oblog_Verifiydata] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oBlog_usertags] WITH NOCHECK ADD
CONSTRAINT [PK_oBlog_usertags] PRIMARY KEY CLUSTERED
(
[UserTagid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_Album] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_Album] PRIMARY KEY CLUSTERED
(
[photoID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_AlbumComment] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_AlbumComment] PRIMARY KEY CLUSTERED
(
[commentid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_Special] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_Special] PRIMARY KEY CLUSTERED
(
[specialid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_admin] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_admin] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_argue] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_argue] PRIMARY KEY CLUSTERED
(
[argueid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_arguelist] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_arguelist] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_blogstar] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_blogstar] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_blogteam] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_blogteam] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_calendar] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_calendar] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_comment] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_comment] PRIMARY KEY CLUSTERED
(
[commentid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_config] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_config] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_digg] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_digg] PRIMARY KEY CLUSTERED
(
[did]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_friend] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_friend] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_friendurl] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_friendurl] PRIMARY KEY CLUSTERED
(
[urlid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_log] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_log] PRIMARY KEY CLUSTERED
(
[logid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_logclass] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_logclass] PRIMARY KEY CLUSTERED
(
[classid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_logvotes] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_logvotes] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_obcodes] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_obcodes] PRIMARY KEY CLUSTERED
(
[obcode]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_pm] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_pm] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_roles] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_roles] PRIMARY KEY CLUSTERED
(
[roleid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_setup] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_setup] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_skinclass] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_skinclass] PRIMARY KEY CLUSTERED
(
[classid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_subject] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_subject] PRIMARY KEY CLUSTERED
(
[subjectid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_syslog] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_syslog] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_tags] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_tags] PRIMARY KEY CLUSTERED
(
[TagId]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_team] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_team] PRIMARY KEY CLUSTERED
(
[teamid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_teampost] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_teampost] PRIMARY KEY CLUSTERED
(
[postid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_teamskin] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_teamskin] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_teamusers] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_teamusers] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_trackback] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_trackback] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_upfile] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_upfile] PRIMARY KEY CLUSTERED
(
[fileid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_url] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_url] PRIMARY KEY CLUSTERED
(
[urlid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_user] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_user] PRIMARY KEY CLUSTERED
(
[userid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_userclass] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_userclass] PRIMARY KEY CLUSTERED
(
[classid]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_userdigg] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_userdigg] PRIMARY KEY CLUSTERED
(
[diggID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_userdir] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_userdir] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_userskin] WITH NOCHECK ADD
CONSTRAINT [PK_oblog_userskin] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO
ALTER TABLE [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
ALTER TABLE [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
CREATE INDEX [Index_usertags_logId] ON [dbo].[oBlog_usertags]([logid]) ON [PRIMARY]
GO
CREATE INDEX [Index_usertags_tagid] ON [dbo].[oBlog_usertags]([TagId]) ON [PRIMARY]
GO
CREATE INDEX [Index_usertags_UserId] ON [dbo].[oBlog_usertags]([Userid]) ON [PRIMARY]
GO
CREATE INDEX [iNum] ON [dbo].[oBlog_usertags]([iNum]) ON [PRIMARY]
GO
CREATE INDEX [logid] ON [dbo].[oBlog_usertags]([logid]) ON [PRIMARY]
GO
CREATE INDEX [TagId] ON [dbo].[oBlog_usertags]([TagId]) ON [PRIMARY]
GO
CREATE INDEX [Userid] ON [dbo].[oBlog_usertags]([Userid]) ON [PRIMARY]
GO
CREATE INDEX [UserTagid] ON [dbo].[oBlog_usertags]([UserTagid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [Index_Album_userID] ON [dbo].[oblog_Album]([userID]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_TeamID] ON [dbo].[oblog_Album]([TeamID]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_sysClassId] ON [dbo].[oblog_Album]([sysClassId]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_userClassId] ON [dbo].[oblog_Album]([userClassId]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_fileID] ON [dbo].[oblog_Album]([fileID]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_commentnum] ON [dbo].[oblog_Album]([commentnum]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_isencomment] ON [dbo].[oblog_Album]([isencomment]) ON [PRIMARY]
GO
CREATE INDEX [Index_Album_views] ON [dbo].[oblog_Album]([views]) ON [PRIMARY]
GO
CREATE INDEX [Index_log_Is_Album_default] ON [dbo].[oblog_Album]([Is_Album_default]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [Index_AlbumComment_mainid] ON [dbo].[oblog_AlbumComment]([mainid]) ON [PRIMARY]
GO
CREATE INDEX [Index_AlbumComment_userid] ON [dbo].[oblog_AlbumComment]([userid]) ON [PRIMARY]
GO
CREATE INDEX [Index_AlbumComment_teamid] ON [dbo].[oblog_AlbumComment]([teamid]) ON [PRIMARY]
GO
ALTER TABLE [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
ALTER TABLE [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
ALTER TABLE [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
CREATE INDEX [id] ON [dbo].[oblog_admin]([id]) ON [PRIMARY]
GO
CREATE INDEX [pid] ON [dbo].[oblog_admin]([username]) ON [PRIMARY]
GO
CREATE INDEX [roleid] ON [dbo].[oblog_admin]([roleid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [argueid] ON [dbo].[oblog_argue]([argueid]) ON [PRIMARY]
GO
CREATE INDEX [idays] ON [dbo].[oblog_argue]([idays]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_argue]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [argueid] ON [dbo].[oblog_arguelist]([argueid]) ON [PRIMARY]
GO
CREATE INDEX [id] ON [dbo].[oblog_arguelist]([id]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_arguelist]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [ispass] ON [dbo].[oblog_blogstar]([ispass]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [mainuserid] ON [dbo].[oblog_blogteam]([mainuserid]) ON [PRIMARY]
GO
CREATE INDEX [otheruserid] ON [dbo].[oblog_blogteam]([otheruserid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [userid] ON [dbo].[oblog_calendar]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [commentid] ON [dbo].[oblog_comment]([commentid]) ON [PRIMARY]
GO
CREATE INDEX [mainid] ON [dbo].[oblog_comment]([mainid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_comment]([userid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_config] ADD
CONSTRAINT [DF__oblog_config__id__1BFD2C07] DEFAULT (0) FOR [id]
GO
CREATE INDEX [id] ON [dbo].[oblog_config]([id]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [Index_digg_userID] ON [dbo].[oblog_digg]([userID]) ON [PRIMARY]
GO
CREATE INDEX [Index_digg_diggid] ON [dbo].[oblog_digg]([diggid]) ON [PRIMARY]
GO
CREATE INDEX [Index_digg_logid] ON [dbo].[oblog_digg]([logid]) ON [PRIMARY]
GO
CREATE INDEX [Index_digg_authorid] ON [dbo].[oblog_digg]([authorid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [firendid] ON [dbo].[oblog_friend]([id]) ON [PRIMARY]
GO
CREATE INDEX [friendid] ON [dbo].[oblog_friend]([friendid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_friend]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [ordernum] ON [dbo].[oblog_friendurl]([ordernum]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_friendurl]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [groupid] ON [dbo].[oblog_groups]([groupid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [addtime] ON [dbo].[oblog_log]([addtime]) ON [PRIMARY]
GO
CREATE INDEX [authorid] ON [dbo].[oblog_log]([authorid]) ON [PRIMARY]
GO
CREATE INDEX [classid] ON [dbo].[oblog_log]([classid]) ON [PRIMARY]
GO
CREATE INDEX [isbest] ON [dbo].[oblog_log]([isbest]) ON [PRIMARY]
GO
CREATE INDEX [isdraft] ON [dbo].[oblog_log]([isdraft]) ON [PRIMARY]
GO
CREATE INDEX [ishide] ON [dbo].[oblog_log]([ishide]) ON [PRIMARY]
GO
CREATE INDEX [istop] ON [dbo].[oblog_log]([istop]) ON [PRIMARY]
GO
CREATE INDEX [logid] ON [dbo].[oblog_log]([logid]) ON [PRIMARY]
GO
CREATE INDEX [logTagsId] ON [dbo].[oblog_log]([logTagsId]) ON [PRIMARY]
GO
CREATE INDEX [passcheck] ON [dbo].[oblog_log]([passcheck]) ON [PRIMARY]
GO
CREATE INDEX [specialid] ON [dbo].[oblog_log]([specialid]) ON [PRIMARY]
GO
CREATE INDEX [subjectid] ON [dbo].[oblog_log]([subjectid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_log]([userid]) ON [PRIMARY]
GO
CREATE INDEX [Index_log_classid] ON [dbo].[oblog_log]([IsSpecial]) ON [PRIMARY]
GO
CREATE INDEX [Index_log_diggNum] ON [dbo].[oblog_log]([diggNum]) ON [PRIMARY]
GO
CREATE INDEX [Index_log_ViewGroupId] ON [dbo].[oblog_log]([ViewGroupId]) ON [PRIMARY]
GO
CREATE INDEX [Index_log_is_log_default_hidden] ON [dbo].[oblog_log]([is_log_default_hidden]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE UNIQUE INDEX [id] ON [dbo].[oblog_logclass]([id]) ON [PRIMARY]
GO
CREATE INDEX [classid] ON [dbo].[oblog_logclass]([classid]) ON [PRIMARY]
GO
CREATE INDEX [classlognum] ON [dbo].[oblog_logclass]([classlognum]) ON [PRIMARY]
GO
CREATE INDEX [idType] ON [dbo].[oblog_logclass]([idType]) ON [PRIMARY]
GO
CREATE INDEX [nextid] ON [dbo].[oblog_logclass]([nextid]) ON [PRIMARY]
GO
CREATE INDEX [orderid] ON [dbo].[oblog_logclass]([orderid]) ON [PRIMARY]
GO
CREATE INDEX [ordernum] ON [dbo].[oblog_logclass]([ordernum]) ON [PRIMARY]
GO
CREATE INDEX [ParentID] ON [dbo].[oblog_logclass]([parentid]) ON [PRIMARY]
GO
CREATE INDEX [previd] ON [dbo].[oblog_logclass]([previd]) ON [PRIMARY]
GO
CREATE INDEX [rootid] ON [dbo].[oblog_logclass]([rootid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [id] ON [dbo].[oblog_logvotes]([id]) ON [PRIMARY]
GO
CREATE INDEX [logid] ON [dbo].[oblog_logvotes]([logid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_logvotes]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [userid] ON [dbo].[oblog_message]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [id] ON [dbo].[oblog_myurl]([id]) ON [PRIMARY]
GO
CREATE INDEX [urlid] ON [dbo].[oblog_myurl]([urlid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_myurl]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [obcode] ON [dbo].[oblog_obcodes]([obcode]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [pid] ON [dbo].[oblog_pm]([pid]) ON [PRIMARY]
GO
CREATE INDEX [sender] ON [dbo].[oblog_pm]([sender], [incept], [isreaded], [delR], [delS]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [roleid] ON [dbo].[oblog_roles]([roleid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [show_blogupdate_num] ON [dbo].[oblog_setup]([comment_count]) ON [PRIMARY]
GO
CREATE INDEX [siterefu_num] ON [dbo].[oblog_setup]([user_count]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [classid] ON [dbo].[oblog_skinclass]([classid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [ordernum] ON [dbo].[oblog_subject]([ordernum]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_subject]([userid]) ON [PRIMARY]
GO
CREATE INDEX [Index_subject_subjectType] ON [dbo].[oblog_subject]([subjectType]) ON [PRIMARY]
GO
CREATE INDEX [Index_subject_ishide] ON [dbo].[oblog_subject]([ishide]) ON [PRIMARY]
GO
CREATE INDEX [Index_subject_views] ON [dbo].[oblog_subject]([views]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_syslog] ADD
CONSTRAINT [DF__oblog_sys__itype__2B0A656D] DEFAULT (0) FOR [itype]
GO
CREATE INDEX [id] ON [dbo].[oblog_syslog]([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_sysskin] ADD
CONSTRAINT [DF__oblog_sys__isdef__2CF2ADDF] DEFAULT (0) FOR [isdefault]
GO
CREATE INDEX [id] ON [dbo].[oblog_sysskin]([id]) ON [PRIMARY]
GO
CREATE INDEX [isdefault] ON [dbo].[oblog_sysskin]([isdefault]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [Index_tags_tagid] ON [dbo].[oblog_tags]([TagId]) ON [PRIMARY]
GO
CREATE INDEX [iNum] ON [dbo].[oblog_tags]([iNum]) ON [PRIMARY]
GO
CREATE INDEX [TagId] ON [dbo].[oblog_tags]([TagId]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [classid] ON [dbo].[oblog_team]([classid]) ON [PRIMARY]
GO
CREATE INDEX [createrid] ON [dbo].[oblog_team]([createrid]) ON [PRIMARY]
GO
CREATE INDEX [teamid] ON [dbo].[oblog_team]([teamid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [parentid] ON [dbo].[oblog_teampost]([parentid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_teampost]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [Index_teamskin_classid] ON [dbo].[oblog_teamskin]([classid]) ON [PRIMARY]
GO
CREATE INDEX [Index_teamskin_isdefault] ON [dbo].[oblog_teamskin]([isdefault]) ON [PRIMARY]
GO
CREATE INDEX [Index_teamskin_ispass] ON [dbo].[oblog_teamskin]([ispass]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [ID] ON [dbo].[oblog_teamusers]([ID]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [blogid] ON [dbo].[oblog_trackback]([logid]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_trackback]([userid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [logid] ON [dbo].[oblog_upfile]([logid]) ON [PRIMARY]
GO
CREATE INDEX [sysClassid] ON [dbo].[oblog_upfile]([sysClassId]) ON [PRIMARY]
GO
CREATE INDEX [userClassId] ON [dbo].[oblog_upfile]([userClassId]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_upfile]([userid], [isphoto], [issave]) ON [PRIMARY]
GO
CREATE INDEX [viewNum] ON [dbo].[oblog_upfile]([viewNum]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [urlid] ON [dbo].[oblog_url]([urlid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [emailValid] ON [dbo].[oblog_user]([emailValid]) ON [PRIMARY]
GO
CREATE INDEX [lastcode] ON [dbo].[oblog_user]([lastcode]) ON [PRIMARY]
GO
CREATE INDEX [roleid] ON [dbo].[oblog_user]([roleid]) ON [PRIMARY]
GO
CREATE INDEX [sub_num] ON [dbo].[oblog_user]([sub_num]) ON [PRIMARY]
GO
CREATE INDEX [user_domain] ON [dbo].[oblog_user]([user_domain] DESC ) ON [PRIMARY]
GO
CREATE INDEX [user_domainroot] ON [dbo].[oblog_user]([user_domainroot], [lockuser], [user_classid], [user_level], [username]) ON [PRIMARY]
GO
CREATE INDEX [user_photorow_num] ON [dbo].[oblog_user]([user_photorow_num]) ON [PRIMARY]
GO
CREATE INDEX [userid] ON [dbo].[oblog_user]([userid]) ON [PRIMARY]
GO
CREATE INDEX [Index_user_diggs] ON [dbo].[oblog_user]([diggs]) ON [PRIMARY]
GO
CREATE INDEX [Index_user_passport_userid] ON [dbo].[oblog_user]([passport_userid]) ON [PRIMARY]
GO
CREATE INDEX [Index_log_is_log_default_hidden] ON [dbo].[oblog_user]([is_log_default_hidden]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE UNIQUE INDEX [id] ON [dbo].[oblog_userclass]([id]) ON [PRIMARY]
GO
CREATE INDEX [classid] ON [dbo].[oblog_userclass]([classid]) ON [PRIMARY]
GO
CREATE INDEX [classlognum] ON [dbo].[oblog_userclass]([classlognum]) ON [PRIMARY]
GO
CREATE INDEX [idType] ON [dbo].[oblog_userclass]([idType]) ON [PRIMARY]
GO
CREATE INDEX [nextid] ON [dbo].[oblog_userclass]([nextid]) ON [PRIMARY]
GO
CREATE INDEX [orderid] ON [dbo].[oblog_userclass]([orderid]) ON [PRIMARY]
GO
CREATE INDEX [ordernum] ON [dbo].[oblog_userclass]([ordernum]) ON [PRIMARY]
GO
CREATE INDEX [ParentID] ON [dbo].[oblog_userclass]([parentid]) ON [PRIMARY]
GO
CREATE INDEX [previd] ON [dbo].[oblog_userclass]([previd]) ON [PRIMARY]
GO
CREATE INDEX [rootid] ON [dbo].[oblog_userclass]([rootid]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [Index_userdigg_diggnum] ON [dbo].[oblog_userdigg]([diggnum]) ON [PRIMARY]
GO
CREATE INDEX [Index_userdigg_logid] ON [dbo].[oblog_userdigg]([logid]) ON [PRIMARY]
GO
CREATE INDEX [Index_userdigg_authorid] ON [dbo].[oblog_userdigg]([authorid]) ON [PRIMARY]
GO
CREATE INDEX [Index_userdigg_classid] ON [dbo].[oblog_userdigg]([classid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[oblog_userdir] ADD
CONSTRAINT [DF__oblog_use__is_de__0C50D423] DEFAULT (0) FOR [is_default]
GO
CREATE INDEX [ID] ON [dbo].[oblog_userdir]([ID]) ON [PRIMARY]
GO
CREATE INDEX [is_default] ON [dbo].[oblog_userdir]([is_default]) ON [PRIMARY]
GO
ALTER TABLE [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
CREATE INDEX [classid] ON [dbo].[oblog_userskin]([classid]) ON [PRIMARY]
GO
CREATE INDEX [id] ON [dbo].[oblog_userskin]([id]) ON [PRIMARY]
GO
CREATE INDEX [isdefault] ON [dbo].[oblog_userskin]([isdefault]) ON [PRIMARY]
GO
CREATE INDEX [ispass] ON [dbo].[oblog_userskin]([ispass]) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [ob_calendar]
@logdate smalldatetime,
@userid int
AS
SELECT addtime ,logfile
FROM oblog_log
WHERE datediff(n,@logdate,addtime)>0 and userid=@userid
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
© 版权声明
文章版权归作者所有，未经允许请勿转载。
