diff options
Diffstat (limited to 'Database/SQL/article.sql')
-rw-r--r-- | Database/SQL/article.sql | 6 |
1 files changed, 4 insertions, 2 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 |