text: -- Copied from http://bazaar.launchpad.net/~sandbox-developers/test-db/employees_db_1/view/head:/employees_db/employees.sql
  -- Dump copied from https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-dump-files-1.0.5.tar.bz2
  -- https://dev.mysql.com/doc/employee/en/employees-installation.html
  
  -- How to execute this script
  -- BANL128a4f3d4:employees_db rpalaniappan$ mysql -u root -p < employees.sql 
  -- Enter password: 
  -- INFO
  -- CREATING DATABASE STRUCTURE
  -- INFO
  -- storage engine: InnoDB
  -- INFO
  -- LOADING departments
  -- INFO
  -- LOADING employees
  -- INFO
  -- LOADING dept_emp
  -- INFO
  -- LOADING dept_manager
  -- INFO
  -- LOADING titles
  -- INFO
  -- LOADING salaries
  -- 
  
  --  Sample employee database 
  --  See changelog table for details
  --  Copyright (C) 2007,2008, MySQL AB
  --  
  --  Original data created by Fusheng Wang and Carlo Zaniolo
  --  http://www.cs.aau.dk/TimeCenter/software.htm
  --  http://www.cs.aau.dk/TimeCenter/Data/employeeTemporalDataSet.zip
  -- 
  --  Current schema by Giuseppe Maxia 
  --  Data conversion from XML to relational by Patrick Crews
  -- 
  -- This work is licensed under the 
  -- Creative Commons Attribution-Share Alike 3.0 Unported License. 
  -- To view a copy of this license, visit 
  -- http://creativecommons.org/licenses/by-sa/3.0/ or send a letter to 
  -- Creative Commons, 171 Second Street, Suite 300, San Francisco, 
  -- California, 94105, USA.
  -- 
  --  DISCLAIMER
  --  To the best of our knowledge, this data is fabricated, and
  --  it does not correspond to real people. 
  --  Any similarity to existing people is purely coincidental.
  -- 
  
  DROP DATABASE IF EXISTS employees;
  CREATE DATABASE IF NOT EXISTS employees;
  USE employees;
  
  SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';
  
  DROP TABLE IF EXISTS dept_emp,
                       dept_manager,
                       titles,
                       salaries, 
                       employees, 
                       departments;
  
     set storage_engine = InnoDB;
  -- set storage_engine = MyISAM;
  -- set storage_engine = Falcon;
  -- set storage_engine = PBXT;
  -- set storage_engine = Maria;
  
  select CONCAT('storage engine: ', @@storage_engine) as INFO;
  
  CREATE TABLE employees (
      emp_no      INT             NOT NULL,
      birth_date  DATE            NOT NULL,
      first_name  VARCHAR(14)     NOT NULL,
      last_name   VARCHAR(16)     NOT NULL,
      gender      ENUM ('M','F')  NOT NULL,    
      hire_date   DATE            NOT NULL,
      PRIMARY KEY (emp_no)
  );
  
  CREATE TABLE departments (
      dept_no     CHAR(4)         NOT NULL,
      dept_name   VARCHAR(40)     NOT NULL,
      PRIMARY KEY (dept_no),
      UNIQUE  KEY (dept_name)
  );
  
  CREATE TABLE dept_manager (
     dept_no      CHAR(4)         NOT NULL,
     emp_no       INT             NOT NULL,
     from_date    DATE            NOT NULL,
     to_date      DATE            NOT NULL,
     KEY         (emp_no),
     KEY         (dept_no),
     FOREIGN KEY (emp_no)  REFERENCES employees (emp_no)    ON DELETE CASCADE,
     FOREIGN KEY (dept_no) REFERENCES departments (dept_no) ON DELETE CASCADE,
     PRIMARY KEY (emp_no,dept_no)
  ); 
  
  CREATE TABLE dept_emp (
      emp_no      INT             NOT NULL,
      dept_no     CHAR(4)         NOT NULL,
      from_date   DATE            NOT NULL,
      to_date     DATE            NOT NULL,
      KEY         (emp_no),
      KEY         (dept_no),
      FOREIGN KEY (emp_no)  REFERENCES employees   (emp_no)  ON DELETE CASCADE,
      FOREIGN KEY (dept_no) REFERENCES departments (dept_no) ON DELETE CASCADE,
      PRIMARY KEY (emp_no,dept_no)
  );
  
  CREATE TABLE titles (
      emp_no      INT             NOT NULL,
      title       VARCHAR(50)     NOT NULL,
      from_date   DATE            NOT NULL,
      to_date     DATE,
      KEY         (emp_no),
      FOREIGN KEY (emp_no) REFERENCES employees (emp_no) ON DELETE CASCADE,
      PRIMARY KEY (emp_no,title, from_date)
  ); 
  
  CREATE TABLE salaries (
      emp_no      INT             NOT NULL,
      salary      INT             NOT NULL,
      from_date   DATE            NOT NULL,
      to_date     DATE            NOT NULL,
      KEY         (emp_no),
      FOREIGN KEY (emp_no) REFERENCES employees (emp_no) ON DELETE CASCADE,
      PRIMARY KEY (emp_no, from_date)
  ); 
  
  SELECT 'LOADING departments' as 'INFO';
  source load_departments.dump ;
  SELECT 'LOADING employees' as 'INFO';
  source load_employees.dump ;
  SELECT 'LOADING dept_emp' as 'INFO';
  source load_dept_emp.dump ;
  SELECT 'LOADING dept_manager' as 'INFO';
  source load_dept_manager.dump ;
  SELECT 'LOADING titles' as 'INFO';
  source load_titles.dump ;
  SELECT 'LOADING salaries' as 'INFO';
  source load_salaries.dump ;
  
  