CREATE TABLE [dbo].[Kj_JiaoAn] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[jcbb] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[xueke] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[username] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[nianji] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[filetype] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyFrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DefaultPicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hits] [int] NULL ,
	[Downloadurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[kjsize] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Downloadhits] [int] NULL ,
	[rarmima] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CreateTime] [datetime] NULL ,
	[UpdateTime] [datetime] NULL ,
	[Private] [int] NULL ,
	[Rec] [int] NULL ,
	[Status] [int] NULL 
) 

CREATE TABLE [dbo].[Kj_ShiTi] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[jcbb] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[xueke] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[username] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[nianji] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[filetype] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Author] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyFrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DefaultPicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hits] [int] NULL ,
	[Downloadurl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[kjsize] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Downloadhits] [int] NULL ,
	[rarmima] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[CreateTime] [datetime] NULL ,
	[UpdateTime] [datetime] NULL ,
	[Private] [int] NULL ,
	[Rec] [int] NULL ,
	[Status] [int] NULL 
) 

update Kj_zd set name='',px=7,code='shiti',fid=0  where id=8

update Kj_zd set name='̰',px=8,code='jiaoan',fid=0  where id=9

insert into Kj_zd(code,name,fid,px) values ('shuxue','ѧ',2,2)

insert into Kj_zd(code,name,fid,px) values ('yingyu','Ӣ',2,3)

insert into Kj_zd(code,name,fid,px) values ('XinShouKe','ڿ',9,1)

insert into Kj_zd(code,name,fid,px) values ('FuXiKe','ϰ',9,2)

insert into Kj_zd(code,name,fid,px) values ('SuiTangLianXi','ϰ',8,1)

insert into Kj_zd(code,name,fid,px) values ('XiaoJiLianXi','Сϰ',8,2)

insert into Kj_zd(code,name,fid,px) values ('JiaJiangXunLian','ǿѵ',8,3)

insert into Kj_zd(code,name,fid,px) values ('JiZhongKaoShi','п',8,4)

insert into Kj_zd(code,name,fid,px) values ('JiMoKaoShi','ĩ',8,5)
