1 files changed, 0 insertions, 30 deletions
diff --git a/init.sql b/init.sql
deleted file mode 100644
index dbbc310..0000000
--- a/init.sql
+++ /dev/null
@@ -1,30 +0,0 @@
-SET NAMES 'utf8mb4';
-SET CHARACTER SET utf8mb4;
-
-CREATE TABLE feed (
-  id INT NOT NULL AUTO_INCREMENT,
-  url VARCHAR(255) NOT NULL,
-  web_url VARCHAR(255) NOT NULL DEFAULT "",
-  title VARCHAR(255) NOT NULL DEFAULT "",
-  category VARCHAR(255) NOT NULL DEFAULT "uncategorized",
-  last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  UNIQUE KEY (url),
-  PRIMARY KEY (id)
-);
-
-CREATE TABLE item (
-  id INT NOT NULL AUTO_INCREMENT,
-  feed_id INT NOT NULL,
-  title TEXT NOT NULL DEFAULT "",
-  url VARCHAR(255) NOT NULL,
-  description TEXT NOT NULL DEFAULT "",
-  full_content TEXT NOT NULL DEFAULT "",
-  header_image TEXT NOT NULL DEFAULT "",
-  publish_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
-  read_state BOOLEAN DEFAULT FALSE NOT NULL,
-  starred BOOLEAN DEFAULT FALSE NOT NULL,
-  FOREIGN KEY (feed_id) REFERENCES feed(id) ON DELETE CASCADE,
-  UNIQUE KEY (url),
-  INDEX (publish_date),
-  PRIMARY KEY (id)
-);