Write code in main.sql

Initialize.sql $($read online no edit$)$:

$--$ Drop all existing tables

DROP TABLE IF EXISTS address, customer, staff, store, phone;

$--$ Create address, customer, staff, and store tables

CREATE TABLE address $($

address$\_$id smallint unsigned NOT NULL AUTO$\_$INCREMENT,

address varchar$(50)$ NOT NULL,

address$2$ varchar$(50)$ DEFAULT NULL,

district varchar$(20)$ NOT NULL,

city$\_$id smallint unsigned NOT NULL,

postal$\_$code varchar$(10)$ DEFAULT NULL,

phone varchar$(20)$ NOT NULL,

location geometry NOT NULL $/*!80003$ SRID $0*/,$

last$\_$update timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $($address$\_$id$)$

$)$;

CREATE TABLE customer $($

customer$\_$id smallint unsigned NOT NULL AUTO$\_$INCREMENT,

store$\_$id tinyint unsigned NOT NULL,

first$\_$name varchar$(45)$ NOT NULL,

last$\_$name varchar$(45)$ NOT NULL,

email varchar$(50)$ DEFAULT NULL,

address$\_$id smallint unsigned NOT NULL,

active tinyint$(1)$ NOT NULL DEFAULT $\text{'}1\text{'},$

create$\_$date datetime NOT NULL,

last$\_$update timestamp NULL DEFAULT CURRENT$\_$TIMESTAMP ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $($customer$\_$id$)$

$)$;

CREATE TABLE staff $($

staff$\_$id tinyint unsigned NOT NULL AUTO$\_$INCREMENT,

first$\_$name varchar$(45)$ NOT NULL,

last$\_$name varchar$(45)$ NOT NULL,

address$\_$id smallint unsigned NOT NULL,

picture blob,

email varchar$(50)$ DEFAULT NULL,

store$\_$id tinyint unsigned NOT NULL,

active tinyint$(1)$ NOT NULL DEFAULT $\text{'}1\text{'},$

username varchar$(16)$ NOT NULL,

password varchar$(40)$ CHARACTER SET utf$8$mb$4$ COLLATE utf$8$mb$4\_$bin DEFAULT NULL,

last$\_$update timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $($staff$\_$id$)$

$)$;

CREATE TABLE store $($

store$\_$id tinyint unsigned NOT NULL AUTO$\_$INCREMENT,

manager$\_$staff$\_$id tinyint unsigned NOT NULL,

address$\_$id smallint unsigned NOT NULL,

last$\_$update timestamp NOT NULL DEFAULT CURRENT$\_$TIMESTAMP ON UPDATE CURRENT$\_$TIMESTAMP,

PRIMARY KEY $($store$\_$id$)$

$)$;