改正后.sql

医院网站系统

-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2009 年 03 月 03 日 13:53
-- 服务器版本: 5.0.18
-- PHP 版本: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- 数据库: `hostipal`
-- 

-- --------------------------------------------------------

-- 
-- 表的结构 `rooms`
-- 

CREATE TABLE `rooms` (
  `id` int(10) NOT NULL auto_increment,
  `number` varchar(200) character set gb2312 default NULL,
  `roomtype` varchar(200) character set gb2312 default NULL,
  `bedsum` varchar(100) character set gb2312 default NULL,
  `price` varchar(200) character set gb2312 default NULL,
  `address` varchar(700) character set gb2312 default NULL,
  `note` varchar(1000) character set gb2312 default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- 
-- 导出表中的数据 `rooms`
-- 

INSERT INTO `rooms` VALUES (1, 'test', 'test', 'test', 'test', 'test', '中文测试');

-- --------------------------------------------------------

-- 
-- 表的结构 `secker`
-- 

CREATE TABLE `secker` (
  `id` int(10) NOT NULL auto_increment,
  `number` varchar(200) character set gb2312 default NULL,
  `doctor` varchar(200) character set gb2312 default NULL,
  `roomnum` varchar(100) character set gb2312 default NULL,
  `bednum` varchar(100) character set gb2312 default NULL,
  `name` varchar(100) character set gb2312 default NULL,
  `sexy` varchar(40) character set gb2312 default NULL,
  `age` varchar(40) character set gb2312 default NULL,
  `address` varchar(500) character set gb2312 default NULL,
  `tel` varchar(170) character set gb2312 default NULL,
  `sicktype` varchar(500) character set gb2312 default NULL,
  `pill` varchar(500) character set gb2312 default NULL,
  `time` varchar(200) character set gb2312 default NULL,
  `note` varchar(2000) character set gb2312 default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- 导出表中的数据 `secker`
-- 

INSERT INTO `secker` VALUES (1, '0000001', '2', '17#101', '2034', '高峰', '男', '35', '江西南昌', '3301422', '感冒', '青霉素', '2007-7-12', '无');
INSERT INTO `secker` VALUES (2, '0000002', '1', '17#104', '3307', '李四', '女', '25', '江西南昌', '7146582', '感冒', '青霉素', '2007-5-7', '无');
INSERT INTO `secker` VALUES (3, '0000003', '11', '17#104', '3309', '余飞', '女', '5110', '江西南昌', '7146582', '感冒', '青霉素', '2007-5-7', '无');
INSERT INTO `secker` VALUES (4, '0000003', '11', '17#104', '3309', '余飞', '女', '5110', '江西南昌', '7146582', '感冒', '青霉素', '2007-5-7', '无');

-- --------------------------------------------------------

-- 
-- 表的结构 `tools`
-- 

CREATE TABLE `tools` (
  `id` int(10) NOT NULL auto_increment,
  `number` varchar(200) character set gb2312 default NULL,
  `pillinfo` varchar(700) character set gb2312 default NULL,
  `name` varchar(200) character set gb2312 default NULL,
  `price` varchar(100) character set gb2312 default NULL,
  `innumber` varchar(500) character set gb2312 default NULL,
  `note` varchar(2000) character set gb2312 default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- 导出表中的数据 `tools`
-- 


-- --------------------------------------------------------

-- 
-- 表的结构 `worker`
-- 

CREATE TABLE `worker` (
  `id` int(10) NOT NULL auto_increment,
  `number` varchar(200) default NULL,
  `name` varchar(200) default NULL,
  `sexy` varchar(40) default NULL,
  `age` varchar(70) default NULL,
  `do` varchar(1000) default NULL,
  `from` varchar(1000) default NULL,
  `idcard` varchar(200) default NULL,
  `worktime` varchar(300) default NULL,
  `address` varchar(1000) default NULL,
  `tel` varchar(150) default NULL,
  `mail` varchar(500) default NULL,
  `qq` varchar(100) default NULL,
  `income` varchar(100) default NULL,
  `mobile` varchar(13) default NULL,
  `bumen` varchar(500) default NULL,
  `duty` varchar(1000) default NULL,
  `note` varchar(2000) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

-- 
-- 导出表中的数据 `worker`
-- 

INSERT INTO `worker` VALUES (1, '0000001', '飒飒', '女', '19', '护士', '江西', '530016532485756415', '2006-7-7', '南昌市区', '7146726', '[e-mail]', '67588667', '3000', '13988756564', '门诊部', '无', '无');
INSERT INTO `worker` VALUES (2, '0000002', '大师傅', '男', '27', '医生', '江西', '530016532485751234', '2000-6-7', '南昌市区', '7146226', '[e-mail]', '67445667', '5000', '13985875432', '住院部', '无', '无');
INSERT INTO `worker` VALUES (3, '0000003', '簌簌', '男', '22', '医生', '江西', '550016532485751234', '2000-2-7', '南昌市区', '7146246', '[e-mail]', '22245667', '3000', '13985875444', '门诊部', '无', '无');
INSERT INTO `worker` VALUES (4, '0000004', 'DQ', '男', '19', '名医', '江西', '443116532485751234', '2000-9-2', '云南', '7146726', '[e-mail]', '67588667', '7000', '13576117055', '总经理', '无', '嘿嘿，开玩笑的');
INSERT INTO `worker` VALUES (5, '0000005', '印欣', '男', '20', '主任医师', '云南', '530021585123248468', '2007-7-7', '云南', '7146725', '[e-mail]', '67588667', '3000', '13988756564', '手术室', '无', '党员');
INSERT INTO `worker` VALUES (7, '0000010', '董琪', '男', '21', '医生', '云南', '530381198609020075', '2007-7-9', '云南', '7146726', '[e-mail]', '67588667', '5000', '13576117055', '技术部', '无', '无');
INSERT INTO `worker` VALUES (9, '0000007', '郁郁', '女', '19', '护士', '江西', '5110030424325346504', '2007-2-22', '华东交大', '7146726', '[e-mail]', '67588667', '2200', '13778954351', '门诊部', '无', '无');