Java backend - SQL scripts

1. Order table creation

DROP DATABASE IF EXISTS FullStackDev;

CREATE DATABASE IF NOT EXISTS FullStackDev;

USE FullStackDev;

-- Create table User --

DROP TABLE IF EXISTS `Order`;

CREATE TABLE IF NOT EXISTS `Order` (

order_id SMALLINT UNSIGNED NOT NULL,

product_id SMALLINT UNSIGNED NOT NULL,

title VARCHAR(50) NOT NULL UNIQUE KEY,

PRIMARY KEY (order_id, product_id)

);

-- Insert data

INSERT INTO `Order` (order_id, product_id, title) 

VALUE (1, 1, 'Order 1'),

(1, 2, 'Order 2'),

(2, 3, 'Order 3');

SELECT * FROM `Order`;