7 lines
228 B
SQL
7 lines
228 B
SQL
CREATE TABLE user_alerts (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
user_id VARCHAR(255) NOT NULL,
|
|
alert JSON NOT NULL,
|
|
acknowledged BOOLEAN NOT NULL DEFAULT FALSE,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
); |