createinitialdata.sql

来自「JAVA编写的远程教育程序,包含了教育学的基本思想和网络应用程序的基本开发模式」· SQL 代码 · 共 12 行

insert into t_school ( SchoolId, SchoolName )
		values( 'CNTR', 'Center School')
go

insert into t_user( UserId, SchoolId, UserName, LoginName, LoginPassword, NeedChangePassword, State, Gender, UserType )
	   values ( 101,'CNTR','Administrator', 'admin', '1111',             'N',             1,    '男', 5)
go

insert into t_administrator ( UserId )
	values(101 )
go