DROP TABLE IF EXISTS diary_texts;
CREATE TABLE diary_texts
(
	day				DATE,
	par				INTEGER,
	text			TEXT,
	PRIMARY KEY		diary_pk (day, par),
	KEY				diary_day (day),
	KEY				diary_par (par)
);

DROP TABLE IF EXISTS diary_index;
CREATE TABLE diary_index
(
	day				DATE,
	par				INTEGER,
	word_id			INTEGER,
	PRIMARY KEY		diary_index_pk (day, par, word_id),
	KEY				diary_index_day (day),
	KEY				diary_index_par (par),
	KEY				diary_index_word_id (word_id)
);

DROP TABLE IF EXISTS diary_words;
CREATE TABLE diary_words
(
	id				INTEGER NOT NULL,
	word			CHAR(255),
	PRIMARY KEY		diary_words_pk (id),
	UNIQUE KEY		diary_words_word (word)
);

-- DROP TABLE IF EXISTS diary_words_2;
-- CREATE TABLE diary_words_2
-- (
-- 	id				INTEGER NOT NULL,
-- 	word			CHAR(255),
-- 	PRIMARY KEY		diary_words_2_pk (id),
-- 	UNIQUE KEY		diary_words_2_word (word)
-- );