CREATE TABLE items (
        id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
        source INTEGER,
        created TIMESTAMP,
        date TIMESTAMP,
        title VARCHAR(128),
        link VARCHAR(255),
        description TEXT,
        uniq VARCHAR(255)
);
CREATE TABLE items_meta (
	id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
	item INTEGER,
	name VARCHAR(64),
	value VARCHAR(255)
);
CREATE TABLE sources (
        id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
        url VARCHAR(255),
        link VARCHAR(255),
        title VARCHAR(128),
        description VARCHAR(255)
);
CREATE TABLE sources_meta (
	id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
	source INTEGER,
	name VARCHAR(64),
	value VARCHAR(255)
);
CREATE INDEX index_items_created ON items (created);
CREATE INDEX index_items_date ON items (date);
CREATE INDEX index_items_id on items (id);
CREATE INDEX index_items_meta_item ON items_meta (item);
CREATE INDEX index_items_meta_item_name ON items_meta (item, name);
CREATE INDEX index_items_meta_item_name_value ON items_meta (item, name, value);
CREATE INDEX index_items_meta_name ON items_meta (name);
CREATE INDEX index_items_meta_name_value ON items_meta (name, value);
CREATE INDEX index_items_meta_value ON items_meta (name);
CREATE INDEX index_items_source on items (source);
CREATE INDEX index_items_title on items (title);
CREATE INDEX index_items_uniq ON items (uniq);
CREATE INDEX index_sources_id on sources (id);
CREATE INDEX index_sources_meta_name ON sources_meta (name);
CREATE INDEX index_sources_meta_name_value ON sources_meta (name, value);
CREATE INDEX index_sources_meta_source ON sources_meta (source);
CREATE INDEX index_sources_meta_source_name ON sources_meta (source, name);
CREATE INDEX index_sources_meta_source_name_value on sources_meta (source, name, value);
CREATE INDEX index_sources_meta_value ON sources_meta (name);
CREATE INDEX index_sources_url ON sources (url);