/*
SQLyog Ultimate v10.00 Beta1
MySQL - 5.5.15 : Database - myemployees
*********************************************************************
*//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!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' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;CREATEDATABASE/*!32312 IF NOT EXISTS*/`myemployees`/*!40100 DEFAULT CHARACTER SET gb2312 */;USE`myemployees`;/*Table structure for table `departments` */DROPTABLEIFEXISTS`departments`;CREATETABLE`departments`(`department_id`int(4)NOTNULLAUTO_INCREMENT,`department_name`varchar(3)DEFAULTNULL,`manager_id`int(6)DEFAULTNULL,`location_id`int(4)DEFAULTNULL,PRIMARYKEY(`department_id`),KEY`loc_id_fk`(`location_id`),CONSTRAINT`loc_id_fk`FOREIGNKEY(`location_id`)REFERENCES`locations`(`location_id`))ENGINE=InnoDBAUTO_INCREMENT=271DEFAULTCHARSET=gb2312;/*Data for the table `departments` */insertinto`departments`(`department_id`,`department_name`,`manager_id`,`location_id`)values(10,'Adm',200,1700),(20,'Mar',201,1800),(30,'Pur',114,1700),(40,'Hum',203,2400),(50,'Shi',121,1500),(60,'IT',103,1400),(70,'Pub',204,2700),(80,'Sal',145,2500),(90,'Exe',100,1700),(100,'Fin',108,1700),(110,'Acc',205,1700),(120,'Tre',NULL,1700),(130,'Cor',NULL,1700),(140,'Con',NULL,1700),(150,'Sha',NULL,1700),(160,'Ben',NULL,1700),(170,'Man',NULL,1700),(180,'Con',NULL,1700),(190,'Con',NULL,1700),(200,'Ope',NULL,1700),(210,'IT ',NULL,1700),(220,'NOC',NULL,1700),(230,'IT ',NULL,1700),(240,'Gov',NULL,1700),(250,'Ret',NULL,1700),(260,'Rec',NULL,1700),(270,'Pay',NULL,1700);/*Table structure for table `employees` */DROPTABLEIFEXISTS`employees`;CREATETABLE`employees`(`employee_id`int(6)NOTNULLAUTO_INCREMENT,`first_name`varchar(20)DEFAULTNULL,`last_name`varchar(25)DEFAULTNULL,`email`varchar(25)DEFAULTNULL,`phone_number`varchar(20)DEFAULTNULL,`job_id`varchar(10)DEFAULTNULL,`salary`double(10,2)DEFAULTNULL,`commission_pct`double(4,2)DEFAULTNULL,`manager_id`int(6)DEFAULTNULL,`department_id`int(4)DEFAULTNULL,`hiredate`datetimeDEFAULTNULL,PRIMARYKEY(`employee_id`),KEY`dept_id_fk`(`department_id`),KEY`job_id_fk`(`job_id`),CONSTRAINT`dept_id_fk`FOREIGNKEY(`department_id`)REFERENCES`departments`(`department_id`),CONSTRAINT`job_id_fk`FOREIGNKEY(`job_id`)REFERENCES`jobs`(`job_id`))ENGINE=InnoDBAUTO_INCREMENT=207DEFAULTCHARSET=gb2312;/*Data for the table `employees` */insertinto`employees`(`employee_id`,`first_name`,`last_name`,`email`,`phone_number`,`job_id`,`salary`,`commission_pct`,`manager_id`,`department_id`,`hiredate`)values(100,'Steven','K_ing','SKING','515.123.4567','AD_PRES',24000.00,NULL,NULL,90,'1992-04-03 00:00:00'),(101,'Neena','Kochhar','NKOCHHAR','515.123.4568','AD_VP',17000.00,NULL,100,90,'1992-04-03 00:00:00'),(102,'Lex','De Haan','LDEHAAN','515.123.4569','AD_VP',17000.00,NULL,100,90,'1992-04-03 00:00:00'),(103,'Alexander','Hunold','AHUNOLD','590.423.4567','IT_PROG',9000.00,NULL,102,60,'1992-04-03 00:00:00'),(104,'Bruce','Ernst','BERNST','590.423.4568','IT_PROG',6000.00,NULL,103,60,'1992-04-03 00:00:00'),(105,'David','Austin','DAUSTIN','590.423.4569','IT_PROG',4800.00,NULL,103,60,'1998-03-03 00:00:00'),(106,'Valli','Pataballa','VPATABAL','590.423.4560','IT_PROG',4800.00,NULL,103,60,'1998-03-03 00:00:00'),(107,'Diana','Lorentz','DLORENTZ','590.423.5567','IT_PROG',4200.00,NULL,103,60,'1998-03-03 00:00:00'),(108,'Nancy','Greenberg','NGREENBE','515.124.4569','FI_MGR',12000.00,NULL,101,100,'1998-03-03 00:00:00'),(109,'Daniel','Faviet','DFAVIET','515.124.4169','FI_ACCOUNT',9000.00,NULL,108,100,'1998-03-03 00:00:00'),(110,'John','Chen','JCHEN','515.124.4269','FI_ACCOUNT',8200.00,NULL,108,100,'2000-09-09 00:00:00'),(111,'Ismael','Sciarra','ISCIARRA','515.124.4369','FI_ACCOUNT',7700.00,NULL,108,100,'2000-09-09 00:00:00'),(112,'Jose Manuel','Urman','JMURMAN','515.124.4469','FI_ACCOUNT',7800.00,NULL,108,100,'2000-09-09 00:00:00'),(113,'Luis','Popp','LPOPP','515.124.4567','FI_ACCOUNT',6900.00,NULL,108,100,'2000-09-09 00:00:00'),(114,'Den','Raphaely','DRAPHEAL','515.127.4561','PU_MAN',11000.00,NULL,100,30,'2000-09-09 00:00:00'),(115,'Alexander','Khoo','AKHOO','515.127.4562','PU_CLERK',3100.00,NULL,114,30,'2000-09-09 00:00:00'),(116,'Shelli','Baida','SBAIDA','515.127.4563','PU_CLERK',2900.00,NULL,114