hrsys.sql

本人自己做的简单的宿舍管理系统！！添加删除

/*create table [dbo].[roominfo]
(
roomid char(30) not null,
name1 char(30) not null,
name2 char(30) not null,
name3 char(30) not null,
name4 char(30) not null,
master char(30) not null
);
*/
/*
ceate table [dbo].[fee]
(
 roomid char(30) not null,
master char(30) not null,
mobil char(20) not null,
water int ,
elet int ,
ttm char(30) not null,
hand bit ,
make char(30)
);*/

/*create table [dbo].[trouble]
(
roomid char(30) not null,
master char(30) not null,
mobil char(20) not null,
trouble char(128) not null,
ttm1 char(20) not null,
solve bit,
person char(128),
ttm2 char (20)
);*/
select * from trouble