diff options
author | Adam Mathes <adam@trenchant.org> | 2018-06-12 14:58:02 -0700 |
---|---|---|
committer | Adam Mathes <adam@trenchant.org> | 2018-06-12 14:58:02 -0700 |
commit | 9e011074bcc80e00e6deb5b914371718e5991ce2 (patch) | |
tree | f8e7ef28d53f271354b369a3f5ef0844cd8a7ee6 /mysql.init.sql | |
parent | 968d44abeb1fc378d4ce8e207c9f4983c19eb47a (diff) | |
download | neko-9e011074bcc80e00e6deb5b914371718e5991ce2.tar.gz neko-9e011074bcc80e00e6deb5b914371718e5991ce2.tar.bz2 neko-9e011074bcc80e00e6deb5b914371718e5991ce2.zip |
sqlite3 support
Diffstat (limited to 'mysql.init.sql')
-rw-r--r-- | mysql.init.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql.init.sql b/mysql.init.sql new file mode 100644 index 0000000..dbbc310 --- /dev/null +++ b/mysql.init.sql @@ -0,0 +1,30 @@ +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) +); |