test.sql

本系统设有管理员

CREATE TABLE [dbo].[Teacher] (
    [Teacherno] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL primary key ,
    [TeaName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [TeaPwd] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [TeaSex] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
    [TeaTelephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [TeaEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [TeaCanAnnounce] [int] NOT NULL ,
    [TeaIntro] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
    [PersonalPage] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [DepartmentNo] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [TitleNo] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [Inline] [int] NULL
) ON [PRIMARY]
insert into teacher values('1','admin','0000','','','',1,'','','','','')
insert into teacher values('2','刘海','1234','男','13154287845','[e-mail]',2,'计算机学院教工篮球队绝对核心','','101','','')
GO