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 ++++-- Database/SQL/config.sql | 6 ++++-- 2 files changed, 8 insertions(+), 4 deletions(-) (limited to 'Database') 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 diff --git a/Database/SQL/config.sql b/Database/SQL/config.sql index 579c633..4a8296f 100644 --- a/Database/SQL/config.sql +++ b/Database/SQL/config.sql @@ -1,9 +1,11 @@ CREATE TABLE config ( - id NOT NULL PRIMARY KEY AUTO_INCREMENT, + config_id INT NOT NULL, title INT, description INT, image_link INT, article_link INT, source INT, - publish_date INT + publish_date INT, + + PRIMARY KEY(config_id) ) \ No newline at end of file -- cgit v1.2.3-13-gbd6f