7 lines
284 B
SQL
7 lines
284 B
SQL
CREATE TABLE IF NOT EXISTS `uploads` (
|
|
`id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
`user_id` INT(11) UNSIGNED NOT NULL,
|
|
`file_path` VARCHAR(255) NOT NULL,
|
|
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
|
|
); |