From 48b20ac818a8d9f6e0c70f6aafc2c7a60f15d5bb Mon Sep 17 00:00:00 2001
From: Adam Mathes <adam@trenchant.org>
Date: Sun, 25 May 2025 19:28:58 -0700
Subject: clean up old files, update git ignore

---
 mysql.init.sql | 30 ------------------------------
 1 file changed, 30 deletions(-)
 delete mode 100644 mysql.init.sql

(limited to 'mysql.init.sql')

diff --git a/mysql.init.sql b/mysql.init.sql
deleted file mode 100644
index dbbc310..0000000
--- a/mysql.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)
-);
-- 
cgit v1.2.3

