【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“hospital.sql”一文,供大家参考学习!
-- MySQLAdministrator dump 1.0
--
-- ------------------------------------------------------
-- Server version 4.0.18-max-nt
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `hospital`;
USE `hospital`;
DROP TABLE IF EXISTS `appointment`;
CREATE TABLE `appointment` (
`DID` varchar(5) NOT NULL default '',
`SunA` tinyint(3) unsigned NOT NULL default '0',
`SunP` tinyint(3) unsigned NOT NULL default '0',
`MonA` tinyint(3) unsigned NOT NULL default '0',
`MonP` tinyint(3) unsigned NOT NULL default '0',
`TueA` tinyint(3) unsigned NOT NULL default '0',
`TueP` tinyint(3) unsigned NOT NULL default '0',
`WedA` tinyint(3) unsigned NOT NULL default '0',
`WedP` tinyint(3) unsigned NOT NULL default '0',
`ThuA` tinyint(3) unsigned NOT NULL default '0',
`ThuP` tinyint(3) unsigned NOT NULL default '0',
`FriA` tinyint(3) unsigned NOT NULL default '0',
`FriP` tinyint(3) unsigned NOT NULL default '0',
`SatA` tinyint(3) unsigned NOT NULL default '0',
`SatP` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`DID`)
) TYPE=InnoDB;
INSERT INTO `appointment` (`DID`,`SunA`,`SunP`,`MonA`,`MonP`,`TueA`,`TueP`,`WedA`,`WedP`,`ThuA`,`ThuP`,`FriA`,`FriP`,`SatA`,`SatP`) VALUES ('00001',4,4,4,4,4,4,4,4,4,4,4,4,4,4),('01111',1,2,3,4,5,6,7,8,9,0,12,3,21,10);
DROP TABLE IF EXISTS `curappointment`;
CREATE TABLE `curappointment` (
`DID` varchar(5) NOT NULL default '',
`SunA` tinyint(3) unsigned NOT NULL default '0',
`SunP` tinyint(3) unsigned NOT NULL default '0',
`MonA` tinyint(3) unsigned NOT NULL default '0',
`MonP` tinyint(3) unsigned NOT NULL default '0',
`TueA` tinyint(3) unsigned NOT NULL default '0',
`TueP` tinyint(3) unsigned NOT NULL default '0',
`WedA` tinyint(3) unsigned NOT NULL default '0',
`WedP` tinyint(3) unsigned NOT NULL default '0',
`ThuA` tinyint(3) unsigned NOT NULL default '0',
`ThuP` tinyint(3) unsigned NOT NULL default '0',
`FriA` tinyint(3) unsigned NOT NULL default '0',
`FriP` tinyint(3) unsigned NOT NULL default '0',
`SatA` tinyint(3) unsigned NOT NULL default '0',
`SatP` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`DID`)
) TYPE=InnoDB;
INSERT INTO `curappointment` (`DID`,`SunA`,`SunP`,`MonA`,`MonP`,`TueA`,`TueP`,`WedA`,`WedP`,`ThuA`,`ThuP`,`FriA`,`FriP`,`SatA`,`SatP`) VALUES ('00001',4,3,4,4,4,4,4,4,4,3,4,4,3,4),('01111',1,2,3,4,5,5,6,8,9,0,12,3,21,10);
DROP TABLE IF EXISTS `doctor`;
CREATE TABLE `doctor` (
`DID` varchar(5) NOT NULL default '',
`Name` varchar(12) NOT NULL default '',
`Password` varchar(20) NOT NULL default '',
`Age` tinyint(3) unsigned NOT NULL default '1',
`Sex` tinyint(1) unsigned NOT NULL default '0',
`Level` varchar(12) NOT NULL default '',
`Section` varchar(20) NOT NULL default '',
`Specialism` varchar(20) NOT NULL default '',
`Phone` varchar(15) default '',
PRIMARY KEY (`DID`),
KEY `Section` (`Section`),
KEY `Name` (`Name`)
) TYPE=InnoDB;
INSERT INTO `doctor` (`DID`,`Name`,`Password`,`Age`,`Sex`,`Level`,`Section`,`Specialism`,`Phone`) VALUES ('00001','Fido Dido','72141edf556757f9',21,0,'professor','eye','short sighted','82330000'),('01111','Dido Fido','186227ea343eb2aa',21,1,'professor','head','headache','82310000');
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
`HID` int(10) unsigned NOT NULL auto_increment,
`Doctor` varchar(5) NOT NULL default '',
`Description` tinytext NOT NULL,
`Diagnose` tinytext NOT NULL,
`Patient` mediumint(8) unsigned NOT NULL default '0',
`Rx` tinytext NOT NULL,
`Finished` tinyint(1) unsigned NOT NULL default '0',
`FDate` datetime default '0000-00-00 00:00:00',
`SDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`HID`),
KEY `Doctor` (`Doctor`)
) TYPE=InnoDB;
INSERT INTO `history` (`HID`,`Doctor`,`Description`,`Diagnose`,`Patient`,`Rx`,`Finished`,`FDate`,`SDate`) VALUES (2,'00001','headache','sars',1,'madecine',0,'0000-00-00 00:00:00','2004-09-20 23:53:44'),(3,'00001','stomache','cold',1,'madecine',1,'2004-09-21 16:08:01','2004-09-21 15:44:04'),(4,'01111','sick','too tired',1,'madecine',0,'0000-00-00 00:00:00','2004-09-21 17:05:01');
DROP TABLE IF EXISTS `patient`;
CREATE TABLE `patient` (
`PID` mediumint(8) unsigned NOT NULL auto_increment,
`Name` varchar(12) NOT NULL default '',
`Username` varchar(20) NOT NULL defa