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)