createinitialdata.sql

采用Eclispe开发平台

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