aboutsummaryrefslogtreecommitdiff
path: root/Database/SQL/article.sql
diff options
context:
space:
mode:
Diffstat (limited to 'Database/SQL/article.sql')
-rw-r--r--Database/SQL/article.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/Database/SQL/article.sql b/Database/SQL/article.sql
index 0f95cc4..5b3de4a 100644
--- a/Database/SQL/article.sql
+++ b/Database/SQL/article.sql
@@ -1,9 +1,11 @@
CREATE TABLE article (
- id NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ article_id INT NOT NULL,
title VARCHAR(255),
description VARCHAR(255),
image_link VARCHAR(128),
article_link VARCHAR(64),
source VARCHAR(8),
- publish_date DATE
+ publish_date DATE,
+
+ PRIMARY KEY(article_id)
) \ No newline at end of file