summaryrefslogtreecommitdiff
path: root/scripts/create_db.sql
diff options
context:
space:
mode:
authorniliara-edu <nil.jimeno@estudiant.fjaverianas.com>2024-10-02 23:21:43 +0200
committerniliara-edu <nil.jimeno@estudiant.fjaverianas.com>2024-10-02 23:21:43 +0200
commit7df09f8b146ae7fb091787770fe5681381164f0e (patch)
tree0310d8dad1d0c6198d68d13b22030db3c5e8b28f /scripts/create_db.sql
parent0972fa6eab8c9111311f082ba8abfdc6b4a40945 (diff)
fix database setup
Diffstat (limited to 'scripts/create_db.sql')
-rw-r--r--scripts/create_db.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/scripts/create_db.sql b/scripts/create_db.sql
index f803714..405fa96 100644
--- a/scripts/create_db.sql
+++ b/scripts/create_db.sql
@@ -17,6 +17,7 @@ CREATE TABLE album (
name varchar(255),
cover varchar(510),
artist_id int,
+ release_date date,
PRIMARY KEY (id),
FOREIGN KEY (artist_id) REFERENCES artist(id)