
CREATE TABLE errors (
    id serial,
    pointer varchar(500),
    documentid varchar(100),
    before text,            # remove
    content varchar(500),   # fix
    after text,             # remove
    code varchar(128),
    author varchar(50),
    deleted boolean default false,
    created timestamp default now()
);

CREATE TABLE texts (
    documentid varchar(100),
    html text,
    plaintext text,
    status int default 0,
    deleted boolean default false
);

COMMENT ON COLUMN texts.status IS '0 - modifiable
1 - in marking process';


CREATE TABLE docrefs (
    word character varying(255),
    "DocumentID" character varying(50) NOT NULL,
    "ID" bigint NOT NULL,
    "language" character varying(10),
    wstat integer DEFAULT 0 NOT NULL,
    corpus character varying(25),
    deleted boolean default false
);


CREATE TABLE documents (
    "DocumentID" character varying(100) NOT NULL,
    title character varying(255),
    corpus character varying(25),
    "language" character varying(10),
    deleted boolean default false
);


CREATE TABLE analysis (
    documentid varchar(100),
    rawmorfo text
);

alter table docrefs rename "DocumentID" to documentid;
alter table documents rename "DocumentID" to documentid;


CREATE TABLE tags (
    id serial,
    uname varchar(32),
    label varchar(50),
    global boolean default true,
    script varchar(40)
);

CREATE TABLE tagged (
    id serial,
    uname varchar(32),
    documentid varchar(100),
    tag int
);

CREATE TABLE sentences (
	id serial,
	documentid varchar(100),
	language character varying(10),
	sentence text,
	analysis text,
    deleted boolean default false
);

CREATE TABLE sentencewords(
 id serial,
 sentenceid int,
 itemid int,
 word varchar(255),
 original boolean,
 lemma_unif varchar(100)
);

CREATE TABLE wordanalysis(
 id serial,
 sentencewordid int,
 analysis text,
 lemma varchar(100),
 analysis_start varchar(255),
 analysis_end varchar(255)
);