24 lines
2.0 KiB
PHP
24 lines
2.0 KiB
PHP
<?php
|
|
include_once "db_config.php";
|
|
$queryString ="create table patient_90(patient_id char(50),patient_name char(50),patient_gender char(1),patient_address char(50))ENGINE=MyISAM DEFAULT CHARSET=utf8";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="create table doctor_90(doctor_id char(50),doctor_name char(50),doctor_gender char(1), department_id char(50))ENGINE=MyISAM DEFAULT CHARSET=utf8";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="create table department_90(department_id char(50),department_name char(50),department_location char(50))ENGINE=MyISAM DEFAULT CHARSET=utf8";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="create table register_90(biz_id char(50),doctor_id char(50),patient_id char(50),register_date int,fee int,state char(1))ENGINE=MyISAM DEFAULT CHARSET=utf8";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into patient_90(patient_id,patient_name,patient_gender,patient_address)values('510103001','张三','1','成都')";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into patient_90(patient_id,patient_name,patient_gender,patient_address)values('510103002','李四','2','重庆')";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into doctor_90(doctor_id,doctor_name,doctor_gender,department_id)values('510105001','王医生','2','001')";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into doctor_90(doctor_id,doctor_name,doctor_gender,department_id)values('510105002','罗医生','1','002')";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into doctor_90(doctor_id,doctor_name,doctor_gender,department_id)values('510105003','陈医生','1','001')";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into department_90(department_id,department_name,department_location)values('001','内科','1楼2诊室')";
|
|
mysqli_query($link, $queryString);
|
|
$queryString ="insert into department_90(department_id,department_name,department_location)values('002','外科','1楼5诊室')";
|
|
mysqli_query($link, $queryString); |