operator.sql

十分好的一个医院管理系统

CREATE TABLE operator (
	loginname char(10),
	fullname char(10),
	sex float,
	belong char(20),
	password char(20),
	menuright char(60));
INSERT INTO operator VALUES (
	'adm',
	'系统管理员',
	1,
	'数据中心',
	'hishis',
	'111111111111111111111111111111111111111111111111111111111111');
INSERT INTO operator VALUES (
	'lf',
	'黎枫',
	1,
	'主任室',
	'hishis',
	'111111111111111111111111111100001111111000');
INSERT INTO operator VALUES (
	'wxq',
	'温雪琴',
	0,
	'业务科',
	'000',
	'111100010010001011110000000000000000000110');
INSERT INTO operator VALUES (
	'jlf',
	'江龙芳',
	0,
	'业务科',
	'111111',
	'111100010010001011110000000000000000000110');
INSERT INTO operator VALUES (
	'qy',
	'丘英',
	0,
	'财会',
	'5188',
	'111101010000000001111111111111111111111111');
INSERT INTO operator VALUES (
	'lyq',
	'蓝勇强',
	0,
	'医务',
	'333',
	'000000000000000000001111110111111111111111');