DROP TABLE IF EXISTS Prewikka_Version;

CREATE TABLE Prewikka_Version (
	version VARCHAR(255) NOT NULL
);
INSERT INTO Prewikka_Version (version) VALUES('0.9.0');



DROP TABLE IF EXISTS Prewikka_User;

CREATE TABLE Prewikka_User (
	login VARCHAR(32) NOT NULL PRIMARY KEY,
	password VARCHAR(32) NULL,
	email VARCHAR(64) NULL
);



DROP TABLE IF EXISTS Prewikka_Permission;

CREATE TABLE Prewikka_Permission (
	login VARCHAR(32) NOT NULL,
	INDEX(login),
	permission VARCHAR(32) NOT NULL
);



DROP TABLE IF EXISTS Prewikka_Session;

CREATE TABLE Prewikka_Session (
	sessionid VARCHAR(128) NOT NULL PRIMARY KEY,
	login VARCHAR(32) NOT NULL,
	INDEX(login),
	time DATETIME NOT NULL
);



DROP TABLE IF EXISTS Prewikka_Filter;

CREATE TABLE Prewikka_Filter (
	id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	login VARCHAR(32) NOT NULL,
	name VARCHAR(64) NOT NULL,
	UNIQUE INDEX(login, name),
	comment VARCHAR(255) NULL,
	formula VARCHAR(255) NOT NULL
);



DROP TABLE IF EXISTS Prewikka_Filter_Criterion;

CREATE TABLE Prewikka_Filter_Criterion (
	id BIGINT UNSIGNED NOT NULL,
	INDEX(id),
	name VARCHAR(16) NOT NULL,
	path VARCHAR(255) NOT NULL,
	operator VARCHAR(8) NULL,
	value VARCHAR(255) NULL
);