CREATE TABLE authors(
    id         INTEGER(8) NOT NULL AUTO_INCREMENT,
    login      VARCHAR(16) NOT NULL UNIQUE,
    passwd     VARCHAR(16) NOT NULL,
    email      VARCHAR(64) NOT NULL,
    img_name   VARCHAR(64),
    PRIMARY KEY(id)
);

CREATE TABLE author_profiles(
    author_id INTEGER(8) NOT NULL REFERENCES authors,
    lang       CHAR(2) NOT NULL,
    first_name VARCHAR(64) NOT NULL,
    last_name  VARCHAR(64) NOT NULL,
    pen_name   VARCHAR(64) NOT NULL,
    summary    TEXT
);

CREATE TABLE news_items(
    id INTEGER(8)  NOT NULL AUTO_INCREMENT,
    author_id      INTEGER(8) NOT NULL REFERENCES authors,
    lang CHAR(2) NOT NULL,
    img_name       VARCHAR(64),
    body           TEXT NOT NULL,
    creation_time  INTEGER(10) NOT NULL,
    PRIMARY KEY(id)
);

CREATE TABLE events(
    id        INTEGER(8)  NOT NULL AUTO_INCREMENT,
    place_ru  VARCHAR(128) NOT NULL,
    place_en  VARCHAR(128) NOT NULL,
    time      INTEGER(10) NOT NULL,
    PRIMARY KEY(id)
);

INSERT INTO authors(id, login, passwd, email, img_name) VALUES(NULL, 'ilya', '123456', 'ilya@anatomyofsoul.com', -1);
INSERT INTO author_profiles(author_id, lang, first_name, last_name, pen_name, summary) VALUES(1, 'en', 'Ilya', 'Sokoloff', 'Ilya', '');
INSERT INTO author_profiles(author_id, lang, first_name, last_name, pen_name, summary) VALUES(1, 'ru', '', '', '', '');