Java backend part 15

 SQL script:

DROP DATABASE IF EXISTS FullStackDev;

CREATE DATABASE IF NOT EXISTS FullStackDev;

USE FullStackDev;

-- Create table User --

DROP TABLE IF EXISTS `User`;

CREATE TABLE IF NOT EXISTS `User` (

id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

username VARCHAR(50) NOT NULL UNIQUE

);

-- Create table Address --

DROP TABLE IF EXISTS `Address`;

CREATE TABLE IF NOT EXISTS `Address` (

id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,

street VARCHAR(50) NOT NULL,

city VARCHAR(50) NOT NULL,

    user_id INT UNSIGNED NOT NULL,

    FOREIGN KEY (user_id) REFERENCES `User`(id)

);

INSERT INTO `User` (username)

VALUE   ('user1'),

('user2'),

        ('user3');

-- Insert data

INSERT INTO `Address` (street, city, user_id) 

VALUE ('Street 1', 'city 1', 1),

('Street 2', 'city 2', 1),

('Street 3', 'city 3', 2),

        ('Street 4', 'city 4', 3);