From 8a458ba1f37d59983d4fedd2d4dd966bb08105b4 Mon Sep 17 00:00:00 2001
From: Aryadev Chavali <aryadevchavali1@gmail.com>
Date: Mon, 4 Feb 2019 07:51:34 +0000
Subject: Changed SQL to use PrimaryKey()

---
 Database/SQL/article.sql | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'Database/SQL/article.sql')

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
-- 
cgit v1.2.3-13-gbd6f

