11 lines
367 B
SQL
11 lines
367 B
SQL
-- db/migrations/002_create_workers_table.sql
|
|
CREATE TABLE IF NOT EXISTS workers (
|
|
id INT(11) NOT NULL AUTO_INCREMENT,
|
|
name VARCHAR(255) NOT NULL,
|
|
email VARCHAR(255) NOT NULL,
|
|
password_hash VARCHAR(255) NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (id),
|
|
UNIQUE KEY (email)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|