diff options
Diffstat (limited to 'mysql.init.sql')
-rw-r--r-- | mysql.init.sql | 30 |
1 files changed, 0 insertions, 30 deletions
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) -); |