10 lines
325 B
SQL
10 lines
325 B
SQL
CREATE DATABASE IF NOT EXISTS storage_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
USE storage_db;
|
|
|
|
CREATE TABLE IF NOT EXISTS storage (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
name VARCHAR(255) NOT NULL,
|
|
phone VARCHAR(20) NOT NULL,
|
|
location VARCHAR(10) NOT NULL,
|
|
bulk BOOLEAN NOT NULL DEFAULT FALSE
|
|
); |