From 8a458ba1f37d59983d4fedd2d4dd966bb08105b4 Mon Sep 17 00:00:00 2001 From: Aryadev Chavali 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