From 54299514b4a0e71acbb2fff2099d89901e871d08 Mon Sep 17 00:00:00 2001 From: Aryadev Chavali Date: Mon, 4 Feb 2019 09:12:58 +0000 Subject: Changed names of tables to plural --- Database/SQL/article.sql | 11 ----------- Database/SQL/articles.sql | 11 +++++++++++ Database/SQL/config.sql | 11 ----------- Database/SQL/configs.sql | 11 +++++++++++ 4 files changed, 22 insertions(+), 22 deletions(-) delete mode 100644 Database/SQL/article.sql create mode 100644 Database/SQL/articles.sql delete mode 100644 Database/SQL/config.sql create mode 100644 Database/SQL/configs.sql (limited to 'Database') diff --git a/Database/SQL/article.sql b/Database/SQL/article.sql deleted file mode 100644 index 5b3de4a..0000000 --- a/Database/SQL/article.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE article ( - 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 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 diff --git a/Database/SQL/config.sql b/Database/SQL/config.sql deleted file mode 100644 index 4a8296f..0000000 --- a/Database/SQL/config.sql +++ /dev/null @@ -1,11 +0,0 @@ -CREATE TABLE config ( - config_id INT NOT NULL, - title INT, - description INT, - image_link INT, - article_link INT, - source INT, - publish_date INT, - - PRIMARY KEY(config_id) -) \ No newline at end of file diff --git a/Database/SQL/configs.sql b/Database/SQL/configs.sql new file mode 100644 index 0000000..a55052e --- /dev/null +++ b/Database/SQL/configs.sql @@ -0,0 +1,11 @@ +CREATE TABLE configs ( + config_id INT NOT NULL, + title INT, + description INT, + image_link INT, + article_link INT, + source INT, + publish_date INT, + + PRIMARY KEY(config_id) +) \ No newline at end of file -- cgit v1.2.3-13-gbd6f