diff options
-rw-r--r-- | Database/SQL/article.sql | 6 | ||||
-rw-r--r-- | Database/SQL/config.sql | 6 |
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 |