﻿if exists (select * from dbo.sysobjects where id = object_id(N'[admin_g_s]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [admin_g_s]


if exists (select * from dbo.sysobjects where id = object_id(N'[caiji]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [caiji]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbfADMIN_1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbfADMIN_1]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_168reg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_168reg]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_ad]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_cj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_cj]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_ic]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_ic]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_pay_c]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_pay_c]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_sc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_sc]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_sm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_sm]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_sp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_sp]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbf_spm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbf_spm]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbfress]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbfress]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbftype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbftype]


if exists (select * from dbo.sysobjects where id = object_id(N'[cbfusers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [cbfusers]


if exists (select * from dbo.sysobjects where id = object_id(N'[fengge]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [fengge]


if exists (select * from dbo.sysobjects where id = object_id(N'[help]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [help]


if exists (select * from dbo.sysobjects where id = object_id(N'[home]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [home]


if exists (select * from dbo.sysobjects where id = object_id(N'[login]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [login]


if exists (select * from dbo.sysobjects where id = object_id(N'[movie]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [movie]


if exists (select * from dbo.sysobjects where id = object_id(N'[movielook]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [movielook]


if exists (select * from dbo.sysobjects where id = object_id(N'[movieserver]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [movieserver]


if exists (select * from dbo.sysobjects where id = object_id(N'[movietxt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [movietxt]


if exists (select * from dbo.sysobjects where id = object_id(N'[movieurl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [movieurl]


if exists (select * from dbo.sysobjects where id = object_id(N'[play]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [play]


if exists (select * from dbo.sysobjects where id = object_id(N'[user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [user]


if exists (select * from dbo.sysobjects where id = object_id(N'[vote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [vote]


CREATE TABLE [admin_g_s] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[admin_id] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[goip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[count] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[postdate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [caiji] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[webname] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[weburl] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[caiconten] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[leover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[gotocaiji] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playurls] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[idurl] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[idpm] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[id1] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[id2] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjtf] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[vip] [int] NULL ,
	[hits] [int] NULL ,
	[server1] [int] NULL ,
	[look] [int] NULL ,
	[gud] [int] NULL ,
	[list] [int] NULL ,
	[movieb] [int] NOT NULL ,
	[userid] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[exhibition] [datetime] NULL ,
	[stanrting] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[how] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[play] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[canlook] [int] NULL ,
	[ress] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbftype] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[keywords] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playurlstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playurlover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playforover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playforstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ctypeforstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ctypeforover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ressforstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ressforover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[movcontenover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[movcontenstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[imgstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[imgover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[yianover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[yianstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[titestart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[titeover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[lianover] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[lianstart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[lestart] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[playsok] [int] NULL ,
	[cjgotoname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotonames] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotourl] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotopwss] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotopwsss] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotosubmit] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotoabc] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotoabcs] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotoabcy] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgotoabcurl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cjgoto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [cbfADMIN_1] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[a] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[b] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[d] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[e] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[f] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[g] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[h] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[i] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[j] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[k] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[l] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[n] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[m] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[1] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[2] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[3] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[4] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[5] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[6] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[7] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[8] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[9] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbf001A_D_M_I_N] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbfADM_n_id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[admin1] [int] NULL ,
	[admin2] [int] NULL ,
	[admin3] [int] NULL ,
	[admin4] [int] NULL ,
	[admin5] [int] NULL ,
	[admin6] [int] NULL ,
	[admin7] [int] NULL ,
	[admin8] [int] NULL ,
	[admin9] [int] NULL ,
	[admin202] [int] NULL ,
	[admin201] [int] NULL ,
	[admin203] [int] NULL ,
	[admin200] [int] NULL ,
	[admin109] [int] NULL ,
	[admin108] [int] NULL ,
	[admin107] [int] NULL ,
	[admin106] [int] NULL ,
	[admin105] [int] NULL ,
	[admin104] [int] NULL ,
	[admin103] [int] NULL ,
	[admin102] [int] NULL ,
	[admin101] [int] NULL ,
	[admin10] [int] NULL ,
	[datetime] [datetime] NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_168reg] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[reg_userid] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[paykey] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[receive_url] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_ad] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[ad17] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad16] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad15] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad14] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad13] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad12] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad11] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad1] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad9] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad8] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad7] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad6] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad5] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad4] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad3] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad2] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ad10] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_cj] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[cname] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[curl] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [datetime] NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_ic] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[movieic] [int] NULL ,
	[moviepw] [int] NULL ,
	[moviedayb] [int] NULL ,
	[userid] [int] NULL ,
	[money] [int] NULL ,
	[times] [datetime] NULL ,
	[list] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_pay_c] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[cbf_m] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbf_b] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbf_day] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bay_h] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbf_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[list] [int] NULL ,
	[times] [datetime] NULL ,
	[ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pay] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[user] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pcs] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_sc] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [datetime] NULL ,
	[movie] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[movieid] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_sm] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sm_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sm_content] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [datetime] NULL ,
	[list] [int] NULL ,
	[for_name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_sp] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[pc] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[list] [int] NULL ,
	[times] [datetime] NULL 
) ON [PRIMARY]


CREATE TABLE [cbf_spm] (
	[cid] [int] NULL ,
	[spm] [int] NULL ,
	[times] [datetime] NULL ,
	[list] [int] NULL ,
	[spname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[isok] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [cbfress] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[nameress] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[look] [int] NULL ,
	[top] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [cbftype] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[movie_type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[index_type] [int] NULL ,
	[movie_type_img] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[type_images] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[movie_url] [int] NULL ,
	[url_1] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[url_2] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[classid] [int] NULL ,
	[movie_b] [int] NULL ,
	[fontcolor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[time_type] [datetime] NULL ,
	[look] [int] NULL ,
	[top] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [cbfusers] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[users] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[userpay] [int] NULL ,
	[xuvod] [int] NULL ,
	[plays] [int] NULL ,
	[downs] [int] NULL ,
	[list] [int] NULL ,
	[times] [datetime] NULL ,
	[date19] [int] NULL ,
	[date18] [int] NULL ,
	[date17] [int] NULL ,
	[date16] [int] NULL ,
	[date15] [int] NULL ,
	[date14] [int] NULL ,
	[date13] [int] NULL ,
	[date12] [int] NULL ,
	[date11] [int] NULL ,
	[date24] [int] NULL ,
	[date23] [int] NULL ,
	[date22] [int] NULL ,
	[date21] [int] NULL ,
	[date20] [int] NULL ,
	[date10] [int] NULL ,
	[date9] [int] NULL ,
	[date8] [int] NULL ,
	[date7] [int] NULL ,
	[date6] [int] NULL ,
	[date5] [int] NULL ,
	[date4] [int] NULL ,
	[date3] [int] NULL ,
	[date2] [int] NULL ,
	[date1] [int] NULL ,
	[dayplay] [int] NULL ,
	[daydown] [int] NULL ,
	[vip] [int] NULL ,
	[paycontent] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[payd] [int] NULL ,
	[paym] [int] NULL ,
	[pc] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [fengge] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ok] [datetime] NULL ,
	[css] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[index1] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[index] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[down1] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[down] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[movie1] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[movie] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[css1] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[top1] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[top] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[time] [datetime] NULL 
) ON [PRIMARY]


CREATE TABLE [help] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[helpname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[helpconten] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [datetime] NULL ,
	[list] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [home] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[icp] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[sshop] [int] NULL ,
	[shoptime] [int] NULL ,
	[freemovie] [int] NULL ,
	[reg4] [int] NULL ,
	[reg3] [int] NULL ,
	[reg1] [int] NULL ,
	[reg2] [int] NULL ,
	[upfile] [int] NULL ,
	[rege] [int] NULL ,
	[regz] [int] NULL ,
	[ipshop] [int] NULL ,
	[regsms] [int] NULL ,
	[regemail] [int] NULL ,
	[emailsys] [int] NULL ,
	[ah] [int] NULL ,
	[regfor] [int] NULL ,
	[smtpgo] [int] NULL ,
	[movieplay] [int] NULL ,
	[freeuser] [int] NULL ,
	[downbt] [int] NULL ,
	[downmovie] [int] NULL ,
	[moviead] [int] NULL ,
	[list] [int] NULL ,
	[movieaduser] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[html] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq4] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq3] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq2] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq1] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[smtppwss] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[smtpname] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[smtpsys] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[shopreg] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [datetime] NULL ,
	[regsmsconten] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[regzconten] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[regeconten] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[regconten] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[btsize] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[imgsize] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[imgname] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[btname] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[bt] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[img] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[metakey] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[metamiao] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[freeconten] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[sfor] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[sto] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[for] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[to] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[listhtml] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[nameurl] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[keywords] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[names] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[vod2008z] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[splist] [int] NULL ,
	[sp_m] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sysuf2] [int] NULL ,
	[sysuf1] [int] NULL ,
	[sysuf3] [int] NULL ,
	[sysuf] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [login] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[user] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gototime] [datetime] NULL ,
	[ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [movie] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[caijiname] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[caijiurl] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[keywords] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbftype] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ress] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[canlook] [int] NULL ,
	[play] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[how] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[stanrting] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[exhibition] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[spy] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[movieb] [int] NULL ,
	[userid] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[content] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
	[list] [int] NULL ,
	[gud] [int] NULL ,
	[times] [datetime] NULL ,
	[look] [int] NULL ,
	[movieserver] [int] NULL ,
	[server6] [int] NULL ,
	[server5] [int] NULL ,
	[server4] [int] NULL ,
	[server3] [int] NULL ,
	[server2] [int] NULL ,
	[server1] [int] NULL ,
	[hits] [int] NULL ,
	[imgurl] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[bturl] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[vip] [int] NULL ,
	[caiji] [int] NULL ,
	[moviecbf001paly] [int] NULL ,
	[playsok] [int] NULL ,
	[caijicid] [int] NULL ,
	[cjgoto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [movielook] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[times] [datetime] NULL ,
	[key] [datetime] NULL ,
	[list] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[moviename] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[movieid] [int] NULL 
) ON [PRIMARY]


CREATE TABLE [movieserver] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[server6] [nvarchar] (2500) COLLATE Chinese_PRC_CI_AS NULL ,
	[server5] [nvarchar] (2500) COLLATE Chinese_PRC_CI_AS NULL ,
	[server4] [nvarchar] (2500) COLLATE Chinese_PRC_CI_AS NULL ,
	[server3] [nvarchar] (2500) COLLATE Chinese_PRC_CI_AS NULL ,
	[server2] [nvarchar] (2500) COLLATE Chinese_PRC_CI_AS NULL ,
	[server1] [nvarchar] (2500) COLLATE Chinese_PRC_CI_AS NULL ,
	[list] [int] NULL ,
	[movieservertime] [datetime] NULL ,
	[cbf001iis] [int] NULL ,
	[downiis] [int] NULL ,
	[userurl] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [movietxt] (
	[cbf001movieid] [int] IDENTITY (1, 1) NOT NULL ,
	[userid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[time] [datetime] NULL ,
	[movienames] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[movietextid] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbf001movietext] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [movieurl] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[nameid] [int] NULL ,
	[url] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [play] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[list] [int] NULL ,
	[width] [int] NULL ,
	[height] [int] NULL ,
	[gud] [int] NULL ,
	[time] [datetime] NULL ,
	[content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[content2] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


CREATE TABLE [user] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[qq] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sex] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[web] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[home] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
	[singned] [nvarchar] (260) COLLATE Chinese_PRC_CI_AS NULL ,
	[introduction] [nvarchar] (260) COLLATE Chinese_PRC_CI_AS NULL ,
	[userid] [int] NULL ,
	[usertime] [datetime] NULL ,
	[shoptime] [datetime] NULL ,
	[sp] [int] NULL ,
	[goto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ipto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gotime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lookto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[looktime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lookmovie] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lookip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[downto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[downtime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[downip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[foruser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[spuser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[year] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[month] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[day] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[timeto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[movieb] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cookn] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[spm] [int] NULL ,
	[emailuser] [int] NULL ,
	[downmovie] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ipint] [int] NULL ,
	[sip1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sip2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]


CREATE TABLE [vote] (
	[cid] [int] IDENTITY (1, 1) NOT NULL ,
	[votename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[c_int] [int] NULL 
) ON [PRIMARY]


ALTER TABLE [admin_g_s] WITH NOCHECK ADD 
	CONSTRAINT [PK_admin_g_s] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 


ALTER TABLE [caiji] WITH NOCHECK ADD 
	CONSTRAINT [PK_caiji] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbfADMIN_1] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbfADMIN_1] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_168reg] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_168reg] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_ad] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_ad] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_cj] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_cj] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_ic] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_ic] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_pay_c] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_pay_c] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_sc] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_sc] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_sm] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_sm] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbf_sp] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbf_sp] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbfress] WITH NOCHECK ADD 
	CONSTRAINT [PK_ress] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [cbfusers] WITH NOCHECK ADD 
	CONSTRAINT [PK_cbfusers] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [fengge] WITH NOCHECK ADD 
	CONSTRAINT [PK_fengge] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [help] WITH NOCHECK ADD 
	CONSTRAINT [PK_help] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [home] WITH NOCHECK ADD 
	CONSTRAINT [PK_home] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [login] WITH NOCHECK ADD 
	CONSTRAINT [PK_login] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [movie] WITH NOCHECK ADD 
	CONSTRAINT [PK_movie] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [movielook] WITH NOCHECK ADD 
	CONSTRAINT [PK_movielook] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [movieserver] WITH NOCHECK ADD 
	CONSTRAINT [PK_movieserver] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [movietxt] WITH NOCHECK ADD 
	CONSTRAINT [PK_movietxt] PRIMARY KEY  CLUSTERED 
	(
		[cbf001movieid]
	)  ON [PRIMARY] 


ALTER TABLE [play] WITH NOCHECK ADD 
	CONSTRAINT [PK_play] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [user] WITH NOCHECK ADD 
	CONSTRAINT [PK_user] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [vote] WITH NOCHECK ADD 
	CONSTRAINT [PK_vote] PRIMARY KEY  CLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [admin_g_s] ADD 
	CONSTRAINT [DF_admin_g_s_postdate] DEFAULT (getdate()) FOR [postdate]


ALTER TABLE [caiji] ADD 
	CONSTRAINT [DF_caiji_exhibition] DEFAULT (getdate()) FOR [exhibition],
	CONSTRAINT [DF_caiji_playsok] DEFAULT (0) FOR [playsok]


ALTER TABLE [cbfADMIN_1] ADD 
	CONSTRAINT [DF_cbfADMIN_1_a] DEFAULT (0) FOR [a],
	CONSTRAINT [DF_cbfADMIN_1_b] DEFAULT (0) FOR [b],
	CONSTRAINT [DF_cbfADMIN_1_c] DEFAULT (0) FOR [c],
	CONSTRAINT [DF_cbfADMIN_1_d] DEFAULT (0) FOR [d],
	CONSTRAINT [DF_cbfADMIN_1_e] DEFAULT (0) FOR [e],
	CONSTRAINT [DF_cbfADMIN_1_f] DEFAULT (0) FOR [f],
	CONSTRAINT [DF_cbfADMIN_1_g] DEFAULT (0) FOR [g],
	CONSTRAINT [DF_cbfADMIN_1_h] DEFAULT (0) FOR [h],
	CONSTRAINT [DF_cbfADMIN_1_i] DEFAULT (0) FOR [i],
	CONSTRAINT [DF_cbfADMIN_1_j] DEFAULT (0) FOR [j],
	CONSTRAINT [DF_cbfADMIN_1_k] DEFAULT (0) FOR [k],
	CONSTRAINT [DF_cbfADMIN_1_l] DEFAULT (0) FOR [l],
	CONSTRAINT [DF_cbfADMIN_1_n] DEFAULT (0) FOR [n],
	CONSTRAINT [DF_cbfADMIN_1_m] DEFAULT (0) FOR [m],
	CONSTRAINT [DF_cbfADMIN_1_1] DEFAULT (0) FOR [1],
	CONSTRAINT [DF_cbfADMIN_1_2] DEFAULT (0) FOR [2],
	CONSTRAINT [DF_cbfADMIN_1_3] DEFAULT (0) FOR [3],
	CONSTRAINT [DF_cbfADMIN_1_4] DEFAULT (0) FOR [4],
	CONSTRAINT [DF_cbfADMIN_1_5] DEFAULT (0) FOR [5],
	CONSTRAINT [DF_cbfADMIN_1_6] DEFAULT (0) FOR [6],
	CONSTRAINT [DF_cbfADMIN_1_7] DEFAULT (0) FOR [7],
	CONSTRAINT [DF_cbfADMIN_1_8] DEFAULT (0) FOR [8],
	CONSTRAINT [DF_cbfADMIN_1_9] DEFAULT (0) FOR [9],
	CONSTRAINT [DF_cbfADMIN_1_admin1] DEFAULT (0) FOR [admin1],
	CONSTRAINT [DF_cbfADMIN_1_admin2] DEFAULT (0) FOR [admin2],
	CONSTRAINT [DF_cbfADMIN_1_admin3] DEFAULT (0) FOR [admin3],
	CONSTRAINT [DF_cbfADMIN_1_admin4] DEFAULT (0) FOR [admin4],
	CONSTRAINT [DF_cbfADMIN_1_admin5] DEFAULT (0) FOR [admin5],
	CONSTRAINT [DF_cbfADMIN_1_admin6] DEFAULT (0) FOR [admin6],
	CONSTRAINT [DF_cbfADMIN_1_admin7] DEFAULT (0) FOR [admin7],
	CONSTRAINT [DF_cbfADMIN_1_admin8] DEFAULT (0) FOR [admin8],
	CONSTRAINT [DF_cbfADMIN_1_admin9] DEFAULT (0) FOR [admin9],
	CONSTRAINT [DF_cbfADMIN_1_admin2011] DEFAULT (0) FOR [admin202],
	CONSTRAINT [DF_cbfADMIN_1_admin2001_1] DEFAULT (0) FOR [admin201],
	CONSTRAINT [DF_cbfADMIN_1_admin2001] DEFAULT (0) FOR [admin203],
	CONSTRAINT [DF_cbfADMIN_1_admin1010] DEFAULT (0) FOR [admin200],
	CONSTRAINT [DF_cbfADMIN_1_admin109] DEFAULT (0) FOR [admin109],
	CONSTRAINT [DF_cbfADMIN_1_admin108] DEFAULT (0) FOR [admin108],
	CONSTRAINT [DF_cbfADMIN_1_admin107] DEFAULT (0) FOR [admin107],
	CONSTRAINT [DF_cbfADMIN_1_admin106] DEFAULT (0) FOR [admin106],
	CONSTRAINT [DF_cbfADMIN_1_admin105] DEFAULT (0) FOR [admin105],
	CONSTRAINT [DF_cbfADMIN_1_admin104] DEFAULT (0) FOR [admin104],
	CONSTRAINT [DF_cbfADMIN_1_admin103] DEFAULT (0) FOR [admin103],
	CONSTRAINT [DF_cbfADMIN_1_admin102] DEFAULT (0) FOR [admin102],
	CONSTRAINT [DF_cbfADMIN_1_admin101] DEFAULT (0) FOR [admin101],
	CONSTRAINT [DF_cbfADMIN_1_admin10] DEFAULT (0) FOR [admin10],
	CONSTRAINT [DF_cbfADMIN_1_datetime] DEFAULT (getdate()) FOR [datetime]


ALTER TABLE [cbf_cj] ADD 
	CONSTRAINT [DF_cbf_cj_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [cbf_ic] ADD 
	CONSTRAINT [DF_cbf_ic_movieic] DEFAULT (0) FOR [movieic],
	CONSTRAINT [DF_cbf_ic_moviepw] DEFAULT (0) FOR [moviepw],
	CONSTRAINT [DF_cbf_ic_times] DEFAULT (getdate()) FOR [times],
	CONSTRAINT [DF_cbf_ic_list] DEFAULT (0) FOR [list]


ALTER TABLE [cbf_pay_c] ADD 
	CONSTRAINT [DF_cbf_pay_c_list] DEFAULT (0) FOR [list],
	CONSTRAINT [DF_cbf_pay_c_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [cbf_sc] ADD 
	CONSTRAINT [DF_cbf_sc_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [cbf_sm] ADD 
	CONSTRAINT [DF_cbf_sm_times] DEFAULT (getdate()) FOR [times],
	CONSTRAINT [DF_cbf_sm_list] DEFAULT (0) FOR [list]


ALTER TABLE [cbf_sp] ADD 
	CONSTRAINT [DF_cbf_sp_list] DEFAULT (0) FOR [list],
	CONSTRAINT [DF_cbf_sp_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [cbf_spm] ADD 
	CONSTRAINT [DF_cbf_spm_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [cbftype] ADD 
	CONSTRAINT [DF_cbftype_classid] DEFAULT (0) FOR [classid],
	CONSTRAINT [DF_cbftype_time_type] DEFAULT (getdate()) FOR [time_type],
	CONSTRAINT [DF_cbftype_top] DEFAULT (0) FOR [top],
	CONSTRAINT [PK_cbftype] PRIMARY KEY  NONCLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


 CREATE  INDEX [IX_cbftype_2] ON [cbftype]([top]) ON [PRIMARY]


 CREATE  INDEX [IX_cbftype] ON [cbftype]([classid]) ON [PRIMARY]


ALTER TABLE [cbfusers] ADD 
	CONSTRAINT [DF_cbfusers_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [fengge] ADD 
	CONSTRAINT [DF_fengge_css] DEFAULT (0) FOR [css],
	CONSTRAINT [DF_fengge_index1] DEFAULT (0) FOR [index1],
	CONSTRAINT [DF_fengge_index] DEFAULT (0) FOR [index],
	CONSTRAINT [DF_fengge_down1] DEFAULT (0) FOR [down1],
	CONSTRAINT [DF_fengge_down] DEFAULT (0) FOR [down],
	CONSTRAINT [DF_fengge_movie1] DEFAULT (0) FOR [movie1],
	CONSTRAINT [DF_fengge_movie] DEFAULT (0) FOR [movie],
	CONSTRAINT [DF_fengge_css1] DEFAULT (0) FOR [css1],
	CONSTRAINT [DF_fengge_top1] DEFAULT (0) FOR [top1],
	CONSTRAINT [DF_fengge_top] DEFAULT (0) FOR [top],
	CONSTRAINT [DF_fengge_time] DEFAULT (getdate()) FOR [time]


ALTER TABLE [help] ADD 
	CONSTRAINT [DF_help_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [home] ADD 
	CONSTRAINT [DF_home_splist] DEFAULT (1) FOR [splist],
	CONSTRAINT [DF_home_sysuf2] DEFAULT (0) FOR [sysuf2],
	CONSTRAINT [DF_home_sysuf1] DEFAULT (0) FOR [sysuf1],
	CONSTRAINT [DF_home_sysuf3] DEFAULT (0) FOR [sysuf3],
	CONSTRAINT [DF_home_sysuf] DEFAULT (0) FOR [sysuf],
	CONSTRAINT [DF_home_times] DEFAULT (getdate()) FOR [times]

ALTER TABLE [login] ADD 
	CONSTRAINT [DF_login_gototime] DEFAULT (getdate()) FOR [gototime]


ALTER TABLE [movie] ADD 
	CONSTRAINT [DF_movie_content] DEFAULT ('暂无') FOR [content],
	CONSTRAINT [DF_movie_times] DEFAULT (getdate()) FOR [times],
	CONSTRAINT [DF_movie_moviecbf001paly] DEFAULT (0) FOR [moviecbf001paly],
	CONSTRAINT [DF_movie_caijicid] DEFAULT (0) FOR [caijicid]


 CREATE  INDEX [IX_movie_1] ON [movie]([hits]) ON [PRIMARY]


 CREATE  INDEX [IX_movie_2] ON [movie]([cbftype]) ON [PRIMARY]


 CREATE  INDEX [IX_movie] ON [movie]([times]) ON [PRIMARY]


ALTER TABLE [movielook] ADD 
	CONSTRAINT [DF_movielook_times] DEFAULT (getdate()) FOR [times]


ALTER TABLE [movieserver] ADD 
	CONSTRAINT [DF_movieserver_list] DEFAULT (0) FOR [list],
	CONSTRAINT [DF_movieserver_movieservertime] DEFAULT (getdate()) FOR [movieservertime],
	CONSTRAINT [DF_movieserver_list2] DEFAULT (0) FOR [cbf001iis],
	CONSTRAINT [DF_movieserver_list1] DEFAULT (0) FOR [downiis]


ALTER TABLE [movietxt] ADD 
	CONSTRAINT [DF_movietxt_time] DEFAULT (getdate()) FOR [time]


ALTER TABLE [movieurl] ADD 
	CONSTRAINT [PK_movieurl] PRIMARY KEY  NONCLUSTERED 
	(
		[cid]
	)  ON [PRIMARY] 


ALTER TABLE [play] ADD 
	CONSTRAINT [DF_play_time] DEFAULT (getdate()) FOR [time]


ALTER TABLE [user] ADD 
	CONSTRAINT [DF_user_userid] DEFAULT (1) FOR [userid],
	CONSTRAINT [DF_user_usertime] DEFAULT (getdate()) FOR [usertime],
	CONSTRAINT [DF_user_shoptime] DEFAULT (getdate()) FOR [shoptime],
	CONSTRAINT [DF_user_sp] DEFAULT (0) FOR [sp],
	CONSTRAINT [DF_user_goto] DEFAULT (0) FOR [goto],
	CONSTRAINT [DF_user_downto] DEFAULT (0) FOR [downto],
	CONSTRAINT [DF_user_movieb] DEFAULT (0) FOR [movieb],
	CONSTRAINT [DF_user_spm] DEFAULT (0) FOR [spm],
	CONSTRAINT [DF_user_emailuser] DEFAULT (0) FOR [emailuser],
	CONSTRAINT [DF_user_ipint] DEFAULT (0) FOR [ipint]


ALTER TABLE [vote] ADD 
	CONSTRAINT [DF_vote_c_int] DEFAULT (0) FOR [c_int]