• Home
• br.com.objectos.sql
• api
• 0.12.0
• source code
• V002__EMPLOYEE.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.sql.V002__EMPLOYEE.sql Maven / Gradle / Ivy

use OBJECTOS_SQL;

create table EMPLOYEE (

  EMP_NO int not null, 
  BIRTH_DATE date not null,
  FIRST_NAME varchar(14) not null,
  LAST_NAME varchar(16) not null,
  HIRE_DATE date not null,
  
  primary key(EMP_NO)

) engine=InnoDB;

insert into 
EMPLOYEE (EMP_NO, BIRTH_DATE, FIRST_NAME, LAST_NAME, HIRE_DATE)
values 
(1, '1970-01-01', 'Homer', 'Simpson', '2010-01-01'), 
(2, '1975-06-25', 'Marge', 'Simpson', '2011-05-03'), 
(3, '1980-09-05', 'Moe', 'Szyslak', '2012-02-01');