aboutsummaryrefslogtreecommitdiff
path: root/Database
diff options
context:
space:
mode:
Diffstat (limited to 'Database')
-rw-r--r--Database/SQL/article.sql6
-rw-r--r--Database/SQL/config.sql6
2 files changed, 8 insertions, 4 deletions
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