oblog_4.6_SQL 语句
程序员文章站
2022-07-02 08:58:54
复制代码 代码如下:if exists (select * from dbo.sysobjects where&...
复制代码 代码如下:
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
上一篇： YUV格式及采集、转换