Write code in main.sql please

initialize.sql $($read only no edit$)$:

$--$ Initialize database

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

$--$ Create address table

CREATE TABLE address $($

address$\_$id SMALLINT UNSIGNED NOT NULL,

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,

last$\_$update TIMESTAMP NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

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

$)$;

$--$ Create store table

CREATE TABLE store $($

store$\_$id TINYINT UNSIGNED NOT NULL,

manager$\_$staff$\_$id TINYINT UNSIGNED NOT NULL,

address$\_$id SMALLINT UNSIGNED NOT NULL,

last$\_$update TIMESTAMP NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

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

$)$;

$--$ Create customer table

CREATE TABLE customer $($

customer$\_$id SMALLINT 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 NOT NULL DEFAULT $\text{'}1\text{'},$

create$\_$date DATETIME NOT NULL,

last$\_$update TIMESTAMP NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

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

FOREIGN KEY $($address$\_$id$)$ REFERENCES address $($address$\_$id$)$

ON DELETE RESTRICT

ON UPDATE CASCADE

$)$;

$--$ Create staff table

CREATE TABLE staff $($

staff$\_$id TINYINT UNSIGNED NOT NULL,

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 NOT NULL DEFAULT $\text{'}1\text{'},$

username VARCHAR$(16)$ NOT NULL,

password VARCHAR$(40)$ DEFAULT NULL,

last$\_$update TIMESTAMP NOT NULL DEFAULT CURRENT$\_$TIMESTAMP,

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

FOREIGN KEY $($address$\_$id$)$ REFERENCES address $($address$\_$id$)$

ON DELETE RESTRICT

ON UPDATE CASCADE,

FOREIGN KEY $($store$\_$id$)$ REFERENCES store $($store$\_$id$)$

ON DELETE RESTRICT

ON UPDATE CASCADE

$)$;