drop table if exists history;
drop table if exists pages;
drop table if exists connections;
drop table if exists users;
drop table if exists options;

create table options (
	lang varchar(16) not null,
	name varchar(32) not null,
	value text not null,
	constraint unique(lang,name)
) Engine = InnoDB;

create table users (
	id integer auto_increment primary key not null,
	username varchar(32) unique not null,
	password varchar(32) not null
) Engine = InnoDB;

create table pages (
	id integer auto_increment primary key not null,
	lang varchar(16) not null,
	slug varchar(128) not null,
	title varchar(256) not null,
	content text null,
	sidebar text not null,
	users_only integer not null,
	constraint unique (lang,slug),
	pad_url varchar(256) null
) Engine = InnoDB;

create table history (
	id integer not null,
	version integer not null,
	created datetime not null,
	author varchar(32) not null,
	title varchar(256) not null,
	content text null,
	sidebar text not null,
	constraint unique(id,version),
	pad_url varchar(256) null,
	foreign key(id) references pages(id),
	primary key(id,version)
) Engine = InnoDB;

create index history_timeline on history(created);