10 lines
323 B
SQL
10 lines
323 B
SQL
CREATE TABLE comments (
|
|
id INT(11) NOT NULL AUTO_INCREMENT,
|
|
username VARCHAR(255) NOT NULL,
|
|
content TEXT NOT NULL,
|
|
visible BOOLEAN DEFAULT 1,
|
|
date_sent DATETIME DEFAULT CURRENT_TIME,
|
|
users_id INT(11) NOT NULL,
|
|
PRIMARY KEY (id),
|
|
FOREIGN KEY (users_id) REFERENCES users(id) ON DELETE NO ACTION
|
|
); |