Java Backend part 23

 SQL Script:

DROP DATABASE IF EXISTS FullStackDev;

CREATE DATABASE IF NOT EXISTS FullStackDev;

USE FullStackDev;

-- Create table RegularEmployee --

CREATE TABLE `RegularEmployee` (

id INT UNSIGNED PRIMARY KEY,

    `name` VARCHAR(50) NOT NULL,

salary INT NOT NULL,

    bonus INT NOT NULL

);

-- Create table ContractEmployee --

CREATE TABLE `ContractEmployee` (

id INT UNSIGNED PRIMARY KEY,

    `name` VARCHAR(50) NOT NULL,

    pay_per_hour INT NOT NULL,

    contract_duration VARCHAR(50) NOT NULL

);

      

INSERT INTO `RegularEmployee` (id, `name`, salary, bonus)

VALUE (1, 'name1', 2000, 100),

  (2, 'name2', 2000, 200);

      

INSERT INTO `ContractEmployee` (id, `name`, pay_per_hour, contract_duration)

VALUE (3, 'name3', 10, '3 years');