Articles idnexing

1 files changed, 19 insertions, 0 deletions

diff --git a/db.sql b/db.sql
new file mode 100644
index 0000000..06db73b
--- /dev/null
+++ b/db.sql
@@ -0,0 +1,19 @@
+CREATE TABLE Articles (
+	Id INTEGER PRIMARY KEY AUTOINCREMENT, 
+    DisplayName TEXT UNIQUE,
+    FileName TEXT UNIQUE,
+    URL TEXT UNIQUE,
+    CreatedAt TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE TABLE Tags (
+	Id INTEGER PRIMARY KEY AUTOINCREMENT, 
+    Name TEXT
+);
+
+CREATE TABLE ArticlesToTags (
+    ArticleId INTEGER,
+    TagId INTEGER,
+    FOREIGN KEY(ArticleId) REFERENCES Articles(Id),
+    FOREIGN KEY(TagId) REFERENCES Tags(Id)
+);