gusucode.com > 36624教学课件教案试题综合管理平台 1.5源码程序 > 网站文件/Install/up11_15.txt

    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)