CREATE TABLE users (
	id SMALLINT UNSIGNED NOT NULL,
	email VARCHAR(255) NOT NULL,
	password VARCHAR(255) NOT NULL,
	url VARCHAR(255) NOT NULL,
);

CREATE TABLE feeds (
	id MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY auto_increment,
	url VARCHAR(255) NOT NULL,
	last_update DATETIME,
	update_interval INT UNSIGNED
);

CREATE TABLE feeds_users (
	feed_id MEDIUMINT UNSIGNED NOT NULL,
	title VARCHAR(255),
	website_url VARCHAR(255),
	description TEXT,
	user_id SMALLINT UNSIGNED NOT NULL,
	is_nsfw TINYINT NOT NULL,
	public TINYINT NOT NULL DEFAULT 1,
);

CREATE TABLE elements (
	id INT UNSIGNED NOT NULL,
	feed_id MEDIUMINT UNSIGNED NOT NULL,
	title VARCHAR(255),
	url VARCHAR(255),
	content TEXT,
	content_type TINYINT,
);

CREATE TABLE elements_read (
	feed_id MEDIUMINT UNSIGNED,
	user_id SMALLINT UNSIGNED,
	element_id INT UNSIGNED
);