procedure_inittable.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 21 行

USE HOTEL
go
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = 'InitialTable' 
	   AND 	  type = 'P')
    DROP PROCEDURE InitialTable
GO
CREATE PROCEDURE InitialTable
AS
insert into userlist(username,secret,memo) values('admin','admin','系统管理员')
insert into rolelist(rolename,memo) values('系统管理员','具有最高权限')
insert into userroles(userid,roleid) values(1,1)
insert into CountryList(country_name)values('中国')
insert into sexlist(sex_name) values('男')
insert into sexlist(sex_name) values('女')
insert into BedStatus(bedstate_name) values('空闲')
insert into BedStatus(bedstate_name) values('正在使用')
insert into BedStatus(bedstate_name) values('已预定')
insert into BedStatus(bedstate_name) values('已退房')
insert into RoomProperty(roompro_name) values('普通房间')