aboutsummaryrefslogtreecommitdiff
path: root/Database/SQL/articles.sql
diff options
context:
space:
mode:
authorAryadev Chavali <aryadevchavali1@gmail.com>2019-02-04 09:12:58 +0000
committerAryadev Chavali <aryadevchavali1@gmail.com>2019-02-04 09:12:58 +0000
commit54299514b4a0e71acbb2fff2099d89901e871d08 (patch)
treee77d8e44ca8f6f9876e8e94a40f6c60d748af3a0 /Database/SQL/articles.sql
parent8a458ba1f37d59983d4fedd2d4dd966bb08105b4 (diff)
downloadnewsaggregator-54299514b4a0e71acbb2fff2099d89901e871d08.tar.gz
newsaggregator-54299514b4a0e71acbb2fff2099d89901e871d08.tar.bz2
newsaggregator-54299514b4a0e71acbb2fff2099d89901e871d08.zip
Changed names of tables to plural
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