--We do no encryption, just plain text
CREATE TABLE account (
    ID INTEGER PRIMARY KEY autoincrement,
    email TEXT NOT NULL,
    PASSWORD TEXT NOT NULL
);

CREATE TABLE event (
    title TEXT NOT NULL,
    all_day INT NOT NULL,
    START INTEGER NOT NULL,
    END INTEGER NOT NULL,
    description TEXT NOT NULL,
    creator INTEGER NOT NULL,
    FOREIGN KEY (creator) REFERENCES account(ID)
);

INSERT INTO account (email, PASSWORD) VALUES
  ('[email protected]', 'helloworld');

INSERT INTO account (email, PASSWORD) VALUES
  ('[email protected]', 'password');

INSERT INTO event VALUES
  ('some_event', 1, 1474095600000, 1474354800000, 'desc', 10);