aboutsummaryrefslogtreecommitdiff
path: root/Database/SQL/articles.sql
diff options
context:
space:
mode:
Diffstat (limited to 'Database/SQL/articles.sql')
-rw-r--r--Database/SQL/articles.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/Database/SQL/articles.sql b/Database/SQL/articles.sql
new file mode 100644
index 0000000..4ad3034
--- /dev/null
+++ b/Database/SQL/articles.sql
@@ -0,0 +1,11 @@
+CREATE TABLE articles (
+ 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,
+
+ PRIMARY KEY(article_id)
+) \ No newline at end of file