hosinfo.sql

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

CREATE TABLE hosinfo (
	hoscode char(4),
	name char(60),
	district char(24),
	address char(60),
	tele char(18),
	dialno char(8),
	staticip char(12),
	linkman char(16),
	fax char(18),
	bank char(60),
	account char(60),
	accname char(60),
	hostname char(16),
	wbcode char(10),
	pycode char(10),
	stateflag float,
	updateflag char(60));
INSERT INTO hosinfo VALUES (
	'0001',
	'县人民医院',
	'县内',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0002',
	'县中医院',
	'县内',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0003',
	'县骨科医院',
	'县内',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0005',
	'马坡卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0006',
	'沙坡卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0007',
	'珊罗卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0008',
	'平乐卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0009',
	'米场卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0011',
	'温泉卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0012',
	'大桥卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0013',
	'横山卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0014',
	'乌石卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0015',
	'月垌卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0017',
	'良田卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0018',
	'清湖卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0019',
	'古城卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0004',
	'陆城镇医院',
	'市区',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0010',
	'沙湖卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0016',
	'滩面卫生院',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0020',
	'县妇幼医院',
	'县内',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0021',
	'雄忠药店',
	'乡镇',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0022',
	'新洲大药店',
	'市区',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0023',
	'天福堂大药店',
	'市区',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	1,
	'001100101111001100010001111111111111111111111111111111111111');
INSERT INTO hosinfo VALUES (
	'0024',
	'玉林红十字会医院',
	'市区',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	4,
	NULL);